zc_handler_change.sql 889 B

1234567891011121314
  1. CREATE TABLE `zc_handler_change` (
  2. `zhc_id` varchar(64) NOT NULL COMMENT 'ID',
  3. `zhc_company_id` varchar(64) NOT NULL COMMENT '企业iD(sys_company.scy_id)',
  4. `zhc_user_id` bigint(20) NOT NULL COMMENT '当前经办人id(sys_user.user_id)',
  5. `zhc_to_user_id` bigint(20) NOT NULL COMMENT '申请经办人id(sys_user.user_id)',
  6. `zhc_file1_id` varchar(64) NOT NULL COMMENT '变更文件1',
  7. `zhc_file2_id` varchar(64) NOT NULL COMMENT '变更文件2',
  8. `zhc_status` char(2) NOT NULL COMMENT '变更状态(00:待平台处理, 01:平台已处理)',
  9. `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  10. `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  11. `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  12. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  13. PRIMARY KEY (`zhc_id`)
  14. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='经办人变更申请表';