sys_vendgroup_vend.pdc

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

-- Create table
create table SYS_VENDGROUP_VEND
(
  VENDGROUPVEND_KEY NUMBER(10) not null,
  VENDGROUP_ID      NUMBER(10) not null,
  VEND_ID           NUMBER(10) not null,
  LOTNO_HDR         VARCHAR2(10) default '' not null,
  ISVALID           VARCHAR2(1) default 'Y' not null,
  UPDATE_DATE       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_VENDGROUP_VEND
  add constraint PK_VENDGROUP_VEND_01 primary key (VENDGROUPVEND_KEY)
  using index 
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table SYS_VENDGROUP_VEND
  add constraint IDX_VENDGROUP_VEND_01 unique (VENDGROUP_ID, VEND_ID, ISVALID)
  using index 
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );