sys_log_activity.pdc

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

-- Create table
create table SYS_LOG_ACTIVITY
(
  ACTIVITY_KEY        NUMBER(20) not null,
  ACTIVITYDATE        DATE,
  USER_CODE           VARCHAR2(50),
  APP_CODE            VARCHAR2(50),
  ACTIVITYTYPE_CODE   VARCHAR2(50),
  ACTIVITYSTATUS_CODE VARCHAR2(50),
  ACTIVITYNOTE        VARCHAR2(200),
  RETURN_ID           NUMBER(15)
)
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_LOG_ACTIVITY
  add constraint PK_SYS_LOG_ACTIVITY primary key (ACTIVITY_KEY)
  using index 
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );