sys_feature_parameter.pdc

用C＃开发的一套数据仓库的代码。（C＃＋ORACLE）

-- Create table
create table SYS_FEATURE_PARAMETER
(
  FEATUREPARAMETER_KEY  NUMBER(20) not null,
  APP_CODE              VARCHAR2(20) not null,
  FEATURE_ID            NUMBER(10) not null,
  PAGEPARAMETER_VKEY    VARCHAR2(21) not null,
  VALUE                 VARCHAR2(100) default ' ' not null,
  LOOKUP_ENABLED        VARCHAR2(1) default 'Y' not null,
  UPDATE_ENABLED        VARCHAR2(1) default 'Y' not null,
  LOOKUP_UPDATE_ENABLED VARCHAR2(1) default 'Y' not null,
  UPDATEDATE            DATE default SYSDATE not null,
  UPDATEBYUSER_CODE     VARCHAR2(20) default ' ' not null
)
tablespace SYSINFO
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints 
alter table SYS_FEATURE_PARAMETER
  add constraint PK_SYS_FEATURE_PARAMETER primary key (FEATUREPARAMETER_KEY)
  using index 
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );