create table NIFM_TARGET_FIELD
(
FIELD_SEQ NUMBER not null,
CATEGORY_ID NUMBER,
FIELD_MANDATORY VARCHAR2(5),
FIELD_EDITABLE VARCHAR2(5),
TARGET_TABLE VARCHAR2(10),
DERIVE_ORDER NUMBER not null,
DERIVE_RULE VARCHAR2(4000),
FIELD_NAME VARCHAR2(50),
USE_EXISTEDDATA VARCHAR2(5),
EXCEL_DERIVE_RULE VARCHAR2(4000)
)
tablespace TS_DATA_2
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 2M
next 2M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table NIFM_TARGET_FIELD
add constraint NIFM_TARGET_FIELD_PK primary key (FIELD_SEQ)
using index
tablespace TS_INDEXES_2
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 2M
next 2M
minextents 1
maxextents unlimited
pctincrease 0
);
alter table NIFM_TARGET_FIELD
add constraint NIFM_TARGET_FIELD_UK unique (CATEGORY_ID, FIELD_NAME, TARGET_TABLE)
using index
tablespace TS_DATA_1
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 2M
next 2M
minextents 1
maxextents unlimited
pctincrease 0
);
alter table NIFM_TARGET_FIELD
add constraint NIFM_TARGET_FIELD_CAT_FK foreign key (CATEGORY_ID)
references NIFM_MSG_CATEGORY (CATEGORY_ID) on delete cascade;
(
FIELD_SEQ NUMBER not null,
CATEGORY_ID NUMBER,
FIELD_MANDATORY VARCHAR2(5),
FIELD_EDITABLE VARCHAR2(5),
TARGET_TABLE VARCHAR2(10),
DERIVE_ORDER NUMBER not null,
DERIVE_RULE VARCHAR2(4000),
FIELD_NAME VARCHAR2(50),
USE_EXISTEDDATA VARCHAR2(5),
EXCEL_DERIVE_RULE VARCHAR2(4000)
)
tablespace TS_DATA_2
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 2M
next 2M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table NIFM_TARGET_FIELD
add constraint NIFM_TARGET_FIELD_PK primary key (FIELD_SEQ)
using index
tablespace TS_INDEXES_2
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 2M
next 2M
minextents 1
maxextents unlimited
pctincrease 0
);
alter table NIFM_TARGET_FIELD
add constraint NIFM_TARGET_FIELD_UK unique (CATEGORY_ID, FIELD_NAME, TARGET_TABLE)
using index
tablespace TS_DATA_1
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 2M
next 2M
minextents 1
maxextents unlimited
pctincrease 0
);
alter table NIFM_TARGET_FIELD
add constraint NIFM_TARGET_FIELD_CAT_FK foreign key (CATEGORY_ID)
references NIFM_MSG_CATEGORY (CATEGORY_ID) on delete cascade;