sys_appgroup_feature.pdc

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

-- Create table
create table SYS_APPGROUP_FEATURE
(
  APPGROUPFEATURE_KEY NUMBER(20) not null,
  APPGROUP_ID         NUMBER(10) not null,
  APP_CODE            VARCHAR2(20) not null,
  APPFEATURE_CODE     VARCHAR2(20),
  VIEW_ENABLED        VARCHAR2(1) default 'N' not null,
  APPEND_ENABLED      VARCHAR2(1) default 'N' not null,
  UPDATE_ENABLED      VARCHAR2(1) default 'N' not null,
  DELETE_ENABLED      VARCHAR2(1) default 'N' not null,
  EXPORT_ENABLED      VARCHAR2(1) default 'N' not null,
  ISVALID             VARCHAR2(1) default 'Y' not null,
  UPDATEDATE          DATE,
  UPDATEBYUSER_CODE   VARCHAR2(20)
)
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_APPGROUP_FEATURE
  add constraint PK_SYS_APPGROUP_FEATURE primary key (APPGROUPFEATURE_KEY)
  using index 
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate indexes 
create index SYS_APPGROUP_FEATURE_N1 on SYS_APPGROUP_FEATURE (APPFEATURE_CODE)
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 48K
    minextents 1
    maxextents unlimited
  );