kyj-yanglao-end-new/sql/mysql/notice.sql

DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '须知类型：APPOINTMENT或者VISIT',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '须知内容',
  `tenant_id` bigint(20) NULL DEFAULT NULL COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_type`(`type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '须知表' ROW_FORMAT = Dynamic;