1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
-- ----------------------------
-- 2024-07-27
-- ----------------------------
DROP TABLE IF EXISTS `mortals_xhx_child_license`;
CREATE TABLE `mortals_xhx_child_license` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID，主键，自增长',
`siteId` bigint(20) DEFAULT NULL COMMENT '站点Id',
`siteName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '站点名称',
`catalogId` bigint(20) DEFAULT NULL COMMENT '目录id',
`catalogName` varchar(64) DEFAULT NULL COMMENT '目录名称',
`applyId` bigint(20) DEFAULT NULL COMMENT '申请Id',
`documentId` bigint(20) DEFAULT NULL COMMENT '子证配置Id',
`documentName` varchar(128) NOT NULL COMMENT '子证名称',
`deptId` bigint(20) NOT NULL COMMENT '部门id',
`deptName` varchar(128) NOT NULL COMMENT '部门名称',
`marketEntityName` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '市场主体名称',
`licenseCode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '许可证编号',
`legalPersonName` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '法定代表人（负责人）',
`creditCode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '统一社会信用代码',
`productLicenseTime` datetime NULL DEFAULT NULL COMMENT '制证日期',
`certQRCode` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '证件二维码',
`certAuthority` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '制证机关',
`businessPlace` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '经营场所',
`licensedItems` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '许可项目',
`originalFileName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '正本文件名称',
`originalFilePath` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '正本文件相对路径地址',
`copyFileName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '副本文件名称',
`copyFilePath` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '副本文件相对路径地址',
`summary` varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简介',
`formStyleContent` mediumtext COMMENT '动态表单样式',
`formContent` mediumtext COMMENT '提交的表单',
`processStatus` tinyint(2) DEFAULT '0' COMMENT '处理状态(0.未处理,1.已处理)',
`remark` varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`reportUserId` bigint(20) DEFAULT NULL COMMENT '联报用户',
`reportUserName` varchar(64) DEFAULT NULL COMMENT '联报用户名称',
`reportTime` datetime DEFAULT NULL COMMENT '联报时间',
`createTime` datetime(0) NOT NULL COMMENT '创建时间',
`createUserId` bigint(20) NOT NULL COMMENT '创建用户',
`createUserName` varchar(64) DEFAULT NULL COMMENT '创建用户名称',
`updateUserId` bigint(20) DEFAULT NULL COMMENT '更新用户',
`updateUserName` varchar(64) DEFAULT NULL COMMENT '更新用户名称',
`updateTime` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
KEY `siteId` (`siteId`) USING BTREE,
KEY `catalogId` (`catalogId`) USING BTREE,
KEY `applyId` (`applyId`) USING BTREE,
KEY `documentId` (`documentId`) USING BTREE,
KEY `deptId` (`deptId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '行业许可子证' ROW_FORMAT = Dynamic;
ALTER TABLE mortals_xhx_child_license ADD COLUMN `resolutionValue` varchar(64) DEFAULT '' COMMENT '设备分辨率' AFTER resolution;
-- ----------------------------
-- 2024-07-30
-- ----------------------------
ALTER TABLE mortals_xhx_child_license
ADD COLUMN `shortName` varchar(64) DEFAULT '' COMMENT '简称' ,
ADD COLUMN `ext1` varchar(255) DEFAULT '' COMMENT '扩展列1' ,
ADD COLUMN `ext2` varchar(255) DEFAULT '' COMMENT '扩展列2' ,
ADD COLUMN `ext3` varchar(255) DEFAULT '' COMMENT '扩展列3' ,
ADD COLUMN `ext4` varchar(255) DEFAULT '' COMMENT '扩展列4' ,
ADD COLUMN `ext5` varchar(255) DEFAULT '' COMMENT '扩展列5' ,
ADD COLUMN `ext6` varchar(255) DEFAULT '' COMMENT '扩展列6' ,
ADD COLUMN `ext7` varchar(255) DEFAULT '' COMMENT '扩展列7' ,
ADD COLUMN `ext8` varchar(255) DEFAULT '' COMMENT '扩展列8' ,
ADD COLUMN `childStatus` tinyint(2) DEFAULT '1' COMMENT '子证状态(0.禁用,1.启用)',
ADD COLUMN `deleted` tinyint(2) DEFAULT '0' COMMENT '删除状态(0.未删除,1.已删除)'
AFTER remark;
ALTER TABLE mortals_xhx_certificate_document
ADD COLUMN `shortName` varchar(64) DEFAULT '' COMMENT '简称' AFTER documentName ;
ALTER TABLE mortals_xhx_certificate_catalog
ADD COLUMN `shortName` varchar(64) DEFAULT '' COMMENT '简称' AFTER catalogCode ;
ALTER TABLE mortals_xhx_certificate_child
ADD COLUMN `catalogName` varchar(64) DEFAULT NULL COMMENT '目录名称',
ADD COLUMN `documentName` varchar(64) DEFAULT NULL COMMENT '子证名称'
AFTER catalogId ;