HFM数据接口表创建脚本

HFM接口表创建脚本

-- Create table
create table CUX_HFM_INTERFACE_DATA
(
  scenario_code  VARCHAR2(255) not null,
  year_code      VARCHAR2(255) not null,
  period_code    VARCHAR2(255) not null,
  view_code      VARCHAR2(255) not null,
  entity_code    VARCHAR2(255) not null,
  value_code     VARCHAR2(255) not null,
  account_code   VARCHAR2(255) not null,
  icp_code       VARCHAR2(255) not null,
  c1_code        VARCHAR2(255) not null,
  c2_code        VARCHAR2(255) not null,
  c3_code        VARCHAR2(255) not null,
  c4_code        VARCHAR2(255) not null,
  c5_code        VARCHAR2(255) not null,
  c6_code        VARCHAR2(255) not null,
  c7_code        VARCHAR2(255) not null,
  c8_code        VARCHAR2(255) not null,
  c9_code        VARCHAR2(255) not null,
  c10_code       VARCHAR2(255) not null,
  c11_code       VARCHAR2(255) not null,
  c12_code       VARCHAR2(255) not null,
  datavalue      NUMBER not null,
  from_table     VARCHAR2(255) not null,
  from_comb      VARCHAR2(255),
  update_date    TIMESTAMP(6) not null,
  user_id        VARCHAR2(255) not null,
  from_module    VARCHAR2(255) not null,
  odi_session_id VARCHAR2(255) not null,
  l_id           VARCHAR2(255) not null,
  backup1        VARCHAR2(255),
  backup2        VARCHAR2(255),
  backup3        VARCHAR2(255),
  backup4        VARCHAR2(255),
  backup5        VARCHAR2(255),
  backup6        VARCHAR2(255),
  backup7        VARCHAR2(255),
  backup8        VARCHAR2(255),
  backup9        VARCHAR2(255),
  backup10       VARCHAR2(255)
)
tablespace HDM_DATA
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate indexes 
create index CUX_HFM_INTERFACE_DATA_N1 on CUX_HFM_INTERFACE_DATA (YEAR_CODE, PERIOD_CODE, ENTITY_CODE)
  tablespace HDM_DATA
  pctfree 0
  initrans 11
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints 
alter table CUX_HFM_INTERFACE_DATA
  add constraint CUX_HFM_INTERFACE_DATA_ID_PK primary key (L_ID)
  using index 
  tablespace HDM_DATA
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Grant/Revoke object privileges 
grant select, insert, update, delete on CUX_HFM_INTERFACE_DATA to HYHFM;