21wm_agent_comp_doc.sql 1.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041
  1. USE `cnbg_20240511_001`;
  2. SET NAMES utf8mb4;
  3. SET FOREIGN_KEY_CHECKS = 0;
  4. -- ----------------------------
  5. -- Table structure for wm_agent_comp_doc
  6. -- ----------------------------
  7. DROP TABLE IF EXISTS `wm_agent_comp_doc`;
  8. CREATE TABLE `wm_agent_comp_doc`
  9. (
  10. `doc_id` BIGINT UNSIGNED AUTO_INCREMENT NOT NULL COMMENT '主键ID',
  11. `dept_id` INT NOT NULL COMMENT '代理商ID',
  12. `emp_book` JSON COMMENT '员工规范手册',
  13. `ctrl_sys_manu` JSON COMMENT '内部控制制度手册',
  14. `inter_audit_doc` JSON COMMENT '内部审计文件',
  15. `comp_mant_sys` JSON COMMENT '合规制度管理',
  16. `anti_corr_bri_sys` JSON COMMENT '反腐败和反贿赂制度',
  17. `emp_man_sys` JSON COMMENT '员工招待管理制度',
  18. `comp_commit_let` JSON COMMENT '合规承诺函',
  19. `inner_train_doc` JSON COMMENT '内部合规培训材料',
  20. `create_by` VARCHAR(64) NOT NULL COMMENT '创建人',
  21. `update_by` VARCHAR(64) NOT NULL COMMENT '修改人',
  22. `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  23. `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  24. PRIMARY KEY `pk_id` (`doc_id`),
  25. UNIQUE KEY `uk_did` (`dept_id`)
  26. ) ENGINE = InnoDB
  27. DEFAULT CHARSET = utf8mb4
  28. COLLATE = utf8mb4_general_ci
  29. ROW_FORMAT = DYNAMIC COMMENT ='服务商合规文件';
  30. -- ----------------------------
  31. -- Records of wm_agent_comp_doc
  32. -- ----------------------------
  33. BEGIN;
  34. COMMIT;
  35. SET FOREIGN_KEY_CHECKS = 1;