123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384 |
- ##数据字典表
- # 字典类型
- create table dic_dt_type
- (
- id varchar(20) not null primary key ,
- group_code varchar(20) null,
- type varchar(40) not null,
- name varchar(40) not null,
- description varchar(200) null,
- status int not null,
- create_time timestamp null,
- create_by varchar(40) null,
- update_time timestamp null,
- update_by varchar(40) null,
- remark varchar(200) null
- );
- # 字典数据
- create table dic_dt_data
- (
- id varchar(20) not null primary key ,
- dict_type_id varchar(20) not null,
- parent_id varchar(20) null,
- type varchar(40) not null,
- code varchar(40) not null,
- label varchar(40) not null,
- status int not null,
- create_time timestamp null,
- create_by varchar(40) null,
- update_time timestamp null,
- update_by varchar(40) null,
- remark varchar(200) null
- );
- # 字典数据映射
- create table dic_dt_data_map
- (
- id varchar(20) not null primary key ,
- dict_data_id varchar(20) not null,
- type varchar(40) not null,
- group_code varchar(20) not null,
- target_code varchar(20) not null,
- label varchar(40) not null,
- code varchar(40) not null,
- status int not null,
- create_time timestamp null,
- create_by varchar(40) null,
- update_time timestamp null,
- update_by varchar(40) null,
- remark varchar(200) null
- );
- # 知识库类型
- create table dic_kl_type
- (
- id varchar(20) not null primary key ,
- code varchar(40) not null,
- name varchar(40) not null,
- description varchar(500) null,
- status int not null,
- create_time timestamp null,
- create_by varchar(40) null,
- update_time timestamp null,
- update_by varchar(40) null,
- remark varchar(200) null
- );
- # 知识库数据
- create table dic_kl_data
- (
- id varchar(20) not null primary key ,
- kl_type_code varchar(20) not null,
- kl_type_name varchar(40) not null,
- parent_id varchar(20) null,
- code varchar(40) not null,
- label varchar(40) not null,
- value varchar(500) null,
- status int not null,
- create_time timestamp null,
- create_by varchar(40) null,
- update_time timestamp null,
- update_by varchar(40) null,
- remark varchar(200) null
- );
|