persagy-dmp-doc/SQL/dic.ddl.sql

##数据字典表
# 字典类型
DROP TABLE IF EXISTS `dic_dt_type`;
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_user varchar(40) null,
    update_time timestamp null,
    update_user varchar(40) null,
    remark varchar(200) null
) comment '字典类型';

# 字典数据
DROP TABLE IF EXISTS `dic_dt_data`;
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_user varchar(40) null,
    update_time timestamp null,
    update_user varchar(40) null,
    remark varchar(200) null
) comment '字典数据';

# 字典数据映射
DROP TABLE IF EXISTS `dic_dt_data_map`;
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_user varchar(40) null,
    update_time timestamp null,
    update_user varchar(40) null,
    remark varchar(200) null
) comment '字典数据映射';

# 知识库类型
DROP TABLE IF EXISTS `dic_kl_type`;
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_user varchar(40) null,
    update_time timestamp null,
    update_user varchar(40) null,
    remark varchar(200) null
) comment '知识库类型';

# 知识库数据
DROP TABLE IF EXISTS `dic_kl_data`;
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_user varchar(40) null,
    update_time timestamp null,
    update_user varchar(40) null,
    remark varchar(200) null
) comment '知识库数据';