一个简洁设计系统参数表结构

系统参数表 --PRM_ENUM_ID枚举值，可以保存数组-- Create tablecreate table SYS_PARAM_TAB(  PRM_NAME    VARCHAR2(60) not null,  PRM_ENUM_ID VARCHAR2(10) not null,  PRM_CN_NAME VARCHAR2(1800),  PRM_VALUE   VARCHAR2(1600),  PRM_REMARK  VARCHAR2(255),  PRM_STATUS  VARCHAR2(1) default '0' not null,  CREATE_DATE DATE default SYSDATE not null,  CREATE_BY   VARCHAR2(20) default '999999' not null);-- Add comments to the table comment on table SYS_PARAM_TAB  is 'RSS系统参数表';-- Add comments to the columns comment on column SYS_PARAM_TAB.PRM_NAME  is '参数名称';comment on column SYS_PARAM_TAB.PRM_ENUM_ID  is '参数枚举编号';comment on column SYS_PARAM_TAB.PRM_CN_NAME  is '参数中文涵义';comment on column SYS_PARAM_TAB.PRM_VALUE  is '参数数值';comment on column SYS_PARAM_TAB.PRM_REMARK  is '参数备注';comment on column SYS_PARAM_TAB.PRM_STATUS  is '参数状态，0-正常 1-审核未通过 2-待审核';comment on column SYS_PARAM_TAB.CREATE_DATE  is '创建日期';comment on column SYS_PARAM_TAB.CREATE_BY  is '创建人';-- Create/Recreate primary, unique and foreign key constraints alter table SYS_PARAM_TAB  add constraint PK_SYS_PARAM_TAB primary key (PRM_NAME, PRM_ENUM_ID);-- Grant/Revoke object privileges grant select, insert, update, delete on SYS_PARAM_TAB to PUBDSG;grant select, insert, update, delete on SYS_PARAM_TAB to R_RSSDATA_DML;grant select on SYS_PARAM_TAB to R_RSSDATA_QRY;