系统数据字典模块设计

1.表设计

2.表SQL

 1 CREATE TABLE `sys_dictionaries` (
 2 `ZD_ID`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
 3 `NAME`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
 4 `BIANMA`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
 5 `ORDY_BY`  int(10) NULL DEFAULT NULL ,
 6 `PARENT_ID`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
 7 `JB`  int(10) NULL DEFAULT NULL ,
 8 `P_BM`  varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
 9 PRIMARY KEY (`ZD_ID`)
10 )
11 ENGINE=InnoDB    
12 DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
13 ROW_FORMAT=COMPACT;

3.表字段说明

ZD_ID 唯一标识

NAME标识名称

BIANMA标识ID

ORDY_BY排序

PARENT_ID父级标识

JB级别

P_BM 父子级拼接标识

4.统一查询接口

5.统一查询接口SQL

 1 SELECT
 2     sd.`NAME`,
 3     sd.BIANMA
 4 FROM
 5     sys_dictionaries sd
 6 WHERE
 7     sd.PARENT_ID IN (
 8         SELECT
 9             d.ZD_ID
10         FROM
11             sys_dictionaries d
12         WHERE
13             d.P_BM = 'BILL_STATUS'
14     ) ;