项目字典表设计
系统字典表，一半涉及两张表：字典1：n字典项。是一对多的关系
字典表：
字典项表：
如，消息类型，在字典表就是
在字典项对应的多条：
字典表sql：
CREATE TABLE `sys_dict` ( `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `dict_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'字典名称\', `dict_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'字典编码\', `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'描述\', `del_flag` int(1) NULL DEFAULT NULL COMMENT \'删除状态\', `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'创建人\', `create_time` datetime(0) NULL DEFAULT NULL COMMENT \'创建时间\', `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'更新人\', `update_time` datetime(0) NULL DEFAULT NULL COMMENT \'更新时间\', `type` int(1) UNSIGNED ZEROFILL NULL DEFAULT 0 COMMENT \'字典类型0为string,1为number\', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `indextable_dict_code`(`dict_code`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
字典项表sql：
CREATE TABLE `sys_dict_item` ( `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `dict_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'字典id\', `item_text` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'字典项文本\', `item_value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'字典项值\', `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'描述\', `sort_order` int(10) NULL DEFAULT NULL COMMENT \'排序\', `status` int(11) NULL DEFAULT NULL COMMENT \'状态（1启用 0不启用）\', `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `create_time` datetime(0) NULL DEFAULT NULL, `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `update_time` datetime(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `index_table_dict_id`(`dict_id`) USING BTREE, INDEX `index_table_sort_order`(`sort_order`) USING BTREE, INDEX `index_table_dict_status`(`status`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
欢迎关注个人公众号一起交流学习：
版权声明：本文为lihaoyang原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。