t_personal_page.sql 1.7 KB

123456789101112131415161718192021222324252627
  1. SET NAMES utf8mb4;
  2. SET FOREIGN_KEY_CHECKS = 0;
  3. -- ----------------------------
  4. -- Table structure for t_personal_page
  5. -- ----------------------------
  6. DROP TABLE IF EXISTS `t_personal_page`;
  7. CREATE TABLE `t_personal_page` (
  8. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  9. `customer_id` bigint(20) NULL DEFAULT NULL COMMENT '客户id(会员id)',
  10. `customer` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户姓名',
  11. `stakeholder` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '干系人姓名',
  12. `stakeholder_birthday` datetime(0) NULL DEFAULT NULL COMMENT '干系人生日',
  13. `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像url',
  14. `template_id` int(11) NULL DEFAULT NULL COMMENT '个人页模板id',
  15. `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '个人页内容 富文本',
  16. `enable` int(1) NULL DEFAULT NULL COMMENT '启用 0正常,1停用',
  17. `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  18. `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  19. `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  20. `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  21. `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  22. PRIMARY KEY (`id`) USING BTREE
  23. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '个人页' ROW_FORMAT = Dynamic;
  24. SET FOREIGN_KEY_CHECKS = 1;