canna-cloud【九】系统参数设计

系统参数，存储值为key-value的数据结构，设计E-R图如下：

相应的建表语句：

 drop table canna_base_configure;

/*==============================================================*/
/* Table: canna_base_configure                                  */
/*==============================================================*/
create table canna_base_configure (
   id                   serial8              not null,
   param_key            character varying(64) null,
   param_value          text                 null,
   param_status         character varying(32) null,
   description          character varying(255) null,
   create_time          timestamp            null,
   constraint PK_CANNA_BASE_CONFIGURE primary key (id)
);

comment on table canna_base_configure is
'系统参数配置';

comment on column canna_base_configure.id is
'ID';

comment on column canna_base_configure.param_key is
'参数';

comment on column canna_base_configure.param_value is
'参数值';

comment on column canna_base_configure.param_status is
'参数状态';

comment on column canna_base_configure.description is
'参数描述';

comment on column canna_base_configure.create_time is
'创建时间';