You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
21 lines
1.3 KiB
21 lines
1.3 KiB
DROP TABLE IF EXISTS `promise_self_file`;
|
|
CREATE TABLE `promise_self_file`
|
|
(
|
|
`id` int(32) NOT NULL AUTO_INCREMENT COMMENT 'id',
|
|
`sid` varchar(64) NOT NULL COMMENT 'sid 标识 技术人员扩展表',
|
|
`lockVersion` int(32) NOT NULL DEFAULT '0' COMMENT '记录版本，锁',
|
|
`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
|
|
`modifyTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录最后修改时间',
|
|
`isEnable` int(32) NOT NULL DEFAULT '1' COMMENT '记录是否可用，1:可用，0:不可用',
|
|
`state` int(11) DEFAULT '1' COMMENT '记录状态值',
|
|
`isDelete` int(32) DEFAULT '0' COMMENT '记录是否被删除，0:未删除，1:已经删除',
|
|
`remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
|
|
`createBySid` varchar(64) DEFAULT NULL COMMENT '创建者',
|
|
`updateBySid` varchar(64) DEFAULT NULL COMMENT '更新者',
|
|
`industryKey` varchar(64) DEFAULT NULL COMMENT '行业key',
|
|
`filePath` varchar(64) DEFAULT NULL COMMENT '模板路径',
|
|
`fileName` varchar(64) NULL DEFAULT NULL COMMENT '模板名称',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE = InnoDB
|
|
DEFAULT CHARSET = utf8
|
|
ROW_FORMAT = DYNAMIC COMMENT ='自评表模板文件';
|