sys_calculator.pdc

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

-- Create table
create table SYS_CALCULATOR
(
  CALC_ID           NUMBER(10) not null,
  CALCDESC          VARCHAR2(200),
  CALCGROUP_ID      NUMBER(10),
  CALCFILENAME      VARCHAR2(200),
  CALCPURPOSE       VARCHAR2(200),
  CALCTYPE_ID       NUMBER(10),
  CALCVERSION       NUMBER(10),
  CALCSTATUS_CODE   VARCHAR2(20),
  CALCUSERS         VARCHAR2(200),
  UPDATEDATE        DATE,
  UPDATEBYUSER_CODE VARCHAR2(20),
  FILE_CONTENT      BLOB
)
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_CALCULATOR
  add constraint PK_SYS_CALCULATOR primary key (CALC_ID)
  using index 
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );