33sys_ent_cont_info.sql 1.3 KB

1234567891011121314151617181920212223242526272829303132333435
  1. USE `cnbg_20240511_001`;
  2. SET NAMES utf8mb4;
  3. SET FOREIGN_KEY_CHECKS = 0;
  4. -- ----------------------------
  5. -- Table structure for sys_ent_cont_info
  6. -- ----------------------------
  7. DROP TABLE IF EXISTS `sys_ent_cont_info`;
  8. CREATE TABLE `sys_ent_cont_info`
  9. (
  10. `info_id` INT UNSIGNED AUTO_INCREMENT NOT NULL COMMENT '信息',
  11. `ent_id` INT NOT NULL COMMENT '企业ID',
  12. `ent_name` VARCHAR(64) NULL COMMENT '企业名称',
  13. `ent_addr` VARCHAR(255) NULL COMMENT '企业地址',
  14. `ent_resp_name` VARCHAR(64) NULL COMMENT '企业法人',
  15. `ent_contact_name` VARCHAR(64) NULL COMMENT '企业联系人',
  16. `ent_contact_phone` VARCHAR(64) NULL COMMENT '企业联系电话',
  17. `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  18. PRIMARY KEY `pk_id` (`info_id`) USING BTREE,
  19. KEY `idx_eid` (`ent_id`) USING BTREE
  20. ) ENGINE = InnoDB
  21. DEFAULT CHARSET = utf8mb4
  22. COLLATE = utf8mb4_general_ci
  23. ROW_FORMAT = DYNAMIC COMMENT ='企业合同信息';
  24. -- ----------------------------
  25. -- Records of sys_ent_cont_info
  26. -- ----------------------------
  27. BEGIN;
  28. COMMIT;
  29. SET FOREIGN_KEY_CHECKS = 1;