SQL转Java实体类

 
CREATE TABLE `favorite` (
    `aid` int unsigned NOT NULL AUTO_INCREMENT,
    `mid` bigint unsigned NOT NULL,
    `title` varchar(50) NOT NULL DEFAULT '',
    `avatar` varchar(255) NOT NULL DEFAULT '',
    `gender` tinyint unsigned NOT NULL DEFAULT '0',
    `acc_balance` int unsigned NOT NULL DEFAULT '0' COMMENT '账户积分',
    `keywords` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
    `acc_status` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '账户状态',
    `created_at` int unsigned NOT NULL,
    `LastAt` double(10,3) NOT NULL DEFAULT '0.000',
    PRIMARY KEY (`aid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='收藏信息表';

转换结果...​x
 
​

SQL转Java实体类

SQL转Java实体类

Template Customizer

Theming

Layout