sys_page_parameter.pdc

来自「用C＃开发的一套数据仓库的代码。（C＃＋ORACLE）」· PDC 代码 · 共 39 行

-- Create table
create table SYS_PAGE_PARAMETER
(
  PAGEPARAMETER_VKEY  VARCHAR2(21) not null,
  PAGE_ID             NUMBER(10) not null,
  PAGEPARAMETERNUMBER NUMBER(10) not null,
  PAGEPARAMETERDESC   VARCHAR2(200),
  REFERENCESOURCE     VARCHAR2(30),
  REFERENCE_CODE      VARCHAR2(20),
  REFERENCEUI         VARCHAR2(30),
  UPDATEDATE          DATE,
  UPDATEBYUSER_CODE   VARCHAR2(20),
  UICOMPONENT_TYPE    VARCHAR2(4) default 'ASP' 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_PAGE_PARAMETER
  add constraint PK_SYS_PAGE_PARAMETER primary key (PAGEPARAMETER_VKEY)
  using index 
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );