常用Web系统分析——常用辅助表

数据字典

保存数据的状态类型。

CREATE TABLE `crm_dict` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` varchar(50) NOT NULL DEFAULT '' COMMENT '类型',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '名称',
  `value` varchar(50) NOT NULL DEFAULT '' COMMENT '值',
  `order` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '排序',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_type_name` (`type`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='数据字典';

插入示例

INSERT `crm_dict` VALUES(NULL, "hotel_level", "A级", "A", "0");
INSERT `crm_dict` VALUES(NULL, "hotel_level", "B级", "B", "1");
INSERT `crm_dict` VALUES(NULL, "hotel_level", "C级", "C", "2");
INSERT `crm_dict` VALUES(NULL, "hotel_level", "D级", "D", "3");
INSERT `crm_dict` VALUES(NULL, "hotel_level", "E级", "E", "4");