笔记:懂得自然懂这张表的重要性,不懂得看看得了...
建表语句:
-- ----------------------------
-- Table structure for sys_codeitemdefine
-- ----------------------------
DROP TABLE IF EXISTS `sys_codeitemdefine`;
CREATE TABLE `sys_codeitemdefine` (
`DMCOD` varchar(58) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '要保存的状态码',
`ID` varchar(58) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '新代码表所用ID',
`DMGRP` varchar(58) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '代码表名称',
`DMCPT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '功能描述',
`DMABR` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '简称',
`YESPRV` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否展示',
`PORDER` int(0) NULL DEFAULT NULL COMMENT '序号',
`CREATEUSER` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
`CREATETIME` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`UPDATEUSER` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人',
`UPDATETIME` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`DMGRP`, `ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_codeitemdefine
-- ----------------------------
INSERT INTO `sys_codeitemdefine` VALUES ('0', 'gender1', 'genderState', '男', '男', '1', 1, NULL, NULL, NULL, NULL);
INSERT INTO `sys_codeitemdefine` VALUES ('1', 'gender2', 'genderState', '女', '女', '1', 2, NULL, NULL, NULL, NULL);
INSERT INTO `sys_codeitemdefine` VALUES ('1', '2', 'noticeState', '已发布', '已发布', '1', 2, NULL, NULL, NULL, NULL);
INSERT INTO `sys_codeitemdefine` VALUES ('2', '3', 'noticeState', '已暂停', '已暂停', '1', 3, NULL, NULL, NULL, NULL);
INSERT INTO `sys_codeitemdefine` VALUES ('0', '1', 'noticeState ', '未发布', '未发布', '1', 1, NULL, NULL, NULL, NULL);
SET FOREIGN_KEY_CHECKS = 1;
想要了解具体业务应用场景,联系作者!!!