canna-cloud【八】数据字典设计

数据字典设计。

结构：key-hashKey-hashValue，一般用于前端数据类型的展示，便于对经常变更的数据进行维护。

对应的在缓存中如redis的保存结构为：HashMap的格式

字典项为第一级，parent_code可以设置默认值：CANNA_PARENT

字典项中的详细记录列表，parent_code设置为字典项中的code进行关联。

drop index INDEX_CANNA_BASE_DICT_PARENT_CODE;

drop index INDEX_CANNA_BASE_DICT_CODE;

drop table canna_base_dict;

/*==============================================================*/
/* Table: canna_base_dict                                       */
/*==============================================================*/
create table canna_base_dict (
   id                   bigint               not null,
   code                 character varying(256) null,
   cn_name              character varying(256) null,
   en_name              character varying(32) null,
   value                character varying(1024) null,
   parent_code          character varying(32) null,
   status               character varying(32) null,
   remark               character varying(255) null,
   sort                 bigint               null,
   constraint PK_CANNA_BASE_DICT primary key (id)
);

comment on column canna_base_dict.id is
'ID';

comment on column canna_base_dict.code is
'字典编码';

comment on column canna_base_dict.cn_name is
'字典中文名';

comment on column canna_base_dict.en_name is
'字典英文名';

comment on column canna_base_dict.value is
'字典值';

comment on column canna_base_dict.parent_code is
'父节点编码';

comment on column canna_base_dict.status is
'字典状态';

comment on column canna_base_dict.remark is
'备注';

comment on column canna_base_dict.sort is
'顺序';

/*==============================================================*/
/* Index: INDEX_CANNA_BASE_DICT_CODE                            */
/*==============================================================*/
create  index INDEX_CANNA_BASE_DICT_CODE on canna_base_dict (
code
);

/*==============================================================*/
/* Index: INDEX_CANNA_BASE_DICT_PARENT_CODE                     */
/*==============================================================*/
create  index INDEX_CANNA_BASE_DICT_PARENT_CODE on canna_base_dict (
parent_code
);