forked from Gitlink/microservices
20 lines
2.1 KiB
SQL
20 lines
2.1 KiB
SQL
SET FOREIGN_KEY_CHECKS=0;
|
||
|
||
CREATE TABLE `ruoyi-gitlink`.`zone_partners` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '合作伙伴主键',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '合作伙伴名称',
|
||
`link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '合作伙伴跳转链接',
|
||
`logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '合作伙伴图片',
|
||
`sort` int(4) NULL DEFAULT 1 COMMENT '合作伙伴排序',
|
||
`dept_id` int(11) NOT NULL COMMENT '所属组织Id',
|
||
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
|
||
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
||
`zone_id` int(11) NOT NULL COMMENT '专区标识',
|
||
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '特色专区合作伙伴' ROW_FORMAT = DYNAMIC;
|
||
|
||
SET FOREIGN_KEY_CHECKS=1; |