新建字典表：
drop table T_BUS_PARAMETER cascade constraints;
/*==============================================================*/
/* Table: T_BUS_PARAMETER */
/*==============================================================*/
create table T_BUS_PARAMETER
(
S_PMAPPNAME VARCHAR2(400) not null,
S_PMNAME VARCHAR2(400) not null,
S_PMVALUE VARCHAR2(4000),
S_PMV2 VARCHAR2(4000),
S_PMV3 VARCHAR2(4000),
S_PMV4 VARCHAR2(4000),
S_PMV5 VARCHAR2(4000),
N_SORTORDER NUMBER default 0,
S_PMDESC VARCHAR2(1000),
S_STATUS VARCHAR2(200) default 'Y' not null,
S_INSMAN VARCHAR2(200),
D_INSDATE DATE default SYSDATE,
S_LASTUPDMAN VARCHAR2(200),
S_LASTUPDDATE DATE,
constraint PK_BUS_PARAMETER_001 primary key (S_PMAPPNAME, S_PMNAME)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
comment on table T_BUS_PARAMETER is
'参数表';
comment on column T_BUS_PARAMETER.S_PMAPPNAME is
'分类名称';
comment on column T_BUS_PARAMETER.S_PMNAME is
'项名';
comment on column T_BUS_PARAMETER.S_PMVALUE is
'项值';
comment on column T_BUS_PARAMETER.S_PMV2 is
'值2';
comment on column T_BUS_PARAMETER.S_PMV3 is
'值3';
comment on column T_BUS_PARAMETER.S_PMV4 is
'值4';
comment on column T_BUS_PARAMETER.S_PMV5 is
'值5';
comment on column T_BUS_PARAMETER.N_SORTORDER is
'排序';
comment on column T_BUS_PARAMETER.S_PMDESC is
'说明';
comment on column T_BUS_PARAMETER.S_STATUS is
'数据有效状态，Y有效，N无效';
comment on column T_BUS_PARAMETER.S_INSMAN is
'创建人';
comment on column T_BUS_PARAMETER.D_INSDATE is
'创建时间';
comment on column T_BUS_PARAMETER.S_LASTUPDMAN is
'最后一次修改人';
comment on column T_BUS_PARAMETER.S_LASTUPDDATE is
'最后一次修改时间';
insert into NJ_ZHFW.T_BUS_PARAMETER (s_pmappname,s_pmname,s_pmvalue,n_sortorder,s_status) values ('RELEASE_STATUS','RELEASE_STATUS','发布状态','0','Y');
insert into NJ_ZHFW.T_BUS_PARAMETER (s_pmappname,s_pmname,s_pmvalue,n_sortorder,s_status) values ('RELEASE_STATUS','Y','已发布','1','Y');
insert into NJ_ZHFW.T_BUS_PARAMETER (s_pmappname,s_pmname,s_pmvalue,n_sortorder,s_status) values ('RELEASE_STATUS','N','未发布','2','Y');