CREATE TABLE license (
id varchar(20) NOT NULL,
create_time bigint(20) DEFAULT NULL,
update_time bigint(20) DEFAULT NULL,
is_deleted int(11) DEFAULT ‘0’,
user_id varchar(100) DEFAULT NULL COMMENT ‘用户id’,
zlb_user_id varchar(100) DEFAULT NULL COMMENT ‘浙里办id’,
ins_id varchar(20) DEFAULT NULL,
org_id varchar(20) DEFAULT NULL COMMENT ‘成果目录id’,
license_type varchar(255) DEFAULT NULL COMMENT ‘成果类型’,
license_data json DEFAULT NULL COMMENT ‘成果字段详情’,
org_license_type varchar(30) DEFAULT NULL COMMENT ‘成果org_license细分’,
course_id varchar(20) DEFAULT NULL COMMENT ‘课程id’,
course_name varchar(100) DEFAULT NULL COMMENT ‘课程名称’,
tran_time bigint(0) DEFAULT ‘0’ COMMENT ‘转化时间’,
apply_file json DEFAULT NULL COMMENT ‘申请文件’,
mec_id varchar(50) DEFAULT NULL COMMENT ‘机构id’,
status varchar(20) DEFAULT NULL COMMENT ‘审核状态’,
tran_status varchar(30) DEFAULT NULL COMMENT ‘转换状态’,
first_mec_id varchar(30) DEFAULT NULL COMMENT ‘一级机构id’,
second_mec_id varchar(30) DEFAULT NULL COMMENT ‘二级机构id’,
license_code varchar(50) DEFAULT NULL COMMENT ‘成果代码’,
hash_value varchar(256) DEFAULT NULL COMMENT ‘区块链hash’,
source varchar(30) DEFAULT NULL,
id_card varchar(50) DEFAULT NULL COMMENT ‘身份证’,
credit_hour varchar(30) DEFAULT NULL,
user_name varchar(50) DEFAULT NULL,
user_code varchar(30) DEFAULT NULL,
org_code varchar(50) DEFAULT NULL,
license_name varchar(100) DEFAULT NULL,
career_qualification_data json DEFAULT NULL COMMENT ‘证书，课程，专业信息’,
operation_phone varchar(50) DEFAULT NULL COMMENT ‘操作人手机号’,
operation_name varchar(50) DEFAULT NULL COMMENT ‘操作人姓名’,
mec_name varchar(50) DEFAULT NULL COMMENT ‘机构名称’,
is_old tinyint(3) DEFAULT ‘0’ COMMENT ‘是否老系统’,
old_id varchar(50) DEFAULT NULL COMMENT ‘老系统id’,
KEY zlbuserid_idx (zlb_user_id),
PRIMARY KEY (id) /*T![clustered_index] NONCLUSTERED */,
KEY id_card_idx (id_card),
KEY create_time_idx (create_time),
KEY idx_delete_type_mec_create (is_deleted,org_license_type,mec_id,create_time),
KEY idx_delete_type_first_mec_create (is_deleted,org_license_type,first_mec_id,create_time),
KEY idx_deleted_orgId (is_deleted,org_id),
KEY idx_delete_type_second_mec_create (is_deleted,org_license_type,second_mec_id,create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;