25wm_qcc_info.sql 2.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. USE `cnbg_20240511_001`;
  2. SET NAMES utf8mb4;
  3. SET FOREIGN_KEY_CHECKS = 0;
  4. -- ----------------------------
  5. -- Table structure for wm_qcc_info
  6. -- ----------------------------
  7. DROP TABLE IF EXISTS `wm_qcc_info`;
  8. CREATE TABLE `wm_qcc_info`
  9. (
  10. `info_id` BIGINT UNSIGNED AUTO_INCREMENT NOT NULL COMMENT '主键ID',
  11. `reg_code` VARCHAR(32) NOT NULL COMMENT '三合一码',
  12. `biz_info` JSON NULL COMMENT '工商照面信息',
  13. `revoke_info` JSON NULL COMMENT '注销吊销信息',
  14. `bank_info` JSON NULL COMMENT '开票信息',
  15. `scale` VARCHAR(10) NULL COMMENT '企业规模',
  16. `partner_list` JSON NULL COMMENT '工商登记股东',
  17. `employee_list` JSON NULL COMMENT '工商登记主要人员',
  18. `change_list` JSON NULL COMMENT '变更信息',
  19. `actual_controller_list` JSON NULL COMMENT '实际控制人',
  20. `admin_license_list` JSON NULL COMMENT '行政许可',
  21. `tax_credit_list` JSON NULL COMMENT '纳税等级',
  22. `shi_xin` JSON NULL COMMENT '失信人',
  23. `zhi_xing` JSON NULL COMMENT '被执行人',
  24. `admin_penalty` JSON NULL COMMENT '行政处罚',
  25. `exp` JSON NULL COMMENT '经营异常',
  26. `chattel_mortgage` JSON NULL COMMENT '动产抵押',
  27. `liquidation` JSON NULL COMMENT '清算信息',
  28. `serious_illegal` JSON NULL COMMENT '严重违法',
  29. `bankruptcy` JSON NULL COMMENT '破产重组',
  30. `sumptuary` JSON NULL COMMENT '限制高消费',
  31. `tax_illegal` JSON NULL COMMENT '税收违法',
  32. `tax_abnormal` JSON NULL COMMENT '税收非正常户',
  33. `create_by` VARCHAR(32) NOT NULL COMMENT '创建人',
  34. `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL COMMENT '创建时间',
  35. PRIMARY KEY `pk_id` (`info_id`) USING BTREE
  36. ) ENGINE = InnoDB
  37. DEFAULT CHARSET = utf8mb4
  38. COLLATE = utf8mb4_general_ci
  39. ROW_FORMAT = DYNAMIC COMMENT ='企查查信息';
  40. -- ----------------------------
  41. -- Records of wm_pkg_rdp
  42. -- ----------------------------
  43. BEGIN;
  44. COMMIT;
  45. SET FOREIGN_KEY_CHECKS = 1;