December 11, 2015 at 12:33 pm
here is the query pls help
CREATE TABLE "PREFCOMM"."T_SERVICE_EVENT"
("SERVICE_EVENT_CD" VARCHAR2(5) NOT NULL ENABLE,
"DEFAULT_CONTACT_METHOD_CD" VARCHAR2(5) NOT NULL ENABLE,
"SERVICE_EVENT_DESC" VARCHAR2(200),
"SERVICE_EVENT_NAME" VARCHAR2(20),
"RECORD_STAT" VARCHAR2(1) NOT NULL ENABLE,
"CREATED_BY" VARCHAR2(100) NOT NULL ENABLE,
"CREATED_DT" TIMESTAMP (6) NOT NULL ENABLE,
"MODIFIED_BY" VARCHAR2(100),
"MODIFIED_DT" TIMESTAMP (6),
CONSTRAINT "PK_SERVICE_EVENT" PRIMARY KEY ("SERVICE_EVENT_CD")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA" ENABLE,
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,
CONSTRAINT "FK_SERVICE_EVENT" FOREIGN KEY ("DEFAULT_CONTACT_METHOD_CD")
REFERENCES "PREFCOMM"."T_CONTACT_METHOD" ("CONTACT_METHOD_CD") ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA";
CREATE TABLE "PREFCOMM"."T_CONTACT_METHOD"
("CONTACT_METHOD_CD" VARCHAR2(5) NOT NULL ENABLE,
"CONTACT_METHOD_DESC" VARCHAR2(100) NOT NULL ENABLE,
"RECORD_STAT" VARCHAR2(1) NOT NULL ENABLE,
"CREATED_BY" VARCHAR2(100) NOT NULL ENABLE,
"CREATED_DT" TIMESTAMP (6) NOT NULL ENABLE,
"MODIFIED_BY" VARCHAR2(100),
"MODIFIED_DT" TIMESTAMP (6),
CONSTRAINT "PK_CONTACT_METHOD" PRIMARY KEY ("CONTACT_METHOD_CD")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA" ENABLE,
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA";
CREATE TABLE "PREFCOMM"."T_BILLING_SYSTEM"
("BILLING_SYSTEM_CD" VARCHAR2(5) NOT NULL ENABLE,
"BILLING_SYSTEM_NAME" VARCHAR2(30),
"RECORD_STAT" VARCHAR2(1) NOT NULL ENABLE,
"CREATED_BY" VARCHAR2(100) NOT NULL ENABLE,
"CREATED_DT" TIMESTAMP (6) NOT NULL ENABLE,
"MODIFIED_BY" VARCHAR2(100),
"MODIFIED_DT" TIMESTAMP (6),
CONSTRAINT "PK_BILLING_SYSTEM" PRIMARY KEY ("BILLING_SYSTEM_CD")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA" ENABLE,
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA";
CREATE TABLE "PREFCOMM"."T_CONTACT"
("CONTACT_ID" NUMBER(38,0) NOT NULL ENABLE,
"ROLE_CD" VARCHAR2(5) NOT NULL ENABLE,
"PREF_ACCOUNT_ID" NUMBER(38,0) NOT NULL ENABLE,
"USER_NAME" VARCHAR2(100),
"RECORD_STAT" VARCHAR2(1) NOT NULL ENABLE,
"CREATED_BY" VARCHAR2(100) NOT NULL ENABLE,
"CREATED_DT" TIMESTAMP (6) NOT NULL ENABLE,
"MODIFIED_BY" VARCHAR2(100),
"MODIFIED_DT" TIMESTAMP (6),
"NAME_ID" NUMBER(12,0),
CONSTRAINT "PK_CONTACT" PRIMARY KEY ("CONTACT_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA" ENABLE,
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,
SUPPLEMENTAL LOG DATA (ALL) COLUMNS,
CONSTRAINT "FK_CONTACT1" FOREIGN KEY ("ROLE_CD")
REFERENCES "PREFCOMM"."T_CONTACT_ROLE" ("ROLE_CD") ENABLE,
CONSTRAINT "FK_CONTACT" FOREIGN KEY ("PREF_ACCOUNT_ID")
REFERENCES "PREFCOMM"."T_PREF_ACCOUNT" ("PREF_ACCOUNT_ID") ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA";
CREATE TABLE "PREFCOMM"."T_CONTACT_DATA"
("CONTACT_DATA_ID" NUMBER(38,0) NOT NULL ENABLE,
"CONTACT_TYPE_CD" VARCHAR2(5) NOT NULL ENABLE,
"CONTACT_ID" NUMBER(38,0) NOT NULL ENABLE,
"CONTACT_VAL" VARCHAR2(100),
"OPTIN_PREF" VARCHAR2(1) NOT NULL ENABLE,
"SMS_CAPABLE" VARCHAR2(1) NOT NULL ENABLE,
"CONTACT_VALID" VARCHAR2(1) NOT NULL ENABLE,
"INVALID_REASON" VARCHAR2(200),
"PROTECTED_FLAG" VARCHAR2(1),
"RECORD_STAT" VARCHAR2(1) NOT NULL ENABLE,
"CREATED_BY" VARCHAR2(100) NOT NULL ENABLE,
"CREATED_DT" TIMESTAMP (6) NOT NULL ENABLE,
"MODIFIED_BY" VARCHAR2(100),
"MODIFIED_DT" TIMESTAMP (6),
"IN_IDM_FLAG" VARCHAR2(1),
CONSTRAINT "PK_CONTACT_DATA" PRIMARY KEY ("CONTACT_DATA_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA" ENABLE,
CONSTRAINT "T_CONTACT_DATA_UK1" UNIQUE ("CONTACT_ID", "CONTACT_TYPE_CD")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA" ENABLE,
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,
CONSTRAINT "FK_CONTACT_DATA" FOREIGN KEY ("CONTACT_TYPE_CD")
REFERENCES "PREFCOMM"."T_CONTACT_TYPE" ("CONTACT_TYPE_CD") ENABLE,
CONSTRAINT "FK_CONTACT_DATA1" FOREIGN KEY ("CONTACT_ID")
REFERENCES "PREFCOMM"."T_CONTACT" ("CONTACT_ID") ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA";
CREATE TABLE "PREFCOMM"."T_CONTACT_DATA_HISTORY"
("CONTACT_DATA_HISTORY_ID" NUMBER(38,0) NOT NULL ENABLE,
"PREF_ACCOUNT_ID" NUMBER(38,0) NOT NULL ENABLE,
"CONTACT_DATA_ID" NUMBER(38,0),
"USER_NAME" VARCHAR2(100),
"CONTACT_VAL" VARCHAR2(100),
"ROLE_CD" VARCHAR2(5) NOT NULL ENABLE,
"BILLING_SYSTEM_CD" VARCHAR2(5) NOT NULL ENABLE,
"ACCOUNT_NUMBER" VARCHAR2(30) NOT NULL ENABLE,
"CONTACT_ID" NUMBER(38,0) NOT NULL ENABLE,
"LANGUAGE_CD" VARCHAR2(5) NOT NULL ENABLE,
"INVALID_REASON" VARCHAR2(200),
"PROTECTED_FLAG" VARCHAR2(1),
"OPTIN_PREF" VARCHAR2(1),
"CONTACT_TYPE_CD" VARCHAR2(5),
"SMS_CAPABLE" VARCHAR2(1),
"CONTACT_VALID" VARCHAR2(1),
"RECORD_STAT" VARCHAR2(1) NOT NULL ENABLE,
"CREATED_BY" VARCHAR2(100) NOT NULL ENABLE,
"CREATED_DT" TIMESTAMP (6) NOT NULL ENABLE,
"MODIFIED_BY" VARCHAR2(100),
"MODIFIED_DT" TIMESTAMP (6),
"OPER_PERF" VARCHAR2(1),
"IN_IDM_FLAG" VARCHAR2(1),
CONSTRAINT "PK_CONTACT_DATA_HISTORY" PRIMARY KEY ("CONTACT_DATA_HISTORY_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA" ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA";
CREATE TABLE "PREFCOMM"."T_CONTACT_TYPE"
("CONTACT_TYPE_CD" VARCHAR2(5) NOT NULL ENABLE,
"CONTACT_TYPE_DESC" VARCHAR2(20) NOT NULL ENABLE,
"RECORD_STAT" VARCHAR2(1) NOT NULL ENABLE,
"CREATED_BY" VARCHAR2(100) NOT NULL ENABLE,
"CREATED_DT" TIMESTAMP (6) NOT NULL ENABLE,
"MODIFIED_BY" VARCHAR2(100),
"MODIFIED_DT" TIMESTAMP (6),
"CONTACT_TYPE" VARCHAR2(50),
CONSTRAINT "PK_CONTACT_TYPE" PRIMARY KEY ("CONTACT_TYPE_CD")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA" ENABLE,
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA";
CREATE TABLE "PREFCOMM"."T_PREF_ACCOUNT"
("PREF_ACCOUNT_ID" NUMBER(38,0) NOT NULL ENABLE,
"BILLING_SYSTEM_CD" VARCHAR2(5) NOT NULL ENABLE,
"LANGUAGE_CD" VARCHAR2(5),
"ACCOUNT_NUMBER" VARCHAR2(30) NOT NULL ENABLE,
"RECORD_STAT" VARCHAR2(1) NOT NULL ENABLE,
"CREATED_BY" VARCHAR2(100) NOT NULL ENABLE,
"CREATED_DT" TIMESTAMP (6) NOT NULL ENABLE,
"MODIFIED_BY" VARCHAR2(100),
"MODIFIED_DT" TIMESTAMP (6),
"ACCOUNT_ID" NUMBER(12,0),
CONSTRAINT "PK_PREF_ACCOUNT" PRIMARY KEY ("PREF_ACCOUNT_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA" ENABLE,
CONSTRAINT "T_PREF_ACCOUNT" UNIQUE ("ACCOUNT_NUMBER", "BILLING_SYSTEM_CD")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA" ENABLE,
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,
CONSTRAINT "FK_PREF_ACCOUNT" FOREIGN KEY ("BILLING_SYSTEM_CD")
REFERENCES "PREFCOMM"."T_BILLING_SYSTEM" ("BILLING_SYSTEM_CD") ENABLE,
CONSTRAINT "FK_PREF_ACCOUNT1" FOREIGN KEY ("LANGUAGE_CD")
REFERENCES "PREFCOMM"."T_LANGUAGE_TYPE" ("LANGUAGE_CD") ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA";
CREATE TABLE "PREFCOMM"."T_UI_APPL"
("UI_APPL_CD" VARCHAR2(5) NOT NULL ENABLE,
"APPLICATION_NAME" VARCHAR2(100),
"RECORD_STAT" VARCHAR2(1) NOT NULL ENABLE,
"CREATED_BY" VARCHAR2(100) NOT NULL ENABLE,
"CREATED_DT" TIMESTAMP (6) NOT NULL ENABLE,
"MODIFIED_BY" VARCHAR2(100),
"MODIFIED_DT" TIMESTAMP (6),
CONSTRAINT "PK_UI_APPL" PRIMARY KEY ("UI_APPL_CD")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA" ENABLE,
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA";
CREATE TABLE "PREFCOMM"."T_LANGUAGE_TYPE"
("LANGUAGE_CD" VARCHAR2(5) NOT NULL ENABLE,
"LANGUAGE_DESC" VARCHAR2(20),
"RECORD_STAT" VARCHAR2(1) NOT NULL ENABLE,
"CREATED_BY" VARCHAR2(100) NOT NULL ENABLE,
"CREATED_DT" TIMESTAMP (6) NOT NULL ENABLE,
"MODIFIED_BY" VARCHAR2(100),
"MODIFIED_DT" TIMESTAMP (6),
CONSTRAINT "PK_LANGUAGE_TYPE" PRIMARY KEY ("LANGUAGE_CD")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA" ENABLE,
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA";
CREATE TABLE "PREFCOMM"."T_UI_EVENT_FAMILY"
("EVENT_FAMILY_ID" NUMBER NOT NULL ENABLE,
"UI_APPL_CD" VARCHAR2(5) NOT NULL ENABLE,
"SERVICE_EVENT_CD" VARCHAR2(5) NOT NULL ENABLE,
"RECO_CONTACT_METHOD_CD" VARCHAR2(5) NOT NULL ENABLE,
"MANDATORY_STATUS" VARCHAR2(1),
"SEQUENCE_CD" VARCHAR2(5),
"RECORD_STAT" VARCHAR2(1) NOT NULL ENABLE,
"CREATED_BY" VARCHAR2(100) NOT NULL ENABLE,
"CREATED_DT" TIMESTAMP (6) NOT NULL ENABLE,
"MODIFIED_BY" VARCHAR2(100),
"MODIFIED_DT" TIMESTAMP (6),
CONSTRAINT "PK_UI_EVENT_FAMILY" PRIMARY KEY ("EVENT_FAMILY_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA" ENABLE,
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,
CONSTRAINT "FK_UI_EVENT_FAMILY" FOREIGN KEY ("UI_APPL_CD")
REFERENCES "PREFCOMM"."T_UI_APPL" ("UI_APPL_CD") ENABLE,
CONSTRAINT "FK_UI_EVENT_FAMILY1" FOREIGN KEY ("SERVICE_EVENT_CD")
REFERENCES "PREFCOMM"."T_SERVICE_EVENT" ("SERVICE_EVENT_CD") ENABLE,
CONSTRAINT "FK_UI_EVENT_FAMILY2" FOREIGN KEY ("RECO_CONTACT_METHOD_CD")
REFERENCES "PREFCOMM"."T_CONTACT_METHOD" ("CONTACT_METHOD_CD") ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA";
CREATE TABLE "PREFCOMM"."T_CONTACT_PREFERENCE_HISTORY"
("CONTACT_PREFERENCE_HISTORY_ID" NUMBER(38,0) NOT NULL ENABLE,
"CONTACT_PREFERENCE_ID" NUMBER(38,0) NOT NULL ENABLE,
"ROLE_CD" VARCHAR2(5) NOT NULL ENABLE,
"ACCOUNT_NUMBER" VARCHAR2(30) NOT NULL ENABLE,
"SERVICE_EVENT_CD" VARCHAR2(5),
"PREF_ACCOUNT_ID" NUMBER(38,0) NOT NULL ENABLE,
"CONTACT_DATA_ID" NUMBER(38,0),
"BILLING_SYSTEM_CD" VARCHAR2(5),
"CONTACT_METHOD_CD" VARCHAR2(5),
"CONTACT_TYPE_CD" VARCHAR2(5),
"DISABLED_FLAG" VARCHAR2(1) NOT NULL ENABLE,
"RECORD_STAT" VARCHAR2(1) NOT NULL ENABLE,
"CREATED_BY" VARCHAR2(100) NOT NULL ENABLE,
"CREATED_DT" TIMESTAMP (6) NOT NULL ENABLE,
"MODIFIED_BY" VARCHAR2(100),
"MODIFIED_DT" TIMESTAMP (6),
"OPER_PERF" VARCHAR2(1),
CONSTRAINT "PK_CONTACT_PREFERENCE_HISTORY" PRIMARY KEY ("CONTACT_PREFERENCE_HISTORY_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA" ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA";
CREATE TABLE "PREFCOMM"."T_CONTACT_ROLE"
("ROLE_CD" VARCHAR2(5) NOT NULL ENABLE,
"ROLE_DESC" VARCHAR2(100) NOT NULL ENABLE,
"RECORD_STAT" VARCHAR2(1) NOT NULL ENABLE,
"CREATED_BY" VARCHAR2(100) NOT NULL ENABLE,
"CREATED_DT" TIMESTAMP (6) NOT NULL ENABLE,
"MODIFIED_BY" VARCHAR2(100),
"MODIFIED_DT" TIMESTAMP (6),
CONSTRAINT "PK_CONTACT_ROLE" PRIMARY KEY ("ROLE_CD")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA" ENABLE,
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA";
CREATE TABLE "PREFCOMM"."T_EVENT_COMMN"
("EVENT_COMMN_ID" NUMBER NOT NULL ENABLE,
"SERVICE_EVENT_CD" VARCHAR2(5) NOT NULL ENABLE,
"UI_APPL_CD" VARCHAR2(5) NOT NULL ENABLE,
"APP_CONTACT_METHOD_CD" VARCHAR2(5) NOT NULL ENABLE,
"RECORD_STAT" VARCHAR2(1) NOT NULL ENABLE,
"CREATED_BY" VARCHAR2(100) NOT NULL ENABLE,
"CREATED_DT" TIMESTAMP (6) NOT NULL ENABLE,
"MODIFIED_BY" VARCHAR2(100),
"MODIFIED_DT" TIMESTAMP (6),
CONSTRAINT "PK_EVENT_COMMN" PRIMARY KEY ("EVENT_COMMN_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA" ENABLE,
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,
CONSTRAINT "FK_EVENT_COMMN" FOREIGN KEY ("SERVICE_EVENT_CD")
REFERENCES "PREFCOMM"."T_SERVICE_EVENT" ("SERVICE_EVENT_CD") ENABLE,
CONSTRAINT "FK_EVENT_COMMN1" FOREIGN KEY ("UI_APPL_CD")
REFERENCES "PREFCOMM"."T_UI_APPL" ("UI_APPL_CD") ENABLE,
CONSTRAINT "FK_EVENT_COMMN2" FOREIGN KEY ("APP_CONTACT_METHOD_CD")
REFERENCES "PREFCOMM"."T_CONTACT_METHOD" ("CONTACT_METHOD_CD") ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA";
CREATE TABLE "PREFCOMM"."T_CONTACT_PREFERENCE"
("CONTACT_PREFERENCE_ID" NUMBER(38,0) NOT NULL ENABLE,
"CONTACT_DATA_ID" NUMBER(38,0),
"PREF_ACCOUNT_ID" NUMBER(38,0) NOT NULL ENABLE,
"CONTACT_METHOD_CD" VARCHAR2(5) NOT NULL ENABLE,
"SERVICE_EVENT_CD" VARCHAR2(5) NOT NULL ENABLE,
"DISABLED_FLAG" VARCHAR2(1),
"RECORD_STAT" VARCHAR2(1) NOT NULL ENABLE,
"CREATED_BY" VARCHAR2(100) NOT NULL ENABLE,
"CREATED_DT" TIMESTAMP (6) NOT NULL ENABLE,
"MODIFIED_BY" VARCHAR2(100),
"MODIFIED_DT" TIMESTAMP (6),
CONSTRAINT "PK_CONTACT_PREFERENCE" PRIMARY KEY ("CONTACT_PREFERENCE_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA" ENABLE,
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,
CONSTRAINT "FK_CONTACT_PREFERENCE1" FOREIGN KEY ("SERVICE_EVENT_CD")
REFERENCES "PREFCOMM"."T_SERVICE_EVENT" ("SERVICE_EVENT_CD") ENABLE,
CONSTRAINT "FK_CONTACT_PREFERENCE" FOREIGN KEY ("CONTACT_DATA_ID")
REFERENCES "PREFCOMM"."T_CONTACT_DATA" ("CONTACT_DATA_ID") ENABLE,
CONSTRAINT "FK_CONTACT_PREFERENCE2" FOREIGN KEY ("CONTACT_METHOD_CD")
REFERENCES "PREFCOMM"."T_CONTACT_METHOD" ("CONTACT_METHOD_CD") ENABLE,
CONSTRAINT "FK_CONTACT_PREFERENCE3" FOREIGN KEY ("PREF_ACCOUNT_ID")
REFERENCES "PREFCOMM"."T_PREF_ACCOUNT" ("PREF_ACCOUNT_ID") ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PREFCOMM_DATA";
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply