| 1234567891011121314151617181920212223242526272829303132 |
- CREATE TABLE `aft_dev`.`copyright_info` (
- `id` VARCHAR(36) NOT NULL COMMENT '主键',
- `uid` VARCHAR(36) NOT NULL COMMENT '用户主键',
- `serial_number` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
- `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `accept_time` DATETIME NULL COMMENT '受理时间',
- `principal` VARCHAR(36) NULL COMMENT '负责人id',
- `contact` INT(1) NULL COMMENT '联系人序号',
- `copyright_info` VARCHAR(255) NULL COMMENT '软著简介',
- `copyright_name` VARCHAR(60) NULL COMMENT '软著名字',
- `status` INT(1) NULL COMMENT '申请状态',
- `work_issue` VARCHAR(128) NULL COMMENT '派单信息',
- `comment` VARCHAR(128) NULL COMMENT '当前备注',
- `outsource` VARCHAR(60) NULL COMMENT '外包信息',
- `in_urgent` INT(3) NULL COMMENT '加急天数',
- `authorized_date` DATETIME NULL COMMENT '下证时间',
- PRIMARY KEY (`id`),
- UNIQUE INDEX `serial_number_UNIQUE` (`serial_number` ASC)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `copyright_log` (
- `id` varchar(36) NOT NULL COMMENT '主键',
- `cid` varchar(36) NOT NULL COMMENT '软著申请id',
- `record_time` datetime DEFAULT NULL COMMENT '操作时间',
- `status` int(1) DEFAULT NULL COMMENT '状态',
- `principal` varchar(36) DEFAULT NULL COMMENT '负责人',
- `operator` varchar(36) DEFAULT NULL COMMENT '操作人',
- `comment` varchar(45) DEFAULT NULL COMMENT '备注',
- PRIMARY KEY (`id`),
- KEY `fk_copyright_log_copyright_info1_idx` (`cid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|