--RAU CK_APPLICATION_LOGIC_PK
alter table i$CK_APPLICATION_LOGIC
add constraint CK_APPLICATION_LOGIC_PK primary key (parent_ivid
, AL_ID
)
/
--RAU SDD_NLS_MESSAGES_RPK
alter table l$SDD_NLS_MESSAGES
add constraint SDD_NLS_MESSAGES_RPK primary key (ivid, lid)
/
--RAU SDD_NLS_PROMPTS_RPK
alter table l$SDD_NLS_PROMPTS
add constraint SDD_NLS_PROMPTS_RPK primary key (ivid, lid)
/
--RAU SDD_NLS_PROPLIST_ENTRIES_RPK
alter table l$SDD_NLS_PROPLIST_ENTRIES
add constraint SDD_NLS_PROPLIST_ENTRIES_RPK primary key (ivid, lid)
/
--RAU SDD_NLS_RESOURCES_RPK
alter table l$SDD_NLS_RESOURCES
add constraint SDD_NLS_RESOURCES_RPK primary key (ivid, lid)
/
--RAU SDD_PROPERTY_LISTS_RPK
alter table i$SDD_PROPERTY_LISTS
add constraint SDD_PROPERTY_LISTS_RPK primary key (ivid)
/
--RAU SDD_PROPLIST_ENTRIES_RPK
alter table i$SDD_PROPLIST_ENTRIES
add constraint SDD_PROPLIST_ENTRIES_RPK primary key (ivid)
/
--RAU SDD_WIDGETS_RPK
alter table i$SDD_WIDGETS
add constraint SDD_WIDGETS_RPK primary key (ivid)
/
--RAU PK_SDD_A1
alter table i$SDD_A1
add constraint PK_SDD_A1 primary key (parent_ivid
, IRID
)
/
--RAU UK_A1
alter table i$SDD_A1
add constraint UK_A1
unique (parent_ivid
, CSF_REF
)
deferrable initially deferred
/
--RAU PK_SDD_A10
alter table i$SDD_A10
add constraint PK_SDD_A10 primary key (parent_ivid
, IRID
)
/
--RAU UK_A10
alter table i$SDD_A10
add constraint UK_A10
unique (parent_ivid
, PROBLEM_REF
)
deferrable initially deferred
/
--RAU PK_SDD_A11
alter table i$SDD_A11
add constraint PK_SDD_A11 primary key (parent_ivid
, IRID
)
/
--RAU UK_A11
alter table i$SDD_A11
add constraint UK_A11
unique (parent_ivid
, FUNCTION_REF
)
deferrable initially deferred
/
--RAU PK_SDD_A2
alter table i$SDD_A2
add constraint PK_SDD_A2 primary key (parent_ivid
, IRID
)
/
--RAU UK_A2
alter table i$SDD_A2
add constraint UK_A2
unique (parent_ivid
, MODULE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_A20
alter table i$SDD_A20
add constraint PK_SDD_A20 primary key (parent_ivid
, IRID
)
/
--RAU UK_A20
alter table i$SDD_A20
add constraint UK_A20
unique (parent_ivid
, USE_OF_NODE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_A21
alter table i$SDD_A21
add constraint PK_SDD_A21 primary key (parent_ivid
, IRID
)
/
--RAU UK_A21
alter table i$SDD_A21
add constraint UK_A21
unique (parent_ivid
, NODE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_A23
alter table i$SDD_A23
add constraint PK_SDD_A23 primary key (parent_ivid
, IRID
)
/
--RAU UK_A23
alter table i$SDD_A23
add constraint UK_A23
unique (parent_ivid
, MODULE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_A24
alter table i$SDD_A24
add constraint PK_SDD_A24 primary key (parent_ivid
, IRID
)
/
--RAU UK_A24
alter table i$SDD_A24
add constraint UK_A24
unique (parent_ivid
, BUSINESS_UNIT_REF
)
deferrable initially deferred
/
--RAU PK_SDD_A3
alter table i$SDD_A3
add constraint PK_SDD_A3 primary key (parent_ivid
, IRID
)
/
--RAU UK_A3
alter table i$SDD_A3
add constraint UK_A3
unique (parent_ivid
, KPI_REF
)
deferrable initially deferred
/
--RAU PK_SDD_A4
alter table i$SDD_A4
add constraint PK_SDD_A4 primary key (parent_ivid
, IRID
)
/
--RAU UK_A4
alter table i$SDD_A4
add constraint UK_A4
unique (parent_ivid
, FUNCTION_REF
)
deferrable initially deferred
/
--RAU PK_SDD_A5
alter table i$SDD_A5
add constraint PK_SDD_A5 primary key (parent_ivid
, IRID
)
/
--RAU UK_A5
alter table i$SDD_A5
add constraint UK_A5
unique (parent_ivid
, MODULE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_A6
alter table i$SDD_A6
add constraint PK_SDD_A6 primary key (parent_ivid
, IRID
)
/
--RAU UK_A6
alter table i$SDD_A6
add constraint UK_A6
unique (parent_ivid
, TABLE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_A7
alter table i$SDD_A7
add constraint PK_SDD_A7 primary key (parent_ivid
, IRID
)
/
--RAU UK_A7
alter table i$SDD_A7
add constraint UK_A7
unique (parent_ivid
, MODULE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_A8
alter table i$SDD_A8
add constraint PK_SDD_A8 primary key (parent_ivid
, IRID
)
/
--RAU UK_A8
alter table i$SDD_A8
add constraint UK_A8
unique (parent_ivid
, OBJECTIVE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_A9
alter table i$SDD_A9
add constraint PK_SDD_A9 primary key (parent_ivid
, IRID
)
/
--RAU UK_A9
alter table i$SDD_A9
add constraint UK_A9
unique (parent_ivid
, BUSINESS_UNIT_REF
)
deferrable initially deferred
/
--RAU PK_SDD_ACI
alter table i$SDD_ACI
add constraint PK_SDD_ACI primary key (parent_ivid
, IRID
)
/
--RAU UK_ACI
alter table i$SDD_ACI
add constraint UK_ACI
unique (parent_ivid
, MCN_REF
, WINDOW_REF
, NAME
)
deferrable initially deferred
/
--RAU SDD_ACR_RPK
alter table i$SDD_ACR
add constraint SDD_ACR_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_ACRACR
alter table i$SDD_ACRACR
add constraint PK_SDD_ACRACR primary key (parent_ivid
, IRID
)
/
--RAU UK_ACRACR
alter table i$SDD_ACRACR
add constraint UK_ACRACR
unique (parent_ivid
, SUPERTYPE_ACTOR_REF
)
deferrable initially deferred
/
--RAU PK_SDD_ACRORG
alter table i$SDD_ACRORG
add constraint PK_SDD_ACRORG primary key (parent_ivid
, IRID
)
/
--RAU UK_ACRORG
alter table i$SDD_ACRORG
add constraint UK_ACRORG
unique (parent_ivid
, ACTOR_REF
)
deferrable initially deferred
/
--RAU SDD_ACT_RPK
alter table i$SDD_ACT
add constraint SDD_ACT_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_ACTACT
alter table i$SDD_ACTACT
add constraint PK_SDD_ACTACT primary key (parent_ivid
, IRID
)
/
--RAU UK_ACTACT
alter table i$SDD_ACTACT
add constraint UK_ACTACT
unique (parent_ivid
, CHILD_ACTIVITY_REF
)
deferrable initially deferred
/
--RAU PK_SDD_ACTE1
alter table i$SDD_ACTE1
add constraint PK_SDD_ACTE1 primary key (parent_ivid
, IRID
)
/
--RAU UK_ACTE1
alter table i$SDD_ACTE1
add constraint UK_ACTE1
unique (parent_ivid
, OBJECTIVE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_ACTORG
alter table i$SDD_ACTORG
add constraint PK_SDD_ACTORG primary key (parent_ivid
, IRID
)
/
--RAU UK_ACTORG
alter table i$SDD_ACTORG
add constraint UK_ACTORG
unique (parent_ivid
, ORGANIZATION_UNIT_REF
, SEQUENCE_NUMBER
)
deferrable initially deferred
/
--RAU PK_SDD_ACUACR
alter table i$SDD_ACUACR
add constraint PK_SDD_ACUACR primary key (parent_ivid
, IRID
)
/
--RAU UK_ACUACR
alter table i$SDD_ACUACR
add constraint UK_ACUACR
unique (parent_ivid
, ACTIVITY_USAGE_REF
, ACTOR_REF
)
deferrable initially deferred
/
--RAU PK_SDD_ADR
alter table i$SDD_ADR
add constraint PK_SDD_ADR primary key (parent_ivid
, IRID
)
/
--RAU UK_ADR
alter table i$SDD_ADR
add constraint UK_ADR
unique (parent_ivid
, CLASSIFIER_ATTRIBUTE_REF
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_AEN
alter table i$SDD_AEN
add constraint PK_SDD_AEN primary key (parent_ivid
, IRID
)
/
--RAU UK_AEN
alter table i$SDD_AEN
add constraint UK_AEN
unique (parent_ivid
, SEQUENCE
)
deferrable initially deferred
/
--RAU PK_SDD_AENEAT
alter table i$SDD_AENEAT
add constraint PK_SDD_AENEAT primary key (parent_ivid
, IRID
)
/
--RAU UK_AENEAT
alter table i$SDD_AENEAT
add constraint UK_AENEAT
unique (parent_ivid
, ASSOCIATION_END_REF
, EO_ATTRIBUTE_FROM_REF
)
deferrable initially deferred
/
--RAU UK_AENEAT_2
alter table i$SDD_AENEAT
add constraint UK_AENEAT_2
unique (parent_ivid
, ASSOCIATION_END_REF
, EO_ATTRIBUTE_TO_REF
)
deferrable initially deferred
/
--RAU PK_SDD_AEU
alter table i$SDD_AEU
add constraint PK_SDD_AEU primary key (parent_ivid
, IRID
)
/
--RAU UK_AEU
alter table i$SDD_AEU
add constraint UK_AEU
unique (parent_ivid
, ENTITY_OBJECT_USAGE_REF
, ASSOCIATION_END_REF
)
deferrable initially deferred
/
--RAU PK_SDD_AMCAMC
alter table i$SDD_AMCAMC
add constraint PK_SDD_AMCAMC primary key (parent_ivid
, IRID
)
/
--RAU UK_AMCAMC
alter table i$SDD_AMCAMC
add constraint UK_AMCAMC
unique (parent_ivid
, CHILD_APP_MODULE_REF
, ROLE_NAME
)
deferrable initially deferred
/
--RAU PK_SDD_AMCBOB
alter table i$SDD_AMCBOB
add constraint PK_SDD_AMCBOB primary key (parent_ivid
, IRID
)
/
--RAU UK_AMCBOB
alter table i$SDD_AMCBOB
add constraint UK_AMCBOB
unique (parent_ivid
, BUSINESS_OBJECT_REF
)
deferrable initially deferred
/
--RAU PK_SDD_AMCPRJ
alter table i$SDD_AMCPRJ
add constraint PK_SDD_AMCPRJ primary key (parent_ivid
, IRID
)
/
--RAU UK_AMCPRJ
alter table i$SDD_AMCPRJ
add constraint UK_AMCPRJ
unique (parent_ivid
, PROJECT_REF
, REMOTE_TARGET_TYPE
)
deferrable initially deferred
/
--RAU PK_SDD_ARG
alter table i$SDD_ARG
add constraint PK_SDD_ARG primary key (parent_ivid
, IRID
)
/
--RAU UK_ARG
alter table i$SDD_ARG
add constraint UK_ARG
unique (parent_ivid
, GENERAL_MODULE_REF
, PLSQL_MODULE_REF
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_ARGITE
alter table i$SDD_ARGITE
add constraint PK_SDD_ARGITE primary key (parent_ivid
, IRID
)
/
--RAU UK_ARGITE
alter table i$SDD_ARGITE
add constraint UK_ARGITE
unique (parent_ivid
, MODULE_ARGUMENT_REF
, ITEM_REF
)
deferrable initially deferred
/
--RAU SDD_ASS_RPK
alter table i$SDD_ASS
add constraint SDD_ASS_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_ASSASS
alter table i$SDD_ASSASS
add constraint PK_SDD_ASSASS primary key (parent_ivid
, IRID
)
/
--RAU UK_ASSASS
alter table i$SDD_ASSASS
add constraint UK_ASSASS
unique (parent_ivid
, PART_OF_ASSOC_END_REF
, USE_OF_ASSOC_END_REF
)
deferrable initially deferred
/
--RAU PK_SDD_ATT
alter table i$SDD_ATT
add constraint PK_SDD_ATT primary key (parent_ivid
, IRID
)
/
--RAU UK_ATT
alter table i$SDD_ATT
add constraint UK_ATT
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_ATV
alter table i$SDD_ATV
add constraint PK_SDD_ATV primary key (parent_ivid
, IRID
)
/
--RAU UK_ATV
alter table i$SDD_ATV
add constraint UK_ATV
unique (parent_ivid
, UNBOUND_ITEM_REF
, ATTRIBUTE_REF
, MODULE_ARGUMENT_REF
, COLUMN_REF
, DOMAIN_REF
, LOW_VALUE
, HIGH_VALUE
)
deferrable initially deferred
/
--RAU SDD_BAT_RPK
alter table i$SDD_BAT
add constraint SDD_BAT_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_BLI
alter table i$SDD_BLI
add constraint PK_SDD_BLI primary key (parent_ivid
, IRID
)
/
--RAU UK_BLI
alter table i$SDD_BLI
add constraint UK_BLI
unique (parent_ivid
, SEQUENCE
)
deferrable initially deferred
/
--RAU SDD_BOB_RPK
alter table i$SDD_BOB
add constraint SDD_BOB_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_BOBINC
alter table i$SDD_BOBINC
add constraint PK_SDD_BOBINC primary key (parent_ivid
, IRID
)
/
--RAU UK_BOBINC
alter table i$SDD_BOBINC
add constraint UK_BOBINC
unique (parent_ivid
, INTERFACE_CLASSIFIER_REF
)
deferrable initially deferred
/
--RAU PK_SDD_BRL
alter table i$SDD_BRL
add constraint PK_SDD_BRL primary key (parent_ivid
, IRID
)
/
--RAU UK_BRL
alter table i$SDD_BRL
add constraint UK_BRL
unique (parent_ivid
, RELATION_SELECTION_REF
, SNAPSHOT_REF
, VIEW_IMPLEMENTATION_REF
)
deferrable initially deferred
/
--RAU PK_SDD_BRU
alter table i$SDD_BRU
add constraint PK_SDD_BRU primary key (parent_ivid
, IRID
)
/
--RAU UK_BRU
alter table i$SDD_BRU
add constraint UK_BRU
unique (parent_ivid
, BATCH_LABEL
)
deferrable initially deferred
/
--RAU PK_SDD_BRUBLI
alter table i$SDD_BRUBLI
add constraint PK_SDD_BRUBLI primary key (parent_ivid
, IRID
)
/
--RAU UK_BRUBLI
alter table i$SDD_BRUBLI
add constraint UK_BRUBLI
unique (parent_ivid
, BATCH_RUN_REF
, BATCHLINE_REF
)
deferrable initially deferred
/
--RAU SDD_BUN_RPK
alter table i$SDD_BUN
add constraint SDD_BUN_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_CAT
alter table i$SDD_CAT
add constraint PK_SDD_CAT primary key (parent_ivid
, IRID
)
/
--RAU PK_SDD_CATAEN
alter table i$SDD_CATAEN
add constraint PK_SDD_CATAEN primary key (parent_ivid
, IRID
)
/
--RAU UK_CATAEN
alter table i$SDD_CATAEN
add constraint UK_CATAEN
unique (parent_ivid
, ASSOCIATION_END_REF
, EO_ATTRIBUTE_REF
, GENERAL_ATTRIBUTE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_CATEAT
alter table i$SDD_CATEAT
add constraint PK_SDD_CATEAT primary key (parent_ivid
, IRID
)
/
--RAU UK_CATEAT
alter table i$SDD_CATEAT
add constraint UK_CATEAT
unique (parent_ivid
, GENERAL_ATTRIBUTE_REF
, EO_ATTRIBUTE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_CCD
alter table i$SDD_CCD
add constraint PK_SDD_CCD primary key (parent_ivid
, IRID
)
/
--RAU UK_CCD
alter table i$SDD_CCD
add constraint UK_CCD
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU SDD_CDE_RPK
alter table i$SDD_CDE
add constraint SDD_CDE_RPK primary key (ivid)
/
--RAU SDD_CLA_RPK
alter table i$SDD_CLA
add constraint SDD_CLA_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_CLAAEN
alter table i$SDD_CLAAEN
add constraint PK_SDD_CLAAEN primary key (parent_ivid
, IRID
)
/
--RAU UK_CLAAEN
alter table i$SDD_CLAAEN
add constraint UK_CLAAEN
unique (parent_ivid
, ASSOCIATION_END_REF
)
deferrable initially deferred
/
--RAU PK_SDD_CLACLA
alter table i$SDD_CLACLA
add constraint PK_SDD_CLACLA primary key (parent_ivid
, IRID
)
/
--RAU UK_CLACLA
alter table i$SDD_CLACLA
add constraint UK_CLACLA
unique (parent_ivid
, SUPERTYPE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_CLAEVC
alter table i$SDD_CLAEVC
add constraint PK_SDD_CLAEVC primary key (parent_ivid
, IRID
)
/
--RAU UK_CLAEVC
alter table i$SDD_CLAEVC
add constraint UK_CLAEVC
unique (parent_ivid
, EVENT_CLASSIFIER_REF
)
deferrable initially deferred
/
--RAU PK_SDD_CLAINC
alter table i$SDD_CLAINC
add constraint PK_SDD_CLAINC primary key (parent_ivid
, IRID
)
/
--RAU UK_CLAINC
alter table i$SDD_CLAINC
add constraint UK_CLAINC
unique (parent_ivid
, INTERFACE_CLASSIFIER_REF
)
deferrable initially deferred
/
--RAU PK_SDD_CMA
alter table i$SDD_CMA
add constraint PK_SDD_CMA primary key (parent_ivid
, IRID
)
/
--RAU UK_CMA
alter table i$SDD_CMA
add constraint UK_CMA
unique (parent_ivid
, EVENT_RAISER_REF
, EVENT_HANDLER_REF
, CLASSIFIER_ATTRIBUTE_REF
, EVENT_CLASSIFIER_REF
)
deferrable initially deferred
/
--RAU PK_SDD_CNU
alter table i$SDD_CNU
add constraint PK_SDD_CNU primary key (parent_ivid
, IRID
)
/
--RAU UK_CNU
alter table i$SDD_CNU
add constraint UK_CNU
unique (parent_ivid
, TABLE_USAGE_REF
, CONSTRAINT_REF
)
deferrable initially deferred
/
--RAU PK_SDD_COB
alter table i$SDD_COB
add constraint PK_SDD_COB primary key (parent_ivid
, IRID
)
/
--RAU UK_COB
alter table i$SDD_COB
add constraint UK_COB
unique (parent_ivid
, BATCHLINE_REF
, TYPE
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_COL
alter table i$SDD_COL
add constraint PK_SDD_COL primary key (parent_ivid
, IRID
)
/
--RAU UK_COL
alter table i$SDD_COL
add constraint UK_COL
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU SDD_COM_RPK
alter table i$SDD_COM
add constraint SDD_COM_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_COMNOD
alter table i$SDD_COMNOD
add constraint PK_SDD_COMNOD primary key (parent_ivid
, IRID
)
/
--RAU UK_COMNOD
alter table i$SDD_COMNOD
add constraint UK_COMNOD
unique (parent_ivid
, NODE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_COMODB
alter table i$SDD_COMODB
add constraint PK_SDD_COMODB primary key (parent_ivid
, IRID
)
/
--RAU UK_COMODB
alter table i$SDD_COMODB
add constraint UK_COMODB
unique (parent_ivid
, ORACLE_DATABASE_REF
)
deferrable initially deferred
/
--RAU SDD_COR_RPK
alter table i$SDD_COR
add constraint SDD_COR_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_CORI
alter table i$SDD_CORI
add constraint PK_SDD_CORI primary key (parent_ivid
, IRID
)
/
--RAU UK_CORI
alter table i$SDD_CORI
add constraint UK_CORI
unique (parent_ivid
, CLASSIFIER_ATTRIBUTE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_CQA
alter table i$SDD_CQA
add constraint PK_SDD_CQA primary key (parent_ivid
, IRID
)
/
--RAU PK_SDD_CQACOL
alter table i$SDD_CQACOL
add constraint PK_SDD_CQACOL primary key (parent_ivid
, IRID
)
/
--RAU UK_CQACOL
alter table i$SDD_CQACOL
add constraint UK_CQACOL
unique (parent_ivid
, COLUMN_REF
, CQA_REF
)
deferrable initially deferred
/
--RAU UK_CQACOL_2
alter table i$SDD_CQACOL
add constraint UK_CQACOL_2
unique (parent_ivid
, CQA_REF
, SEQUENCE
)
deferrable initially deferred
/
--RAU PK_SDD_CRU
alter table i$SDD_CRU
add constraint PK_SDD_CRU primary key (parent_ivid
, IRID
)
/
--RAU UK_CRU
alter table i$SDD_CRU
add constraint UK_CRU
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_CSG
alter table i$SDD_CSG
add constraint PK_SDD_CSG primary key (parent_ivid
, IRID
)
/
--RAU UK_CSG
alter table i$SDD_CSG
add constraint UK_CSG
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_CST
alter table i$SDD_CST
add constraint PK_SDD_CST primary key (parent_ivid
, IRID
)
/
--RAU UK_CST
alter table i$SDD_CST
add constraint UK_CST
unique (parent_ivid
, TABLE_IMPLEMENTATION_REF
, COLUMN_REF
, CQA_REF
)
deferrable initially deferred
/
--RAU PK_SDD_DAT
alter table i$SDD_DAT
add constraint PK_SDD_DAT primary key (parent_ivid
, IRID
)
/
--RAU UK_DAT
alter table i$SDD_DAT
add constraint UK_DAT
unique (parent_ivid
, PLSQL_MODULE_REF
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_DATCOM
alter table i$SDD_DATCOM
add constraint PK_SDD_DATCOM primary key (parent_ivid
, IRID
)
/
--RAU UK_DATCOM
alter table i$SDD_DATCOM
add constraint UK_DATCOM
unique (parent_ivid
, ARC_RULE_REF
, UNIQUENESS_RULE_REF
, CLASSIFIER_ATTRIBUTE_REF
, ASSOCIATION_END_REF
)
deferrable initially deferred
/
--RAU PK_SDD_DBU
alter table i$SDD_DBU
add constraint PK_SDD_DBU primary key (parent_ivid
, IRID
)
/
--RAU PK_SDD_DBUGRP
alter table i$SDD_DBUGRP
add constraint PK_SDD_DBUGRP primary key (parent_ivid
, IRID
)
/
--RAU UK_DBUGRP
alter table i$SDD_DBUGRP
add constraint UK_DBUGRP
unique (parent_ivid
, DATABASE_USER_REF
, ROLE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_DBUMOD
alter table i$SDD_DBUMOD
add constraint PK_SDD_DBUMOD primary key (parent_ivid
, IRID
)
/
--RAU UK_DBUMOD
alter table i$SDD_DBUMOD
add constraint UK_DBUMOD
unique (parent_ivid
, DATABASE_USER_REF
, GENERAL_MODULE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_DEU
alter table i$SDD_DEU
add constraint PK_SDD_DEU primary key (parent_ivid
, IRID
)
/
--RAU UK_DEU
alter table i$SDD_DEU
add constraint UK_DEU
unique (parent_ivid
, CIELEMENT_REF
)
deferrable initially deferred
/
--RAU PK_SDD_DFI
alter table i$SDD_DFI
add constraint PK_SDD_DFI primary key (parent_ivid
, IRID
)
/
--RAU UK_DAF
alter table i$SDD_DFI
add constraint UK_DAF
unique (parent_ivid
, ORACLE_DATABASE_REF
, TABLESPACE_REF
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_DFL
alter table i$SDD_DFL
add constraint PK_SDD_DFL primary key (parent_ivid
, IRID
)
/
--RAU UK_DFL
alter table i$SDD_DFL
add constraint UK_DFL
unique (parent_ivid
, FUNCTION_DEST_REF
, DATASTORE_DEST_REF
, EXTERNAL_DEST_REF
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_DFLATT
alter table i$SDD_DFLATT
add constraint PK_SDD_DFLATT primary key (parent_ivid
, IRID
)
/
--RAU UK_DFLATT
alter table i$SDD_DFLATT
add constraint UK_DFLATT
unique (parent_ivid
, DATAFLOW_REF
, ATTRIBUTE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_DFLDIT
alter table i$SDD_DFLDIT
add constraint PK_SDD_DFLDIT primary key (parent_ivid
, IRID
)
/
--RAU UK_DFLDIT
alter table i$SDD_DFLDIT
add constraint UK_DFLDIT
unique (parent_ivid
, DATAFLOW_REF
, DATA_ITEM_REF
)
deferrable initially deferred
/
--RAU SDD_DIA_RPK
alter table i$SDD_DIA
add constraint SDD_DIA_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_DIAGRAM_SEGMENTS
alter table i$SDD_DIAGRAM_SEGMENTS
add constraint PK_SDD_DIAGRAM_SEGMENTS primary key (parent_ivid
, IRID
)
/
--RAU UK_SEG
alter table i$SDD_DIAGRAM_SEGMENTS
add constraint UK_SEG
unique (parent_ivid
, SEQUENCE
)
deferrable initially deferred
/
--RAU PK_SDD_DIR
alter table i$SDD_DIR
add constraint PK_SDD_DIR primary key (parent_ivid
, IRID
)
/
--RAU UK_DIR
alter table i$SDD_DIR
add constraint UK_DIR
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU SDD_DIT_RPK
alter table i$SDD_DIT
add constraint SDD_DIT_RPK primary key (ivid)
/
--RAU SDD_DOC_RPK
alter table i$SDD_DOC
add constraint SDD_DOC_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_DOCXXX
alter table i$SDD_DOCXXX
add constraint PK_SDD_DOCXXX primary key (parent_ivid
, IRID
)
/
--RAU UK_DOCXXX
alter table i$SDD_DOCXXX
add constraint UK_DOCXXX
unique (parent_ivid
, ELEMENT_REF
)
deferrable initially deferred
/
--RAU PK_SDD_DOG
alter table i$SDD_DOG
add constraint PK_SDD_DOG primary key (parent_ivid
, IRID
)
/
--RAU UK_DOG
alter table i$SDD_DOG
add constraint UK_DOG
unique (parent_ivid
, DATABASE_USER_REF
, ROLE_REF
, VIEW_REF
, SEQUENCE_REF
, SNAPSHOT_REF
, DIRECTORY_REF
, TABLE_REF
, JMI_REF
, PLSQL_MODULE_REF
, QUI_REF
)
deferrable initially deferred
/
--RAU PK_SDD_DOI
alter table i$SDD_DOI
add constraint PK_SDD_DOI primary key (parent_ivid
, IRID
)
/
--RAU UK_HANDCRAFTED_DOI
alter table i$SDD_DOI
add constraint UK_HANDCRAFTED_DOI
unique (parent_ivid
, DATABASE_USER_REF
, VIEW_DEFINITION_REF
, TABLE_DEFINITION_REF
, JAVA_MODULE_REF
, CLUSTER_REF
, PLSQL_MODULE_REF
, SEQUENCE_REF
, SNAPSHOT_DEFINITION_REF
, QUEUE_TABLE_DEF_REF
)
deferrable initially deferred
/
--RAU SDD_DOM_RPK
alter table i$SDD_DOM
add constraint SDD_DOM_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_DPR
alter table i$SDD_DPR
add constraint PK_SDD_DPR primary key (parent_ivid
, IRID
)
/
--RAU UK_DPR
alter table i$SDD_DPR
add constraint UK_DPR
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU SDD_DST_RPK
alter table i$SDD_DST
add constraint SDD_DST_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_DSTATT
alter table i$SDD_DSTATT
add constraint PK_SDD_DSTATT primary key (parent_ivid
, IRID
)
/
--RAU UK_DSTATT
alter table i$SDD_DSTATT
add constraint UK_DSTATT
unique (parent_ivid
, ATTRIBUTE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_DSTDIT
alter table i$SDD_DSTDIT
add constraint PK_SDD_DSTDIT primary key (parent_ivid
, IRID
)
/
--RAU UK_DSTDIT
alter table i$SDD_DSTDIT
add constraint UK_DSTDIT
unique (parent_ivid
, DATA_ITEM_REF
)
deferrable initially deferred
/
--RAU PK_SDD_DSY
alter table i$SDD_DSY
add constraint PK_SDD_DSY primary key (parent_ivid
, IRID
)
/
--RAU SDD_E1_RPK
alter table i$SDD_E1
add constraint SDD_E1_RPK primary key (ivid
, IRID
)
/
--RAU SDD_E2_RPK
alter table i$SDD_E2
add constraint SDD_E2_RPK primary key (ivid)
/
--RAU SDD_E20_RPK
alter table i$SDD_E20
add constraint SDD_E20_RPK primary key (ivid
, IRID
)
/
--RAU SDD_E3_RPK
alter table i$SDD_E3
add constraint SDD_E3_RPK primary key (ivid
, IRID
)
/
--RAU SDD_E4_RPK
alter table i$SDD_E4
add constraint SDD_E4_RPK primary key (ivid
, IRID
)
/
--RAU SDD_E5_RPK
alter table i$SDD_E5
add constraint SDD_E5_RPK primary key (ivid
, IRID
)
/
--RAU SDD_E6_RPK
alter table i$SDD_E6
add constraint SDD_E6_RPK primary key (ivid
, IRID
)
/
--RAU SDD_ENT_RPK
alter table i$SDD_ENT
add constraint SDD_ENT_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_ENTBUN
alter table i$SDD_ENTBUN
add constraint PK_SDD_ENTBUN primary key (parent_ivid
, IRID
)
/
--RAU UK_ENTBUN
alter table i$SDD_ENTBUN
add constraint UK_ENTBUN
unique (parent_ivid
, BUSINESS_UNIT_REF
)
deferrable initially deferred
/
--RAU PK_SDD_ENTUIE
alter table i$SDD_ENTUIE
add constraint PK_SDD_ENTUIE primary key (parent_ivid
, IRID
)
/
--RAU UK_ENTUIE
alter table i$SDD_ENTUIE
add constraint UK_ENTUIE
unique (parent_ivid
, UNIQUE_IDENTIFIER_REF
, ATTRIBUTE_REF
, RELATIONSHIP_END_REF
)
deferrable initially deferred
/
--RAU UK_ENTUIE_2
alter table i$SDD_ENTUIE
add constraint UK_ENTUIE_2
unique (parent_ivid
, UNIQUE_IDENTIFIER_REF
, SEQUENCE_WITHIN_UID
)
deferrable initially deferred
/
--RAU PK_SDD_EOU
alter table i$SDD_EOU
add constraint PK_SDD_EOU primary key (parent_ivid
, IRID
)
/
--RAU UK_EOU
alter table i$SDD_EOU
add constraint UK_EOU
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU UK_EOU_2
alter table i$SDD_EOU
add constraint UK_EOU_2
unique (parent_ivid
, SQL_ALIAS
)
deferrable initially deferred
/
--RAU PK_SDD_ELRUL
alter table i$SDD_ERU
add constraint PK_SDD_ELRUL primary key (parent_ivid
, IRID
)
/
--RAU PK_SDD_EVH
alter table i$SDD_EVH
add constraint PK_SDD_EVH primary key (parent_ivid
, IRID
)
/
--RAU UK_EVH
alter table i$SDD_EVH
add constraint UK_EVH
unique (parent_ivid
, METHOD_REF
, EVENT_SUBSCRIPTION_REF
, SUBSCRIPTION_DETAIL_REF
)
deferrable initially deferred
/
--RAU PK_SDD_EVR
alter table i$SDD_EVR
add constraint PK_SDD_EVR primary key (parent_ivid
, IRID
)
/
--RAU UK_EVR
alter table i$SDD_EVR
add constraint UK_EVR
unique (parent_ivid
, METHOD_REF
, EVENT_PUBLICATION_REF
)
deferrable initially deferred
/
--RAU PK_SDD_EVS
alter table i$SDD_EVS
add constraint PK_SDD_EVS primary key (parent_ivid
, IRID
)
/
--RAU UK_EVS
alter table i$SDD_EVS
add constraint UK_EVS
unique (parent_ivid
, EVENT_CLASSIFIER_REF
)
deferrable initially deferred
/
--RAU SDD_EVT_RPK
alter table i$SDD_EVT
add constraint SDD_EVT_RPK primary key (ivid
, IRID
)
/
--RAU SDD_EXT_RPK
alter table i$SDD_EXT
add constraint SDD_EXT_RPK primary key (ivid
, IRID
)
/
--RAU SDD_FIL_RPK
alter table i$SDD_FIL
add constraint SDD_FIL_RPK primary key (ivid)
/
--RAU SDD_FILES_RPK
alter table i$SDD_FILES
add constraint SDD_FILES_RPK primary key (ivid)
/
--RAU PK_SDD_FILPAC
alter table i$SDD_FILPAC
add constraint PK_SDD_FILPAC primary key (parent_ivid
, IRID
)
/
--RAU UK_FILPAC
alter table i$SDD_FILPAC
add constraint UK_FILPAC
unique (parent_ivid
, PRIMARY_ACCESS_FILE_REF
)
deferrable initially deferred
/
--RAU SDD_FOLDERS_RPK
alter table i$SDD_FOLDERS
add constraint SDD_FOLDERS_RPK primary key (ivid
, IRID
)
/
--RAU PK_FOLDER_MEMBERS
alter table i$SDD_FOLDER_MEMBERS
add constraint PK_FOLDER_MEMBERS primary key (parent_ivid
, IRID
)
/
--RAU SDD_FOLDER_MEMBER_UK
alter table i$SDD_FOLDER_MEMBERS
add constraint SDD_FOLDER_MEMBER_UK
unique (parent_ivid
, MEMBER_OBJECT
)
deferrable initially deferred
/
--RAU PK_SDD_FSE
alter table i$SDD_FSE
add constraint PK_SDD_FSE primary key (parent_ivid
, IRID
)
/
--RAU UK_FSE
alter table i$SDD_FSE
add constraint UK_FSE
unique (parent_ivid
, LANGUAGE_NAME
, CODE_SECTION_TYPE
, SEQUENCE_NUMBER
)
deferrable initially deferred
/
--RAU SDD_FUN_RPK
alter table i$SDD_FUN
add constraint SDD_FUN_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_FUNATT
alter table i$SDD_FUNATT
add constraint PK_SDD_FUNATT primary key (parent_ivid
, IRID
)
/
--RAU UK_FUNATT
alter table i$SDD_FUNATT
add constraint UK_FUNATT
unique (parent_ivid
, ATTRIBUTE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_FUNBUN
alter table i$SDD_FUNBUN
add constraint PK_SDD_FUNBUN primary key (parent_ivid
, IRID
)
/
--RAU UK_FUNBUN
alter table i$SDD_FUNBUN
add constraint UK_FUNBUN
unique (parent_ivid
, BUSINESS_UNIT_REF
)
deferrable initially deferred
/
--RAU PK_SDD_FUNENT
alter table i$SDD_FUNENT
add constraint PK_SDD_FUNENT primary key (parent_ivid
, IRID
)
/
--RAU UK_FUNENT
alter table i$SDD_FUNENT
add constraint UK_FUNENT
unique (parent_ivid
, ENTITY_REF
)
deferrable initially deferred
/
--RAU PK_SDD_FUNEVT
alter table i$SDD_FUNEVT
add constraint PK_SDD_FUNEVT primary key (parent_ivid
, IRID
)
/
--RAU UK_FUNEVT
alter table i$SDD_FUNEVT
add constraint UK_FUNEVT
unique (parent_ivid
, TRIGGERING_FUNCTION_REF
, TRIGGERING_EVENT_REF
)
deferrable initially deferred
/
--RAU PK_SDD_GRP
alter table i$SDD_GRP
add constraint PK_SDD_GRP primary key (parent_ivid
, IRID
)
/
--RAU PK_SDD_GRPGRP
alter table i$SDD_GRPGRP
add constraint PK_SDD_GRPGRP primary key (parent_ivid
, IRID
)
/
--RAU UK_GRPGRP
alter table i$SDD_GRPGRP
add constraint UK_GRPGRP
unique (parent_ivid
, GRANTOR_ROLE_REF
, GRANTEE_ROLE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_GRPMOD
alter table i$SDD_GRPMOD
add constraint PK_SDD_GRPMOD primary key (parent_ivid
, IRID
)
/
--RAU UK_GRPMOD
alter table i$SDD_GRPMOD
add constraint UK_GRPMOD
unique (parent_ivid
, ROLE_REF
, GENERAL_MODULE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_IGR
alter table i$SDD_IGR
add constraint PK_SDD_IGR primary key (parent_ivid
, IRID
)
/
--RAU UK_IGR
alter table i$SDD_IGR
add constraint UK_IGR
unique (parent_ivid
, MODULE_COMPONENT_REF
, SUBCOMPONENT_REF
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_IND
alter table i$SDD_IND
add constraint PK_SDD_IND primary key (parent_ivid
, IRID
)
/
--RAU PK_SDD_INDCOL
alter table i$SDD_INDCOL
add constraint PK_SDD_INDCOL primary key (parent_ivid
, IRID
)
/
--RAU UK_INDCOL
alter table i$SDD_INDCOL
add constraint UK_INDCOL
unique (parent_ivid
, RELATION_INDEX_REF
, SEQUENCE_NUMBER
)
deferrable initially deferred
/
--RAU PK_SDD_INP
alter table i$SDD_INP
add constraint PK_SDD_INP primary key (parent_ivid
, IRID
)
/
--RAU UK_HANDCRAFTED_INP
alter table i$SDD_INP
add constraint UK_HANDCRAFTED_INP
unique (parent_ivid
, INDEX_STORAGE_REF
, SEQUENCE_NUMBER
, TABLE_PARTITION_REF
)
deferrable initially deferred
/
--RAU UK_HANDCRAFTED_INP_2
alter table i$SDD_INP
add constraint UK_HANDCRAFTED_INP_2
unique (parent_ivid
, INDEX_STORAGE_REF
, NAME
, ELEMENT_TYPE_NAME
)
deferrable initially deferred
/
--RAU PK_SDD_INS
alter table i$SDD_INS
add constraint PK_SDD_INS primary key (parent_ivid
, IRID
)
/
--RAU UK_HANDCRAFTED_INS
alter table i$SDD_INS
add constraint UK_HANDCRAFTED_INS
unique (parent_ivid
, CLUSTER_REF
, TABLE_IMPLEMENTATION_REF
, SNAPSHOT_REF
, IMPLICIT_INDEX_TYPE
, INDEX_REF
, PRIMARY_KEY_REF
, UNIQUE_KEY_REF
)
deferrable initially deferred
/
--RAU PK_SDD_ITE
alter table i$SDD_ITE
add constraint PK_SDD_ITE primary key (parent_ivid
, IRID
)
/
--RAU UK_ITE
alter table i$SDD_ITE
add constraint UK_ITE
unique (parent_ivid
, MODULE_UNIT_REF
, SQL_QUERY_SET_REF
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_ITM
alter table i$SDD_ITM
add constraint PK_SDD_ITM primary key (parent_ivid
, IRID
)
/
--RAU UK_ITM
alter table i$SDD_ITM
add constraint UK_ITM
unique (parent_ivid
, DATASTRUCTURE_REF
, NAME
)
deferrable initially deferred
/
--RAU SDD_LAN_RPK
alter table i$SDD_LAN
add constraint SDD_LAN_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_LST
alter table i$SDD_LST
add constraint PK_SDD_LST primary key (parent_ivid
, IRID
)
/
--RAU UK_LST
alter table i$SDD_LST
add constraint UK_LST
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_LVI
alter table i$SDD_LVI
add constraint PK_SDD_LVI primary key (parent_ivid
, IRID
)
/
--RAU UK_LVI
alter table i$SDD_LVI
add constraint UK_LVI
unique (parent_ivid
, GENERAL_MODULE_REF
, USAGE_SEQUENCE
)
deferrable initially deferred
/
--RAU PK_SDD_MAP
alter table i$SDD_MAP
add constraint PK_SDD_MAP primary key (parent_ivid
, IRID
)
/
--RAU UK_MAP
alter table i$SDD_MAP
add constraint UK_MAP
unique (parent_ivid
, SOURCE_CIELEMENT_REF
, TARGET_CIELEMENT_REF
)
deferrable initially deferred
/
--RAU PK_SDD_MCH
alter table i$SDD_MCH
add constraint PK_SDD_MCH primary key (parent_ivid
, IRID
)
/
--RAU UK_MCH
alter table i$SDD_MCH
add constraint UK_MCH
unique (parent_ivid
, MODULE_REF
, CHANGE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_MCL
alter table i$SDD_MCL
add constraint PK_SDD_MCL primary key (parent_ivid
, IRID
)
/
--RAU PK_SDD_MCN
alter table i$SDD_MCN
add constraint PK_SDD_MCN primary key (parent_ivid
, IRID
)
/
--RAU UK_MCN
alter table i$SDD_MCN
add constraint UK_MCN
unique (parent_ivid
, GENERAL_MODULE_REF
, USAGE_SEQUENCE
)
deferrable initially deferred
/
--RAU PK_SDD_MEMCOM
alter table i$SDD_MEMCOM
add constraint PK_SDD_MEMCOM primary key (parent_ivid
, IRID
)
/
--RAU UK_MEMCOM
alter table i$SDD_MEMCOM
add constraint UK_MEMCOM
unique (parent_ivid
, NAMED_RULE_REF
, CROSS_OBJECT_RULE_REF
, INTEGRITY_RULE_REF
, STATE_RULE_REF
, ATTRIBUTE_DERIV_RULE_REF
, CLASSIFIER_ATTRIBUTE_REF
, ASSOCIATION_END_REF
, METHOD_REF
)
deferrable initially deferred
/
--RAU PK_SDD_MET
alter table i$SDD_MET
add constraint PK_SDD_MET primary key (parent_ivid
, IRID
)
/
--RAU UK_MET
alter table i$SDD_MET
add constraint UK_MET
unique (parent_ivid
, INTERNAL_NAME
)
deferrable initially deferred
/
--RAU PK_SDD_METRUL
alter table i$SDD_METRUL
add constraint PK_SDD_METRUL primary key (parent_ivid
, IRID
)
/
--RAU UK_METRUL
alter table i$SDD_METRUL
add constraint UK_METRUL
unique (parent_ivid
, NAMED_RULE_REF
, ATTRIBUTE_DERIV_RULE_REF
, CLASSIFIER_RULE_REF
, STATE_RULE_REF
, CROSS_OBJECT_RULE_REF
, METHOD_REF
, CALL_TYPE
)
deferrable initially deferred
/
--RAU SDD_MOD_RPK
alter table i$SDD_MOD
add constraint SDD_MOD_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_MODBUN
alter table i$SDD_MODBUN
add constraint PK_SDD_MODBUN primary key (parent_ivid
, IRID
)
/
--RAU UK_MODBUN
alter table i$SDD_MODBUN
add constraint UK_MODBUN
unique (parent_ivid
, MODULE_REF
, BUSINESS_UNIT_REF
)
deferrable initially deferred
/
--RAU PK_SDD_MODFUN
alter table i$SDD_MODFUN
add constraint PK_SDD_MODFUN primary key (parent_ivid
, IRID
)
/
--RAU UK_MODFUN
alter table i$SDD_MODFUN
add constraint UK_MODFUN
unique (parent_ivid
, MODULE_REF
, FUNCTION_REF
)
deferrable initially deferred
/
--RAU PK_SDD_MODMOD
alter table i$SDD_MODMOD
add constraint PK_SDD_MODMOD primary key (parent_ivid
, IRID
)
/
--RAU UK_MODMOD
alter table i$SDD_MODMOD
add constraint UK_MODMOD
unique (parent_ivid
, PARENT_MODULE_REF
, CHILD_MODULE_REF
, CALLED_SEQUENCE
)
deferrable initially deferred
/
--RAU PK_SDD_MODPGD
alter table i$SDD_MODPGD
add constraint PK_SDD_MODPGD primary key (parent_ivid
, IRID
)
/
--RAU UK_MODPGD
alter table i$SDD_MODPGD
add constraint UK_MODPGD
unique (parent_ivid
, GENERAL_MODULE_REF
, PLSQL_MODULE_REF
, PROGRAM_DATUM_REF
)
deferrable initially deferred
/
--RAU PK_SDD_MPA
alter table i$SDD_MPA
add constraint PK_SDD_MPA primary key (parent_ivid
, IRID
)
/
--RAU UK_MPA
alter table i$SDD_MPA
add constraint UK_MPA
unique (parent_ivid
, METHOD_REF
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_MTI
alter table i$SDD_MTI
add constraint PK_SDD_MTI primary key (parent_ivid
, IRID
)
/
--RAU UK_MTI
alter table i$SDD_MTI
add constraint UK_MTI
unique (parent_ivid
, MODULE_UNIT_REF
, SQL_QUERY_SET_REF
, ALIAS
)
deferrable initially deferred
/
--RAU SDD_MUN_RPK
alter table i$SDD_MUN
add constraint SDD_MUN_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_MWF
alter table i$SDD_MWF
add constraint PK_SDD_MWF primary key (parent_ivid
, IRID
)
/
--RAU UK_MWF
alter table i$SDD_MWF
add constraint UK_MWF
unique (parent_ivid
, MODULE_TYPE
, COMPLEXITY
)
deferrable initially deferred
/
--RAU SDD_OCL_RPK
alter table i$SDD_OCL
add constraint SDD_OCL_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_OCO
alter table i$SDD_OCO
add constraint PK_SDD_OCO primary key (parent_ivid
, IRID
)
/
--RAU SDD_ODB_RPK
alter table i$SDD_ODB
add constraint SDD_ODB_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_ODBODB
alter table i$SDD_ODBODB
add constraint PK_SDD_ODBODB primary key (parent_ivid
, IRID
)
/
--RAU UK_ODBODB
alter table i$SDD_ODBODB
add constraint UK_ODBODB
unique (parent_ivid
, DATABASE_REF_TO
)
deferrable initially deferred
/
--RAU PK_SDD_OKY
alter table i$SDD_OKY
add constraint PK_SDD_OKY primary key (parent_ivid
, IRID
)
/
--RAU UK_OKY
alter table i$SDD_OKY
add constraint UK_OKY
unique (parent_ivid
, CONSTRAINT_REF
, COLUMN_REF
, CQA_REF
)
deferrable initially deferred
/
--RAU SDD_ORG_RPK
alter table i$SDD_ORG
add constraint SDD_ORG_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_ORGPER
alter table i$SDD_ORGPER
add constraint PK_SDD_ORGPER primary key (parent_ivid
, IRID
)
/
--RAU UK_ORGPER
alter table i$SDD_ORGPER
add constraint UK_ORGPER
unique (parent_ivid
, PERSON_REF
)
deferrable initially deferred
/
--RAU PK_SDD_ORS
alter table i$SDD_ORS
add constraint PK_SDD_ORS primary key (parent_ivid
, IRID
)
/
--RAU UK_ORS
alter table i$SDD_ORS
add constraint UK_ORS
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU SDD_ORT_RPK
alter table i$SDD_ORT
add constraint SDD_ORT_RPK primary key (ivid
, IRID
)
/
--RAU SDD_OSP_RPK
alter table i$SDD_OSP
add constraint SDD_OSP_RPK primary key (ivid)
/
--RAU SDD_OSQ_RPK
alter table i$SDD_OSQ
add constraint SDD_OSQ_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_OST
alter table i$SDD_OST
add constraint PK_SDD_OST primary key (parent_ivid
, IRID
)
/
--RAU UK_OST
alter table i$SDD_OST
add constraint UK_OST
unique (parent_ivid
, CLASSIFIER_REF
, BUSINESS_OBJECT_REF
, WORKFLOW_ITEM_TYPE_REF
, WORKFLOW_MESS_TYPE_REF
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_OSTOST
alter table i$SDD_OSTOST
add constraint PK_SDD_OSTOST primary key (parent_ivid
, IRID
)
/
--RAU UK_OSTOST
alter table i$SDD_OSTOST
add constraint UK_OSTOST
unique (parent_ivid
, OBJECT_STATE_OF_REF
, OBJECT_STATE_ON_REF
)
deferrable initially deferred
/
--RAU PK_SDD_OTB
alter table i$SDD_OTB
add constraint PK_SDD_OTB primary key (parent_ivid
, IRID
)
/
--RAU UK_OTB
alter table i$SDD_OTB
add constraint UK_OTB
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU SDD_PER_RPK
alter table i$SDD_PER
add constraint SDD_PER_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_PERACR
alter table i$SDD_PERACR
add constraint PK_SDD_PERACR primary key (parent_ivid
, IRID
)
/
--RAU UK_PERACR
alter table i$SDD_PERACR
add constraint UK_PERACR
unique (parent_ivid
, ACTOR_REF
)
deferrable initially deferred
/
--RAU PK_SDD_PERPER
alter table i$SDD_PERPER
add constraint PK_SDD_PERPER primary key (parent_ivid
, IRID
)
/
--RAU UK_PERPER
alter table i$SDD_PERPER
add constraint UK_PERPER
unique (parent_ivid
, MANAGED_PERSON_REF
)
deferrable initially deferred
/
--RAU PK_SDD_PGD
alter table i$SDD_PGD
add constraint PK_SDD_PGD primary key (parent_ivid
, IRID
)
/
--RAU UK_PGD
alter table i$SDD_PGD
add constraint UK_PGD
unique (parent_ivid
, GENERAL_MODULE_REF
, PLSQL_MODULE_REF
, NAME
)
deferrable initially deferred
/
--RAU SDD_PRS_RPK
alter table i$SDD_PRS
add constraint SDD_PRS_RPK primary key (ivid)
/
--RAU PK_SDD_PRU
alter table i$SDD_PRU
add constraint PK_SDD_PRU primary key (parent_ivid
, IRID
)
/
--RAU SDD_PSE_RPK
alter table i$SDD_PSE
add constraint SDD_PSE_RPK primary key (ivid
, IRID
)
/
--RAU SDD_PST_RPK
alter table i$SDD_PST
add constraint SDD_PST_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_PSTADC
alter table i$SDD_PSTADC
add constraint PK_SDD_PSTADC primary key (parent_ivid
, IRID
)
/
--RAU UK_PSTADC
alter table i$SDD_PSTADC
add constraint UK_PSTADC
unique (parent_ivid
, ATTRIBUTE_DOMAIN_REF
)
deferrable initially deferred
/
--RAU PK_SDD_PVL
alter table i$SDD_PVL
add constraint PK_SDD_PVL primary key (parent_ivid
, IRID
)
/
--RAU UK_HANDCRAFTED_PVL
alter table i$SDD_PVL
add constraint UK_HANDCRAFTED_PVL
unique (parent_ivid
, CALLED_ARGUMENT_REF
, MODULE_NETWORK_REF
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_QSU
alter table i$SDD_QSU
add constraint PK_SDD_QSU primary key (parent_ivid
, IRID
)
/
--RAU SDD_QTD_RPK
alter table i$SDD_QTD
add constraint SDD_QTD_RPK primary key (ivid)
/
--RAU SDD_QUE_RPK
alter table i$SDD_QUE
add constraint SDD_QUE_RPK primary key (ivid)
/
--RAU PK_SDD_QUI
alter table i$SDD_QUI
add constraint PK_SDD_QUI primary key (parent_ivid
, IRID
)
/
--RAU UK_HANDCRAFTED_QUI
alter table i$SDD_QUI
add constraint UK_HANDCRAFTED_QUI
unique (parent_ivid
, PERSISTENT_QUEUE_REF
, NON_PERSISTENT_QUEUE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_RELEND
alter table i$SDD_RELEND
add constraint PK_SDD_RELEND primary key (parent_ivid
, IRID
)
/
--RAU PK_SDD_RGP
alter table i$SDD_RGP
add constraint PK_SDD_RGP primary key (parent_ivid
, IRID
)
/
--RAU UK_RGP
alter table i$SDD_RGP
add constraint UK_RGP
unique (parent_ivid
, REPLICATION_GROUP_REF
, ORACLE_DATABASE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_RPG
alter table i$SDD_RPG
add constraint PK_SDD_RPG primary key (parent_ivid
, IRID
)
/
--RAU UK_RPG
alter table i$SDD_RPG
add constraint UK_RPG
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU SDD_RUL_RPK
alter table i$SDD_RUL
add constraint SDD_RUL_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_RULRUL
alter table i$SDD_RULRUL
add constraint PK_SDD_RULRUL primary key (parent_ivid
, IRID
)
/
--RAU UK_RULRUL
alter table i$SDD_RULRUL
add constraint UK_RULRUL
unique (parent_ivid
, USE_OF_RULE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_SBA
alter table i$SDD_SBA
add constraint PK_SDD_SBA primary key (parent_ivid
, IRID
)
/
--RAU UK_SBA
alter table i$SDD_SBA
add constraint UK_SBA
unique (parent_ivid
, METHOD_REF
, EVENT_SUBSCRIPTION_REF
, SUBSCRIPTION_DETAIL_REF
, SEQUENCE
)
deferrable initially deferred
/
--RAU PK_SDD_SMI
alter table i$SDD_SMI
add constraint PK_SDD_SMI primary key (parent_ivid
, IRID
)
/
--RAU UK_SMI
alter table i$SDD_SMI
add constraint UK_SMI
unique (parent_ivid
, ELEMENT_REF
)
deferrable initially deferred
/
--RAU PK_SDD_SOU
alter table i$SDD_SOU
add constraint PK_SDD_SOU primary key (parent_ivid
, IRID
)
/
--RAU UK_SOU
alter table i$SDD_SOU
add constraint UK_SOU
unique (parent_ivid
, BATCHLINE_REF
, CIELEMENT_REF
)
deferrable initially deferred
/
--RAU PK_SDD_SPV
alter table i$SDD_SPV
add constraint PK_SDD_SPV primary key (parent_ivid
, IRID
)
/
--RAU UK_SPV
alter table i$SDD_SPV
add constraint UK_SPV
unique (parent_ivid
, DATABASE_USER_REF
, ROLE_REF
, SYSTEM_PRIVILEGE_NAME
)
deferrable initially deferred
/
--RAU PK_SDD_SQS
alter table i$SDD_SQS
add constraint PK_SDD_SQS primary key (parent_ivid
, IRID
)
/
--RAU UK_SQS
alter table i$SDD_SQS
add constraint UK_SQS
unique (parent_ivid
, MODULE_COMPONENT_REF
, LIST_OF_VALUES_REF
, SEQUENCE_NUMBER
)
deferrable initially deferred
/
--RAU UK_SQS_2
alter table i$SDD_SQS
add constraint UK_SQS_2
unique (parent_ivid
, MODULE_COMPONENT_REF
, LIST_OF_VALUES_REF
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_SRG
alter table i$SDD_SRG
add constraint PK_SDD_SRG primary key (parent_ivid
, IRID
)
/
--RAU UK_SRG
alter table i$SDD_SRG
add constraint UK_SRG
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_SRU
alter table i$SDD_SRU
add constraint PK_SDD_SRU primary key (parent_ivid
, IRID
)
/
--RAU UK_SRU
alter table i$SDD_SRU
add constraint UK_SRU
unique (parent_ivid
, OBJECT_STATE_REF
, NAME
)
deferrable initially deferred
/
--RAU SDD_STE_RPK
alter table i$SDD_STE
add constraint SDD_STE_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_STESTE
alter table i$SDD_STESTE
add constraint PK_SDD_STESTE primary key (parent_ivid
, IRID
)
/
--RAU UK_STESTE
alter table i$SDD_STESTE
add constraint UK_STESTE
unique (parent_ivid
, SUPERTYPE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_SUD
alter table i$SDD_SUD
add constraint PK_SDD_SUD primary key (parent_ivid
, IRID
)
/
--RAU UK_SUD
alter table i$SDD_SUD
add constraint UK_SUD
unique (parent_ivid
, EVENT_SUBSCRIPTION_REF
, EVENT_PUBLICATION_REF
)
deferrable initially deferred
/
--RAU SDD_SYN_RPK
alter table i$SDD_SYN
add constraint SDD_SYN_RPK primary key (ivid)
/
--RAU SDD_TAB_RPK
alter table i$SDD_TAB
add constraint SDD_TAB_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_TABENT
alter table i$SDD_TABENT
add constraint PK_SDD_TABENT primary key (parent_ivid
, IRID
)
/
--RAU UK_TABENT
alter table i$SDD_TABENT
add constraint UK_TABENT
unique (parent_ivid
, ENTITY_REF
)
deferrable initially deferred
/
--RAU PK_SDD_TAG
alter table i$SDD_TAG
add constraint PK_SDD_TAG primary key (parent_ivid
, IRID
)
/
--RAU UK_TAG
alter table i$SDD_TAG
add constraint UK_TAG
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_TAGVAL
alter table i$SDD_TAGVAL
add constraint PK_SDD_TAGVAL primary key (parent_ivid
, IRID
)
/
--RAU PK_SDD_TBICOL
alter table i$SDD_TBICOL
add constraint PK_SDD_TBICOL primary key (parent_ivid
, IRID
)
/
--RAU UK_TBICOL
alter table i$SDD_TBICOL
add constraint UK_TBICOL
unique (parent_ivid
, TABLE_IMPLEMENTATION_REF
, INDEX_STORAGE_REF
, COLUMN_REF
)
deferrable initially deferred
/
--RAU UK_TBICOL_2
alter table i$SDD_TBICOL
add constraint UK_TBICOL_2
unique (parent_ivid
, TABLE_IMPLEMENTATION_REF
, INDEX_STORAGE_REF
, SEQUENCE_NUMBER
)
deferrable initially deferred
/
--RAU PK_SDD_TBP
alter table i$SDD_TBP
add constraint PK_SDD_TBP primary key (parent_ivid
, IRID
)
/
--RAU UK_TBP
alter table i$SDD_TBP
add constraint UK_TBP
unique (parent_ivid
, TABLE_IMPLEMENTATION_REF
, NAME
)
deferrable initially deferred
/
--RAU UK_TBP_2
alter table i$SDD_TBP
add constraint UK_TBP_2
unique (parent_ivid
, TABLE_IMPLEMENTATION_REF
, SEQUENCE_NUMBER
)
deferrable initially deferred
/
--RAU SDD_TER_RPK
alter table i$SDD_TER
add constraint SDD_TER_RPK primary key (ivid)
/
--RAU SDD_TMS_RPK
alter table i$SDD_TMS
add constraint SDD_TMS_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_TRA
alter table i$SDD_TRA
add constraint PK_SDD_TRA primary key (parent_ivid
, IRID
)
/
--RAU UK_TRA
alter table i$SDD_TRA
add constraint UK_TRA
unique (parent_ivid
, SOURCE_ACTIVITY_REF
, SOURCE_ACT_USAGE_REF
, SOURCE_OBJECT_STATE_REF
, SOURCE_PSEUDOSTATE_REF
, SOURCE_EVENT_REF
, TARGET_ACTIVITY_REF
, TARGET_ACT_USAGE_REF
, TARGET_OBJECT_STATE_REF
, TARGET_PSEUDOSTATE_REF
, TARGET_EVENT_REF
, SEQUENCE_NUMBER
)
deferrable initially deferred
/
--RAU PK_SDD_TRG
alter table i$SDD_TRG
add constraint PK_SDD_TRG primary key (parent_ivid
, IRID
)
/
--RAU PK_SDD_TRGCOL
alter table i$SDD_TRGCOL
add constraint PK_SDD_TRGCOL primary key (parent_ivid
, IRID
)
/
--RAU UK_TRGCOL
alter table i$SDD_TRGCOL
add constraint UK_TRGCOL
unique (parent_ivid
, DATABASE_TRIGGER_REF
, COLUMN_REF
)
deferrable initially deferred
/
--RAU PK_SDD_TSQ
alter table i$SDD_TSQ
add constraint PK_SDD_TSQ primary key (parent_ivid
, IRID
)
/
--RAU UK_TSQ
alter table i$SDD_TSQ
add constraint UK_TSQ
unique (parent_ivid
, TABLESPACE_REF
, DATABASE_USER_REF
)
deferrable initially deferred
/
--RAU PK_SDD_UCA
alter table i$SDD_UCA
add constraint PK_SDD_UCA primary key (parent_ivid
, IRID
)
/
--RAU UK_UCA
alter table i$SDD_UCA
add constraint UK_UCA
unique (parent_ivid
, GENERAL_ACTION_REF
, SEQUENCE_IN_PARENT
)
deferrable initially deferred
/
--RAU SDD_UDE_RPK
alter table i$SDD_UDE
add constraint SDD_UDE_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_UDECLI
alter table i$SDD_UDECLI
add constraint PK_SDD_UDECLI primary key (parent_ivid
, IRID
)
/
--RAU UK_UDECLI
alter table i$SDD_UDECLI
add constraint UK_UDECLI
unique (parent_ivid
, CLIENT_ELEMENT_REF
)
deferrable initially deferred
/
--RAU PK_SDD_UDESUP
alter table i$SDD_UDESUP
add constraint PK_SDD_UDESUP primary key (parent_ivid
, IRID
)
/
--RAU UK_UDESUP
alter table i$SDD_UDESUP
add constraint UK_UDESUP
unique (parent_ivid
, SUPPLIER_ELEMENT_REF
)
deferrable initially deferred
/
--RAU SDD_UDS_RPK
alter table i$SDD_UDS
add constraint SDD_UDS_RPK primary key (ivid
, IRID
)
/
--RAU SDD_UEE_RPK
alter table i$SDD_UEE
add constraint SDD_UEE_RPK primary key (ivid)
/
--RAU PK_SDD_UES
alter table i$SDD_UES
add constraint PK_SDD_UES primary key (parent_ivid
, IRID
)
/
--RAU PK_SDD_UID
alter table i$SDD_UID
add constraint PK_SDD_UID primary key (parent_ivid
, IRID
)
/
--RAU UK_UID
alter table i$SDD_UID
add constraint UK_UID
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_UPR
alter table i$SDD_UPR
add constraint PK_SDD_UPR primary key (parent_ivid
, IRID
)
/
--RAU SDD_URU_RPK
alter table i$SDD_URU
add constraint SDD_URU_RPK primary key (ivid)
/
--RAU SDD_USC_RPK
alter table i$SDD_USC
add constraint SDD_USC_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_USCACR
alter table i$SDD_USCACR
add constraint PK_SDD_USCACR primary key (parent_ivid
, IRID
)
/
--RAU UK_USCACR
alter table i$SDD_USCACR
add constraint UK_USCACR
unique (parent_ivid
, ACTOR_REF
)
deferrable initially deferred
/
--RAU PK_SDD_USCE1
alter table i$SDD_USCE1
add constraint PK_SDD_USCE1 primary key (parent_ivid
, IRID
)
/
--RAU UK_USCE1
alter table i$SDD_USCE1
add constraint UK_USCE1
unique (parent_ivid
, OBJECTIVE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_USCEPA
alter table i$SDD_USCEPA
add constraint PK_SDD_USCEPA primary key (parent_ivid
, IRID
)
/
--RAU UK_USCEPA
alter table i$SDD_USCEPA
add constraint UK_USCEPA
unique (parent_ivid
, EXTENSION_POINT_REF
)
deferrable initially deferred
/
--RAU PK_SDD_USCEVI
alter table i$SDD_USCEVI
add constraint PK_SDD_USCEVI primary key (parent_ivid
, IRID
)
/
--RAU UK_USCEVI
alter table i$SDD_USCEVI
add constraint UK_USCEVI
unique (parent_ivid
, EVENT_CLASSIFIER_REF
)
deferrable initially deferred
/
--RAU PK_SDD_USCEVO
alter table i$SDD_USCEVO
add constraint PK_SDD_USCEVO primary key (parent_ivid
, IRID
)
/
--RAU UK_USCEVO
alter table i$SDD_USCEVO
add constraint UK_USCEVO
unique (parent_ivid
, EVENT_CLASSIFIER_REF
)
deferrable initially deferred
/
--RAU PK_SDD_USCUSC
alter table i$SDD_USCUSC
add constraint PK_SDD_USCUSC primary key (parent_ivid
, IRID
)
/
--RAU UK_USCUSC
alter table i$SDD_USCUSC
add constraint UK_USCUSC
unique (parent_ivid
, SUPERTYPE_REF
)
deferrable initially deferred
/
--RAU PK_SDD_VAL
alter table i$SDD_VAL
add constraint PK_SDD_VAL primary key (parent_ivid
, IRID
)
/
--RAU UK_VAL
alter table i$SDD_VAL
add constraint UK_VAL
unique (parent_ivid
, ATTRIBUTE_DOMAIN_REF
, INTEGRITY_RULE_REF
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_VALGAT
alter table i$SDD_VALGAT
add constraint PK_SDD_VALGAT primary key (parent_ivid
, IRID
)
/
--RAU UK_VALGAT
alter table i$SDD_VALGAT
add constraint UK_VALGAT
unique (parent_ivid
, VALIDATOR_REF
, GENERAL_ATTRIBUTE_REF
, VALUE
)
deferrable initially deferred
/
--RAU PK_SDD_VLE
alter table i$SDD_VLE
add constraint PK_SDD_VLE primary key (parent_ivid
, IRID
)
/
--RAU UK_VLE
alter table i$SDD_VLE
add constraint UK_VLE
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_VLEU
alter table i$SDD_VLEU
add constraint PK_SDD_VLEU primary key (parent_ivid
, IRID
)
/
--RAU UK_VLEU
alter table i$SDD_VLEU
add constraint UK_VLEU
unique (parent_ivid
, VIEW_LINK_USAGE_REF
, VIEW_LINK_END_REF
)
deferrable initially deferred
/
--RAU PK_SDD_VLEVOA
alter table i$SDD_VLEVOA
add constraint PK_SDD_VLEVOA primary key (parent_ivid
, IRID
)
/
--RAU UK_VLEVOA
alter table i$SDD_VLEVOA
add constraint UK_VLEVOA
unique (parent_ivid
, VIEW_LINK_END_REF
, VIEW_OBJECT_ATT_REF
)
deferrable initially deferred
/
--RAU SDD_VLI_RPK
alter table i$SDD_VLI
add constraint SDD_VLI_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_VLU
alter table i$SDD_VLU
add constraint PK_SDD_VLU primary key (parent_ivid
, IRID
)
/
--RAU UK_VLU
alter table i$SDD_VLU
add constraint UK_VLU
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_VOU
alter table i$SDD_VOU
add constraint PK_SDD_VOU primary key (parent_ivid
, IRID
)
/
--RAU UK_VOU
alter table i$SDD_VOU
add constraint UK_VOU
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU PK_SDD_VWTAB
alter table i$SDD_VWTAB
add constraint PK_SDD_VWTAB primary key (parent_ivid
, IRID
)
/
--RAU UK_VWTAB
alter table i$SDD_VWTAB
add constraint UK_VWTAB
unique (parent_ivid
, TABLE_REF
, SEQUENCE_NUMBER
)
deferrable initially deferred
/
--RAU PK_SDD_WAT
alter table i$SDD_WAT
add constraint PK_SDD_WAT primary key (parent_ivid
, IRID
)
/
--RAU UK_HANDCRAFTED_WAT
alter table i$SDD_WAT
add constraint UK_HANDCRAFTED_WAT
unique (parent_ivid
, WORKFLOW_ITEM_TYPE_REF
, WORKFLOW_MESS_TYPE_REF
, NAME
)
deferrable initially deferred
/
--RAU UK_HANDCRAFTED_WAT_2
alter table i$SDD_WAT
add constraint UK_HANDCRAFTED_WAT_2
unique (parent_ivid
, WORKFLOW_ITEM_TYPE_REF
, WORKFLOW_MESS_TYPE_REF
, IMPLEMENTATION_NAME
)
deferrable initially deferred
/
--RAU PK_SDD_WIN
alter table i$SDD_WIN
add constraint PK_SDD_WIN primary key (parent_ivid
, IRID
)
/
--RAU UK_WIN
alter table i$SDD_WIN
add constraint UK_WIN
unique (parent_ivid
, GENERAL_MODULE_REF
, NAME
)
deferrable initially deferred
/
--RAU SDD_WIT_RPK
alter table i$SDD_WIT
add constraint SDD_WIT_RPK primary key (ivid
, IRID
)
/
--RAU PK_SDD_WMT
alter table i$SDD_WMT
add constraint PK_SDD_WMT primary key (parent_ivid
, IRID
)
/
--RAU UK_WMT
alter table i$SDD_WMT
add constraint UK_WMT
unique (parent_ivid
, NAME
)
deferrable initially deferred
/
--RAU UK_WMT_2
alter table i$SDD_WMT
add constraint UK_WMT_2
unique (parent_ivid
, IMPLEMENTATION_NAME
)
deferrable initially deferred
/
--RAU FK_A1_TO_E1
alter table i$SDD_A1
add constraint FK_A1_TO_E1 foreign key (parent_ivid
  , OBJECTIVE_REF
)
references i$SDD_E1
on delete cascade deferrable initially deferred
/
--RAU FK_A10_TO_BUN
alter table i$SDD_A10
add constraint FK_A10_TO_BUN foreign key (parent_ivid
  , BUSINESS_UNIT_REF
)
references i$SDD_BUN
on delete cascade deferrable initially deferred
/
--RAU FK_A11_TO_E3
alter table i$SDD_A11
add constraint FK_A11_TO_E3 foreign key (parent_ivid
  , KPI_REF
)
references i$SDD_E3
on delete cascade deferrable initially deferred
/
--RAU FK_A2_TO_E1
alter table i$SDD_A2
add constraint FK_A2_TO_E1 foreign key (parent_ivid
  , OBJECTIVE_REF
)
references i$SDD_E1
on delete cascade deferrable initially deferred
/
--RAU FK_A20_TO_E20
alter table i$SDD_A20
add constraint FK_A20_TO_E20 foreign key (parent_ivid
  , PART_OF_NODE_REF
)
references i$SDD_E20
on delete cascade deferrable initially deferred
/
--RAU FK_A21_TO_E6
alter table i$SDD_A21
add constraint FK_A21_TO_E6 foreign key (parent_ivid
  , LOCATION_REF
)
references i$SDD_E6
on delete cascade deferrable initially deferred
/
--RAU FK_A23_TO_E20
alter table i$SDD_A23
add constraint FK_A23_TO_E20 foreign key (parent_ivid
  , NODE_REF
)
references i$SDD_E20
on delete cascade deferrable initially deferred
/
--RAU FK_A24_TO_E20
alter table i$SDD_A24
add constraint FK_A24_TO_E20 foreign key (parent_ivid
  , NODE_REF
)
references i$SDD_E20
on delete cascade deferrable initially deferred
/
--RAU FK_A3_TO_E1
alter table i$SDD_A3
add constraint FK_A3_TO_E1 foreign key (parent_ivid
  , OBJECTIVE_REF
)
references i$SDD_E1
on delete cascade deferrable initially deferred
/
--RAU FK_A4_TO_E1
alter table i$SDD_A4
add constraint FK_A4_TO_E1 foreign key (parent_ivid
  , OBJECTIVE_REF
)
references i$SDD_E1
on delete cascade deferrable initially deferred
/
--RAU FK_A5_TO_E4
alter table i$SDD_A5
add constraint FK_A5_TO_E4 foreign key (parent_ivid
  , ASSUMPTION_REF
)
references i$SDD_E4
on delete cascade deferrable initially deferred
/
--RAU FK_A6_TO_E4
alter table i$SDD_A6
add constraint FK_A6_TO_E4 foreign key (parent_ivid
  , ASSUMPTION_REF
)
references i$SDD_E4
on delete cascade deferrable initially deferred
/
--RAU FK_A7_TO_E5
alter table i$SDD_A7
add constraint FK_A7_TO_E5 foreign key (parent_ivid
  , PROBLEM_REF
)
references i$SDD_E5
on delete cascade deferrable initially deferred
/
--RAU FK_A8_TO_BUN
alter table i$SDD_A8
add constraint FK_A8_TO_BUN foreign key (parent_ivid
  , BUSINESS_UNIT_REF
)
references i$SDD_BUN
on delete cascade deferrable initially deferred
/
--RAU FK_A9_TO_E6
alter table i$SDD_A9
add constraint FK_A9_TO_E6 foreign key (parent_ivid
  , LOCATION_REF
)
references i$SDD_E6
on delete cascade deferrable initially deferred
/
--RAU FK_ACI_TO_MCN
alter table i$SDD_ACI
add constraint FK_ACI_TO_MCN foreign key (parent_ivid
  , MCN_REF
)
references i$SDD_MCN
on delete cascade deferrable initially deferred
/
--RAU FK_ACI_TO_WIN
alter table i$SDD_ACI
add constraint FK_ACI_TO_WIN foreign key (parent_ivid
  , WINDOW_REF
)
references i$SDD_WIN
on delete cascade deferrable initially deferred
/
--RAU FK_ACRACR_TO_ACR
alter table i$SDD_ACRACR
add constraint FK_ACRACR_TO_ACR foreign key (parent_ivid
  , SUBTYPE_ACTOR_REF
)
references i$SDD_ACR
on delete cascade deferrable initially deferred
/
--RAU FK_ACRORG_TO_ORG
alter table i$SDD_ACRORG
add constraint FK_ACRORG_TO_ORG foreign key (parent_ivid
  , ORGANIZATION_UNIT_REF
)
references i$SDD_ORG
on delete cascade deferrable initially deferred
/
--RAU FK_ACTACT_TO_ACT
alter table i$SDD_ACTACT
add constraint FK_ACTACT_TO_ACT foreign key (parent_ivid
  , PARENT_ACTIVITY_REF
)
references i$SDD_ACT
on delete cascade deferrable initially deferred
/
--RAU FK_ACTE1_TO_ACT
alter table i$SDD_ACTE1
add constraint FK_ACTE1_TO_ACT foreign key (parent_ivid
  , ACTIVITY_DEFINITION_REF
)
references i$SDD_ACT
on delete cascade deferrable initially deferred
/
--RAU FK_ACTORG_TO_ACT
alter table i$SDD_ACTORG
add constraint FK_ACTORG_TO_ACT foreign key (parent_ivid
  , ACTIVITY_REF
)
references i$SDD_ACT
on delete cascade deferrable initially deferred
/
--RAU FK_ACUACR_TO_ACTORG
alter table i$SDD_ACUACR
add constraint FK_ACUACR_TO_ACTORG foreign key (parent_ivid
  , ACTIVITY_USAGE_REF
)
references i$SDD_ACTORG
on delete cascade deferrable initially deferred
/
--RAU FK_ADR_TO_CAT
alter table i$SDD_ADR
add constraint FK_ADR_TO_CAT foreign key (parent_ivid
  , CLASSIFIER_ATTRIBUTE_REF
)
references i$SDD_CAT
on delete cascade deferrable initially deferred
/
--RAU FK_AEN_TO_ASS
alter table i$SDD_AEN
add constraint FK_AEN_TO_ASS foreign key (parent_ivid
  , ASSOCIATION_REF
)
references i$SDD_ASS
on delete cascade deferrable initially deferred
/
--RAU FK_AENEAT_TO_AEN
alter table i$SDD_AENEAT
add constraint FK_AENEAT_TO_AEN foreign key (parent_ivid
  , ASSOCIATION_END_REF
)
references i$SDD_AEN
on delete cascade deferrable initially deferred
/
--RAU FK_AEU_TO_EOU
alter table i$SDD_AEU
add constraint FK_AEU_TO_EOU foreign key (parent_ivid
  , ENTITY_OBJECT_USAGE_REF
)
references i$SDD_EOU
on delete cascade deferrable initially deferred
/
--RAU FK_AMCAMC_TO_AMC
alter table i$SDD_AMCAMC
add constraint FK_AMCAMC_TO_AMC foreign key (parent_ivid
  , PARENT_APP_MODULE_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_AMCBOB_TO_AMC
alter table i$SDD_AMCBOB
add constraint FK_AMCBOB_TO_AMC foreign key (parent_ivid
  , APPLICATION_MODULE_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_AMCPRJ_TO_AMC
alter table i$SDD_AMCPRJ
add constraint FK_AMCPRJ_TO_AMC foreign key (parent_ivid
  , APPLICATION_MODULE_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_ARGITE_TO_ARG
alter table i$SDD_ARGITE
add constraint FK_ARGITE_TO_ARG foreign key (parent_ivid
  , MODULE_ARGUMENT_REF
)
references i$SDD_ARG
on delete cascade deferrable initially deferred
/
--RAU FK_ASSASS_TO_AEN
alter table i$SDD_ASSASS
add constraint FK_ASSASS_TO_AEN foreign key (parent_ivid
  , PART_OF_ASSOC_END_REF
)
references i$SDD_AEN
on delete cascade deferrable initially deferred
/
--RAU FK_ATT_TO_ENT
alter table i$SDD_ATT
add constraint FK_ATT_TO_ENT foreign key (parent_ivid
  , ENTITY_REF
)
references i$SDD_ENT
on delete cascade deferrable initially deferred
/
--RAU FK_ATV_TO_DOM
alter table i$SDD_ATV
add constraint FK_ATV_TO_DOM foreign key (parent_ivid
  , DOMAIN_REF
)
references i$SDD_DOM
on delete cascade deferrable initially deferred
/
--RAU FK_ATV_TO_UBI
alter table i$SDD_ATV
add constraint FK_ATV_TO_UBI foreign key (parent_ivid
  , UNBOUND_ITEM_REF
)
references i$SDD_ITE
on delete cascade deferrable initially deferred
/
--RAU FK_ATV_TO_ARG
alter table i$SDD_ATV
add constraint FK_ATV_TO_ARG foreign key (parent_ivid
  , MODULE_ARGUMENT_REF
)
references i$SDD_ARG
on delete cascade deferrable initially deferred
/
--RAU FK_ATV_TO_ATT
alter table i$SDD_ATV
add constraint FK_ATV_TO_ATT foreign key (parent_ivid
  , ATTRIBUTE_REF
)
references i$SDD_ATT
on delete cascade deferrable initially deferred
/
--RAU FK_ATV_TO_COL
alter table i$SDD_ATV
add constraint FK_ATV_TO_COL foreign key (parent_ivid
  , COLUMN_REF
)
references i$SDD_COL
on delete cascade deferrable initially deferred
/
--RAU FK_BLI_TO_BAT
alter table i$SDD_BLI
add constraint FK_BLI_TO_BAT foreign key (parent_ivid
  , BATCH_REF
)
references i$SDD_BAT
on delete cascade deferrable initially deferred
/
--RAU FK_BOBINC_TO_BOB
alter table i$SDD_BOBINC
add constraint FK_BOBINC_TO_BOB foreign key (parent_ivid
  , BUSINESS_OBJECT_REF
)
references i$SDD_BOB
on delete cascade deferrable initially deferred
/
--RAU FK_BRL_TO_SNI
alter table i$SDD_BRL
add constraint FK_BRL_TO_SNI foreign key (parent_ivid
  , SNAPSHOT_REF
)
references i$SDD_DOI
on delete cascade deferrable initially deferred
/
--RAU FK_BRL_TO_VWI
alter table i$SDD_BRL
add constraint FK_BRL_TO_VWI foreign key (parent_ivid
  , VIEW_IMPLEMENTATION_REF
)
references i$SDD_DOI
on delete cascade deferrable initially deferred
/
--RAU FK_BRU_TO_BAT
alter table i$SDD_BRU
add constraint FK_BRU_TO_BAT foreign key (parent_ivid
  , BATCH_REF
)
references i$SDD_BAT
on delete cascade deferrable initially deferred
/
--RAU FK_BRUBLI_TO_BRU
alter table i$SDD_BRUBLI
add constraint FK_BRUBLI_TO_BRU foreign key (parent_ivid
  , BATCH_RUN_REF
)
references i$SDD_BRU
on delete cascade deferrable initially deferred
/
--RAU FK_CAT_TO_ADC
alter table i$SDD_CAT
add constraint FK_CAT_TO_ADC foreign key (parent_ivid
  , ATTRIBUTE_DOMAIN_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_CAT_TO_EOC
alter table i$SDD_CAT
add constraint FK_CAT_TO_EOC foreign key (parent_ivid
  , ENTITY_OBJECT_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_CAT_TO_EVC
alter table i$SDD_CAT
add constraint FK_CAT_TO_EVC foreign key (parent_ivid
  , EVENT_CLASSIFIER_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_CAT_TO_GEC
alter table i$SDD_CAT
add constraint FK_CAT_TO_GEC foreign key (parent_ivid
  , GENERIC_CLASS_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_CAT_TO_INC
alter table i$SDD_CAT
add constraint FK_CAT_TO_INC foreign key (parent_ivid
  , INTERFACE_CLASSIFIER_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_CAT_TO_VOB
alter table i$SDD_CAT
add constraint FK_CAT_TO_VOB foreign key (parent_ivid
  , VIEW_OBJECT_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_CATAEN_TO_AEN
alter table i$SDD_CATAEN
add constraint FK_CATAEN_TO_AEN foreign key (parent_ivid
  , ASSOCIATION_END_REF
)
references i$SDD_AEN
on delete cascade deferrable initially deferred
/
--RAU FK_CATEAT_TO_GAT
alter table i$SDD_CATEAT
add constraint FK_CATEAT_TO_GAT foreign key (parent_ivid
  , GENERAL_ATTRIBUTE_REF
)
references i$SDD_CAT
on delete cascade deferrable initially deferred
/
--RAU FK_CCD_TO_OCL
alter table i$SDD_CCD
add constraint FK_CCD_TO_OCL foreign key (parent_ivid
  , CLUSTER_REF
)
references i$SDD_OCL
on delete cascade deferrable initially deferred
/
--RAU FK_CLAAEN_TO_INC
alter table i$SDD_CLAAEN
add constraint FK_CLAAEN_TO_INC foreign key (parent_ivid
  , INTERFACE_CLASSIFIER_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_CLACLA_TO_CLA
alter table i$SDD_CLACLA
add constraint FK_CLACLA_TO_CLA foreign key (parent_ivid
  , SUBTYPE_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_CLAEVC_TO_CLA
alter table i$SDD_CLAEVC
add constraint FK_CLAEVC_TO_CLA foreign key (parent_ivid
  , CLASSIFIER_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_CLAINC_TO_CLA
alter table i$SDD_CLAINC
add constraint FK_CLAINC_TO_CLA foreign key (parent_ivid
  , CLASSIFIER_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_CMA_TO_EVH
alter table i$SDD_CMA
add constraint FK_CMA_TO_EVH foreign key (parent_ivid
  , EVENT_HANDLER_REF
)
references i$SDD_EVH
on delete cascade deferrable initially deferred
/
--RAU FK_CMA_TO_EVR
alter table i$SDD_CMA
add constraint FK_CMA_TO_EVR foreign key (parent_ivid
  , EVENT_RAISER_REF
)
references i$SDD_EVR
on delete cascade deferrable initially deferred
/
--RAU FK_CNU_TO_MTI
alter table i$SDD_CNU
add constraint FK_CNU_TO_MTI foreign key (parent_ivid
  , TABLE_USAGE_REF
)
references i$SDD_MTI
on delete cascade deferrable initially deferred
/
--RAU FK_COB_TO_BLI
alter table i$SDD_COB
add constraint FK_COB_TO_BLI foreign key (parent_ivid
  , BATCHLINE_REF
)
references i$SDD_BLI
on delete cascade deferrable initially deferred
/
--RAU FK_COL_TO_OOT
alter table i$SDD_COL
add constraint FK_COL_TO_OOT foreign key (parent_ivid
  , ORACLE_OBJECT_TYPE_REF
)
references i$SDD_ORT
on delete cascade deferrable initially deferred
/
--RAU FK_COL_TO_TAB
alter table i$SDD_COL
add constraint FK_COL_TO_TAB foreign key (parent_ivid
  , TABLE_REF
)
references i$SDD_TAB
on delete cascade deferrable initially deferred
/
--RAU FK_COMNOD_TO_COM
alter table i$SDD_COMNOD
add constraint FK_COMNOD_TO_COM foreign key (parent_ivid
  , COMMUNITY_REF
)
references i$SDD_COM
on delete cascade deferrable initially deferred
/
--RAU FK_COMODB_TO_COM
alter table i$SDD_COMODB
add constraint FK_COMODB_TO_COM foreign key (parent_ivid
  , COMMUNITY_REF
)
references i$SDD_COM
on delete cascade deferrable initially deferred
/
--RAU FK_CORI_TO_COR
alter table i$SDD_CORI
add constraint FK_CORI_TO_COR foreign key (parent_ivid
  , CROSS_OBJECT_RULE_REF
)
references i$SDD_COR
on delete cascade deferrable initially deferred
/
--RAU FK_CQA_TO_TBL
alter table i$SDD_CQA
add constraint FK_CQA_TO_TBL foreign key (parent_ivid
  , TABLE_DEFINITION_REF
)
references i$SDD_TAB
on delete cascade deferrable initially deferred
/
--RAU FK_CQACOL_TO_CQA
alter table i$SDD_CQACOL
add constraint FK_CQACOL_TO_CQA foreign key (parent_ivid
  , CQA_REF
)
references i$SDD_CQA
on delete cascade deferrable initially deferred
/
--RAU FK_CRU_TO_EOC
alter table i$SDD_CRU
add constraint FK_CRU_TO_EOC foreign key (parent_ivid
  , ENTITY_OBJECT_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_CRU_TO_GEC
alter table i$SDD_CRU
add constraint FK_CRU_TO_GEC foreign key (parent_ivid
  , GENERIC_CLASS_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_CRU_TO_INC
alter table i$SDD_CRU
add constraint FK_CRU_TO_INC foreign key (parent_ivid
  , INTERFACE_CLASSIFIER_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_CRU_TO_VOB
alter table i$SDD_CRU
add constraint FK_CRU_TO_VOB foreign key (parent_ivid
  , VIEW_OBJECT_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_CSG_TO_CLA
alter table i$SDD_CSG
add constraint FK_CSG_TO_CLA foreign key (parent_ivid
  , CLASSIFIER_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_CST_TO_TBI
alter table i$SDD_CST
add constraint FK_CST_TO_TBI foreign key (parent_ivid
  , TABLE_IMPLEMENTATION_REF
)
references i$SDD_DOI
on delete cascade deferrable initially deferred
/
--RAU FK_DATCOM_TO_ARR
alter table i$SDD_DATCOM
add constraint FK_DATCOM_TO_ARR foreign key (parent_ivid
  , ARC_RULE_REF
)
references i$SDD_CRU
on delete cascade deferrable initially deferred
/
--RAU FK_DATCOM_TO_UNR
alter table i$SDD_DATCOM
add constraint FK_DATCOM_TO_UNR foreign key (parent_ivid
  , UNIQUENESS_RULE_REF
)
references i$SDD_CRU
on delete cascade deferrable initially deferred
/
--RAU FK_DBU_TO_ODB
alter table i$SDD_DBU
add constraint FK_DBU_TO_ODB foreign key (parent_ivid
  , DATABASE_REF
)
references i$SDD_ODB
on delete cascade deferrable initially deferred
/
--RAU FK_DBUGRP_TO_DBU
alter table i$SDD_DBUGRP
add constraint FK_DBUGRP_TO_DBU foreign key (parent_ivid
  , DATABASE_USER_REF
)
references i$SDD_DBU
on delete cascade deferrable initially deferred
/
--RAU FK_DBUMOD_TO_DBU
alter table i$SDD_DBUMOD
add constraint FK_DBUMOD_TO_DBU foreign key (parent_ivid
  , DATABASE_USER_REF
)
references i$SDD_DBU
on delete cascade deferrable initially deferred
/
--RAU FK_DEU_TO_DIA
alter table i$SDD_DEU
add constraint FK_DEU_TO_DIA foreign key (parent_ivid
  , DIAGRAM_REF
)
references i$SDD_DIA
on delete cascade deferrable initially deferred
/
--RAU FK_DFI_TO_ORC
alter table i$SDD_DFI
add constraint FK_DFI_TO_ORC foreign key (parent_ivid
  , ORACLE_DATABASE_REF
)
references i$SDD_ODB
on delete cascade deferrable initially deferred
/
--RAU FK_DFI_TO_OTB
alter table i$SDD_DFI
add constraint FK_DFI_TO_OTB foreign key (parent_ivid
  , TABLESPACE_REF
)
references i$SDD_OTB
on delete cascade deferrable initially deferred
/
--RAU FK_DFL_TO_DST
alter table i$SDD_DFL
add constraint FK_DFL_TO_DST foreign key (parent_ivid
  , DATASTORE_SOURCE_REF
)
references i$SDD_DST
on delete cascade deferrable initially deferred
/
--RAU FK_DFL_TO_EXT
alter table i$SDD_DFL
add constraint FK_DFL_TO_EXT foreign key (parent_ivid
  , EXTERNAL_SOURCE_REF
)
references i$SDD_EXT
on delete cascade deferrable initially deferred
/
--RAU FK_DFL_TO_FUN
alter table i$SDD_DFL
add constraint FK_DFL_TO_FUN foreign key (parent_ivid
  , FUNCTION_SOURCE_REF
)
references i$SDD_FUN
on delete cascade deferrable initially deferred
/
--RAU FK_DFLATT_TO_DFL
alter table i$SDD_DFLATT
add constraint FK_DFLATT_TO_DFL foreign key (parent_ivid
  , DATAFLOW_REF
)
references i$SDD_DFL
on delete cascade deferrable initially deferred
/
--RAU FK_DFLDIT_TO_DFL
alter table i$SDD_DFLDIT
add constraint FK_DFLDIT_TO_DFL foreign key (parent_ivid
  , DATAFLOW_REF
)
references i$SDD_DFL
on delete cascade deferrable initially deferred
/
--RAU FK_DIR_TO_ORC
alter table i$SDD_DIR
add constraint FK_DIR_TO_ORC foreign key (parent_ivid
  , ORACLE_DATABASE_REF
)
references i$SDD_ODB
on delete cascade deferrable initially deferred
/
--RAU FK_DOCXXX_TO_DOC
alter table i$SDD_DOCXXX
add constraint FK_DOCXXX_TO_DOC foreign key (parent_ivid
  , DOCUMENT_REF
)
references i$SDD_DOC
on delete cascade deferrable initially deferred
/
--RAU FK_DOG_TO_DBU
alter table i$SDD_DOG
add constraint FK_DOG_TO_DBU foreign key (parent_ivid
  , DATABASE_USER_REF
)
references i$SDD_DBU
on delete cascade deferrable initially deferred
/
--RAU FK_DOG_TO_GRP
alter table i$SDD_DOG
add constraint FK_DOG_TO_GRP foreign key (parent_ivid
  , ROLE_REF
)
references i$SDD_GRP
on delete cascade deferrable initially deferred
/
--RAU FK_DOI_TO_DBU
alter table i$SDD_DOI
add constraint FK_DOI_TO_DBU foreign key (parent_ivid
  , DATABASE_USER_REF
)
references i$SDD_DBU
on delete cascade deferrable initially deferred
/
--RAU FK_DPR_TO_ORC
alter table i$SDD_DPR
add constraint FK_DPR_TO_ORC foreign key (parent_ivid
  , ORACLE_DATABASE_REF
)
references i$SDD_ODB
on delete cascade deferrable initially deferred
/
--RAU FK_DSTATT_TO_DST
alter table i$SDD_DSTATT
add constraint FK_DSTATT_TO_DST foreign key (parent_ivid
  , DATASTORE_REF
)
references i$SDD_DST
on delete cascade deferrable initially deferred
/
--RAU FK_DSTDIT_TO_DST
alter table i$SDD_DSTDIT
add constraint FK_DSTDIT_TO_DST foreign key (parent_ivid
  , DATASTORE_REF
)
references i$SDD_DST
on delete cascade deferrable initially deferred
/
--RAU FK_DSY_TO_OSQ
alter table i$SDD_DSY
add constraint FK_DSY_TO_OSQ foreign key (parent_ivid
  , SEQUENCE_REF
)
references i$SDD_OSQ
on delete cascade deferrable initially deferred
/
--RAU FK_DSY_TO_SNP
alter table i$SDD_DSY
add constraint FK_DSY_TO_SNP foreign key (parent_ivid
  , SNAPSHOT_DEFINITION_REF
)
references i$SDD_TAB
on delete cascade deferrable initially deferred
/
--RAU FK_DSY_TO_TBL
alter table i$SDD_DSY
add constraint FK_DSY_TO_TBL foreign key (parent_ivid
  , TABLE_DEFINITION_REF
)
references i$SDD_TAB
on delete cascade deferrable initially deferred
/
--RAU FK_DSY_TO_VW
alter table i$SDD_DSY
add constraint FK_DSY_TO_VW foreign key (parent_ivid
  , VIEW_DEFINITION_REF
)
references i$SDD_TAB
on delete cascade deferrable initially deferred
/
--RAU FK_ENTBUN_TO_ENT
alter table i$SDD_ENTBUN
add constraint FK_ENTBUN_TO_ENT foreign key (parent_ivid
  , ENTITY_REF
)
references i$SDD_ENT
on delete cascade deferrable initially deferred
/
--RAU FK_ENTUIE_TO_UID
alter table i$SDD_ENTUIE
add constraint FK_ENTUIE_TO_UID foreign key (parent_ivid
  , UNIQUE_IDENTIFIER_REF
)
references i$SDD_UID
on delete cascade deferrable initially deferred
/
--RAU FK_EOU_TO_VOB
alter table i$SDD_EOU
add constraint FK_EOU_TO_VOB foreign key (parent_ivid
  , VIEW_OBJECT_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_EVH_TO_MET
alter table i$SDD_EVH
add constraint FK_EVH_TO_MET foreign key (parent_ivid
  , METHOD_REF
)
references i$SDD_MET
on delete cascade deferrable initially deferred
/
--RAU FK_EVR_TO_MET
alter table i$SDD_EVR
add constraint FK_EVR_TO_MET foreign key (parent_ivid
  , METHOD_REF
)
references i$SDD_MET
on delete cascade deferrable initially deferred
/
--RAU FK_EVS_TO_CLA
alter table i$SDD_EVS
add constraint FK_EVS_TO_CLA foreign key (parent_ivid
  , CLASSIFIER_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_FILPAC_TO_ASS
alter table i$SDD_FILPAC
add constraint FK_FILPAC_TO_ASS foreign key (parent_ivid
  , ASSOCIATION_REF
)
references i$SDD_ASS
on delete cascade deferrable initially deferred
/
--RAU FK_FILPAC_TO_CLA
alter table i$SDD_FILPAC
add constraint FK_FILPAC_TO_CLA foreign key (parent_ivid
  , CLASSIFIER_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_FILPAC_TO_DIA
alter table i$SDD_FILPAC
add constraint FK_FILPAC_TO_DIA foreign key (parent_ivid
  , DIAGRAM_REF
)
references i$SDD_DIA
on delete cascade deferrable initially deferred
/
--RAU FK_FILPAC_TO_VLI
alter table i$SDD_FILPAC
add constraint FK_FILPAC_TO_VLI foreign key (parent_ivid
  , VIEW_LINK_REF
)
references i$SDD_VLI
on delete cascade deferrable initially deferred
/
--RAU FK_FM_TO_FOLDER
alter table i$SDD_FOLDER_MEMBERS
add constraint FK_FM_TO_FOLDER foreign key (parent_ivid
  , FOLDER_REFERENCE
)
references i$SDD_FOLDERS
on delete cascade deferrable initially deferred
/
--RAU FK_FSE_TO_CLA
alter table i$SDD_FSE
add constraint FK_FSE_TO_CLA foreign key (parent_ivid
  , CLASSIFIER_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_FUNATT_TO_FUN
alter table i$SDD_FUNATT
add constraint FK_FUNATT_TO_FUN foreign key (parent_ivid
  , FUNCTION_REF
)
references i$SDD_FUN
on delete cascade deferrable initially deferred
/
--RAU FK_FUNBUN_TO_FUN
alter table i$SDD_FUNBUN
add constraint FK_FUNBUN_TO_FUN foreign key (parent_ivid
  , FUNCTION_REF
)
references i$SDD_FUN
on delete cascade deferrable initially deferred
/
--RAU FK_FUNENT_TO_FUN
alter table i$SDD_FUNENT
add constraint FK_FUNENT_TO_FUN foreign key (parent_ivid
  , FUNCTION_REF
)
references i$SDD_FUN
on delete cascade deferrable initially deferred
/
--RAU FK_FUNEVT_TO_EVT2
alter table i$SDD_FUNEVT
add constraint FK_FUNEVT_TO_EVT2 foreign key (parent_ivid
  , TRIGGERED_EVENT_REF
)
references i$SDD_EVT
on delete cascade deferrable initially deferred
/
--RAU FK_FUNEVT_TO_FUN2
alter table i$SDD_FUNEVT
add constraint FK_FUNEVT_TO_FUN2 foreign key (parent_ivid
  , TRIGGERED_FUNCTION_REF
)
references i$SDD_FUN
on delete cascade deferrable initially deferred
/
--RAU FK_GRP_TO_ORC
alter table i$SDD_GRP
add constraint FK_GRP_TO_ORC foreign key (parent_ivid
  , ORACLE_DATABASE_REF
)
references i$SDD_ODB
on delete cascade deferrable initially deferred
/
--RAU FK_GRPGRP_TO_GRP2
alter table i$SDD_GRPGRP
add constraint FK_GRPGRP_TO_GRP2 foreign key (parent_ivid
  , GRANTEE_ROLE_REF
)
references i$SDD_GRP
on delete cascade deferrable initially deferred
/
--RAU FK_GRPMOD_TO_GRP
alter table i$SDD_GRPMOD
add constraint FK_GRPMOD_TO_GRP foreign key (parent_ivid
  , ROLE_REF
)
references i$SDD_GRP
on delete cascade deferrable initially deferred
/
--RAU FK_IND_TO_OCL
alter table i$SDD_IND
add constraint FK_IND_TO_OCL foreign key (parent_ivid
  , CLUSTER_REF
)
references i$SDD_OCL
on delete cascade deferrable initially deferred
/
--RAU FK_IND_TO_SNP
alter table i$SDD_IND
add constraint FK_IND_TO_SNP foreign key (parent_ivid
  , SNAPSHOT_DEFINITION_REF
)
references i$SDD_TAB
on delete cascade deferrable initially deferred
/
--RAU FK_IND_TO_TBL
alter table i$SDD_IND
add constraint FK_IND_TO_TBL foreign key (parent_ivid
  , TABLE_DEFINITION_REF
)
references i$SDD_TAB
on delete cascade deferrable initially deferred
/
--RAU FK_INDCOL_TO_RIN
alter table i$SDD_INDCOL
add constraint FK_INDCOL_TO_RIN foreign key (parent_ivid
  , RELATION_INDEX_REF
)
references i$SDD_IND
on delete cascade deferrable initially deferred
/
--RAU FK_INP_TO_INS
alter table i$SDD_INP
add constraint FK_INP_TO_INS foreign key (parent_ivid
  , INDEX_STORAGE_REF
)
references i$SDD_INS
on delete cascade deferrable initially deferred
/
--RAU FK_INS_TO_CLI
alter table i$SDD_INS
add constraint FK_INS_TO_CLI foreign key (parent_ivid
  , CLUSTER_REF
)
references i$SDD_DOI
on delete cascade deferrable initially deferred
/
--RAU FK_INS_TO_SNI
alter table i$SDD_INS
add constraint FK_INS_TO_SNI foreign key (parent_ivid
  , SNAPSHOT_REF
)
references i$SDD_DOI
on delete cascade deferrable initially deferred
/
--RAU FK_INS_TO_TBI
alter table i$SDD_INS
add constraint FK_INS_TO_TBI foreign key (parent_ivid
  , TABLE_IMPLEMENTATION_REF
)
references i$SDD_DOI
on delete cascade deferrable initially deferred
/
--RAU FK_ITE_TO_SQS
alter table i$SDD_ITE
add constraint FK_ITE_TO_SQS foreign key (parent_ivid
  , SQL_QUERY_SET_REF
)
references i$SDD_SQS
on delete cascade deferrable initially deferred
/
--RAU FK_ITM_TO_DAT
alter table i$SDD_ITM
add constraint FK_ITM_TO_DAT foreign key (parent_ivid
  , DATASTRUCTURE_REF
)
references i$SDD_DAT
on delete cascade deferrable initially deferred
/
--RAU FK_LST_TO_ORC
alter table i$SDD_LST
add constraint FK_LST_TO_ORC foreign key (parent_ivid
  , ORACLE_DATABASE_REF
)
references i$SDD_ODB
on delete cascade deferrable initially deferred
/
--RAU FK_MAP_TO_TMS
alter table i$SDD_MAP
add constraint FK_MAP_TO_TMS foreign key (parent_ivid
  , TRANSFORMATION_SET_REF
)
references i$SDD_TMS
on delete cascade deferrable initially deferred
/
--RAU FK_MEMCOM_TO_ADR
alter table i$SDD_MEMCOM
add constraint FK_MEMCOM_TO_ADR foreign key (parent_ivid
  , ATTRIBUTE_DERIV_RULE_REF
)
references i$SDD_ADR
on delete cascade deferrable initially deferred
/
--RAU FK_MEMCOM_TO_COR
alter table i$SDD_MEMCOM
add constraint FK_MEMCOM_TO_COR foreign key (parent_ivid
  , CROSS_OBJECT_RULE_REF
)
references i$SDD_COR
on delete cascade deferrable initially deferred
/
--RAU FK_MEMCOM_TO_INR
alter table i$SDD_MEMCOM
add constraint FK_MEMCOM_TO_INR foreign key (parent_ivid
  , INTEGRITY_RULE_REF
)
references i$SDD_CRU
on delete cascade deferrable initially deferred
/
--RAU FK_MEMCOM_TO_RUL
alter table i$SDD_MEMCOM
add constraint FK_MEMCOM_TO_RUL foreign key (parent_ivid
  , NAMED_RULE_REF
)
references i$SDD_RUL
on delete cascade deferrable initially deferred
/
--RAU FK_MEMCOM_TO_SRU
alter table i$SDD_MEMCOM
add constraint FK_MEMCOM_TO_SRU foreign key (parent_ivid
  , STATE_RULE_REF
)
references i$SDD_SRU
on delete cascade deferrable initially deferred
/
--RAU FK_MET_TO_CLA
alter table i$SDD_MET
add constraint FK_MET_TO_CLA foreign key (parent_ivid
  , CLASSIFIER_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_METRUL_TO_MET
alter table i$SDD_METRUL
add constraint FK_METRUL_TO_MET foreign key (parent_ivid
  , METHOD_REF
)
references i$SDD_MET
on delete cascade deferrable initially deferred
/
--RAU FK_MOD_TO_OOT
alter table i$SDD_MOD
add constraint FK_MOD_TO_OOT foreign key (parent_ivid
  , ORACLE_OBJECT_TYPE_REF
)
references i$SDD_ORT
on delete cascade deferrable initially deferred
/
--RAU FK_MPA_TO_MET
alter table i$SDD_MPA
add constraint FK_MPA_TO_MET foreign key (parent_ivid
  , METHOD_REF
)
references i$SDD_MET
on delete cascade deferrable initially deferred
/
--RAU FK_MTI_TO_SQS
alter table i$SDD_MTI
add constraint FK_MTI_TO_SQS foreign key (parent_ivid
  , SQL_QUERY_SET_REF
)
references i$SDD_SQS
on delete cascade deferrable initially deferred
/
--RAU FK_MWF_TO_LAN
alter table i$SDD_MWF
add constraint FK_MWF_TO_LAN foreign key (parent_ivid
  , LANGUAGE_REF
)
references i$SDD_LAN
on delete cascade deferrable initially deferred
/
--RAU FK_OCO_TO_TAB
alter table i$SDD_OCO
add constraint FK_OCO_TO_TAB foreign key (parent_ivid
  , TABLE_REF
)
references i$SDD_TAB
on delete cascade deferrable initially deferred
/
--RAU FK_ODBODB_TO_ORC
alter table i$SDD_ODBODB
add constraint FK_ODBODB_TO_ORC foreign key (parent_ivid
  , DATABASE_REF_FROM
)
references i$SDD_ODB
on delete cascade deferrable initially deferred
/
--RAU FK_OKY_TO_OCO
alter table i$SDD_OKY
add constraint FK_OKY_TO_OCO foreign key (parent_ivid
  , CONSTRAINT_REF
)
references i$SDD_OCO
on delete cascade deferrable initially deferred
/
--RAU FK_ORGPER_TO_ORG
alter table i$SDD_ORGPER
add constraint FK_ORGPER_TO_ORG foreign key (parent_ivid
  , ORGANIZATION_UNIT_REF
)
references i$SDD_ORG
on delete cascade deferrable initially deferred
/
--RAU FK_ORS_TO_ORC
alter table i$SDD_ORS
add constraint FK_ORS_TO_ORC foreign key (parent_ivid
  , ORACLE_DATABASE_REF
)
references i$SDD_ODB
on delete cascade deferrable initially deferred
/
--RAU FK_OST_TO_BOB
alter table i$SDD_OST
add constraint FK_OST_TO_BOB foreign key (parent_ivid
  , BUSINESS_OBJECT_REF
)
references i$SDD_BOB
on delete cascade deferrable initially deferred
/
--RAU FK_OST_TO_CLA
alter table i$SDD_OST
add constraint FK_OST_TO_CLA foreign key (parent_ivid
  , CLASSIFIER_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_OST_TO_WIT
alter table i$SDD_OST
add constraint FK_OST_TO_WIT foreign key (parent_ivid
  , WORKFLOW_ITEM_TYPE_REF
)
references i$SDD_WIT
on delete cascade deferrable initially deferred
/
--RAU FK_OST_TO_WMT
alter table i$SDD_OST
add constraint FK_OST_TO_WMT foreign key (parent_ivid
  , WORKFLOW_MESS_TYPE_REF
)
references i$SDD_WMT
on delete cascade deferrable initially deferred
/
--RAU FK_OSTOST_TO_OST
alter table i$SDD_OSTOST
add constraint FK_OSTOST_TO_OST foreign key (parent_ivid
  , OBJECT_STATE_ON_REF
)
references i$SDD_OST
on delete cascade deferrable initially deferred
/
--RAU FK_OTB_TO_ODB
alter table i$SDD_OTB
add constraint FK_OTB_TO_ODB foreign key (parent_ivid
  , DATABASE_REF
)
references i$SDD_ODB
on delete cascade deferrable initially deferred
/
--RAU FK_PERACR_TO_PER
alter table i$SDD_PERACR
add constraint FK_PERACR_TO_PER foreign key (parent_ivid
  , PERSON_REF
)
references i$SDD_PER
on delete cascade deferrable initially deferred
/
--RAU FK_PERPER_TO_PER
alter table i$SDD_PERPER
add constraint FK_PERPER_TO_PER foreign key (parent_ivid
  , MANAGER_REF
)
references i$SDD_PER
on delete cascade deferrable initially deferred
/
--RAU FK_PSTADC_TO_PST
alter table i$SDD_PSTADC
add constraint FK_PSTADC_TO_PST foreign key (parent_ivid
  , PROJECT_STANDARD_REF
)
references i$SDD_PST
on delete cascade deferrable initially deferred
/
--RAU FK_PVL_TO_MODMOD
alter table i$SDD_PVL
add constraint FK_PVL_TO_MODMOD foreign key (parent_ivid
  , MODULE_NETWORK_REF
)
references i$SDD_MODMOD
on delete cascade deferrable initially deferred
/
--RAU FK_QSU_TO_QUI
alter table i$SDD_QSU
add constraint FK_QSU_TO_QUI foreign key (parent_ivid
  , QUEUE_IMPLEMENTATION_REF
)
references i$SDD_QUI
on delete cascade deferrable initially deferred
/
--RAU FK_QUI_TO_ORC
alter table i$SDD_QUI
add constraint FK_QUI_TO_ORC foreign key (parent_ivid
  , ORACLE_DATABASE_REF
)
references i$SDD_ODB
on delete cascade deferrable initially deferred
/
--RAU FK_RELEND_TO_ENT
alter table i$SDD_RELEND
add constraint FK_RELEND_TO_ENT foreign key (parent_ivid
  , FROM_ENTITY_REF
)
references i$SDD_ENT
on delete cascade deferrable initially deferred
/
--RAU FK_RGP_TO_RPG
alter table i$SDD_RGP
add constraint FK_RGP_TO_RPG foreign key (parent_ivid
  , REPLICATION_GROUP_REF
)
references i$SDD_RPG
on delete cascade deferrable initially deferred
/
--RAU FK_RPG_TO_ORC
alter table i$SDD_RPG
add constraint FK_RPG_TO_ORC foreign key (parent_ivid
  , ORACLE_DATABASE_REF
)
references i$SDD_ODB
on delete cascade deferrable initially deferred
/
--RAU FK_RULRUL_TO_RUL
alter table i$SDD_RULRUL
add constraint FK_RULRUL_TO_RUL foreign key (parent_ivid
  , USED_IN_RULE_REF
)
references i$SDD_RUL
on delete cascade deferrable initially deferred
/
--RAU FK_SBA_TO_MET
alter table i$SDD_SBA
add constraint FK_SBA_TO_MET foreign key (parent_ivid
  , METHOD_REF
)
references i$SDD_MET
on delete cascade deferrable initially deferred
/
--RAU FK_SMI_TO_UDS
alter table i$SDD_SMI
add constraint FK_SMI_TO_UDS foreign key (parent_ivid
  , USER_DEFINED_SET_REF
)
references i$SDD_UDS
on delete cascade deferrable initially deferred
/
--RAU FK_SOU_TO_BLI
alter table i$SDD_SOU
add constraint FK_SOU_TO_BLI foreign key (parent_ivid
  , BATCHLINE_REF
)
references i$SDD_BLI
on delete cascade deferrable initially deferred
/
--RAU FK_SPV_TO_DBU
alter table i$SDD_SPV
add constraint FK_SPV_TO_DBU foreign key (parent_ivid
  , DATABASE_USER_REF
)
references i$SDD_DBU
on delete cascade deferrable initially deferred
/
--RAU FK_SPV_TO_GRP
alter table i$SDD_SPV
add constraint FK_SPV_TO_GRP foreign key (parent_ivid
  , ROLE_REF
)
references i$SDD_GRP
on delete cascade deferrable initially deferred
/
--RAU FK_SRG_TO_ORC
alter table i$SDD_SRG
add constraint FK_SRG_TO_ORC foreign key (parent_ivid
  , ORACLE_DATABASE_REF
)
references i$SDD_ODB
on delete cascade deferrable initially deferred
/
--RAU FK_SRU_TO_OST
alter table i$SDD_SRU
add constraint FK_SRU_TO_OST foreign key (parent_ivid
  , OBJECT_STATE_REF
)
references i$SDD_OST
on delete cascade deferrable initially deferred
/
--RAU FK_STESTE_TO_STE
alter table i$SDD_STESTE
add constraint FK_STESTE_TO_STE foreign key (parent_ivid
  , SUBTYPE_REF
)
references i$SDD_STE
on delete cascade deferrable initially deferred
/
--RAU FK_SUD_TO_EVS
alter table i$SDD_SUD
add constraint FK_SUD_TO_EVS foreign key (parent_ivid
  , EVENT_SUBSCRIPTION_REF
)
references i$SDD_EVS
on delete cascade deferrable initially deferred
/
--RAU FK_TABENT_TO_TAB
alter table i$SDD_TABENT
add constraint FK_TABENT_TO_TAB foreign key (parent_ivid
  , TABLE_REF
)
references i$SDD_TAB
on delete cascade deferrable initially deferred
/
--RAU FK_TAG_TO_STE
alter table i$SDD_TAG
add constraint FK_TAG_TO_STE foreign key (parent_ivid
  , STEREOTYPE_REF
)
references i$SDD_STE
on delete cascade deferrable initially deferred
/
--RAU FK_TBICOL_TO_INS
alter table i$SDD_TBICOL
add constraint FK_TBICOL_TO_INS foreign key (parent_ivid
  , INDEX_STORAGE_REF
)
references i$SDD_INS
on delete cascade deferrable initially deferred
/
--RAU FK_TBICOL_TO_TBI
alter table i$SDD_TBICOL
add constraint FK_TBICOL_TO_TBI foreign key (parent_ivid
  , TABLE_IMPLEMENTATION_REF
)
references i$SDD_DOI
on delete cascade deferrable initially deferred
/
--RAU FK_TBP_TO_TBI
alter table i$SDD_TBP
add constraint FK_TBP_TO_TBI foreign key (parent_ivid
  , TABLE_IMPLEMENTATION_REF
)
references i$SDD_DOI
on delete cascade deferrable initially deferred
/
--RAU FK_TRA_TO_EVC
alter table i$SDD_TRA
add constraint FK_TRA_TO_EVC foreign key (parent_ivid
  , SOURCE_EVENT_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_TRA_TO_OST
alter table i$SDD_TRA
add constraint FK_TRA_TO_OST foreign key (parent_ivid
  , SOURCE_OBJECT_STATE_REF
)
references i$SDD_OST
on delete cascade deferrable initially deferred
/
--RAU FK_TRA_TO_PSE
alter table i$SDD_TRA
add constraint FK_TRA_TO_PSE foreign key (parent_ivid
  , SOURCE_PSEUDOSTATE_REF
)
references i$SDD_PSE
on delete cascade deferrable initially deferred
/
--RAU FK_TRA_TO_ACT
alter table i$SDD_TRA
add constraint FK_TRA_TO_ACT foreign key (parent_ivid
  , SOURCE_ACTIVITY_REF
)
references i$SDD_ACT
on delete cascade deferrable initially deferred
/
--RAU FK_TRA_TO_ACTORG
alter table i$SDD_TRA
add constraint FK_TRA_TO_ACTORG foreign key (parent_ivid
  , SOURCE_ACT_USAGE_REF
)
references i$SDD_ACTORG
on delete cascade deferrable initially deferred
/
--RAU FK_TRG_TO_TBL
alter table i$SDD_TRG
add constraint FK_TRG_TO_TBL foreign key (parent_ivid
  , TABLE_DEFINITION_REF
)
references i$SDD_TAB
on delete cascade deferrable initially deferred
/
--RAU FK_TRG_TO_VW
alter table i$SDD_TRG
add constraint FK_TRG_TO_VW foreign key (parent_ivid
  , VIEW_DEFINITION_REF
)
references i$SDD_TAB
on delete cascade deferrable initially deferred
/
--RAU FK_TRGCOL_TO_TRG
alter table i$SDD_TRGCOL
add constraint FK_TRGCOL_TO_TRG foreign key (parent_ivid
  , DATABASE_TRIGGER_REF
)
references i$SDD_TRG
on delete cascade deferrable initially deferred
/
--RAU FK_TSQ_TO_DBU
alter table i$SDD_TSQ
add constraint FK_TSQ_TO_DBU foreign key (parent_ivid
  , DATABASE_USER_REF
)
references i$SDD_DBU
on delete cascade deferrable initially deferred
/
--RAU FK_UCA_TO_USC
alter table i$SDD_UCA
add constraint FK_UCA_TO_USC foreign key (parent_ivid
  , USE_CASE_REF
)
references i$SDD_USC
on delete cascade deferrable initially deferred
/
--RAU FK_UDECLI_TO_UDE
alter table i$SDD_UDECLI
add constraint FK_UDECLI_TO_UDE foreign key (parent_ivid
  , UML_DEPENDENCY_REF
)
references i$SDD_UDE
on delete cascade deferrable initially deferred
/
--RAU FK_UDESUP_TO_UDE
alter table i$SDD_UDESUP
add constraint FK_UDESUP_TO_UDE foreign key (parent_ivid
  , UML_DEPENDENCY_REF
)
references i$SDD_UDE
on delete cascade deferrable initially deferred
/
--RAU FK_UID_TO_ENT
alter table i$SDD_UID
add constraint FK_UID_TO_ENT foreign key (parent_ivid
  , ENTITY_REF
)
references i$SDD_ENT
on delete cascade deferrable initially deferred
/
--RAU FK_USCACR_TO_USC
alter table i$SDD_USCACR
add constraint FK_USCACR_TO_USC foreign key (parent_ivid
  , USE_CASE_REF
)
references i$SDD_USC
on delete cascade deferrable initially deferred
/
--RAU FK_USCE1_TO_USC
alter table i$SDD_USCE1
add constraint FK_USCE1_TO_USC foreign key (parent_ivid
  , USE_CASE_REF
)
references i$SDD_USC
on delete cascade deferrable initially deferred
/
--RAU FK_USCEPA_TO_USC
alter table i$SDD_USCEPA
add constraint FK_USCEPA_TO_USC foreign key (parent_ivid
  , USE_CASE_REF
)
references i$SDD_USC
on delete cascade deferrable initially deferred
/
--RAU FK_USCEVI_TO_USC
alter table i$SDD_USCEVI
add constraint FK_USCEVI_TO_USC foreign key (parent_ivid
  , USE_CASE_REF
)
references i$SDD_USC
on delete cascade deferrable initially deferred
/
--RAU FK_USCEVO_TO_USC
alter table i$SDD_USCEVO
add constraint FK_USCEVO_TO_USC foreign key (parent_ivid
  , USE_CASE_REF
)
references i$SDD_USC
on delete cascade deferrable initially deferred
/
--RAU FK_USCUSC_TO_USC
alter table i$SDD_USCUSC
add constraint FK_USCUSC_TO_USC foreign key (parent_ivid
  , SUBTYPE_REF
)
references i$SDD_USC
on delete cascade deferrable initially deferred
/
--RAU FK_VAL_TO_ADC
alter table i$SDD_VAL
add constraint FK_VAL_TO_ADC foreign key (parent_ivid
  , ATTRIBUTE_DOMAIN_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_VAL_TO_INR
alter table i$SDD_VAL
add constraint FK_VAL_TO_INR foreign key (parent_ivid
  , INTEGRITY_RULE_REF
)
references i$SDD_CRU
on delete cascade deferrable initially deferred
/
--RAU FK_VALGAT_TO_VAL
alter table i$SDD_VALGAT
add constraint FK_VALGAT_TO_VAL foreign key (parent_ivid
  , VALIDATOR_REF
)
references i$SDD_VAL
on delete cascade deferrable initially deferred
/
--RAU FK_VLE_TO_VLI
alter table i$SDD_VLE
add constraint FK_VLE_TO_VLI foreign key (parent_ivid
  , VIEW_LINK_REF
)
references i$SDD_VLI
on delete cascade deferrable initially deferred
/
--RAU FK_VLEU_TO_VLU
alter table i$SDD_VLEU
add constraint FK_VLEU_TO_VLU foreign key (parent_ivid
  , VIEW_LINK_USAGE_REF
)
references i$SDD_VLU
on delete cascade deferrable initially deferred
/
--RAU FK_VLEVOA_TO_VLE
alter table i$SDD_VLEVOA
add constraint FK_VLEVOA_TO_VLE foreign key (parent_ivid
  , VIEW_LINK_END_REF
)
references i$SDD_VLE
on delete cascade deferrable initially deferred
/
--RAU FK_VLU_TO_AMC
alter table i$SDD_VLU
add constraint FK_VLU_TO_AMC foreign key (parent_ivid
  , APPLICATION_MODULE_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_VOU_TO_AMC
alter table i$SDD_VOU
add constraint FK_VOU_TO_AMC foreign key (parent_ivid
  , APPLICATION_MODULE_REF
)
references i$SDD_CLA
on delete cascade deferrable initially deferred
/
--RAU FK_VWTAB_TO_TAB
alter table i$SDD_VWTAB
add constraint FK_VWTAB_TO_TAB foreign key (parent_ivid
  , VIEW_REF
)
references i$SDD_TAB
on delete cascade deferrable initially deferred
/
--RAU FK_WAT_TO_WIT
alter table i$SDD_WAT
add constraint FK_WAT_TO_WIT foreign key (parent_ivid
  , WORKFLOW_ITEM_TYPE_REF
)
references i$SDD_WIT
on delete cascade deferrable initially deferred
/
--RAU FK_WAT_TO_WMT
alter table i$SDD_WAT
add constraint FK_WAT_TO_WMT foreign key (parent_ivid
  , WORKFLOW_MESS_TYPE_REF
)
references i$SDD_WMT
on delete cascade deferrable initially deferred
/
--RAU FK_WMT_TO_WIT
alter table i$SDD_WMT
add constraint FK_WMT_TO_WIT foreign key (parent_ivid
  , WORKFLOW_ITEM_TYPE_REF
)
references i$SDD_WIT
on delete cascade deferrable initially deferred
/

-- CW 7-Dec-99
-- Fix bug 705609 add index on ivid on secondary objects (by adding a unique key)

--RAU CK_APPLICATION_LOGIC_RUK                                                                      
alter table I$CK_APPLICATION_LOGIC add constraint CK_APPLICATION_LOGIC_RUK unique (ivid)
/           
                                                                                                    
--RAU RM_TEXT_LINES_RUK                                                                             
alter table I$RM_TEXT_LINES add constraint RM_TEXT_LINES_RUK unique (ivid)
/                         
                                                                                                    
--RAU SDD_A1_RUK                                                                                    
alter table I$SDD_A1 add constraint SDD_A1_RUK unique (ivid)
/                                       
                                                                                                    
--RAU SDD_A10_RUK                                                                                   
alter table I$SDD_A10 add constraint SDD_A10_RUK unique (ivid)
/                                    
                                                                                                    
--RAU SDD_A11_RUK                                                                                   
alter table I$SDD_A11 add constraint SDD_A11_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_A2_RUK                                                                                    
alter table I$SDD_A2 add constraint SDD_A2_RUK unique (ivid)
/
                                                                                                    
--RAU SDD_A20_RUK                                                                                   
alter table I$SDD_A20 add constraint SDD_A20_RUK unique (ivid)
/                                  
                                                                                                    
--RAU SDD_A21_RUK                                                                                   
alter table I$SDD_A21 add constraint SDD_A21_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_A23_RUK                                                                                   
alter table I$SDD_A23 add constraint SDD_A23_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_A24_RUK                                                                                   
alter table I$SDD_A24 add constraint SDD_A24_RUK unique (ivid)
/
                                                                                                    
--RAU SDD_A3_RUK                                                                                    
alter table I$SDD_A3 add constraint SDD_A3_RUK unique (ivid)
/                                      
                                                                                                    
--RAU SDD_A4_RUK                                                                                    
alter table I$SDD_A4 add constraint SDD_A4_RUK unique (ivid)
/                                       
                                                                                                    
--RAU SDD_A5_RUK                                                                                    
alter table I$SDD_A5 add constraint SDD_A5_RUK unique (ivid)
/                                      
                                                                                                    
--RAU SDD_A6_RUK                                                                                    
alter table I$SDD_A6 add constraint SDD_A6_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_A7_RUK                                                                                    
alter table I$SDD_A7 add constraint SDD_A7_RUK unique (ivid)
/                                      
                                                                                                    
--RAU SDD_A8_RUK                                                                                    
alter table I$SDD_A8 add constraint SDD_A8_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_A9_RUK                                                                                    
alter table I$SDD_A9 add constraint SDD_A9_RUK unique (ivid)
/                                       
                                                                                                    
--RAU SDD_ACI_RUK                                                                                   
alter table I$SDD_ACI add constraint SDD_ACI_RUK unique (ivid)
/                                   
                                                                                                    
--RAU SDD_ACRACR_RUK                                                                                
alter table I$SDD_ACRACR add constraint SDD_ACRACR_RUK unique (ivid)
/                             
                                                                                                    
--RAU SDD_ACRORG_RUK                                                                                
alter table I$SDD_ACRORG add constraint SDD_ACRORG_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_ACTACT_RUK                                                                                
alter table I$SDD_ACTACT add constraint SDD_ACTACT_RUK unique (ivid)
/                            
                                                                                                    
--RAU SDD_ACTE1_RUK                                                                                 
alter table I$SDD_ACTE1 add constraint SDD_ACTE1_RUK unique (ivid)
/                                
                                                                                                    
--RAU SDD_ACTORG_RUK                                                                                
alter table I$SDD_ACTORG add constraint SDD_ACTORG_RUK unique (ivid)
/                             
                                                                                                    
--RAU SDD_ACUACR_RUK                                                                                
alter table I$SDD_ACUACR add constraint SDD_ACUACR_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_ADR_RUK                                                                                   
alter table I$SDD_ADR add constraint SDD_ADR_RUK unique (ivid)
/                                    
                                                                                                    
--RAU SDD_AEN_RUK                                                                                   
alter table I$SDD_AEN add constraint SDD_AEN_RUK unique (ivid)
/                                   
                                                                                                    
--RAU SDD_AENEAT_RUK                                                                                
alter table I$SDD_AENEAT add constraint SDD_AENEAT_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_AEU_RUK                                                                                   
alter table I$SDD_AEU add constraint SDD_AEU_RUK unique (ivid)
/                                    
                                                                                                    
--RAU SDD_AMCAMC_RUK                                                                                
alter table I$SDD_AMCAMC add constraint SDD_AMCAMC_RUK unique (ivid)
/                             
                                                                                                    
--RAU SDD_AMCBOB_RUK                                                                                
alter table I$SDD_AMCBOB add constraint SDD_AMCBOB_RUK unique (ivid)
/
                                                                                                    
--RAU SDD_AMCPRJ_RUK                                                                                
alter table I$SDD_AMCPRJ add constraint SDD_AMCPRJ_RUK unique (ivid)
/                          
                                                                                                    
--RAU SDD_ARG_RUK                                                                                   
alter table I$SDD_ARG add constraint SDD_ARG_RUK unique (ivid)
/                                   
                                                                                                    
--RAU SDD_ARGITE_RUK                                                                                
alter table I$SDD_ARGITE add constraint SDD_ARGITE_RUK unique (ivid)
/                     
                                                                                                    
--RAU SDD_ASSASS_RUK                                                                                
alter table I$SDD_ASSASS add constraint SDD_ASSASS_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_ATT_RUK                                                                                   
alter table I$SDD_ATT add constraint SDD_ATT_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_ATV_RUK                                                                                   
alter table I$SDD_ATV add constraint SDD_ATV_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_BLI_RUK                                                                                   
alter table I$SDD_BLI add constraint SDD_BLI_RUK unique (ivid)
/
                                                                                                    
--RAU SDD_BOBINC_RUK                                                                                
alter table I$SDD_BOBINC add constraint SDD_BOBINC_RUK unique (ivid)
/
                                                                                                    
--RAU SDD_BRL_RUK                                                                                   
alter table I$SDD_BRL add constraint SDD_BRL_RUK unique (ivid)
/
                                                                                                    
--RAU SDD_BRU_RUK                                                                                   
alter table I$SDD_BRU add constraint SDD_BRU_RUK unique (ivid)
/
                                                                                                    
--RAU SDD_BRUBLI_RUK                                                                                
alter table I$SDD_BRUBLI add constraint SDD_BRUBLI_RUK unique (ivid)
/                            
                                                                                                    
--RAU SDD_CAT_RUK                                                                                   
alter table I$SDD_CAT add constraint SDD_CAT_RUK unique (ivid)
/
                                                                                                    
--RAU SDD_CATAEN_RUK                                                                                
alter table I$SDD_CATAEN add constraint SDD_CATAEN_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_CATEAT_RUK                                                                                
alter table I$SDD_CATEAT add constraint SDD_CATEAT_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_CCD_RUK                                                                                   
alter table I$SDD_CCD add constraint SDD_CCD_RUK unique (ivid)
/                                    
                                                                                                    
--RAU SDD_CLAAEN_RUK                                                                                
alter table I$SDD_CLAAEN add constraint SDD_CLAAEN_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_CLACLA_RUK                                                                                
alter table I$SDD_CLACLA add constraint SDD_CLACLA_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_CLAEVC_RUK                                                                                
alter table I$SDD_CLAEVC add constraint SDD_CLAEVC_RUK unique (ivid)
/                          
                                                                                                    
--RAU SDD_CLAINC_RUK                                                                                
alter table I$SDD_CLAINC add constraint SDD_CLAINC_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_CMA_RUK                                                                                   
alter table I$SDD_CMA add constraint SDD_CMA_RUK unique (ivid)
/                                    
                                                                                                    
--RAU SDD_CNU_RUK                                                                                   
alter table I$SDD_CNU add constraint SDD_CNU_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_COB_RUK                                                                                   
alter table I$SDD_COB add constraint SDD_COB_RUK unique (ivid)
/                                   
                                                                                                    
--RAU SDD_COL_RUK                                                                                   
alter table I$SDD_COL add constraint SDD_COL_RUK unique (ivid)
/                                  
                                                                                                    
--RAU SDD_COMNOD_RUK                                                                                
alter table I$SDD_COMNOD add constraint SDD_COMNOD_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_COMODB_RUK                                                                                
alter table I$SDD_COMODB add constraint SDD_COMODB_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_CORI_RUK                                                                                  
alter table I$SDD_CORI add constraint SDD_CORI_RUK unique (ivid)
/                                   
                                                                                                    
--RAU SDD_CQA_RUK                                                                                   
alter table I$SDD_CQA add constraint SDD_CQA_RUK unique (ivid)
/                            
                                                                                                    
--RAU SDD_CQACOL_RUK                                                                                
alter table I$SDD_CQACOL add constraint SDD_CQACOL_RUK unique (ivid)
/                            
                                                                                                    
--RAU SDD_CRU_RUK                                                                                   
alter table I$SDD_CRU add constraint SDD_CRU_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_CSG_RUK                                                                                   
alter table I$SDD_CSG add constraint SDD_CSG_RUK unique (ivid)
/                                    
                                                                                                    
--RAU SDD_CST_RUK                                                                                   
alter table I$SDD_CST add constraint SDD_CST_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_DAT_RUK                                                                                   
alter table I$SDD_DAT add constraint SDD_DAT_RUK unique (ivid)
/                                    
                                                                                                    
--RAU SDD_DATCOM_RUK                                                                                
alter table I$SDD_DATCOM add constraint SDD_DATCOM_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_DBU_RUK                                                                                   
alter table I$SDD_DBU add constraint SDD_DBU_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_DBUGRP_RUK                                                                                
alter table I$SDD_DBUGRP add constraint SDD_DBUGRP_RUK unique (ivid)
/                           
                                                                                                    
--RAU SDD_DBUMOD_RUK                                                                                
alter table I$SDD_DBUMOD add constraint SDD_DBUMOD_RUK unique (ivid)
/                             

--RAU SDD_DEU_RUK                                                                                   
alter table I$SDD_DEU add constraint SDD_DEU_RUK unique (ivid)
/                                   
                                                                                                    
--RAU SDD_DFI_RUK                                                                                   
alter table I$SDD_DFI add constraint SDD_DFI_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_DFL_RUK                                                                                   
alter table I$SDD_DFL add constraint SDD_DFL_RUK unique (ivid)
/                                  
                                                                                                    
--RAU SDD_DFLATT_RUK                                                                                
alter table I$SDD_DFLATT add constraint SDD_DFLATT_RUK unique (ivid)
/                            
                                                                                                    
--RAU SDD_DFLDIT_RUK                                                                                
alter table I$SDD_DFLDIT add constraint SDD_DFLDIT_RUK unique (ivid)
/
                                                                                                    
--RAU SDD_DIAGRAM_SEGMENTS_RUK                                                                      
alter table I$SDD_DIAGRAM_SEGMENTS add constraint SDD_DIAGRAM_SEGMENTS_RUK unique (ivid)
/          
                                                                                                    
--RAU SDD_DIR_RUK                                                                                   
alter table I$SDD_DIR add constraint SDD_DIR_RUK unique (ivid)
/                                    
                                                                                                    
--RAU SDD_DOCXXX_RUK                                                                                
alter table I$SDD_DOCXXX add constraint SDD_DOCXXX_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_DOG_RUK                                                                                   
alter table I$SDD_DOG add constraint SDD_DOG_RUK unique (ivid)
/                                   
                                                                                                    
--RAU SDD_DOI_RUK                                                                                   
alter table I$SDD_DOI add constraint SDD_DOI_RUK unique (ivid)
/                                  
                                                                                                    
--RAU SDD_DPR_RUK                                                                                   
alter table I$SDD_DPR add constraint SDD_DPR_RUK unique (ivid)
/
                                                                                                    
--RAU SDD_DSTATT_RUK                                                                                
alter table I$SDD_DSTATT add constraint SDD_DSTATT_RUK unique (ivid)
/                             
                                                                                                    
--RAU SDD_DSTDIT_RUK                                                                                
alter table I$SDD_DSTDIT add constraint SDD_DSTDIT_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_DSY_RUK                                                                                   
alter table I$SDD_DSY add constraint SDD_DSY_RUK unique (ivid)
/                                   
                                                                                                    
--RAU SDD_ENTBUN_RUK                                                                                
alter table I$SDD_ENTBUN add constraint SDD_ENTBUN_RUK unique (ivid)
/                             
                                                                                                    
--RAU SDD_ENTUIE_RUK                                                                                
alter table I$SDD_ENTUIE add constraint SDD_ENTUIE_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_EOU_RUK                                                                                   
alter table I$SDD_EOU add constraint SDD_EOU_RUK unique (ivid)
/                                   
                                                                                                    
--RAU SDD_ERU_RUK                                                                                   
alter table I$SDD_ERU add constraint SDD_ERU_RUK unique (ivid)
/                                    
                                                                                                    
--RAU SDD_EVH_RUK                                                                                   
alter table I$SDD_EVH add constraint SDD_EVH_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_EVR_RUK                                                                                   
alter table I$SDD_EVR add constraint SDD_EVR_RUK unique (ivid)
/                                 
                                                                                                    
--RAU SDD_EVS_RUK                                                                                   
alter table I$SDD_EVS add constraint SDD_EVS_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_FILPAC_RUK                                                                                
alter table I$SDD_FILPAC add constraint SDD_FILPAC_RUK unique (ivid)
/
                                                                                                    
--RAU SDD_FOLDER_MEMBERS_RUK                                                                        
alter table I$SDD_FOLDER_MEMBERS add constraint SDD_FOLDER_MEMBERS_RUK unique (ivid)
/          
                                                                                                    
--RAU SDD_FSE_RUK                                                                                   
alter table I$SDD_FSE add constraint SDD_FSE_RUK unique (ivid)
/                                    
                                                                                                    
--RAU SDD_FUNATT_RUK                                                                                
alter table I$SDD_FUNATT add constraint SDD_FUNATT_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_FUNBUN_RUK                                                                                
alter table I$SDD_FUNBUN add constraint SDD_FUNBUN_RUK unique (ivid)
/
                                                                                                    
--RAU SDD_FUNENT_RUK                                                                                
alter table I$SDD_FUNENT add constraint SDD_FUNENT_RUK unique (ivid)
/                           
                                                                                                    
--RAU SDD_FUNEVT_RUK                                                                                
alter table I$SDD_FUNEVT add constraint SDD_FUNEVT_RUK unique (ivid)
/                            
                                                                                                    
--RAU SDD_GRP_RUK                                                                                   
alter table I$SDD_GRP add constraint SDD_GRP_RUK unique (ivid)
/                                   
                                                                                                    
--RAU SDD_GRPGRP_RUK                                                                                
alter table I$SDD_GRPGRP add constraint SDD_GRPGRP_RUK unique (ivid)
/                             
                                                                                                    
--RAU SDD_GRPMOD_RUK                                                                                
alter table I$SDD_GRPMOD add constraint SDD_GRPMOD_RUK unique (ivid)
/                             
                                                                                                    
--RAU SDD_IGR_RUK                                                                                   
alter table I$SDD_IGR add constraint SDD_IGR_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_IND_RUK                                                                                   
alter table I$SDD_IND add constraint SDD_IND_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_INDCOL_RUK                                                                                
alter table I$SDD_INDCOL add constraint SDD_INDCOL_RUK unique (ivid)
/                             
                                                                                                    
--RAU SDD_INP_RUK                                                                                   
alter table I$SDD_INP add constraint SDD_INP_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_INS_RUK                                                                                   
alter table I$SDD_INS add constraint SDD_INS_RUK unique (ivid)
/                                  
                                                                                                    
--RAU SDD_ITE_RUK                                                                                   
alter table I$SDD_ITE add constraint SDD_ITE_RUK unique (ivid)
/                                   
                                                                                                    
--RAU SDD_ITM_RUK                                                                                   
alter table I$SDD_ITM add constraint SDD_ITM_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_LST_RUK                                                                                   
alter table I$SDD_LST add constraint SDD_LST_RUK unique (ivid)
/
                                                                                                    
--RAU SDD_LVI_RUK                                                                                   
alter table I$SDD_LVI add constraint SDD_LVI_RUK unique (ivid)
/                                    
                                                                                                    
--RAU SDD_MAP_RUK                                                                                   
alter table I$SDD_MAP add constraint SDD_MAP_RUK unique (ivid)
/                                   
                                                                                                    
--RAU SDD_MCH_RUK                                                                                   
alter table I$SDD_MCH add constraint SDD_MCH_RUK unique (ivid)
/                                    
                                                                                                    
--RAU SDD_MCL_RUK                                                                                   
alter table I$SDD_MCL add constraint SDD_MCL_RUK unique (ivid)
/                                    
                                                                                                    
--RAU SDD_MCN_RUK                                                                                   
alter table I$SDD_MCN add constraint SDD_MCN_RUK unique (ivid)
/                                    
                                                                                                    
--RAU SDD_MEMCOM_RUK                                                                                
alter table I$SDD_MEMCOM add constraint SDD_MEMCOM_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_MET_RUK                                                                                   
alter table I$SDD_MET add constraint SDD_MET_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_METRUL_RUK                                                                                
alter table I$SDD_METRUL add constraint SDD_METRUL_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_MODBUN_RUK                                                                                
alter table I$SDD_MODBUN add constraint SDD_MODBUN_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_MODFUN_RUK                                                                                
alter table I$SDD_MODFUN add constraint SDD_MODFUN_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_MODMOD_RUK                                                                                
alter table I$SDD_MODMOD add constraint SDD_MODMOD_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_MODPGD_RUK                                                                                
alter table I$SDD_MODPGD add constraint SDD_MODPGD_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_MPA_RUK                                                                                   
alter table I$SDD_MPA add constraint SDD_MPA_RUK unique (ivid)
/                                   
                                                                                                    
--RAU SDD_MTI_RUK                                                                                   
alter table I$SDD_MTI add constraint SDD_MTI_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_MWF_RUK                                                                                   
alter table I$SDD_MWF add constraint SDD_MWF_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_OCO_RUK                                                                                   
alter table I$SDD_OCO add constraint SDD_OCO_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_ODBODB_RUK                                                                                
alter table I$SDD_ODBODB add constraint SDD_ODBODB_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_OKY_RUK                                                                                   
alter table I$SDD_OKY add constraint SDD_OKY_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_ORGPER_RUK                                                                                
alter table I$SDD_ORGPER add constraint SDD_ORGPER_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_ORS_RUK                                                                                   
alter table I$SDD_ORS add constraint SDD_ORS_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_OST_RUK                                                                                   
alter table I$SDD_OST add constraint SDD_OST_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_OSTOST_RUK                                                                                
alter table I$SDD_OSTOST add constraint SDD_OSTOST_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_OTB_RUK                                                                                   
alter table I$SDD_OTB add constraint SDD_OTB_RUK unique (ivid)
/                                    
                                                                                                    
--RAU SDD_PERACR_RUK                                                                                
alter table I$SDD_PERACR add constraint SDD_PERACR_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_PERPER_RUK                                                                                
alter table I$SDD_PERPER add constraint SDD_PERPER_RUK unique (ivid)
/                             
                                                                                                    
--RAU SDD_PGD_RUK                                                                                   
alter table I$SDD_PGD add constraint SDD_PGD_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_PRU_RUK                                                                                   
alter table I$SDD_PRU add constraint SDD_PRU_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_PSTADC_RUK                                                                                
alter table I$SDD_PSTADC add constraint SDD_PSTADC_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_PVL_RUK                                                                                   
alter table I$SDD_PVL add constraint SDD_PVL_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_QSU_RUK                                                                                   
alter table I$SDD_QSU add constraint SDD_QSU_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_QUI_RUK                                                                                   
alter table I$SDD_QUI add constraint SDD_QUI_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_RELEND_RUK                                                                                
alter table I$SDD_RELEND add constraint SDD_RELEND_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_RGP_RUK                                                                                   
alter table I$SDD_RGP add constraint SDD_RGP_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_RPG_RUK                                                                                   
alter table I$SDD_RPG add constraint SDD_RPG_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_RULRUL_RUK                                                                                
alter table I$SDD_RULRUL add constraint SDD_RULRUL_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_SBA_RUK                                                                                   
alter table I$SDD_SBA add constraint SDD_SBA_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_SMI_RUK                                                                                   
alter table I$SDD_SMI add constraint SDD_SMI_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_SOU_RUK                                                                                   
alter table I$SDD_SOU add constraint SDD_SOU_RUK unique (ivid)
/                                    
                                                                                                    
--RAU SDD_SPV_RUK                                                                                   
alter table I$SDD_SPV add constraint SDD_SPV_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_SQS_RUK                                                                                   
alter table I$SDD_SQS add constraint SDD_SQS_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_SRG_RUK                                                                                   
alter table I$SDD_SRG add constraint SDD_SRG_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_SRU_RUK                                                                                   
alter table I$SDD_SRU add constraint SDD_SRU_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_STESTE_RUK                                                                                
alter table I$SDD_STESTE add constraint SDD_STESTE_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_SUD_RUK                                                                                   
alter table I$SDD_SUD add constraint SDD_SUD_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_TABENT_RUK                                                                                
alter table I$SDD_TABENT add constraint SDD_TABENT_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_TAG_RUK                                                                                   
alter table I$SDD_TAG add constraint SDD_TAG_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_TAGVAL_RUK                                                                                
alter table I$SDD_TAGVAL add constraint SDD_TAGVAL_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_TBICOL_RUK                                                                                
alter table I$SDD_TBICOL add constraint SDD_TBICOL_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_TBP_RUK                                                                                   
alter table I$SDD_TBP add constraint SDD_TBP_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_TRA_RUK                                                                                   
alter table I$SDD_TRA add constraint SDD_TRA_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_TRG_RUK                                                                                   
alter table I$SDD_TRG add constraint SDD_TRG_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_TRGCOL_RUK                                                                                
alter table I$SDD_TRGCOL add constraint SDD_TRGCOL_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_TSQ_RUK                                                                                   
alter table I$SDD_TSQ add constraint SDD_TSQ_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_UCA_RUK                                                                                   
alter table I$SDD_UCA add constraint SDD_UCA_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_UDECLI_RUK                                                                                
alter table I$SDD_UDECLI add constraint SDD_UDECLI_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_UDESUP_RUK                                                                                
alter table I$SDD_UDESUP add constraint SDD_UDESUP_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_UES_RUK                                                                                   
alter table I$SDD_UES add constraint SDD_UES_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_UID_RUK                                                                                   
alter table I$SDD_UID add constraint SDD_UID_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_UPR_RUK                                                                                   
alter table I$SDD_UPR add constraint SDD_UPR_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_USCACR_RUK                                                                                
alter table I$SDD_USCACR add constraint SDD_USCACR_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_USCE1_RUK                                                                                 
alter table I$SDD_USCE1 add constraint SDD_USCE1_RUK unique (ivid)
/
                                                                                                    
--RAU SDD_USCEPA_RUK                                                                                
alter table I$SDD_USCEPA add constraint SDD_USCEPA_RUK unique (ivid)
/
                                                                                                    
--RAU SDD_USCEVI_RUK                                                                                
alter table I$SDD_USCEVI add constraint SDD_USCEVI_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_USCEVO_RUK                                                                                
alter table I$SDD_USCEVO add constraint SDD_USCEVO_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_USCUSC_RUK                                                                                
alter table I$SDD_USCUSC add constraint SDD_USCUSC_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_VAL_RUK                                                                                   
alter table I$SDD_VAL add constraint SDD_VAL_RUK unique (ivid)
/
                                                                                                    
--RAU SDD_VALGAT_RUK                                                                                
alter table I$SDD_VALGAT add constraint SDD_VALGAT_RUK unique (ivid)
/                              
                                                                                                    
--RAU SDD_VLE_RUK                                                                                   
alter table I$SDD_VLE add constraint SDD_VLE_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_VLEU_RUK                                                                                  
alter table I$SDD_VLEU add constraint SDD_VLEU_RUK unique (ivid)
/
                                                                                                    
--RAU SDD_VLEVOA_RUK                                                                                
alter table I$SDD_VLEVOA add constraint SDD_VLEVOA_RUK unique (ivid)
/
                                                                                                    
--RAU SDD_VLU_RUK                                                                                   
alter table I$SDD_VLU add constraint SDD_VLU_RUK unique (ivid)
/                               
                                                                                                    
--RAU SDD_VOU_RUK                                                                                   
alter table I$SDD_VOU add constraint SDD_VOU_RUK unique (ivid)
/                                    
                                                                                                    
--RAU SDD_VWTAB_RUK                                                                                 
alter table I$SDD_VWTAB add constraint SDD_VWTAB_RUK unique (ivid)
/                                 
                                                                                                    
--RAU SDD_WAT_RUK                                                                                   
alter table I$SDD_WAT add constraint SDD_WAT_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_WIN_RUK                                                                                   
alter table I$SDD_WIN add constraint SDD_WIN_RUK unique (ivid)
/                                     
                                                                                                    
--RAU SDD_WMT_RUK                                                                                   
alter table I$SDD_WMT add constraint SDD_WMT_RUK unique (ivid)
/

--RAU UK_QSU
alter table i$SDD_QSU
add constraint UK_QSU
unique (parent_ivid
, NAME
, ADDRESS
, PROTOCOL
)
deferrable initially deferred
/

