sys_user.pdc

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

-- Create table
create table SYS_USER
(
  USER_ID           NUMBER(10) not null,
  USER_CODE         VARCHAR2(20) not null,
  FIRSTNAME         VARCHAR2(30),
  LASTNAME          VARCHAR2(30),
  PASSWORD          VARCHAR2(20),
  EMAIL             VARCHAR2(50),
  DATACLEARANCE_ID  NUMBER(10),
  APPGROUP_ID       NUMBER(10),
  CUSTGROUP_ID      NUMBER(10),
  PRODGROUP_ID      NUMBER(10),
  VENDGROUP_ID      NUMBER(10),
  USERSTATUS_CODE   VARCHAR2(20),
  UPDATEDATE        DATE,
  UPDATEBYUSER_CODE VARCHAR2(20),
  PWLASTCHANGEDDATE DATE
)
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_USER
  add primary key (USER_CODE)
  using index 
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table SYS_USER
  add unique (USER_ID)
  using index 
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate indexes 
create index IDX_USER_1 on SYS_USER (USERSTATUS_CODE, PRODGROUP_ID)
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );