3sys_dept_csm.sql 1.0 KB

123456789101112131415161718192021222324252627282930
  1. USE hnqzx;
  2. SET NAMES utf8mb4;
  3. SET FOREIGN_KEY_CHECKS = 0;
  4. -- ----------------------------
  5. -- Table structure for sys_dept_csm
  6. -- ----------------------------
  7. DROP TABLE IF EXISTS `sys_dept_csm`;
  8. CREATE TABLE `sys_dept_csm`
  9. (
  10. `rec_id` INT(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  11. `dept_id` INT(20) NOT NULL COMMENT '企业id',
  12. `wl_qrcode_id` VARCHAR(32) NOT NULL COMMENT '绑定的智能码 id',
  13. `corp_id` VARCHAR(32) NOT NULL COMMENT '企业id',
  14. `csm_name` VARCHAR(32) NOT NULL COMMENT '客户成功姓名',
  15. `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  16. `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  17. PRIMARY KEY (`rec_id`) USING BTREE,
  18. INDEX `idx_dept_id` (`dept_id`) USING BTREE
  19. ) ENGINE = InnoDB
  20. DEFAULT CHARSET = utf8mb4 COMMENT ='企业csm表';
  21. -- ----------------------------
  22. -- Records of sys_dept_csm
  23. -- ----------------------------
  24. BEGIN;
  25. COMMIT;
  26. SET FOREIGN_KEY_CHECKS = 1;