SET FEEDBACK OFF ALTER TABLE DAE_AUTHOR_A ADD (CONSTRAINT fk_DAE_AUTHOR_A1 FOREIGN KEY (DAE_DS_HEADER_S) REFERENCES DAE_DS_HEADER (DAE_DS_HEADER_S)); ALTER TABLE DAE_BD_ORD_CRIT_A ADD (CONSTRAINT fk_DAE_BD_ORD_CRIT_A1 FOREIGN KEY (DAE_EXCH_PROF_S) REFERENCES DAE_EXCH_PROF (DAE_EXCH_PROF_S)); ALTER TABLE DAE_DELETE_CRIT_A ADD (CONSTRAINT fk_DAE_DELETE_CRIT_A1 FOREIGN KEY (DAE_IMPORT_DSC_S) REFERENCES DAE_IMPORT_DSC (DAE_IMPORT_DSC_S)); ALTER TABLE DAE_ELEMENTS_A ADD (CONSTRAINT fk_DAE_ELEMENTS_A1 FOREIGN KEY (DAE_ENUM_TY_S) REFERENCES DAE_ENUM_TY (DAE_ENUM_TY_S)); ALTER TABLE DAE_FILL_CRIT_A ADD (CONSTRAINT fk_DAE_FILL_CRIT_A1 FOREIGN KEY (DAE_IMPORT_DSC_S) REFERENCES DAE_IMPORT_DSC (DAE_IMPORT_DSC_S)); ALTER TABLE DAE_ID_CRIT_A ADD (CONSTRAINT fk_DAE_ID_CRIT_A1 FOREIGN KEY (DAE_EXCH_PROF_S) REFERENCES DAE_EXCH_PROF (DAE_EXCH_PROF_S)); ALTER TABLE DAE_INITIAL_CRIT_A ADD (CONSTRAINT fk_DAE_INITIAL_CRIT_A1 FOREIGN KEY (DAE_EXPORT_DSC_S) REFERENCES DAE_EXPORT_DSC (DAE_EXPORT_DSC_S)); ALTER TABLE DAE_MN_CNTN_CRIT_A ADD (CONSTRAINT fk_DAE_MN_CNTN_CRIT_A1 FOREIGN KEY (DAE_EXCH_PROF_S) REFERENCES DAE_EXCH_PROF (DAE_EXCH_PROF_S)); ALTER TABLE DAE_ORGANIZATION_A ADD (CONSTRAINT fk_DAE_ORGANIZATION_A1 FOREIGN KEY (DAE_DS_HEADER_S) REFERENCES DAE_DS_HEADER (DAE_DS_HEADER_S)); ALTER TABLE DAE_QUALITY_RPT_A ADD (CONSTRAINT fk_DAE_QUALITY_RPT_A1 FOREIGN KEY (DAE_DS_HEADER_S) REFERENCES DAE_DS_HEADER (DAE_DS_HEADER_S)); ALTER TABLE DAE_REFRESH_CRIT_A ADD (CONSTRAINT fk_DAE_REFRESH_CRIT_A1 FOREIGN KEY (DAE_IMPORT_DSC_S) REFERENCES DAE_IMPORT_DSC (DAE_IMPORT_DSC_S)); ALTER TABLE DAE_SCOPE_CRIT_A ADD (CONSTRAINT fk_DAE_SCOPE_CRIT_A1 FOREIGN KEY (DAE_EXCH_PROF_S) REFERENCES DAE_EXCH_PROF (DAE_EXCH_PROF_S)); ALTER TABLE ACTIVITY_CLASS ADD (CONSTRAINT fk_ACTIVITY_CLASS1 FOREIGN KEY (CLASSIFICATION_SYS) REFERENCES CLSN_SYS (CLSN_SYS_NAME)); ALTER TABLE ACTIVITY_CLASS ADD (CONSTRAINT fk_ACTIVITY_CLASS2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE ACTIVITY_CLASS ADD (CONSTRAINT fk_ACTIVITY_CLASS3 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE ACTIVITY_CLASS ADD (CONSTRAINT fk_ACTIVITY_CLASS4 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE ACTIVITY_CLSN ADD (CONSTRAINT fk_ACTIVITY_CLSN1 FOREIGN KEY (ACTIVITY_CLASS_S) REFERENCES ACTIVITY_CLASS (ACTIVITY_CLASS_S)); ALTER TABLE ACTIVITY_CLSN ADD (CONSTRAINT fk_ACTIVITY_CLSN2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE ACTIVITY_CLSN ADD (CONSTRAINT fk_ACTIVITY_CLSN3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE ACTIVITY_FULFL ADD (CONSTRAINT fk_ACTIVITY_FULFL1 FOREIGN KEY (RELATIVE_TIME_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE ACTIVITY_TMPLT ADD (CONSTRAINT fk_ACTIVITY_TMPLT1 FOREIGN KEY (DESCRIBED_ACT) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE ACTIVITY_TMPLT ADD (CONSTRAINT fk_ACTIVITY_TMPLT2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE ACTIVITY_TMPLT ADD (CONSTRAINT fk_ACTIVITY_TMPLT3 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE ACTIVITY_TMPLT ADD (CONSTRAINT fk_ACTIVITY_TMPLT4 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE ACT_CLS_ALIAS ADD (CONSTRAINT fk_ACT_CLS_ALIAS1 FOREIGN KEY (ACTIVITY_CLASS_S) REFERENCES ACTIVITY_CLASS (ACTIVITY_CLASS_S)); ALTER TABLE ACT_CLS_ALIAS ADD (CONSTRAINT fk_ACT_CLS_ALIAS2 FOREIGN KEY (CLASSIFICATION_SYS) REFERENCES CLSN_SYS (CLSN_SYS_NAME)); ALTER TABLE ACT_CLS_ALIAS ADD (CONSTRAINT fk_ACT_CLS_ALIAS3 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE ACT_CLS_ALIAS ADD (CONSTRAINT fk_ACT_CLS_ALIAS4 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE ACT_CLS_ALIAS ADD (CONSTRAINT fk_ACT_CLS_ALIAS5 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE ACT_CLS_CLSN ADD (CONSTRAINT fk_ACT_CLS_CLSN1 FOREIGN KEY (BE_CLASSIFIED_AS_S) REFERENCES ACTIVITY_CLASS (ACTIVITY_CLASS_S)); ALTER TABLE ACT_CLS_CLSN ADD (CONSTRAINT fk_ACT_CLS_CLSN2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE ACT_CLS_CLSN ADD (CONSTRAINT fk_ACT_CLS_CLSN3 FOREIGN KEY (HAVE_AS_A_MEMBER_S) REFERENCES ACTIVITY_CLASS (ACTIVITY_CLASS_S)); ALTER TABLE ACT_CLS_CLSN ADD (CONSTRAINT fk_ACT_CLS_CLSN4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE ACT_CLS_CLSN ADD (CONSTRAINT fk_ACT_CLS_CLSN5 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE ACT_CLS_CLSN ADD (CONSTRAINT fk_ACT_CLS_CLSN6 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE ACT_CLS_CLSN ADD (CONSTRAINT fk_ACT_CLS_CLSN7 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE ACT_TMPLT_CSTR ADD (CONSTRAINT fk_ACT_TMPLT_CSTR1 FOREIGN KEY (ACTIVITY_TMPLT_S) REFERENCES ACTIVITY_TMPLT (ACTIVITY_TMPLT_S)); ALTER TABLE ACT_TMPLT_CSTR ADD (CONSTRAINT fk_ACT_TMPLT_CSTR2 FOREIGN KEY (CONSTRAINED_BY) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE ACT_TMPLT_CSTR ADD (CONSTRAINT fk_ACT_TMPLT_CSTR3 FOREIGN KEY (CONSTRAINT_FOR) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE ACT_TMPLT_CSTR ADD (CONSTRAINT fk_ACT_TMPLT_CSTR4 FOREIGN KEY (R_TMPLT_CSTR_KD_NM) REFERENCES R_TMPLT_CSTR_KD (R_TMPLT_CSTR_KD_NM)); ALTER TABLE AIRCRAFT ADD (CONSTRAINT fk_AIRCRAFT1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE AIRCRAFT ADD (CONSTRAINT fk_AIRCRAFT2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE ALOC_FLW_STRM ADD (CONSTRAINT fk_ALOC_FLW_STRM1 FOREIGN KEY (PFNU_PORT_S) REFERENCES PFNU_PORT (PFNU_PORT_S)); ALTER TABLE ALOW_FLW_STRM ADD (CONSTRAINT fk_ALOW_FLW_STRM1 FOREIGN KEY (PFNU_PORT_S) REFERENCES PFNU_PORT (PFNU_PORT_S)); ALTER TABLE ALOW_FLW_STRM ADD (CONSTRAINT fk_ALOW_FLW_STRM2 FOREIGN KEY (R_ALLOWABLE_KIND) REFERENCES R_ALLOWABLE (R_ALLOWABLE_KIND)); ALTER TABLE ANA_RSVR_ANAL ADD (CONSTRAINT fk_ANA_RSVR_ANAL1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE ANA_RSVR_ANAL ADD (CONSTRAINT fk_ANA_RSVR_ANAL2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE ANA_RSVR_ANAL ADD (CONSTRAINT fk_ANA_RSVR_ANAL3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE ANA_RSVR_ANAL ADD (CONSTRAINT fk_ANA_RSVR_ANAL4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE ANA_RSVR_ANAL ADD (CONSTRAINT fk_ANA_RSVR_ANAL5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE ANA_RSVR_ANAL ADD (CONSTRAINT fk_ANA_RSVR_ANAL6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE ANCHORING_SYS ADD (CONSTRAINT fk_ANCHORING_SYS1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE ANCHORING_SYS ADD (CONSTRAINT fk_ANCHORING_SYS2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE ANCHOR_WINCH ADD (CONSTRAINT fk_ANCHOR_WINCH1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE ANCHOR_WINCH ADD (CONSTRAINT fk_ANCHOR_WINCH2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE APPLICATION_STA ADD (CONSTRAINT fk_APPLICATION_STA1 FOREIGN KEY (APP_FOR_PRMT_S) REFERENCES APP_FOR_PRMT (APP_FOR_PRMT_S)); ALTER TABLE APPLICATION_STA ADD (CONSTRAINT fk_APPLICATION_STA2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE APPLICATION_STA ADD (CONSTRAINT fk_APPLICATION_STA3 FOREIGN KEY (R_APP_STA_KIND) REFERENCES R_APP_STA (R_APP_STA_KIND)); ALTER TABLE APPLICATION_STA ADD (CONSTRAINT fk_APPLICATION_STA4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE APP_CORD_TRFM ADD (CONSTRAINT fk_APP_CORD_TRFM1 FOREIGN KEY (COORDINATE_TRFM_ID) REFERENCES COORDINATE_TRFM (COORDINATE_TRFM_ID)); ALTER TABLE APP_CORD_TRFM ADD (CONSTRAINT fk_APP_CORD_TRFM2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE APP_CORD_TRFM ADD (CONSTRAINT fk_APP_CORD_TRFM3 FOREIGN KEY (SOURCE_CORD_SYS) REFERENCES COORDINATE_SYS (COORDINATE_SYS_ID)); ALTER TABLE APP_CORD_TRFM ADD (CONSTRAINT fk_APP_CORD_TRFM4 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE APP_CORD_TRFM ADD (CONSTRAINT fk_APP_CORD_TRFM5 FOREIGN KEY (TARGET_CORD_SYS) REFERENCES COORDINATE_SYS (COORDINATE_SYS_ID)); ALTER TABLE APP_CORD_TRFM ADD (CONSTRAINT fk_APP_CORD_TRFM6 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE APP_FOR_PRMT ADD (CONSTRAINT fk_APP_FOR_PRMT1 FOREIGN KEY (APPLICANT_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE APP_FOR_PRMT ADD (CONSTRAINT fk_APP_FOR_PRMT2 FOREIGN KEY (CMPS_DOC_SPEC_S) REFERENCES CMPS_DOC_SPEC (CMPS_DOC_SPEC_S)); ALTER TABLE APP_FOR_PRMT ADD (CONSTRAINT fk_APP_FOR_PRMT3 FOREIGN KEY (INFORMATION_CNTN_S) REFERENCES DATA_COLLECTION (DATA_COLLECTION_S)); ALTER TABLE APP_FOR_PRMT ADD (CONSTRAINT fk_APP_FOR_PRMT4 FOREIGN KEY (TYP_DOC_SPEC_ID) REFERENCES TYP_DOC_SPEC (TYP_DOC_SPEC_ID)); ALTER TABLE AREA_CELL ADD (CONSTRAINT fk_AREA_CELL1 FOREIGN KEY (CELL_HEIGHT_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE AREA_CELL ADD (CONSTRAINT fk_AREA_CELL2 FOREIGN KEY (CELL_ORNT_ANGL_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE AREA_CELL ADD (CONSTRAINT fk_AREA_CELL3 FOREIGN KEY (CELL_S) REFERENCES CELL (CELL_S)); ALTER TABLE AREA_CELL ADD (CONSTRAINT fk_AREA_CELL4 FOREIGN KEY (CELL_WIDTH_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE AREA_CELL ADD (CONSTRAINT fk_AREA_CELL5 FOREIGN KEY (HORIZONTAL_OFST_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE AREA_CELL ADD (CONSTRAINT fk_AREA_CELL6 FOREIGN KEY (HORIZONTAL_SPC_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE AREA_CELL ADD (CONSTRAINT fk_AREA_CELL7 FOREIGN KEY (VERTICAL_OFFSET_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE AREA_CELL ADD (CONSTRAINT fk_AREA_CELL8 FOREIGN KEY (VERTICAL_SPACING_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE AREA_ELEMENT ADD (CONSTRAINT fk_AREA_ELEMENT1 FOREIGN KEY (CELL_S) REFERENCES CELL (CELL_S)); ALTER TABLE AREA_ELEMENT ADD (CONSTRAINT fk_AREA_ELEMENT2 FOREIGN KEY (GRAPH_ELE_CMPN_S) REFERENCES CMPS_GRAPH_ELE (CMPS_GRAPH_ELE_S)); ALTER TABLE AREA_ELEMENT ADD (CONSTRAINT fk_AREA_ELEMENT3 FOREIGN KEY (IMAGE_PALET_TY_ID) REFERENCES IMAGE_PALET_TY (IMAGE_PALET_TY_ID)); ALTER TABLE AREA_ELEMENT ADD (CONSTRAINT fk_AREA_ELEMENT4 FOREIGN KEY (PATTERN_FILL_TY_ID) REFERENCES PATTERN_FILL_TY (PATTERN_FILL_TY_ID)); ALTER TABLE AREA_ELEMENT ADD (CONSTRAINT fk_AREA_ELEMENT5 FOREIGN KEY (PAT_ORNT_ANGL_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE AREA_PAT_FILL ADD (CONSTRAINT fk_AREA_PAT_FILL1 FOREIGN KEY (PATTERN_FILL_TY_ID) REFERENCES PATTERN_FILL_TY (PATTERN_FILL_TY_ID)); ALTER TABLE AREA_PAT_FILL ADD (CONSTRAINT fk_AREA_PAT_FILL2 FOREIGN KEY (R_COLOR_NAME) REFERENCES R_COLOR (R_COLOR_NAME)); ALTER TABLE AREA_PAT_FILL ADD (CONSTRAINT fk_AREA_PAT_FILL3 FOREIGN KEY (SYMBOL_LIBRARY_ID) REFERENCES SYMBOL_LIBRARY (SYMBOL_LIBRARY_ID)); ALTER TABLE BINSET_GRID ADD (CONSTRAINT fk_BINSET_GRID1 FOREIGN KEY (R_BNST_GEOM_CLS_KD) REFERENCES R_BNST_GEOM_CLS (R_BNST_GEOM_CLS_KD)); ALTER TABLE BINSET_GRID ADD (CONSTRAINT fk_BINSET_GRID2 FOREIGN KEY (SEISMIC_GEOM_SET_S) REFERENCES SEIS_GEOM_SET (SEIS_GEOM_SET_S)); ALTER TABLE BINSET_GRID ADD (CONSTRAINT fk_BINSET_GRID3 FOREIGN KEY (SEIS_PROC_ACT_S) REFERENCES SEIS_PROC_ACT (SEIS_PROC_ACT_S)); ALTER TABLE BINSET_GRID_VAR ADD (CONSTRAINT fk_BINSET_GRID_VAR1 FOREIGN KEY (BINSET_GRID_S) REFERENCES BINSET_GRID (BINSET_GRID_S)); ALTER TABLE BINSET_GRID_VAR ADD (CONSTRAINT fk_BINSET_GRID_VAR2 FOREIGN KEY (R_BNST_GEOM_CLS_KD) REFERENCES R_BNST_GEOM_CLS (R_BNST_GEOM_CLS_KD)); ALTER TABLE BINSET_GRID_VAR ADD (CONSTRAINT fk_BINSET_GRID_VAR3 FOREIGN KEY (R_GRID_VARIANT_NM) REFERENCES R_GRID_VARIANT (R_GRID_VARIANT_NM)); ALTER TABLE BINSET_GRID_VAR ADD (CONSTRAINT fk_BINSET_GRID_VAR4 FOREIGN KEY (SEIS_PROC_ACT_S) REFERENCES SEIS_PROC_ACT (SEIS_PROC_ACT_S)); ALTER TABLE BINSET_NTRS ADD (CONSTRAINT fk_BINSET_NTRS1 FOREIGN KEY (BINSET_GRID_S) REFERENCES BINSET_GRID (BINSET_GRID_S)); ALTER TABLE BINSET_NTRS ADD (CONSTRAINT fk_BINSET_NTRS2 FOREIGN KEY (INTERSECTED_GEOM_S) REFERENCES BINSET_NTRS (BINSET_NTRS_S)); ALTER TABLE BOREHOLE_CMPN ADD (CONSTRAINT fk_BOREHOLE_CMPN1 FOREIGN KEY (BRHL_CMPN_LEN_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BOREHOLE_CMPN ADD (CONSTRAINT fk_BOREHOLE_CMPN2 FOREIGN KEY (DIAMETER_CRSH_ZN_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BOREHOLE_CMPN ADD (CONSTRAINT fk_BOREHOLE_CMPN3 FOREIGN KEY (DRILL_BOREHOLE_S) REFERENCES DRILL_BOREHOLE (DRILL_BOREHOLE_S)); ALTER TABLE BOREHOLE_CMPN ADD (CONSTRAINT fk_BOREHOLE_CMPN4 FOREIGN KEY (OUTER_DIAMETER_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BOREHOLE_CMPN ADD (CONSTRAINT fk_BOREHOLE_CMPN5 FOREIGN KEY (R_DIAMETER) REFERENCES R_DIAMETER (R_DIAMETER_NAME)); ALTER TABLE BOREHOLE_CMPN ADD (CONSTRAINT fk_BOREHOLE_CMPN6 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE BOREHOLE_CMPN ADD (CONSTRAINT fk_BOREHOLE_CMPN7 FOREIGN KEY (R_PERFORATION_KIND) REFERENCES R_PERFORATION (R_PERFORATION_KIND)); ALTER TABLE BOREHOLE_CMPN ADD (CONSTRAINT fk_BOREHOLE_CMPN8 FOREIGN KEY (SHOOT_PERF_S) REFERENCES SHOOT_PERF (SHOOT_PERF_S)); ALTER TABLE BOREHOLE_CMPN ADD (CONSTRAINT fk_BOREHOLE_CMPN9 FOREIGN KEY (SHOT_ANGLE_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BOREHOLE_CMPN ADD (CONSTRAINT fk_BOREHOLE_CMPN10 FOREIGN KEY (SHOT_DENSITY_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BOREHOLE_CMPN ADD (CONSTRAINT fk_BOREHOLE_CMPN11 FOREIGN KEY (SHOT_DIAMETER_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BOREHOLE_CMPN ADD (CONSTRAINT fk_BOREHOLE_CMPN12 FOREIGN KEY (SHOT_LENGTH_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BOREHOLE_CMPN ADD (CONSTRAINT fk_BOREHOLE_CMPN13 FOREIGN KEY (SHOT_PHASE_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BOREHOLE_CMPN ADD (CONSTRAINT fk_BOREHOLE_CMPN14 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE BOREHOLE_CMPN ADD (CONSTRAINT fk_BOREHOLE_CMPN15 FOREIGN KEY (WELLBORE_S) REFERENCES WELLBORE (WELLBORE_S)); ALTER TABLE BOREHOLE_CMPN ADD (CONSTRAINT fk_BOREHOLE_CMPN16 FOREIGN KEY (WELL_CMPL_1_S) REFERENCES WELL_COMPLETION (WELL_COMPLETION_S)); ALTER TABLE BOREHOLE_FL_SYS ADD (CONSTRAINT fk_BOREHOLE_FL_SYS1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE BOREHOLE_FL_SYS ADD (CONSTRAINT fk_BOREHOLE_FL_SYS2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE BOUNDARY_CLASS ADD (CONSTRAINT fk_BOUNDARY_CLASS1 FOREIGN KEY (CLASSIFICATION_SYS) REFERENCES CLSN_SYS (CLSN_SYS_NAME)); ALTER TABLE BOUNDARY_CLASS ADD (CONSTRAINT fk_BOUNDARY_CLASS2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE BOUNDARY_CLASS ADD (CONSTRAINT fk_BOUNDARY_CLASS3 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE BOUNDARY_CLASS ADD (CONSTRAINT fk_BOUNDARY_CLASS4 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE BOUNDARY_CLSN ADD (CONSTRAINT fk_BOUNDARY_CLSN1 FOREIGN KEY (BOUNDARY_CLASS_S) REFERENCES BOUNDARY_CLASS (BOUNDARY_CLASS_S)); ALTER TABLE BOUNDARY_CLSN ADD (CONSTRAINT fk_BOUNDARY_CLSN2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BOUNDARY_CLSN ADD (CONSTRAINT fk_BOUNDARY_CLSN3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE BRHL_GNR_RUN ADD (CONSTRAINT fk_BRHL_GNR_RUN1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE BRHL_GNR_RUN ADD (CONSTRAINT fk_BRHL_GNR_RUN2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BRHL_GNR_RUN ADD (CONSTRAINT fk_BRHL_GNR_RUN3 FOREIGN KEY (R_ACT_TERM_RSN_NM) REFERENCES R_ACT_TERM_RSN (R_ACT_TERM_RSN_NM)); ALTER TABLE BRHL_GNR_RUN ADD (CONSTRAINT fk_BRHL_GNR_RUN4 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE BRHL_GNR_RUN ADD (CONSTRAINT fk_BRHL_GNR_RUN5 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE BRHL_GNR_RUN ADD (CONSTRAINT fk_BRHL_GNR_RUN6 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE BRHL_GNR_RUN ADD (CONSTRAINT fk_BRHL_GNR_RUN7 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE BRHL_GNR_RUN ADD (CONSTRAINT fk_BRHL_GNR_RUN8 FOREIGN KEY (WELLBORE_S) REFERENCES WELLBORE (WELLBORE_S)); ALTER TABLE BRHL_GNR_RUN ADD (CONSTRAINT fk_BRHL_GNR_RUN9 FOREIGN KEY (WELL_OPR_FL_S) REFERENCES WELL_OPR_FL (WELL_OPR_FL_S)); ALTER TABLE BSASC ADD (CONSTRAINT fk_BSASC1 FOREIGN KEY (KIND) REFERENCES R_BSASC (R_BSASC_KIND)); ALTER TABLE BSASC ADD (CONSTRAINT fk_BSASC2 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE BSASC_ACT_RLE ADD (CONSTRAINT fk_BSASC_ACT_RLE1 FOREIGN KEY (BSASC_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE BSASC_ACT_RLE ADD (CONSTRAINT fk_BSASC_ACT_RLE2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BSASC_ACT_RLE ADD (CONSTRAINT fk_BSASC_ACT_RLE3 FOREIGN KEY (R_BSASC_ACT_RLE_KD) REFERENCES R_BSASC_ACT_RLE (R_BSASC_ACT_RLE_KD)); ALTER TABLE BSASC_ACT_RLE ADD (CONSTRAINT fk_BSASC_ACT_RLE4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE BSASC_ALIAS ADD (CONSTRAINT fk_BSASC_ALIAS1 FOREIGN KEY (BSASC_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE BSASC_ALIAS ADD (CONSTRAINT fk_BSASC_ALIAS2 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE BSASC_FCL_ASN ADD (CONSTRAINT fk_BSASC_FCL_ASN1 FOREIGN KEY (BSASC_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE BSASC_FCL_ASN ADD (CONSTRAINT fk_BSASC_FCL_ASN2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BSASC_FCL_ASN ADD (CONSTRAINT fk_BSASC_FCL_ASN3 FOREIGN KEY (R_BSASC_FCL_RLE_NM) REFERENCES R_BSASC_FCL_RLE (R_BSASC_FCL_RLE_NM)); ALTER TABLE BSASC_FCL_ASN ADD (CONSTRAINT fk_BSASC_FCL_ASN4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE BSASC_INJURY ADD (CONSTRAINT fk_BSASC_INJURY1 FOREIGN KEY (BSASC_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE BSASC_INJURY ADD (CONSTRAINT fk_BSASC_INJURY2 FOREIGN KEY (INCDT_OF_NCOM_S) REFERENCES INCDT_OF_NCOM (INCDT_OF_NCOM_S)); ALTER TABLE BSASC_INJURY ADD (CONSTRAINT fk_BSASC_INJURY3 FOREIGN KEY (LOST_TIME_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BSASC_INJURY ADD (CONSTRAINT fk_BSASC_INJURY4 FOREIGN KEY (MONETARY_LOSS_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE BSASC_INJURY ADD (CONSTRAINT fk_BSASC_INJURY5 FOREIGN KEY (R_BSASC_INJURY_KD) REFERENCES R_BSASC_INJURY (R_BSASC_INJURY_KD)); ALTER TABLE BSASC_JOB_TITLE ADD (CONSTRAINT fk_BSASC_JOB_TITLE1 FOREIGN KEY (BSASN_S) REFERENCES BSASN (BSASN_S)); ALTER TABLE BSASC_JOB_TITLE ADD (CONSTRAINT fk_BSASC_JOB_TITLE2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BSASC_JOB_TITLE ADD (CONSTRAINT fk_BSASC_JOB_TITLE3 FOREIGN KEY (R_BSASC_JOB_TTL_KD) REFERENCES R_BSASC_JOB_TTL (R_BSASC_JOB_TTL_KD)); ALTER TABLE BSASC_JOB_TITLE ADD (CONSTRAINT fk_BSASC_JOB_TITLE4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE BSASC_LFRLE ADD (CONSTRAINT fk_BSASC_LFRLE1 FOREIGN KEY (BSASC_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE BSASC_LFRLE ADD (CONSTRAINT fk_BSASC_LFRLE2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BSASC_LFRLE ADD (CONSTRAINT fk_BSASC_LFRLE3 FOREIGN KEY (R_BSASC_LFRLE_KIND) REFERENCES R_BSASC_LFRLE (R_BSASC_LFRLE_KIND)); ALTER TABLE BSASC_LFRLE ADD (CONSTRAINT fk_BSASC_LFRLE4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE BSASC_PRIVILEGE ADD (CONSTRAINT fk_BSASC_PRIVILEGE1 FOREIGN KEY (BSASC_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE BSASC_PRIVILEGE ADD (CONSTRAINT fk_BSASC_PRIVILEGE2 FOREIGN KEY (DATA_VALUE_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BSASC_PRIVILEGE ADD (CONSTRAINT fk_BSASC_PRIVILEGE3 FOREIGN KEY (R_BSASC_PRIV_KIND) REFERENCES R_BSASC_PRIV (R_BSASC_PRIV_KIND)); ALTER TABLE BSASC_SCTY_STA ADD (CONSTRAINT fk_BSASC_SCTY_STA1 FOREIGN KEY (BSASC_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE BSASC_SCTY_STA ADD (CONSTRAINT fk_BSASC_SCTY_STA2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BSASC_SCTY_STA ADD (CONSTRAINT fk_BSASC_SCTY_STA3 FOREIGN KEY (R_BSASC_SCTY_KIND) REFERENCES R_BSASC_SCTY (R_BSASC_SCTY_KIND)); ALTER TABLE BSASC_SCTY_STA ADD (CONSTRAINT fk_BSASC_SCTY_STA4 FOREIGN KEY (R_BSASN_ROLE_KIND) REFERENCES R_BSASN_ROLE (R_BSASN_ROLE_KIND)); ALTER TABLE BSASC_SCTY_STA ADD (CONSTRAINT fk_BSASC_SCTY_STA5 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE BSASC_SERVICE ADD (CONSTRAINT fk_BSASC_SERVICE1 FOREIGN KEY (BSASC_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE BSASC_SERVICE ADD (CONSTRAINT fk_BSASC_SERVICE2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BSASC_SERVICE ADD (CONSTRAINT fk_BSASC_SERVICE3 FOREIGN KEY (R_BSASC_SERVICE_KD) REFERENCES R_BSASC_SERVICE (R_BSASC_SERVICE_KD)); ALTER TABLE BSASC_SERVICE ADD (CONSTRAINT fk_BSASC_SERVICE4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE BSASN ADD (CONSTRAINT fk_BSASN1 FOREIGN KEY (ASSOCIATED_WITH_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE BSASN ADD (CONSTRAINT fk_BSASN2 FOREIGN KEY (BSASC_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE BSASN ADD (CONSTRAINT fk_BSASN3 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BSASN ADD (CONSTRAINT fk_BSASN4 FOREIGN KEY (R_BSASN_ROLE_KIND) REFERENCES R_BSASN_ROLE (R_BSASN_ROLE_KIND)); ALTER TABLE BSASN ADD (CONSTRAINT fk_BSASN5 FOREIGN KEY (R_BSASN_STRU_ID) REFERENCES R_BSASN_STRU (R_BSASN_STRU_ID)); ALTER TABLE BSASN ADD (CONSTRAINT fk_BSASN6 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE BUILDING ADD (CONSTRAINT fk_BUILDING1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE BUILDING ADD (CONSTRAINT fk_BUILDING2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE BULK_STOR_SYS ADD (CONSTRAINT fk_BULK_STOR_SYS1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE BULK_STOR_SYS ADD (CONSTRAINT fk_BULK_STOR_SYS2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE BUSINESS_CNTC ADD (CONSTRAINT fk_BUSINESS_CNTC1 FOREIGN KEY (CONTACTEE_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE BUSINESS_CNTC ADD (CONSTRAINT fk_BUSINESS_CNTC2 FOREIGN KEY (CONTACTOR_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE BUSINESS_CNTC ADD (CONSTRAINT fk_BUSINESS_CNTC3 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE BUSINESS_CNTC ADD (CONSTRAINT fk_BUSINESS_CNTC4 FOREIGN KEY (R_BUS_CNTC_PURP_KD) REFERENCES R_BUS_CNTC_PURP (R_BUS_CNTC_PURP_KD)); ALTER TABLE BUSINESS_CNTC ADD (CONSTRAINT fk_BUSINESS_CNTC5 FOREIGN KEY (R_BUS_CNTC_RSLT_KD) REFERENCES R_BUS_CNTC_RSLT (R_BUS_CNTC_RSLT_KD)); ALTER TABLE BUSINESS_CNTC ADD (CONSTRAINT fk_BUSINESS_CNTC6 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE CAP_PRS_CV ADD (CONSTRAINT fk_CAP_PRS_CV1 FOREIGN KEY (R_CAPILLARY_PRS_KD) REFERENCES R_CAPILLARY_PRS (R_CAPILLARY_PRS_KD)); ALTER TABLE CAP_PRS_PT ADD (CONSTRAINT fk_CAP_PRS_PT1 FOREIGN KEY (CAP_PRS_CV_S) REFERENCES CAP_PRS_CV (CAP_PRS_CV_S)); ALTER TABLE CAP_PRS_PT ADD (CONSTRAINT fk_CAP_PRS_PT2 FOREIGN KEY (R_CAPILLARY_PRS_KD) REFERENCES R_CAPILLARY_PRS (R_CAPILLARY_PRS_KD)); ALTER TABLE CAP_PRS_PT ADD (CONSTRAINT fk_CAP_PRS_PT3 FOREIGN KEY (R_CAP_PRS_USE_KIND) REFERENCES R_CAP_PRS_USE (R_CAP_PRS_USE_KIND)); ALTER TABLE CARTER_LSA ADD (CONSTRAINT fk_CARTER_LSA1 FOREIGN KEY (R_EAST_OR_WEST_NM) REFERENCES R_EAST_OR_WEST (R_EAST_OR_WEST_NM)); ALTER TABLE CARTER_LSA ADD (CONSTRAINT fk_CARTER_LSA2 FOREIGN KEY (R_NRTH_OR_SOUTH_KD) REFERENCES R_NRTH_OR_SOUTH (R_NRTH_OR_SOUTH_KD)); ALTER TABLE CATALOG_EQP ADD (CONSTRAINT fk_CATALOG_EQP1 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE CATALOG_EQP_INSL ADD (CONSTRAINT fk_CATALOG_EQP_INSL1 FOREIGN KEY (CATALOG_EQP_S) REFERENCES CATALOG_EQP (CATALOG_EQP_S)); ALTER TABLE CATALOG_EQP_INSL ADD (CONSTRAINT fk_CATALOG_EQP_INSL2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CATALOG_EQP_INSL ADD (CONSTRAINT fk_CATALOG_EQP_INSL3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE CATALOG_IT_ASSY ADD (CONSTRAINT fk_CATALOG_IT_ASSY1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CATALOG_IT_ASSY ADD (CONSTRAINT fk_CATALOG_IT_ASSY2 FOREIGN KEY (PART_S) REFERENCES CATALOG_EQP (CATALOG_EQP_S)); ALTER TABLE CATALOG_IT_ASSY ADD (CONSTRAINT fk_CATALOG_IT_ASSY3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE CATALOG_IT_ASSY ADD (CONSTRAINT fk_CATALOG_IT_ASSY4 FOREIGN KEY (WHOLE_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE CATALOG_IT_COLL ADD (CONSTRAINT fk_CATALOG_IT_COLL1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CATALOG_IT_COLL ADD (CONSTRAINT fk_CATALOG_IT_COLL2 FOREIGN KEY (PART_S) REFERENCES CATALOG_EQP (CATALOG_EQP_S)); ALTER TABLE CATALOG_IT_COLL ADD (CONSTRAINT fk_CATALOG_IT_COLL3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE CATALOG_IT_COLL ADD (CONSTRAINT fk_CATALOG_IT_COLL4 FOREIGN KEY (WHOLE_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE CAT_EQP_ALIAS ADD (CONSTRAINT fk_CAT_EQP_ALIAS1 FOREIGN KEY (CATALOG_EQP_S) REFERENCES CATALOG_EQP (CATALOG_EQP_S)); ALTER TABLE CAT_EQP_ALIAS ADD (CONSTRAINT fk_CAT_EQP_ALIAS2 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE CAT_EQP_CLSN ADD (CONSTRAINT fk_CAT_EQP_CLSN1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CAT_EQP_CLSN ADD (CONSTRAINT fk_CAT_EQP_CLSN2 FOREIGN KEY (EQUIPMENT_CLASS_S) REFERENCES EQUIPMENT_CLASS (EQUIPMENT_CLASS_S)); ALTER TABLE CAT_EQP_CLSN ADD (CONSTRAINT fk_CAT_EQP_CLSN3 FOREIGN KEY (MEMBER_S) REFERENCES CATALOG_EQP (CATALOG_EQP_S)); ALTER TABLE CAT_EQP_CLSN ADD (CONSTRAINT fk_CAT_EQP_CLSN4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE CAT_EQP_CMPS ADD (CONSTRAINT fk_CAT_EQP_CMPS1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CAT_EQP_CMPS ADD (CONSTRAINT fk_CAT_EQP_CMPS2 FOREIGN KEY (PART_S) REFERENCES CATALOG_EQP (CATALOG_EQP_S)); ALTER TABLE CAT_EQP_CMPS ADD (CONSTRAINT fk_CAT_EQP_CMPS3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE CAT_EQP_CMPS ADD (CONSTRAINT fk_CAT_EQP_CMPS4 FOREIGN KEY (WHOLE_S) REFERENCES CATALOG_EQP (CATALOG_EQP_S)); ALTER TABLE CAT_EQP_MTRSPEC ADD (CONSTRAINT fk_CAT_EQP_MTRSPEC1 FOREIGN KEY (CATALOG_EQP_S) REFERENCES CATALOG_EQP (CATALOG_EQP_S)); ALTER TABLE CAT_EQP_MTRSPEC ADD (CONSTRAINT fk_CAT_EQP_MTRSPEC2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CAT_EQP_MTRSPEC ADD (CONSTRAINT fk_CAT_EQP_MTRSPEC3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE CAT_EQP_SUCC ADD (CONSTRAINT fk_CAT_EQP_SUCC1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CAT_EQP_SUCC ADD (CONSTRAINT fk_CAT_EQP_SUCC2 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE CAT_EQP_SUCC ADD (CONSTRAINT fk_CAT_EQP_SUCC3 FOREIGN KEY (SUCCEEDED_S) REFERENCES CATALOG_EQP (CATALOG_EQP_S)); ALTER TABLE CAT_EQP_SUCC ADD (CONSTRAINT fk_CAT_EQP_SUCC4 FOREIGN KEY (SUCCESSOR_S) REFERENCES CATALOG_EQP (CATALOG_EQP_S)); ALTER TABLE CAT_EQP_VERSION ADD (CONSTRAINT fk_CAT_EQP_VERSION1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CAT_EQP_VERSION ADD (CONSTRAINT fk_CAT_EQP_VERSION2 FOREIGN KEY (ORIGINAL_S) REFERENCES CATALOG_EQP (CATALOG_EQP_S)); ALTER TABLE CAT_EQP_VERSION ADD (CONSTRAINT fk_CAT_EQP_VERSION3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE CAT_EQP_VERSION ADD (CONSTRAINT fk_CAT_EQP_VERSION4 FOREIGN KEY (VERSION_S) REFERENCES CATALOG_EQP (CATALOG_EQP_S)); ALTER TABLE CELL ADD (CONSTRAINT fk_CELL1 FOREIGN KEY (SYMBOL_LIBRARY_ID) REFERENCES SYMBOL_LIBRARY (SYMBOL_LIBRARY_ID)); ALTER TABLE CELL ADD (CONSTRAINT fk_CELL2 FOREIGN KEY (SYMBOL_TYPE_ID) REFERENCES SYMBOL_TYPE (SYMBOL_TYPE_ID)); ALTER TABLE CEMENT ADD (CONSTRAINT fk_CEMENT1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE CEMENT_CSG_STR ADD (CONSTRAINT fk_CEMENT_CSG_STR1 FOREIGN KEY (CASING_STRING_S) REFERENCES WELLBORE_TUBULAR (WELLBORE_TUBULAR_S)); ALTER TABLE CEMENT_CSG_STR ADD (CONSTRAINT fk_CEMENT_CSG_STR2 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE CEMENT_CSG_STR ADD (CONSTRAINT fk_CEMENT_CSG_STR3 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CEMENT_CSG_STR ADD (CONSTRAINT fk_CEMENT_CSG_STR4 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE CEMENT_CSG_STR ADD (CONSTRAINT fk_CEMENT_CSG_STR5 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE CEMENT_CSG_STR ADD (CONSTRAINT fk_CEMENT_CSG_STR6 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE CEMENT_CSG_STR ADD (CONSTRAINT fk_CEMENT_CSG_STR7 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE CEMENT_CSG_STR ADD (CONSTRAINT fk_CEMENT_CSG_STR8 FOREIGN KEY (WELLBORE_S) REFERENCES WELLBORE (WELLBORE_S)); ALTER TABLE CEMENT_TYPE ADD (CONSTRAINT fk_CEMENT_TYPE1 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE CEMENT_TYPE ADD (CONSTRAINT fk_CEMENT_TYPE2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE CEMENT_TYPE ADD (CONSTRAINT fk_CEMENT_TYPE3 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE CEMENT_TYPE ADD (CONSTRAINT fk_CEMENT_TYPE4 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE CHEMICAL_ELE_TY ADD (CONSTRAINT fk_CHEMICAL_ELE_TY1 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE CHEMICAL_ELE_TY ADD (CONSTRAINT fk_CHEMICAL_ELE_TY2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE CHEMICAL_ELE_TY ADD (CONSTRAINT fk_CHEMICAL_ELE_TY3 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE CHEMICAL_ELE_TY ADD (CONSTRAINT fk_CHEMICAL_ELE_TY4 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE CHEM_CMPD_TY ADD (CONSTRAINT fk_CHEM_CMPD_TY1 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE CHEM_CMPD_TY ADD (CONSTRAINT fk_CHEM_CMPD_TY2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE CHEM_CMPD_TY ADD (CONSTRAINT fk_CHEM_CMPD_TY3 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE CHEM_CMPD_TY ADD (CONSTRAINT fk_CHEM_CMPD_TY4 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE CHOKE ADD (CONSTRAINT fk_CHOKE1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE CHOKE ADD (CONSTRAINT fk_CHOKE2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE CHOKE_ADJ_EVNT ADD (CONSTRAINT fk_CHOKE_ADJ_EVNT1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE CHOKE_ADJ_EVNT ADD (CONSTRAINT fk_CHOKE_ADJ_EVNT2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CHOKE_ADJ_EVNT ADD (CONSTRAINT fk_CHOKE_ADJ_EVNT3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE CHOKE_ADJ_EVNT ADD (CONSTRAINT fk_CHOKE_ADJ_EVNT4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE CHOKE_ADJ_EVNT ADD (CONSTRAINT fk_CHOKE_ADJ_EVNT5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE CHOKE_ADJ_EVNT ADD (CONSTRAINT fk_CHOKE_ADJ_EVNT6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE CLSN_SYS ADD (CONSTRAINT fk_CLSN_SYS1 FOREIGN KEY (KIND) REFERENCES R_CLSN_SYS (NAME)); ALTER TABLE CLSN_SYS ADD (CONSTRAINT fk_CLSN_SYS2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE CLSN_SYS ADD (CONSTRAINT fk_CLSN_SYS3 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE CLSN_SYS ADD (CONSTRAINT fk_CLSN_SYS4 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE CMGL_PRMT ADD (CONSTRAINT fk_CMGL_PRMT1 FOREIGN KEY (CMPS_DOC_SPEC_S) REFERENCES CMPS_DOC_SPEC (CMPS_DOC_SPEC_S)); ALTER TABLE CMGL_PRMT ADD (CONSTRAINT fk_CMGL_PRMT2 FOREIGN KEY (INFORMATION_CNTN_S) REFERENCES DATA_COLLECTION (DATA_COLLECTION_S)); ALTER TABLE CMGL_PRMT ADD (CONSTRAINT fk_CMGL_PRMT3 FOREIGN KEY (ISSUED_BY_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE CMGL_PRMT ADD (CONSTRAINT fk_CMGL_PRMT4 FOREIGN KEY (TYP_DOC_SPEC_ID) REFERENCES TYP_DOC_SPEC (TYP_DOC_SPEC_ID)); ALTER TABLE CMPS_DOC_SPEC ADD (CONSTRAINT fk_CMPS_DOC_SPEC1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE CMPS_DOC_SPEC ADD (CONSTRAINT fk_CMPS_DOC_SPEC2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CMPS_DOC_SPEC ADD (CONSTRAINT fk_CMPS_DOC_SPEC3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE CMPS_DOC_SPEC ADD (CONSTRAINT fk_CMPS_DOC_SPEC4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE CMPS_DOC_SPEC ADD (CONSTRAINT fk_CMPS_DOC_SPEC5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE CMPS_DOC_SPEC ADD (CONSTRAINT fk_CMPS_DOC_SPEC6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE CMPS_GRAPH_ELE ADD (CONSTRAINT fk_CMPS_GRAPH_ELE1 FOREIGN KEY (CELL_S) REFERENCES CELL (CELL_S)); ALTER TABLE CMPS_GRAPH_ELE ADD (CONSTRAINT fk_CMPS_GRAPH_ELE2 FOREIGN KEY (GRAPH_ELE_CMPN_S) REFERENCES CMPS_GRAPH_ELE (CMPS_GRAPH_ELE_S)); ALTER TABLE CNGRS_LSA ADD (CONSTRAINT fk_CNGRS_LSA1 FOREIGN KEY (R_EAST_OR_WEST_NM) REFERENCES R_EAST_OR_WEST (R_EAST_OR_WEST_NM)); ALTER TABLE CNGRS_LSA ADD (CONSTRAINT fk_CNGRS_LSA2 FOREIGN KEY (R_NRTH_OR_SOUTH_KD) REFERENCES R_NRTH_OR_SOUTH (R_NRTH_OR_SOUTH_KD)); ALTER TABLE COILED_TBG_REEL ADD (CONSTRAINT fk_COILED_TBG_REEL1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE COILED_TBG_REEL ADD (CONSTRAINT fk_COILED_TBG_REEL2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE COILED_TBG_SECT ADD (CONSTRAINT fk_COILED_TBG_SECT1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE COILED_TBG_SECT ADD (CONSTRAINT fk_COILED_TBG_SECT2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE COILED_TBG_UNT ADD (CONSTRAINT fk_COILED_TBG_UNT1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE COILED_TBG_UNT ADD (CONSTRAINT fk_COILED_TBG_UNT2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE COILED_TUBING ADD (CONSTRAINT fk_COILED_TUBING1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE COILED_TUBING ADD (CONSTRAINT fk_COILED_TUBING2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE COLOR_PALETTE ADD (CONSTRAINT fk_COLOR_PALETTE1 FOREIGN KEY (IMAGE_PALET_TY_ID) REFERENCES IMAGE_PALET_TY (IMAGE_PALET_TY_ID)); ALTER TABLE COLOR_PALETTE ADD (CONSTRAINT fk_COLOR_PALETTE2 FOREIGN KEY (SYMBOL_LIBRARY_ID) REFERENCES SYMBOL_LIBRARY (SYMBOL_LIBRARY_ID)); ALTER TABLE CONTRACTUAL_OBL ADD (CONSTRAINT fk_CONTRACTUAL_OBL1 FOREIGN KEY (R_CONTRACT_OBL_KD) REFERENCES R_CONTRACT_OBL (R_CONTRACT_OBL_KD)); ALTER TABLE CONTRACTUAL_OBL ADD (CONSTRAINT fk_CONTRACTUAL_OBL2 FOREIGN KEY (R_OBL_FREQ_NAME) REFERENCES R_OBL_FREQ (R_OBL_FREQ_NAME)); ALTER TABLE CONTRACT_ACT_TY ADD (CONSTRAINT fk_CONTRACT_ACT_TY1 FOREIGN KEY (CONTRACTUAL_OBL_S) REFERENCES CONTRACTUAL_OBL (CONTRACTUAL_OBL_S)); ALTER TABLE CONTRACT_ACT_TY ADD (CONSTRAINT fk_CONTRACT_ACT_TY2 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE CONTRACT_ALIAS ADD (CONSTRAINT fk_CONTRACT_ALIAS1 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE CONTRACT_CLAUSE ADD (CONSTRAINT fk_CONTRACT_CLAUSE1 FOREIGN KEY (AMEND_CTRT_CLSE_S) REFERENCES CONTRACT_CLAUSE (CONTRACT_CLAUSE_S)); ALTER TABLE CONTRACT_CLAUSE ADD (CONSTRAINT fk_CONTRACT_CLAUSE2 FOREIGN KEY (CTRT_CLSE_SET_S) REFERENCES CTRT_CLSE_SET (CTRT_CLSE_SET_S)); ALTER TABLE CONTRACT_CLAUSE ADD (CONSTRAINT fk_CONTRACT_CLAUSE3 FOREIGN KEY (R_CLSE_AMND_RSN_NM) REFERENCES R_CLSE_AMND_RSN (R_CLSE_AMND_RSN_NM)); ALTER TABLE CONTRACT_CLAUSE ADD (CONSTRAINT fk_CONTRACT_CLAUSE4 FOREIGN KEY (R_CONTRACT_CLSE_KD) REFERENCES R_CONTRACT_CLSE (R_CONTRACT_CLSE_KD)); ALTER TABLE CONTRACT_DSGN ADD (CONSTRAINT fk_CONTRACT_DSGN1 FOREIGN KEY (AMOUNT_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE CONTRACT_DSGN ADD (CONSTRAINT fk_CONTRACT_DSGN2 FOREIGN KEY (BSASC_ROLE) REFERENCES R_CONTRACT_DSGN (R_CONTRACT_DSGN_KD)); ALTER TABLE CONTRACT_DSGN ADD (CONSTRAINT fk_CONTRACT_DSGN3 FOREIGN KEY (BSASC_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE CONTRACT_DSGN ADD (CONSTRAINT fk_CONTRACT_DSGN4 FOREIGN KEY (CONTRACTUAL_OBL_S) REFERENCES CONTRACTUAL_OBL (CONTRACTUAL_OBL_S)); ALTER TABLE CONTRACT_DSGN ADD (CONSTRAINT fk_CONTRACT_DSGN5 FOREIGN KEY (DEPOSITORY_DSGN_S) REFERENCES CONTRACT_DSGN (CONTRACT_DSGN_S)); ALTER TABLE CONTRACT_DSGN ADD (CONSTRAINT fk_CONTRACT_DSGN6 FOREIGN KEY (KIND) REFERENCES R_INTEREST_DSGN (KIND)); ALTER TABLE CONTRACT_DSGN ADD (CONSTRAINT fk_CONTRACT_DSGN7 FOREIGN KEY (R_HOLD_OR_PAY_KIND) REFERENCES R_HOLD_OR_PAY (R_HOLD_OR_PAY_KIND)); ALTER TABLE CONTRACT_REF ADD (CONSTRAINT fk_CONTRACT_REF1 FOREIGN KEY (R_CTRT_REF_USE_NM) REFERENCES R_CTRT_REF_USE (R_CTRT_REF_USE_NM)); ALTER TABLE CONTRACT_REMARK ADD (CONSTRAINT fk_CONTRACT_REMARK1 FOREIGN KEY (BSASC_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE CONTRACT_STATUS ADD (CONSTRAINT fk_CONTRACT_STATUS1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CONTRACT_STATUS ADD (CONSTRAINT fk_CONTRACT_STATUS2 FOREIGN KEY (R_CONTRACT_STA_NM) REFERENCES R_CONTRACT_STA (R_CONTRACT_STA_NM)); ALTER TABLE CONTRACT_STATUS ADD (CONSTRAINT fk_CONTRACT_STATUS3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE COORDINATE_SYS ADD (CONSTRAINT fk_COORDINATE_SYS1 FOREIGN KEY (GEODETIC_DATUM_ID) REFERENCES GEODETIC_DATUM (GEODETIC_DATUM_ID)); ALTER TABLE COORDINATE_SYS ADD (CONSTRAINT fk_COORDINATE_SYS2 FOREIGN KEY (PRIME_MERIDIAN_ID) REFERENCES PRIME_MERIDIAN (PRIME_MERIDIAN_ID)); ALTER TABLE COORDINATE_SYS ADD (CONSTRAINT fk_COORDINATE_SYS3 FOREIGN KEY (R_AXIS_ORNT_KIND) REFERENCES R_AXIS_ORNT (R_AXIS_ORNT_KIND)); ALTER TABLE COORDINATE_SYS ADD (CONSTRAINT fk_COORDINATE_SYS4 FOREIGN KEY (R_CORD_SYS_CSTR_NM) REFERENCES R_CORD_SYS_CSTR (R_CORD_SYS_CSTR_NM)); ALTER TABLE COORDINATE_SYS ADD (CONSTRAINT fk_COORDINATE_SYS5 FOREIGN KEY (R_DISPLAY_ORNT) REFERENCES R_DISPLAY_ORNT (NAME)); ALTER TABLE COORDINATE_SYS ADD (CONSTRAINT fk_COORDINATE_SYS6 FOREIGN KEY (R_MAP_PROJ_KIND) REFERENCES R_MAP_PROJ (R_MAP_PROJ_KIND)); ALTER TABLE COORDINATE_SYS ADD (CONSTRAINT fk_COORDINATE_SYS7 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE COORDINATE_SYS ADD (CONSTRAINT fk_COORDINATE_SYS8 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE COORDINATE_SYS ADD (CONSTRAINT fk_COORDINATE_SYS9 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE COORDINATE_SYS ADD (CONSTRAINT fk_COORDINATE_SYS10 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE COORDINATE_TRFM ADD (CONSTRAINT fk_COORDINATE_TRFM1 FOREIGN KEY (CORD_TRFM_MTH_ID) REFERENCES CORD_TRFM_MTH (CORD_TRFM_MTH_ID)); ALTER TABLE COORDINATE_TRFM ADD (CONSTRAINT fk_COORDINATE_TRFM2 FOREIGN KEY (R_TRFM_CSTR_NAME) REFERENCES R_TRFM_CSTR (R_TRFM_CSTR_NAME)); ALTER TABLE COORDINATE_TRFM ADD (CONSTRAINT fk_COORDINATE_TRFM3 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE COORDINATE_TRFM ADD (CONSTRAINT fk_COORDINATE_TRFM4 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE COORDINATE_TRFM ADD (CONSTRAINT fk_COORDINATE_TRFM5 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE COO_AGREEMENT ADD (CONSTRAINT fk_COO_AGREEMENT1 FOREIGN KEY (BSASC_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE COO_AGREEMENT ADD (CONSTRAINT fk_COO_AGREEMENT2 FOREIGN KEY (CMPS_DOC_SPEC_S) REFERENCES CMPS_DOC_SPEC (CMPS_DOC_SPEC_S)); ALTER TABLE COO_AGREEMENT ADD (CONSTRAINT fk_COO_AGREEMENT3 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE COO_AGREEMENT ADD (CONSTRAINT fk_COO_AGREEMENT4 FOREIGN KEY (INFORMATION_CNTN_S) REFERENCES DATA_COLLECTION (DATA_COLLECTION_S)); ALTER TABLE COO_AGREEMENT ADD (CONSTRAINT fk_COO_AGREEMENT5 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE COO_AGREEMENT ADD (CONSTRAINT fk_COO_AGREEMENT6 FOREIGN KEY (TYP_DOC_SPEC_ID) REFERENCES TYP_DOC_SPEC (TYP_DOC_SPEC_ID)); ALTER TABLE CORD_SYS_ALIAS ADD (CONSTRAINT fk_CORD_SYS_ALIAS1 FOREIGN KEY (COORDINATE_SYS_ID) REFERENCES COORDINATE_SYS (COORDINATE_SYS_ID)); ALTER TABLE CORD_SYS_ALIAS ADD (CONSTRAINT fk_CORD_SYS_ALIAS2 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE CORD_SYS_AXIS ADD (CONSTRAINT fk_CORD_SYS_AXIS1 FOREIGN KEY (CORD_SYS_ID) REFERENCES COORDINATE_SYS (COORDINATE_SYS_ID)); ALTER TABLE CORD_SYS_AXIS ADD (CONSTRAINT fk_CORD_SYS_AXIS2 FOREIGN KEY (R_AXIS_ORNT_KIND) REFERENCES R_AXIS_ORNT (R_AXIS_ORNT_KIND)); ALTER TABLE CORD_SYS_AXIS ADD (CONSTRAINT fk_CORD_SYS_AXIS3 FOREIGN KEY (R_PROPERTY_TYPE_NM) REFERENCES R_QUANTITY_PTY (R_PROPERTY_TYPE_NM)); ALTER TABLE CORD_SYS_AXIS ADD (CONSTRAINT fk_CORD_SYS_AXIS4 FOREIGN KEY (R_VAXIS_ORNT_NAME) REFERENCES R_VAXIS_ORNT (R_VAXIS_ORNT_NAME)); ALTER TABLE CORD_SYS_AXIS ADD (CONSTRAINT fk_CORD_SYS_AXIS5 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE CORD_SYS_AXIS ADD (CONSTRAINT fk_CORD_SYS_AXIS6 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE CORD_SYS_AXIS ADD (CONSTRAINT fk_CORD_SYS_AXIS7 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE CORD_TRFM_ACT ADD (CONSTRAINT fk_CORD_TRFM_ACT1 FOREIGN KEY (APP_CORD_TRFM_S) REFERENCES APP_CORD_TRFM (APP_CORD_TRFM_S)); ALTER TABLE CORD_TRFM_ACT ADD (CONSTRAINT fk_CORD_TRFM_ACT2 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE CORD_TRFM_ACT ADD (CONSTRAINT fk_CORD_TRFM_ACT3 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CORD_TRFM_ACT ADD (CONSTRAINT fk_CORD_TRFM_ACT4 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE CORD_TRFM_ACT ADD (CONSTRAINT fk_CORD_TRFM_ACT5 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE CORD_TRFM_ACT ADD (CONSTRAINT fk_CORD_TRFM_ACT6 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE CORD_TRFM_ACT ADD (CONSTRAINT fk_CORD_TRFM_ACT7 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE CORD_TRFM_MTH ADD (CONSTRAINT fk_CORD_TRFM_MTH1 FOREIGN KEY (R_CORD_TRFM_KIND) REFERENCES R_CORD_TRFM (R_CORD_TRFM_KIND)); ALTER TABLE CORD_TRFM_MTH ADD (CONSTRAINT fk_CORD_TRFM_MTH2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE CORD_TRFM_MTH ADD (CONSTRAINT fk_CORD_TRFM_MTH3 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE CORD_TRFM_MTH ADD (CONSTRAINT fk_CORD_TRFM_MTH4 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE CORD_TRFM_PAR ADD (CONSTRAINT fk_CORD_TRFM_PAR1 FOREIGN KEY (CORD_TRFM_MTH_ID) REFERENCES CORD_TRFM_MTH (CORD_TRFM_MTH_ID)); ALTER TABLE CORD_TRFM_PAR ADD (CONSTRAINT fk_CORD_TRFM_PAR2 FOREIGN KEY (R_CORD_TRFM_PAR_NM) REFERENCES R_CORD_TRFM_PAR (R_CORD_TRFM_PAR_NM)); ALTER TABLE CORD_TRFM_PAR ADD (CONSTRAINT fk_CORD_TRFM_PAR3 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE CORD_TRFM_PAR ADD (CONSTRAINT fk_CORD_TRFM_PAR4 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE CORD_TRFM_PAR ADD (CONSTRAINT fk_CORD_TRFM_PAR5 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE CORD_TRFM_VAL ADD (CONSTRAINT fk_CORD_TRFM_VAL1 FOREIGN KEY (COORDINATE_TRFM_ID) REFERENCES COORDINATE_TRFM (COORDINATE_TRFM_ID)); ALTER TABLE CORD_TRFM_VAL ADD (CONSTRAINT fk_CORD_TRFM_VAL2 FOREIGN KEY (CORD_TRFM_PAR_S) REFERENCES CORD_TRFM_PAR (CORD_TRFM_PAR_S)); ALTER TABLE CORD_TRFM_VAL ADD (CONSTRAINT fk_CORD_TRFM_VAL3 FOREIGN KEY (QUANTITY_VALUE_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CORD_TRFM_VAL ADD (CONSTRAINT fk_CORD_TRFM_VAL4 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE CORD_TRFM_VAL ADD (CONSTRAINT fk_CORD_TRFM_VAL5 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE CORD_TRFM_VAL ADD (CONSTRAINT fk_CORD_TRFM_VAL6 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE CORE ADD (CONSTRAINT fk_CORE1 FOREIGN KEY (BOTTOM_DEPTH_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CORE ADD (CONSTRAINT fk_CORE2 FOREIGN KEY (BRHL_GNR_RUN_S) REFERENCES BRHL_GNR_RUN (BRHL_GNR_RUN_S)); ALTER TABLE CORE ADD (CONSTRAINT fk_CORE3 FOREIGN KEY (KH_90_DEGREE_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CORE ADD (CONSTRAINT fk_CORE4 FOREIGN KEY (KH_MAX_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CORE ADD (CONSTRAINT fk_CORE5 FOREIGN KEY (KIND) REFERENCES R_CORE (KIND)); ALTER TABLE CORE ADD (CONSTRAINT fk_CORE6 FOREIGN KEY (K_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CORE ADD (CONSTRAINT fk_CORE7 FOREIGN KEY (R_DIAMETER_NAME) REFERENCES R_DIAMETER (R_DIAMETER_NAME)); ALTER TABLE CORE ADD (CONSTRAINT fk_CORE8 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE CORE ADD (CONSTRAINT fk_CORE9 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE CORE ADD (CONSTRAINT fk_CORE10 FOREIGN KEY (TOP_DEPTH_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CORE ADD (CONSTRAINT fk_CORE11 FOREIGN KEY (WRLN_LOG_PASS_S) REFERENCES WRLN_LOG_PASS (WRLN_LOG_PASS_S)); ALTER TABLE CTRT_CLSE_IT ADD (CONSTRAINT fk_CTRT_CLSE_IT1 FOREIGN KEY (CONTRACT_CLAUSE_S) REFERENCES CONTRACT_CLAUSE (CONTRACT_CLAUSE_S)); ALTER TABLE CTRT_CLSE_IT ADD (CONSTRAINT fk_CTRT_CLSE_IT2 FOREIGN KEY (ITEM_QUANTITY_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CTRT_CLSE_IT ADD (CONSTRAINT fk_CTRT_CLSE_IT3 FOREIGN KEY (MONETARY_VALUE_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE CTRT_CLSE_IT ADD (CONSTRAINT fk_CTRT_CLSE_IT4 FOREIGN KEY (R_CTRT_CLSE_IT_KD) REFERENCES R_CTRT_CLSE_IT (R_CTRT_CLSE_IT_KD)); ALTER TABLE CTRT_CLSE_SET ADD (CONSTRAINT fk_CTRT_CLSE_SET1 FOREIGN KEY (CMPS_DOC_SPEC_S) REFERENCES CMPS_DOC_SPEC (CMPS_DOC_SPEC_S)); ALTER TABLE CTRT_CLSE_SET ADD (CONSTRAINT fk_CTRT_CLSE_SET2 FOREIGN KEY (INFORMATION_CNTN_S) REFERENCES DATA_COLLECTION (DATA_COLLECTION_S)); ALTER TABLE CTRT_CLSE_SET ADD (CONSTRAINT fk_CTRT_CLSE_SET3 FOREIGN KEY (TYP_DOC_SPEC_ID) REFERENCES TYP_DOC_SPEC (TYP_DOC_SPEC_ID)); ALTER TABLE CTRT_PROC_OPR ADD (CONSTRAINT fk_CTRT_PROC_OPR1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE CTRT_PROC_OPR ADD (CONSTRAINT fk_CTRT_PROC_OPR2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CTRT_PROC_OPR ADD (CONSTRAINT fk_CTRT_PROC_OPR3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE CTRT_PROC_OPR ADD (CONSTRAINT fk_CTRT_PROC_OPR4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE CTRT_PROC_OPR ADD (CONSTRAINT fk_CTRT_PROC_OPR5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE CTRT_PROC_OPR ADD (CONSTRAINT fk_CTRT_PROC_OPR6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE CURVE_FIT_ACT ADD (CONSTRAINT fk_CURVE_FIT_ACT1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE CURVE_FIT_ACT ADD (CONSTRAINT fk_CURVE_FIT_ACT2 FOREIGN KEY (DIAGRAM_SPEC_S) REFERENCES DIAGRAM_SPEC (DIAGRAM_SPEC_S)); ALTER TABLE CURVE_FIT_ACT ADD (CONSTRAINT fk_CURVE_FIT_ACT3 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE CURVE_FIT_ACT ADD (CONSTRAINT fk_CURVE_FIT_ACT4 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE CURVE_FIT_ACT ADD (CONSTRAINT fk_CURVE_FIT_ACT5 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE CURVE_FIT_ACT ADD (CONSTRAINT fk_CURVE_FIT_ACT6 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE CURVE_FIT_ACT ADD (CONSTRAINT fk_CURVE_FIT_ACT7 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE DAE_APP_PREFER ADD (CONSTRAINT fk_DAE_APP_PREFER1 FOREIGN KEY (APPLICATION_S) REFERENCES DAE_APPLICATION (DAE_APPLICATION_S)); ALTER TABLE DAE_APP_PREFER ADD (CONSTRAINT fk_DAE_APP_PREFER2 FOREIGN KEY (OWNER_S) REFERENCES DAE_USER (DAE_USER_S)); ALTER TABLE DAE_ATR_ATHR ADD (CONSTRAINT fk_DAE_ATR_ATHR1 FOREIGN KEY (ATTRIBUTE_DEF_S) REFERENCES DAE_ATR_DEF (DAE_ATR_DEF_S)); ALTER TABLE DAE_ATR_ATHR ADD (CONSTRAINT fk_DAE_ATR_ATHR2 FOREIGN KEY (GRANTEE_S) REFERENCES DAE_USER (DAE_USER_S)); ALTER TABLE DAE_ATR_ATHR ADD (CONSTRAINT fk_DAE_ATR_ATHR3 FOREIGN KEY (GRANTOR_S) REFERENCES DAE_USER (DAE_USER_S)); ALTER TABLE DAE_ATR_DEF ADD (CONSTRAINT fk_DAE_ATR_DEF1 FOREIGN KEY (INVERTED_ATTR_S) REFERENCES DAE_ATR_DEF (DAE_ATR_DEF_S)); ALTER TABLE DAE_ATR_DEF ADD (CONSTRAINT fk_DAE_ATR_DEF2 FOREIGN KEY (PARENT_ENTITY_S) REFERENCES DAE_ENTITY_DEF (DAE_ENTITY_DEF_S)); ALTER TABLE DAE_DATA_STORE ADD (CONSTRAINT fk_DAE_DATA_STORE1 FOREIGN KEY (OWNER_S) REFERENCES DAE_USER (DAE_USER_S)); ALTER TABLE DAE_DATA_STORE ADD (CONSTRAINT fk_DAE_DATA_STORE2 FOREIGN KEY (PARENT_S) REFERENCES DAE_DATA_STORE (DAE_DATA_STORE_S)); ALTER TABLE DAE_DATA_STORE ADD (CONSTRAINT fk_DAE_DATA_STORE3 FOREIGN KEY (SERVER_S) REFERENCES DAE_SERVER (DAE_SERVER_S)); ALTER TABLE DAE_DIMENSION ADD (CONSTRAINT fk_DAE_DIMENSION1 FOREIGN KEY (GRID_1D_S) REFERENCES GRID_1D (GRID_1D_S)); ALTER TABLE DAE_DIMENSION ADD (CONSTRAINT fk_DAE_DIMENSION2 FOREIGN KEY (PARENT_FRAME_S) REFERENCES DAE_FRAME (DAE_FRAME_S)); ALTER TABLE DAE_DSTORE_ROOT ADD (CONSTRAINT fk_DAE_DSTORE_ROOT1 FOREIGN KEY (DEFINING_DSC_S) REFERENCES DAE_DS_HEADER (DAE_DS_HEADER_S)); ALTER TABLE DAE_DS_HEADER ADD (CONSTRAINT fk_DAE_DS_HEADER1 FOREIGN KEY (IMPORTED_USING_S) REFERENCES DAE_IMPORT_DSC (DAE_IMPORT_DSC_S)); ALTER TABLE DAE_ENTITY_ATHR ADD (CONSTRAINT fk_DAE_ENTITY_ATHR1 FOREIGN KEY (ENTITY_DEF_S) REFERENCES DAE_ENTITY_DEF (DAE_ENTITY_DEF_S)); ALTER TABLE DAE_ENTITY_ATHR ADD (CONSTRAINT fk_DAE_ENTITY_ATHR2 FOREIGN KEY (GRANTEE_S) REFERENCES DAE_USER (DAE_USER_S)); ALTER TABLE DAE_ENTITY_ATHR ADD (CONSTRAINT fk_DAE_ENTITY_ATHR3 FOREIGN KEY (GRANTOR_S) REFERENCES DAE_USER (DAE_USER_S)); ALTER TABLE DAE_ENTITY_DEF ADD (CONSTRAINT fk_DAE_ENTITY_DEF1 FOREIGN KEY (OWNING_DATASTORE_S) REFERENCES DAE_DATA_STORE (DAE_DATA_STORE_S)); ALTER TABLE DAE_EXPORT_DSC ADD (CONSTRAINT fk_DAE_EXPORT_DSC1 FOREIGN KEY (EXCHANGE_SET_S) REFERENCES DAE_DS_HEADER (DAE_DS_HEADER_S)); ALTER TABLE DAE_EXPORT_DSC ADD (CONSTRAINT fk_DAE_EXPORT_DSC2 FOREIGN KEY (EXTRACT_FROM_S) REFERENCES DAE_DS_HEADER (DAE_DS_HEADER_S)); ALTER TABLE DAE_EXPORT_DSC ADD (CONSTRAINT fk_DAE_EXPORT_DSC3 FOREIGN KEY (PROFILE_S) REFERENCES DAE_EXCH_PROF (DAE_EXCH_PROF_S)); ALTER TABLE DAE_FRAME ADD (CONSTRAINT fk_DAE_FRAME1 FOREIGN KEY (COORDINATE_SYS_ID) REFERENCES COORDINATE_SYS (COORDINATE_SYS_ID)); ALTER TABLE DAE_IMPORT_DSC ADD (CONSTRAINT fk_DAE_IMPORT_DSC1 FOREIGN KEY (DESTINATION_S) REFERENCES DAE_DS_HEADER (DAE_DS_HEADER_S)); ALTER TABLE DAE_IMPORT_DSC ADD (CONSTRAINT fk_DAE_IMPORT_DSC2 FOREIGN KEY (PROFILE_S) REFERENCES DAE_EXCH_PROF (DAE_EXCH_PROF_S)); ALTER TABLE DAE_LEAF_FRAME ADD (CONSTRAINT fk_DAE_LEAF_FRAME1 FOREIGN KEY (PARENT_FRAME_S) REFERENCES DAE_FRAME (DAE_FRAME_S)); ALTER TABLE DAE_LEAF_FRAME ADD (CONSTRAINT fk_DAE_LEAF_FRAME2 FOREIGN KEY (PROPERTY_AXIS_S) REFERENCES CORD_SYS_AXIS (CORD_SYS_AXIS_S)); ALTER TABLE DAE_LEAF_FRAME ADD (CONSTRAINT fk_DAE_LEAF_FRAME3 FOREIGN KEY (PROPERTY_TYPE_S) REFERENCES R_PROPERTY_KIND (R_PROPERTY_KIND_S)); ALTER TABLE DAE_LEAF_FRAME ADD (CONSTRAINT fk_DAE_LEAF_FRAME4 FOREIGN KEY (UNIT_ACRONYM) REFERENCES R_UOM (ACRONYM)); ALTER TABLE DAE_ROLE_ATHR ADD (CONSTRAINT fk_DAE_ROLE_ATHR1 FOREIGN KEY (GRANTEE_S) REFERENCES DAE_USER (DAE_USER_S)); ALTER TABLE DAE_ROLE_ATHR ADD (CONSTRAINT fk_DAE_ROLE_ATHR2 FOREIGN KEY (GRANTOR_S) REFERENCES DAE_USER (DAE_USER_S)); ALTER TABLE DAE_ROLE_ATHR ADD (CONSTRAINT fk_DAE_ROLE_ATHR3 FOREIGN KEY (USER_ROLE_S) REFERENCES DAE_ROLE (DAE_ROLE_S)); ALTER TABLE DAE_ROLE_PRIV ADD (CONSTRAINT fk_DAE_ROLE_PRIV1 FOREIGN KEY (ATTRIBUTE_DEF_S) REFERENCES DAE_ATR_DEF (DAE_ATR_DEF_S)); ALTER TABLE DAE_ROLE_PRIV ADD (CONSTRAINT fk_DAE_ROLE_PRIV2 FOREIGN KEY (DAE_ROLE_S) REFERENCES DAE_ROLE (DAE_ROLE_S)); ALTER TABLE DAE_ROLE_PRIV ADD (CONSTRAINT fk_DAE_ROLE_PRIV3 FOREIGN KEY (ENTITY_DEF_S) REFERENCES DAE_ENTITY_DEF (DAE_ENTITY_DEF_S)); ALTER TABLE DAE_SWTCH_RULE ADD (CONSTRAINT fk_DAE_SWTCH_RULE1 FOREIGN KEY (PARENT_DATASTORE_S) REFERENCES DAE_DATA_STORE (DAE_DATA_STORE_S)); ALTER TABLE DAE_SWTCH_RULE ADD (CONSTRAINT fk_DAE_SWTCH_RULE2 FOREIGN KEY (PARENT_ENTITY_S) REFERENCES DAE_ENTITY_DEF (DAE_ENTITY_DEF_S)); ALTER TABLE DAMAGE_AREA ADD (CONSTRAINT fk_DAMAGE_AREA1 FOREIGN KEY (INCDT_OF_NCOM_S) REFERENCES INCDT_OF_NCOM (INCDT_OF_NCOM_S)); ALTER TABLE DATA_COLLECTION ADD (CONSTRAINT fk_DATA_COLLECTION1 FOREIGN KEY (BSASC_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE DATA_COLLECTION ADD (CONSTRAINT fk_DATA_COLLECTION2 FOREIGN KEY (PROCESS_PAR_S) REFERENCES PROCESS_PAR (PROCESS_PAR_S)); ALTER TABLE DATA_COLLECTION ADD (CONSTRAINT fk_DATA_COLLECTION3 FOREIGN KEY (R_DATA_COLL_TY_NM) REFERENCES R_DATA_COLL_TY (R_DATA_COLL_TY_NM)); ALTER TABLE DECLINE_ANAL ADD (CONSTRAINT fk_DECLINE_ANAL1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE DECLINE_ANAL ADD (CONSTRAINT fk_DECLINE_ANAL2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE DECLINE_ANAL ADD (CONSTRAINT fk_DECLINE_ANAL3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE DECLINE_ANAL ADD (CONSTRAINT fk_DECLINE_ANAL4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE DECLINE_ANAL ADD (CONSTRAINT fk_DECLINE_ANAL5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE DECLINE_ANAL ADD (CONSTRAINT fk_DECLINE_ANAL6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE DERV_INT_MKUP ADD (CONSTRAINT fk_DERV_INT_MKUP1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE DERV_INT_MKUP ADD (CONSTRAINT fk_DERV_INT_MKUP2 FOREIGN KEY (INTEREST_OF_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE DERV_INT_MKUP ADD (CONSTRAINT fk_DERV_INT_MKUP3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE DIAGRAM_SPEC ADD (CONSTRAINT fk_DIAGRAM_SPEC1 FOREIGN KEY (CMPS_DOC_SPEC_S) REFERENCES CMPS_DOC_SPEC (CMPS_DOC_SPEC_S)); ALTER TABLE DIAGRAM_SPEC ADD (CONSTRAINT fk_DIAGRAM_SPEC2 FOREIGN KEY (INFORMATION_CNTN_S) REFERENCES DATA_COLLECTION (DATA_COLLECTION_S)); ALTER TABLE DIAGRAM_SPEC ADD (CONSTRAINT fk_DIAGRAM_SPEC3 FOREIGN KEY (TYP_DOC_SPEC_ID) REFERENCES TYP_DOC_SPEC (TYP_DOC_SPEC_ID)); ALTER TABLE DIGITAL_STOR_FCL ADD (CONSTRAINT fk_DIGITAL_STOR_FCL1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE DIGITAL_STOR_FCL ADD (CONSTRAINT fk_DIGITAL_STOR_FCL2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE DIGITIZE_DOC ADD (CONSTRAINT fk_DIGITIZE_DOC1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE DIGITIZE_DOC ADD (CONSTRAINT fk_DIGITIZE_DOC2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE DIGITIZE_DOC ADD (CONSTRAINT fk_DIGITIZE_DOC3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE DIGITIZE_DOC ADD (CONSTRAINT fk_DIGITIZE_DOC4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE DIGITIZE_DOC ADD (CONSTRAINT fk_DIGITIZE_DOC5 FOREIGN KEY (SOURCE_DOCUMENT_S) REFERENCES DOCUMENT (DOCUMENT_S)); ALTER TABLE DIGITIZE_DOC ADD (CONSTRAINT fk_DIGITIZE_DOC6 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE DIGITIZE_DOC ADD (CONSTRAINT fk_DIGITIZE_DOC7 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE DIR_SRVY_ANAL ADD (CONSTRAINT fk_DIR_SRVY_ANAL1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE DIR_SRVY_ANAL ADD (CONSTRAINT fk_DIR_SRVY_ANAL2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE DIR_SRVY_ANAL ADD (CONSTRAINT fk_DIR_SRVY_ANAL3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE DIR_SRVY_ANAL ADD (CONSTRAINT fk_DIR_SRVY_ANAL4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE DIR_SRVY_ANAL ADD (CONSTRAINT fk_DIR_SRVY_ANAL5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE DIR_SRVY_ANAL ADD (CONSTRAINT fk_DIR_SRVY_ANAL6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE DISCOVERY_AREA ADD (CONSTRAINT fk_DISCOVERY_AREA1 FOREIGN KEY (R_DISC_AREA_KIND) REFERENCES R_DISC_AREA (R_DISC_AREA_KIND)); ALTER TABLE DISCOVERY_AREA ADD (CONSTRAINT fk_DISCOVERY_AREA2 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE DIVESTMENT_PKG ADD (CONSTRAINT fk_DIVESTMENT_PKG1 FOREIGN KEY (PART_OF_S) REFERENCES DIVESTMENT_PKG (DIVESTMENT_PKG_S)); ALTER TABLE DIVESTMENT_PKG ADD (CONSTRAINT fk_DIVESTMENT_PKG2 FOREIGN KEY (R_SALE_KIND) REFERENCES R_SALE (R_SALE_KIND)); ALTER TABLE DOCUMENT ADD (CONSTRAINT fk_DOCUMENT1 FOREIGN KEY (DIGITIZE_DOC_S) REFERENCES DIGITIZE_DOC (DIGITIZE_DOC_S)); ALTER TABLE DOCUMENT ADD (CONSTRAINT fk_DOCUMENT2 FOREIGN KEY (RENDER_DOCUMENT_S) REFERENCES RENDER_DOCUMENT (RENDER_DOCUMENT_S)); ALTER TABLE DOCUMENT ADD (CONSTRAINT fk_DOCUMENT3 FOREIGN KEY (R_DIGITAL_FMT_KIND) REFERENCES R_DIGITAL_FMT (R_DIGITAL_FMT_KIND)); ALTER TABLE DOCUMENT ADD (CONSTRAINT fk_DOCUMENT4 FOREIGN KEY (R_HARDCOPY_DOC_NM) REFERENCES R_HARDCOPY_DOC (R_HARDCOPY_DOC_NM)); ALTER TABLE DOCUMENT ADD (CONSTRAINT fk_DOCUMENT5 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE DOCUMENT_CIRC ADD (CONSTRAINT fk_DOCUMENT_CIRC1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE DOCUMENT_CIRC ADD (CONSTRAINT fk_DOCUMENT_CIRC2 FOREIGN KEY (DOCUMENT_S) REFERENCES DOCUMENT (DOCUMENT_S)); ALTER TABLE DOCUMENT_CIRC ADD (CONSTRAINT fk_DOCUMENT_CIRC3 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE DOCUMENT_CIRC ADD (CONSTRAINT fk_DOCUMENT_CIRC4 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE DOCUMENT_CIRC ADD (CONSTRAINT fk_DOCUMENT_CIRC5 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE DOCUMENT_CIRC ADD (CONSTRAINT fk_DOCUMENT_CIRC6 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE DOCUMENT_CIRC ADD (CONSTRAINT fk_DOCUMENT_CIRC7 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE DOC_SPEC_CLCLSN ADD (CONSTRAINT fk_DOC_SPEC_CLCLSN1 FOREIGN KEY (BE_CLASSIFIED_AS_S) REFERENCES DOC_SPEC_CLS (DOC_SPEC_CLS_S)); ALTER TABLE DOC_SPEC_CLCLSN ADD (CONSTRAINT fk_DOC_SPEC_CLCLSN2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE DOC_SPEC_CLCLSN ADD (CONSTRAINT fk_DOC_SPEC_CLCLSN3 FOREIGN KEY (HAVE_AS_A_MEMBER_S) REFERENCES DOC_SPEC_CLS (DOC_SPEC_CLS_S)); ALTER TABLE DOC_SPEC_CLCLSN ADD (CONSTRAINT fk_DOC_SPEC_CLCLSN4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE DOC_SPEC_CLCLSN ADD (CONSTRAINT fk_DOC_SPEC_CLCLSN5 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE DOC_SPEC_CLCLSN ADD (CONSTRAINT fk_DOC_SPEC_CLCLSN6 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE DOC_SPEC_CLCLSN ADD (CONSTRAINT fk_DOC_SPEC_CLCLSN7 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE DOC_SPEC_CLS ADD (CONSTRAINT fk_DOC_SPEC_CLS1 FOREIGN KEY (CLASSIFICATION_SYS) REFERENCES CLSN_SYS (CLSN_SYS_NAME)); ALTER TABLE DOC_SPEC_CLS ADD (CONSTRAINT fk_DOC_SPEC_CLS2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE DOC_SPEC_CLS ADD (CONSTRAINT fk_DOC_SPEC_CLS3 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE DOC_SPEC_CLS ADD (CONSTRAINT fk_DOC_SPEC_CLS4 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE DOC_SPEC_CLSN ADD (CONSTRAINT fk_DOC_SPEC_CLSN1 FOREIGN KEY (DOC_SPEC_CLS_S) REFERENCES DOC_SPEC_CLS (DOC_SPEC_CLS_S)); ALTER TABLE DOC_SPEC_CLSN ADD (CONSTRAINT fk_DOC_SPEC_CLSN2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE DOC_SPEC_CLSN ADD (CONSTRAINT fk_DOC_SPEC_CLSN3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE DOC_SPEC_PLACE ADD (CONSTRAINT fk_DOC_SPEC_PLACE1 FOREIGN KEY (AXIS_ROT_ANGL_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE DOMINION_LSA ADD (CONSTRAINT fk_DOMINION_LSA1 FOREIGN KEY (R_EAST_OR_WEST_NM) REFERENCES R_EAST_OR_WEST (R_EAST_OR_WEST_NM)); ALTER TABLE DRILLING_FCL ADD (CONSTRAINT fk_DRILLING_FCL1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE DRILLING_FCL ADD (CONSTRAINT fk_DRILLING_FCL2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE DRILLING_KICK ADD (CONSTRAINT fk_DRILLING_KICK1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE DRILLING_KICK ADD (CONSTRAINT fk_DRILLING_KICK2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE DRILLING_KICK ADD (CONSTRAINT fk_DRILLING_KICK3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE DRILLING_KICK ADD (CONSTRAINT fk_DRILLING_KICK4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE DRILLING_KICK ADD (CONSTRAINT fk_DRILLING_KICK5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE DRILLING_KICK ADD (CONSTRAINT fk_DRILLING_KICK6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE DRILLING_KICK ADD (CONSTRAINT fk_DRILLING_KICK7 FOREIGN KEY (WELLBORE_S) REFERENCES WELLBORE (WELLBORE_S)); ALTER TABLE DRILLING_KICK_FL ADD (CONSTRAINT fk_DRILLING_KICK_FL1 FOREIGN KEY (DRILLING_KICK_S) REFERENCES DRILLING_KICK (DRILLING_KICK_S)); ALTER TABLE DRILLING_KICK_FL ADD (CONSTRAINT fk_DRILLING_KICK_FL2 FOREIGN KEY (DRILLSTRING_S) REFERENCES WELLBORE_TUBULAR (WELLBORE_TUBULAR_S)); ALTER TABLE DRILLING_PERMIT ADD (CONSTRAINT fk_DRILLING_PERMIT1 FOREIGN KEY (CMPS_DOC_SPEC_S) REFERENCES CMPS_DOC_SPEC (CMPS_DOC_SPEC_S)); ALTER TABLE DRILLING_PERMIT ADD (CONSTRAINT fk_DRILLING_PERMIT2 FOREIGN KEY (INFORMATION_CNTN_S) REFERENCES DATA_COLLECTION (DATA_COLLECTION_S)); ALTER TABLE DRILLING_PERMIT ADD (CONSTRAINT fk_DRILLING_PERMIT3 FOREIGN KEY (ISSUED_BY_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE DRILLING_PERMIT ADD (CONSTRAINT fk_DRILLING_PERMIT4 FOREIGN KEY (TYP_DOC_SPEC_ID) REFERENCES TYP_DOC_SPEC (TYP_DOC_SPEC_ID)); ALTER TABLE DRILLING_RIG ADD (CONSTRAINT fk_DRILLING_RIG1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE DRILLING_RIG ADD (CONSTRAINT fk_DRILLING_RIG2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE DRILLSTEM_TEST ADD (CONSTRAINT fk_DRILLSTEM_TEST1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE DRILLSTEM_TEST ADD (CONSTRAINT fk_DRILLSTEM_TEST2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE DRILLSTEM_TEST ADD (CONSTRAINT fk_DRILLSTEM_TEST3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE DRILLSTEM_TEST ADD (CONSTRAINT fk_DRILLSTEM_TEST4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE DRILLSTEM_TEST ADD (CONSTRAINT fk_DRILLSTEM_TEST5 FOREIGN KEY (TEMPORARY_CMPL_S) REFERENCES BOREHOLE_CMPN (BOREHOLE_CMPN_S)); ALTER TABLE DRILLSTEM_TEST ADD (CONSTRAINT fk_DRILLSTEM_TEST6 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE DRILLSTEM_TEST ADD (CONSTRAINT fk_DRILLSTEM_TEST7 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE DRILLSTEM_TEST ADD (CONSTRAINT fk_DRILLSTEM_TEST8 FOREIGN KEY (WELLBORE_S) REFERENCES WELLBORE (WELLBORE_S)); ALTER TABLE DRILL_BOREHOLE ADD (CONSTRAINT fk_DRILL_BOREHOLE1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE DRILL_BOREHOLE ADD (CONSTRAINT fk_DRILL_BOREHOLE2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE DRILL_BOREHOLE ADD (CONSTRAINT fk_DRILL_BOREHOLE3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE DRILL_BOREHOLE ADD (CONSTRAINT fk_DRILL_BOREHOLE4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE DRILL_BOREHOLE ADD (CONSTRAINT fk_DRILL_BOREHOLE5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE DRILL_BOREHOLE ADD (CONSTRAINT fk_DRILL_BOREHOLE6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE DRILL_BOREHOLE ADD (CONSTRAINT fk_DRILL_BOREHOLE7 FOREIGN KEY (WELLBORE_S) REFERENCES WELLBORE (WELLBORE_S)); ALTER TABLE DRILL_CUT_SAM ADD (CONSTRAINT fk_DRILL_CUT_SAM1 FOREIGN KEY (BRHL_GNR_RUN_S) REFERENCES BRHL_GNR_RUN (BRHL_GNR_RUN_S)); ALTER TABLE DRILL_CUT_SAM ADD (CONSTRAINT fk_DRILL_CUT_SAM2 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE DRILL_CUT_SAM ADD (CONSTRAINT fk_DRILL_CUT_SAM3 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE DRL_DRCK_SYS ADD (CONSTRAINT fk_DRL_DRCK_SYS1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE DRL_DRCK_SYS ADD (CONSTRAINT fk_DRL_DRCK_SYS2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE DST_RECOVERY ADD (CONSTRAINT fk_DST_RECOVERY1 FOREIGN KEY (DRILLSTEM_TEST_S) REFERENCES DRILLSTEM_TEST (DRILLSTEM_TEST_S)); ALTER TABLE DST_RECOVERY ADD (CONSTRAINT fk_DST_RECOVERY2 FOREIGN KEY (RSVR_FL_SYS_S) REFERENCES RSVR_FL_SYS (RSVR_FL_SYS_S)); ALTER TABLE DYNAMIC_POS_SYS ADD (CONSTRAINT fk_DYNAMIC_POS_SYS1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE DYNAMIC_POS_SYS ADD (CONSTRAINT fk_DYNAMIC_POS_SYS2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE DYN_GRAPH_ELE ADD (CONSTRAINT fk_DYN_GRAPH_ELE1 FOREIGN KEY (CELL_S) REFERENCES CELL (CELL_S)); ALTER TABLE DYN_GRAPH_ELE ADD (CONSTRAINT fk_DYN_GRAPH_ELE2 FOREIGN KEY (GRAPH_ELE_CMPN_S) REFERENCES CMPS_GRAPH_ELE (CMPS_GRAPH_ELE_S)); ALTER TABLE DYN_GRAPH_ELE ADD (CONSTRAINT fk_DYN_GRAPH_ELE3 FOREIGN KEY (PREDICATE_TYPE_KD) REFERENCES PREDICATE_TYPE (PREDICATE_TYPE_KD)); ALTER TABLE EARTH_MODEL ADD (CONSTRAINT fk_EARTH_MODEL1 FOREIGN KEY (GEOSCIENCE_NTRP_S) REFERENCES GEOSCIENCE_NTRP (GEOSCIENCE_NTRP_S)); ALTER TABLE EARTH_POS_CMPS ADD (CONSTRAINT fk_EARTH_POS_CMPS1 FOREIGN KEY (GEOSCIENCE_NTRP_S) REFERENCES GEOSCIENCE_NTRP (GEOSCIENCE_NTRP_S)); ALTER TABLE EARTH_POS_CMPS ADD (CONSTRAINT fk_EARTH_POS_CMPS2 FOREIGN KEY (SYN_LOG_TRC_S) REFERENCES SYN_LOG_TRC (SYN_LOG_TRC_S)); ALTER TABLE EARTH_POS_EDG ADD (CONSTRAINT fk_EARTH_POS_EDG1 FOREIGN KEY (GEOSCIENCE_NTRP_S) REFERENCES GEOSCIENCE_NTRP (GEOSCIENCE_NTRP_S)); ALTER TABLE EARTH_POS_EDG ADD (CONSTRAINT fk_EARTH_POS_EDG2 FOREIGN KEY (ID_WHOLE_S) REFERENCES EARTH_POS_CMPS (EARTH_POS_CMPS_S)); ALTER TABLE EARTH_POS_EDG ADD (CONSTRAINT fk_EARTH_POS_EDG3 FOREIGN KEY (SEIS_GEOM_SET_S) REFERENCES SEIS_GEOM_SET (SEIS_GEOM_SET_S)); ALTER TABLE EARTH_POS_EDG ADD (CONSTRAINT fk_EARTH_POS_EDG4 FOREIGN KEY (SYN_LOG_TRC_S) REFERENCES SYN_LOG_TRC (SYN_LOG_TRC_S)); ALTER TABLE EARTH_POS_FACE ADD (CONSTRAINT fk_EARTH_POS_FACE1 FOREIGN KEY (GEOSCIENCE_NTRP_S) REFERENCES GEOSCIENCE_NTRP (GEOSCIENCE_NTRP_S)); ALTER TABLE EARTH_POS_FACE ADD (CONSTRAINT fk_EARTH_POS_FACE2 FOREIGN KEY (ID_WHOLE_S) REFERENCES EARTH_POS_CMPS (EARTH_POS_CMPS_S)); ALTER TABLE EARTH_POS_FACE ADD (CONSTRAINT fk_EARTH_POS_FACE3 FOREIGN KEY (SEIS_GEOM_SET_S) REFERENCES SEIS_GEOM_SET (SEIS_GEOM_SET_S)); ALTER TABLE EARTH_POS_FACE ADD (CONSTRAINT fk_EARTH_POS_FACE4 FOREIGN KEY (SYN_LOG_TRC_S) REFERENCES SYN_LOG_TRC (SYN_LOG_TRC_S)); ALTER TABLE EARTH_POS_RGN ADD (CONSTRAINT fk_EARTH_POS_RGN1 FOREIGN KEY (GEOSCIENCE_NTRP_S) REFERENCES GEOSCIENCE_NTRP (GEOSCIENCE_NTRP_S)); ALTER TABLE EARTH_POS_RGN ADD (CONSTRAINT fk_EARTH_POS_RGN2 FOREIGN KEY (ID_WHOLE_S) REFERENCES EARTH_POS_CMPS (EARTH_POS_CMPS_S)); ALTER TABLE EARTH_POS_RGN ADD (CONSTRAINT fk_EARTH_POS_RGN3 FOREIGN KEY (SEIS_GEOM_SET_S) REFERENCES SEIS_GEOM_SET (SEIS_GEOM_SET_S)); ALTER TABLE EARTH_POS_RGN ADD (CONSTRAINT fk_EARTH_POS_RGN4 FOREIGN KEY (SYN_LOG_TRC_S) REFERENCES SYN_LOG_TRC (SYN_LOG_TRC_S)); ALTER TABLE EARTH_POS_RING ADD (CONSTRAINT fk_EARTH_POS_RING1 FOREIGN KEY (GEOSCIENCE_NTRP_S) REFERENCES GEOSCIENCE_NTRP (GEOSCIENCE_NTRP_S)); ALTER TABLE EARTH_POS_RING ADD (CONSTRAINT fk_EARTH_POS_RING2 FOREIGN KEY (ID_WHOLE_S) REFERENCES EARTH_POS_CMPS (EARTH_POS_CMPS_S)); ALTER TABLE EARTH_POS_RING ADD (CONSTRAINT fk_EARTH_POS_RING3 FOREIGN KEY (SEIS_GEOM_SET_S) REFERENCES SEIS_GEOM_SET (SEIS_GEOM_SET_S)); ALTER TABLE EARTH_POS_RING ADD (CONSTRAINT fk_EARTH_POS_RING4 FOREIGN KEY (SYN_LOG_TRC_S) REFERENCES SYN_LOG_TRC (SYN_LOG_TRC_S)); ALTER TABLE EARTH_POS_SHL ADD (CONSTRAINT fk_EARTH_POS_SHL1 FOREIGN KEY (GEOSCIENCE_NTRP_S) REFERENCES GEOSCIENCE_NTRP (GEOSCIENCE_NTRP_S)); ALTER TABLE EARTH_POS_SHL ADD (CONSTRAINT fk_EARTH_POS_SHL2 FOREIGN KEY (ID_WHOLE_S) REFERENCES EARTH_POS_CMPS (EARTH_POS_CMPS_S)); ALTER TABLE EARTH_POS_SHL ADD (CONSTRAINT fk_EARTH_POS_SHL3 FOREIGN KEY (SEIS_GEOM_SET_S) REFERENCES SEIS_GEOM_SET (SEIS_GEOM_SET_S)); ALTER TABLE EARTH_POS_SHL ADD (CONSTRAINT fk_EARTH_POS_SHL4 FOREIGN KEY (SYN_LOG_TRC_S) REFERENCES SYN_LOG_TRC (SYN_LOG_TRC_S)); ALTER TABLE EARTH_POS_VRTX ADD (CONSTRAINT fk_EARTH_POS_VRTX1 FOREIGN KEY (GEOSCIENCE_NTRP_S) REFERENCES GEOSCIENCE_NTRP (GEOSCIENCE_NTRP_S)); ALTER TABLE EARTH_POS_VRTX ADD (CONSTRAINT fk_EARTH_POS_VRTX2 FOREIGN KEY (ID_WHOLE_S) REFERENCES EARTH_POS_CMPS (EARTH_POS_CMPS_S)); ALTER TABLE EARTH_POS_VRTX ADD (CONSTRAINT fk_EARTH_POS_VRTX3 FOREIGN KEY (SEIS_GEOM_SET_S) REFERENCES SEIS_GEOM_SET (SEIS_GEOM_SET_S)); ALTER TABLE EARTH_POS_VRTX ADD (CONSTRAINT fk_EARTH_POS_VRTX4 FOREIGN KEY (SYN_LOG_TRC_S) REFERENCES SYN_LOG_TRC (SYN_LOG_TRC_S)); ALTER TABLE ELEC_BATTERY ADD (CONSTRAINT fk_ELEC_BATTERY1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE ELEC_BATTERY ADD (CONSTRAINT fk_ELEC_BATTERY2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE ELLIPSOID ADD (CONSTRAINT fk_ELLIPSOID1 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE ELLIPSOID ADD (CONSTRAINT fk_ELLIPSOID2 FOREIGN KEY (SEMIMAJOR_AXIS_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE ELLIPSOID ADD (CONSTRAINT fk_ELLIPSOID3 FOREIGN KEY (SEMIMINOR_AXIS_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE ELLIPSOID ADD (CONSTRAINT fk_ELLIPSOID4 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE ELLIPSOID ADD (CONSTRAINT fk_ELLIPSOID5 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE ELLIPSOID ADD (CONSTRAINT fk_ELLIPSOID6 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE ELLIPSOID_ALIAS ADD (CONSTRAINT fk_ELLIPSOID_ALIAS1 FOREIGN KEY (ELLIPSOID_ID) REFERENCES ELLIPSOID (ELLIPSOID_ID)); ALTER TABLE ELLIPSOID_ALIAS ADD (CONSTRAINT fk_ELLIPSOID_ALIAS2 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE EMAIL_ADDRESS ADD (CONSTRAINT fk_EMAIL_ADDRESS1 FOREIGN KEY (BSASC_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE EMAIL_ADDRESS ADD (CONSTRAINT fk_EMAIL_ADDRESS2 FOREIGN KEY (R_ADDRESS_QLF) REFERENCES R_ADDRESS_QLF (NAME)); ALTER TABLE ENCUMBRANCE ADD (CONSTRAINT fk_ENCUMBRANCE1 FOREIGN KEY (BSASC_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE ENCUMBRANCE ADD (CONSTRAINT fk_ENCUMBRANCE2 FOREIGN KEY (CMPS_DOC_SPEC_S) REFERENCES CMPS_DOC_SPEC (CMPS_DOC_SPEC_S)); ALTER TABLE ENCUMBRANCE ADD (CONSTRAINT fk_ENCUMBRANCE3 FOREIGN KEY (INFORMATION_CNTN_S) REFERENCES DATA_COLLECTION (DATA_COLLECTION_S)); ALTER TABLE ENCUMBRANCE ADD (CONSTRAINT fk_ENCUMBRANCE4 FOREIGN KEY (TYP_DOC_SPEC_ID) REFERENCES TYP_DOC_SPEC (TYP_DOC_SPEC_ID)); ALTER TABLE EQIT_ASSEMBLY ADD (CONSTRAINT fk_EQIT_ASSEMBLY1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE EQIT_ASSEMBLY ADD (CONSTRAINT fk_EQIT_ASSEMBLY2 FOREIGN KEY (PART_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE EQIT_ASSEMBLY ADD (CONSTRAINT fk_EQIT_ASSEMBLY3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE EQIT_ASSEMBLY ADD (CONSTRAINT fk_EQIT_ASSEMBLY4 FOREIGN KEY (WHOLE_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE EQIT_CLSN ADD (CONSTRAINT fk_EQIT_CLSN1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE EQIT_CLSN ADD (CONSTRAINT fk_EQIT_CLSN2 FOREIGN KEY (EQUIPMENT_CLASS_S) REFERENCES EQUIPMENT_CLASS (EQUIPMENT_CLASS_S)); ALTER TABLE EQIT_CLSN ADD (CONSTRAINT fk_EQIT_CLSN3 FOREIGN KEY (EQUIPMENT_ITEM_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE EQIT_CLSN ADD (CONSTRAINT fk_EQIT_CLSN4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE EQIT_COLLECTION ADD (CONSTRAINT fk_EQIT_COLLECTION1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE EQIT_COLLECTION ADD (CONSTRAINT fk_EQIT_COLLECTION2 FOREIGN KEY (PART_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE EQIT_COLLECTION ADD (CONSTRAINT fk_EQIT_COLLECTION3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE EQIT_COLLECTION ADD (CONSTRAINT fk_EQIT_COLLECTION4 FOREIGN KEY (WHOLE_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE EQIT_CONNECTION ADD (CONSTRAINT fk_EQIT_CONNECTION1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE EQIT_CONNECTION ADD (CONSTRAINT fk_EQIT_CONNECTION2 FOREIGN KEY (FROM_EQUIPMENT_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE EQIT_CONNECTION ADD (CONSTRAINT fk_EQIT_CONNECTION3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE EQIT_CONNECTION ADD (CONSTRAINT fk_EQIT_CONNECTION4 FOREIGN KEY (TO_EQUIPMENT_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE EQIT_INSL ADD (CONSTRAINT fk_EQIT_INSL1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE EQIT_INSL ADD (CONSTRAINT fk_EQIT_INSL2 FOREIGN KEY (EQUIPMENT_ITEM_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE EQIT_INSL ADD (CONSTRAINT fk_EQIT_INSL3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE EQP_CLS_ALIAS ADD (CONSTRAINT fk_EQP_CLS_ALIAS1 FOREIGN KEY (CLASSIFICATION_SYS) REFERENCES CLSN_SYS (CLSN_SYS_NAME)); ALTER TABLE EQP_CLS_ALIAS ADD (CONSTRAINT fk_EQP_CLS_ALIAS2 FOREIGN KEY (EQUIPMENT_CLASS_S) REFERENCES EQUIPMENT_CLASS (EQUIPMENT_CLASS_S)); ALTER TABLE EQP_CLS_ALIAS ADD (CONSTRAINT fk_EQP_CLS_ALIAS3 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE EQP_CLS_ALIAS ADD (CONSTRAINT fk_EQP_CLS_ALIAS4 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE EQP_CLS_ALIAS ADD (CONSTRAINT fk_EQP_CLS_ALIAS5 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE EQP_CLS_CLSN ADD (CONSTRAINT fk_EQP_CLS_CLSN1 FOREIGN KEY (BE_CLASSIFIED_AS_S) REFERENCES EQUIPMENT_CLASS (EQUIPMENT_CLASS_S)); ALTER TABLE EQP_CLS_CLSN ADD (CONSTRAINT fk_EQP_CLS_CLSN2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE EQP_CLS_CLSN ADD (CONSTRAINT fk_EQP_CLS_CLSN3 FOREIGN KEY (HAVE_AS_A_MEMBER_S) REFERENCES EQUIPMENT_CLASS (EQUIPMENT_CLASS_S)); ALTER TABLE EQP_CLS_CLSN ADD (CONSTRAINT fk_EQP_CLS_CLSN4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE EQP_CLS_CLSN ADD (CONSTRAINT fk_EQP_CLS_CLSN5 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE EQP_CLS_CLSN ADD (CONSTRAINT fk_EQP_CLS_CLSN6 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE EQP_CLS_CLSN ADD (CONSTRAINT fk_EQP_CLS_CLSN7 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE EQP_REPAIR_JOB ADD (CONSTRAINT fk_EQP_REPAIR_JOB1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE EQP_REPAIR_JOB ADD (CONSTRAINT fk_EQP_REPAIR_JOB2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE EQP_REPAIR_JOB ADD (CONSTRAINT fk_EQP_REPAIR_JOB3 FOREIGN KEY (EQUIPMENT_ITEM_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE EQP_REPAIR_JOB ADD (CONSTRAINT fk_EQP_REPAIR_JOB4 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE EQP_REPAIR_JOB ADD (CONSTRAINT fk_EQP_REPAIR_JOB5 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE EQP_REPAIR_JOB ADD (CONSTRAINT fk_EQP_REPAIR_JOB6 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE EQP_REPAIR_JOB ADD (CONSTRAINT fk_EQP_REPAIR_JOB7 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE EQUIPMENT_CLASS ADD (CONSTRAINT fk_EQUIPMENT_CLASS1 FOREIGN KEY (CLASSIFICATION_SYS) REFERENCES CLSN_SYS (CLSN_SYS_NAME)); ALTER TABLE EQUIPMENT_CLASS ADD (CONSTRAINT fk_EQUIPMENT_CLASS2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE EQUIPMENT_CLASS ADD (CONSTRAINT fk_EQUIPMENT_CLASS3 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE EQUIPMENT_CLASS ADD (CONSTRAINT fk_EQUIPMENT_CLASS4 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE EQUIPMENT_CLBR ADD (CONSTRAINT fk_EQUIPMENT_CLBR1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE EQUIPMENT_CLBR ADD (CONSTRAINT fk_EQUIPMENT_CLBR2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE EQUIPMENT_CLBR ADD (CONSTRAINT fk_EQUIPMENT_CLBR3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE EQUIPMENT_CLBR ADD (CONSTRAINT fk_EQUIPMENT_CLBR4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE EQUIPMENT_CLBR ADD (CONSTRAINT fk_EQUIPMENT_CLBR5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE EQUIPMENT_CLBR ADD (CONSTRAINT fk_EQUIPMENT_CLBR6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE EQUIPMENT_FULFL ADD (CONSTRAINT fk_EQUIPMENT_FULFL1 FOREIGN KEY (FULFILLMENT_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE EQUIPMENT_FULFL ADD (CONSTRAINT fk_EQUIPMENT_FULFL2 FOREIGN KEY (FULFILL_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE EQUIPMENT_ITEM ADD (CONSTRAINT fk_EQUIPMENT_ITEM1 FOREIGN KEY (CATALOG_EQP_S) REFERENCES CATALOG_EQP (CATALOG_EQP_S)); ALTER TABLE EQUIPMENT_ITEM ADD (CONSTRAINT fk_EQUIPMENT_ITEM2 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE EQUIPMENT_ITEM ADD (CONSTRAINT fk_EQUIPMENT_ITEM3 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE ERTH_SFTR_ALIAS ADD (CONSTRAINT fk_ERTH_SFTR_ALIAS1 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE ERTH_SFTR_ALIAS ADD (CONSTRAINT fk_ERTH_SFTR_ALIAS2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE ERTH_SFTR_ALIAS ADD (CONSTRAINT fk_ERTH_SFTR_ALIAS3 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE ERTH_SFTR_ALIAS ADD (CONSTRAINT fk_ERTH_SFTR_ALIAS4 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE EVAL_FLW_STRM ADD (CONSTRAINT fk_EVAL_FLW_STRM1 FOREIGN KEY (KIND) REFERENCES R_EVAL_FLW_STRM (KIND)); ALTER TABLE EVAL_FLW_STRM ADD (CONSTRAINT fk_EVAL_FLW_STRM2 FOREIGN KEY (PFNU_PORT_S) REFERENCES PFNU_PORT (PFNU_PORT_S)); ALTER TABLE FACILITY_CLASS ADD (CONSTRAINT fk_FACILITY_CLASS1 FOREIGN KEY (CLASSIFICATION_SYS) REFERENCES CLSN_SYS (CLSN_SYS_NAME)); ALTER TABLE FACILITY_CLASS ADD (CONSTRAINT fk_FACILITY_CLASS2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE FACILITY_CLASS ADD (CONSTRAINT fk_FACILITY_CLASS3 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE FACILITY_CLASS ADD (CONSTRAINT fk_FACILITY_CLASS4 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE FACILITY_CLSN ADD (CONSTRAINT fk_FACILITY_CLSN1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE FACILITY_CLSN ADD (CONSTRAINT fk_FACILITY_CLSN2 FOREIGN KEY (FACILITY_CLASS_S) REFERENCES FACILITY_CLASS (FACILITY_CLASS_S)); ALTER TABLE FACILITY_CLSN ADD (CONSTRAINT fk_FACILITY_CLSN3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE FACILITY_CMPS ADD (CONSTRAINT fk_FACILITY_CMPS1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE FACILITY_CMPS ADD (CONSTRAINT fk_FACILITY_CMPS2 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE FACILITY_CON ADD (CONSTRAINT fk_FACILITY_CON1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE FACILITY_CON ADD (CONSTRAINT fk_FACILITY_CON2 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE FACILITY_REF_PT ADD (CONSTRAINT fk_FACILITY_REF_PT1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE FACILITY_REF_PT ADD (CONSTRAINT fk_FACILITY_REF_PT2 FOREIGN KEY (R_FCL_REF_PT_NAME) REFERENCES R_FCL_REF_PT (R_FCL_REF_PT_NAME)); ALTER TABLE FACILITY_REF_PT ADD (CONSTRAINT fk_FACILITY_REF_PT3 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE FAULT_PLN_ORNT ADD (CONSTRAINT fk_FAULT_PLN_ORNT1 FOREIGN KEY (EARTH_POS_FACE_S) REFERENCES EARTH_POS_FACE (EARTH_POS_FACE_S)); ALTER TABLE FAULT_PLN_ORNT ADD (CONSTRAINT fk_FAULT_PLN_ORNT2 FOREIGN KEY (EARTH_POS_RGN_S) REFERENCES EARTH_POS_RGN (EARTH_POS_RGN_S)); ALTER TABLE FAULT_PLN_ORNT ADD (CONSTRAINT fk_FAULT_PLN_ORNT3 FOREIGN KEY (R_FAULT_SIDE_NAME) REFERENCES R_FAULT_SIDE (R_FAULT_SIDE_NAME)); ALTER TABLE FCL_CLS_ALIAS ADD (CONSTRAINT fk_FCL_CLS_ALIAS1 FOREIGN KEY (CLASSIFICATION_SYS) REFERENCES CLSN_SYS (CLSN_SYS_NAME)); ALTER TABLE FCL_CLS_ALIAS ADD (CONSTRAINT fk_FCL_CLS_ALIAS2 FOREIGN KEY (FACILITY_CLASS_S) REFERENCES FACILITY_CLASS (FACILITY_CLASS_S)); ALTER TABLE FCL_CLS_ALIAS ADD (CONSTRAINT fk_FCL_CLS_ALIAS3 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE FCL_CLS_ALIAS ADD (CONSTRAINT fk_FCL_CLS_ALIAS4 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE FCL_CLS_ALIAS ADD (CONSTRAINT fk_FCL_CLS_ALIAS5 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE FCL_CLS_CLSN ADD (CONSTRAINT fk_FCL_CLS_CLSN1 FOREIGN KEY (BE_CLASSIFIED_AS_S) REFERENCES FACILITY_CLASS (FACILITY_CLASS_S)); ALTER TABLE FCL_CLS_CLSN ADD (CONSTRAINT fk_FCL_CLS_CLSN2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE FCL_CLS_CLSN ADD (CONSTRAINT fk_FCL_CLS_CLSN3 FOREIGN KEY (HAVE_AS_A_MEMBER_S) REFERENCES FACILITY_CLASS (FACILITY_CLASS_S)); ALTER TABLE FCL_CLS_CLSN ADD (CONSTRAINT fk_FCL_CLS_CLSN4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE FCL_CLS_CLSN ADD (CONSTRAINT fk_FCL_CLS_CLSN5 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE FCL_CLS_CLSN ADD (CONSTRAINT fk_FCL_CLS_CLSN6 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE FCL_CLS_CLSN ADD (CONSTRAINT fk_FCL_CLS_CLSN7 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE FCL_VERSION ADD (CONSTRAINT fk_FCL_VERSION1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE FCL_VERSION ADD (CONSTRAINT fk_FCL_VERSION2 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE FFLW_STREAM_ALOC ADD (CONSTRAINT fk_FFLW_STREAM_ALOC1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE FFLW_STREAM_ALOC ADD (CONSTRAINT fk_FFLW_STREAM_ALOC2 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE FIELD ADD (CONSTRAINT fk_FIELD1 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE FIELD_CLSN ADD (CONSTRAINT fk_FIELD_CLSN1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE FIELD_CLSN ADD (CONSTRAINT fk_FIELD_CLSN2 FOREIGN KEY (FIELD_S) REFERENCES FIELD (FIELD_S)); ALTER TABLE FIELD_CLSN ADD (CONSTRAINT fk_FIELD_CLSN3 FOREIGN KEY (R_FIELD_KIND) REFERENCES R_FIELD (R_FIELD_KIND)); ALTER TABLE FIELD_CLSN ADD (CONSTRAINT fk_FIELD_CLSN4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE FILTER_CAKE ADD (CONSTRAINT fk_FILTER_CAKE1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE FILTER_CAKE ADD (CONSTRAINT fk_FILTER_CAKE2 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE FILTER_CAKE ADD (CONSTRAINT fk_FILTER_CAKE3 FOREIGN KEY (TEMP_OF_RMC_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE FLOW_CTRL_FCL ADD (CONSTRAINT fk_FLOW_CTRL_FCL1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE FLOW_CTRL_FCL ADD (CONSTRAINT fk_FLOW_CTRL_FCL2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE FLOW_SYS_ANAL ADD (CONSTRAINT fk_FLOW_SYS_ANAL1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE FLOW_SYS_ANAL ADD (CONSTRAINT fk_FLOW_SYS_ANAL2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE FLOW_SYS_ANAL ADD (CONSTRAINT fk_FLOW_SYS_ANAL3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE FLOW_SYS_ANAL ADD (CONSTRAINT fk_FLOW_SYS_ANAL4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE FLOW_SYS_ANAL ADD (CONSTRAINT fk_FLOW_SYS_ANAL5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE FLOW_SYS_ANAL ADD (CONSTRAINT fk_FLOW_SYS_ANAL6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE FLUID_ANALYSIS ADD (CONSTRAINT fk_FLUID_ANALYSIS1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE FLUID_ANALYSIS ADD (CONSTRAINT fk_FLUID_ANALYSIS2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE FLUID_ANALYSIS ADD (CONSTRAINT fk_FLUID_ANALYSIS3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE FLUID_ANALYSIS ADD (CONSTRAINT fk_FLUID_ANALYSIS4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE FLUID_ANALYSIS ADD (CONSTRAINT fk_FLUID_ANALYSIS5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE FLUID_ANALYSIS ADD (CONSTRAINT fk_FLUID_ANALYSIS6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE FLUID_CMPN_IACT ADD (CONSTRAINT fk_FLUID_CMPN_IACT1 FOREIGN KEY (I_COMPONENT_S) REFERENCES SPECIFIC_FL_CMPN (SPECIFIC_FL_CMPN_S)); ALTER TABLE FLUID_CMPN_IACT ADD (CONSTRAINT fk_FLUID_CMPN_IACT2 FOREIGN KEY (J_COMPONENT_S) REFERENCES SPECIFIC_FL_CMPN (SPECIFIC_FL_CMPN_S)); ALTER TABLE FLUID_FTR_CNTC ADD (CONSTRAINT fk_FLUID_FTR_CNTC1 FOREIGN KEY (R_FLUID_CONTACT_KD) REFERENCES R_FLUID_CONTACT (R_FLUID_CONTACT_KD)); ALTER TABLE FLUID_LIFT_SYS ADD (CONSTRAINT fk_FLUID_LIFT_SYS1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE FLUID_LIFT_SYS ADD (CONSTRAINT fk_FLUID_LIFT_SYS2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE FLUID_PHASE_LQ ADD (CONSTRAINT fk_FLUID_PHASE_LQ1 FOREIGN KEY (FLUID_SYSTEM_ST_S) REFERENCES FLUID_SYSTEM_ST (FLUID_SYSTEM_ST_S)); ALTER TABLE FLUID_PHASE_SLD ADD (CONSTRAINT fk_FLUID_PHASE_SLD1 FOREIGN KEY (FLUID_SYSTEM_ST_S) REFERENCES FLUID_SYSTEM_ST (FLUID_SYSTEM_ST_S)); ALTER TABLE FLUID_PHASE_VAP ADD (CONSTRAINT fk_FLUID_PHASE_VAP1 FOREIGN KEY (FLUID_SYSTEM_ST_S) REFERENCES FLUID_SYSTEM_ST (FLUID_SYSTEM_ST_S)); ALTER TABLE FLUID_PHS_CMPS ADD (CONSTRAINT fk_FLUID_PHS_CMPS1 FOREIGN KEY (FLUID_SYSTEM_ST_S) REFERENCES FLUID_SYSTEM_ST (FLUID_SYSTEM_ST_S)); ALTER TABLE FLUID_PHS_NTFC ADD (CONSTRAINT fk_FLUID_PHS_NTFC1 FOREIGN KEY (FLUID_COMPONENT_S) REFERENCES SPECIFIC_FL_CMPN (SPECIFIC_FL_CMPN_S)); ALTER TABLE FLUID_PROC ADD (CONSTRAINT fk_FLUID_PROC1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE FLUID_PROC ADD (CONSTRAINT fk_FLUID_PROC2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE FLUID_PROC ADD (CONSTRAINT fk_FLUID_PROC3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE FLUID_PROC ADD (CONSTRAINT fk_FLUID_PROC4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE FLUID_PROC ADD (CONSTRAINT fk_FLUID_PROC5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE FLUID_PROC ADD (CONSTRAINT fk_FLUID_PROC6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE FLUID_SAMPLE ADD (CONSTRAINT fk_FLUID_SAMPLE1 FOREIGN KEY (INITIAL_PRESSURE_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE FLUID_SAMPLE ADD (CONSTRAINT fk_FLUID_SAMPLE2 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE FLUID_SAMPLE ADD (CONSTRAINT fk_FLUID_SAMPLE3 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE FLUID_SAMPLE ADD (CONSTRAINT fk_FLUID_SAMPLE4 FOREIGN KEY (TEMP_OF_RMF_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE FLUID_SAM_ACQ ADD (CONSTRAINT fk_FLUID_SAM_ACQ1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE FLUID_SAM_ACQ ADD (CONSTRAINT fk_FLUID_SAM_ACQ2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE FLUID_SAM_ACQ ADD (CONSTRAINT fk_FLUID_SAM_ACQ3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE FLUID_SAM_ACQ ADD (CONSTRAINT fk_FLUID_SAM_ACQ4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE FLUID_SAM_ACQ ADD (CONSTRAINT fk_FLUID_SAM_ACQ5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE FLUID_SAM_ACQ ADD (CONSTRAINT fk_FLUID_SAM_ACQ6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE FLUID_SAT_COND ADD (CONSTRAINT fk_FLUID_SAT_COND1 FOREIGN KEY (CORE_S) REFERENCES CORE (CORE_S)); ALTER TABLE FLUID_SAT_COND ADD (CONSTRAINT fk_FLUID_SAT_COND2 FOREIGN KEY (DRILL_CUT_SAM_S) REFERENCES DRILL_CUT_SAM (DRILL_CUT_SAM_S)); ALTER TABLE FLUID_SAT_COND ADD (CONSTRAINT fk_FLUID_SAT_COND3 FOREIGN KEY (OUTCROP_SAMPLE_S) REFERENCES OUTCROP_SAMPLE (OUTCROP_SAMPLE_S)); ALTER TABLE FLUID_SYSTEM_ST ADD (CONSTRAINT fk_FLUID_SYSTEM_ST1 FOREIGN KEY (PRESSURE_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE FLUID_SYSTEM_ST ADD (CONSTRAINT fk_FLUID_SYSTEM_ST2 FOREIGN KEY (TEMPERATURE_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE FOSSIL_TAXON ADD (CONSTRAINT fk_FOSSIL_TAXON1 FOREIGN KEY (CLASS_OF_TAXON) REFERENCES FOSSIL_TAXON (TYPICAL_MTRL_NAME)); ALTER TABLE FOSSIL_TAXON ADD (CONSTRAINT fk_FOSSIL_TAXON2 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE FOSSIL_TAXON ADD (CONSTRAINT fk_FOSSIL_TAXON3 FOREIGN KEY (R_TAXONOMIC_CLS_KD) REFERENCES R_TAXONOMIC_CLS (R_TAXONOMIC_CLS_KD)); ALTER TABLE FOSSIL_TAXON ADD (CONSTRAINT fk_FOSSIL_TAXON4 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE FOSSIL_TAXON ADD (CONSTRAINT fk_FOSSIL_TAXON5 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE FOSSIL_TAXON ADD (CONSTRAINT fk_FOSSIL_TAXON6 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE FPS_LSA ADD (CONSTRAINT fk_FPS_LSA1 FOREIGN KEY (R_LATITUDE_1_OU) REFERENCES R_UOM (ACRONYM)); ALTER TABLE FPS_LSA ADD (CONSTRAINT fk_FPS_LSA2 FOREIGN KEY (R_LATITUDE_CS) REFERENCES COORDINATE_SYS (COORDINATE_SYS_ID)); ALTER TABLE FPS_LSA ADD (CONSTRAINT fk_FPS_LSA3 FOREIGN KEY (R_LONGITUDE_1_OU) REFERENCES R_UOM (ACRONYM)); ALTER TABLE FPS_LSA ADD (CONSTRAINT fk_FPS_LSA4 FOREIGN KEY (R_LONGITUDE_CS) REFERENCES COORDINATE_SYS (COORDINATE_SYS_ID)); ALTER TABLE FRACTURE ADD (CONSTRAINT fk_FRACTURE1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE FRACTURE ADD (CONSTRAINT fk_FRACTURE2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE GATHERING_FCL ADD (CONSTRAINT fk_GATHERING_FCL1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE GATHERING_FCL ADD (CONSTRAINT fk_GATHERING_FCL2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE GDLN_PRIV_COM ADD (CONSTRAINT fk_GDLN_PRIV_COM1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE GDLN_PRIV_COM ADD (CONSTRAINT fk_GDLN_PRIV_COM2 FOREIGN KEY (R_GDLN_COM_STA_KD) REFERENCES R_GDLN_COM_STA (R_GDLN_COM_STA_KD)); ALTER TABLE GDLN_PRIV_COM ADD (CONSTRAINT fk_GDLN_PRIV_COM3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE GDLN_PRIV_RMDY ADD (CONSTRAINT fk_GDLN_PRIV_RMDY1 FOREIGN KEY (ACTION_VALUE_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE GDLN_PRIV_RMDY ADD (CONSTRAINT fk_GDLN_PRIV_RMDY2 FOREIGN KEY (TEST_VALUE_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE GDLN_PRIV_RMDY ADD (CONSTRAINT fk_GDLN_PRIV_RMDY3 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE GENERAL_ESRF_PT ADD (CONSTRAINT fk_GENERAL_ESRF_PT1 FOREIGN KEY (GEOSCIENCE_NTRP_S) REFERENCES GEOSCIENCE_NTRP (GEOSCIENCE_NTRP_S)); ALTER TABLE GENERAL_ESRF_PT ADD (CONSTRAINT fk_GENERAL_ESRF_PT2 FOREIGN KEY (R_OTHER_ERTH_PT_KD) REFERENCES R_OTHER_ERTH_PT (R_OTHER_ERTH_PT_KD)); ALTER TABLE GENERAL_SURF_LN ADD (CONSTRAINT fk_GENERAL_SURF_LN1 FOREIGN KEY (GEOSCIENCE_NTRP_S) REFERENCES GEOSCIENCE_NTRP (GEOSCIENCE_NTRP_S)); ALTER TABLE GENERAL_WB_PT ADD (CONSTRAINT fk_GENERAL_WB_PT1 FOREIGN KEY (DEPTH_1_OU) REFERENCES R_UOM (ACRONYM)); ALTER TABLE GENERAL_WB_PT ADD (CONSTRAINT fk_GENERAL_WB_PT2 FOREIGN KEY (DEPTH_CS) REFERENCES COORDINATE_SYS (COORDINATE_SYS_ID)); ALTER TABLE GENERAL_WB_PT ADD (CONSTRAINT fk_GENERAL_WB_PT3 FOREIGN KEY (GEOSCIENCE_NTRP_S) REFERENCES GEOSCIENCE_NTRP (GEOSCIENCE_NTRP_S)); ALTER TABLE GENERAL_WB_PT ADD (CONSTRAINT fk_GENERAL_WB_PT4 FOREIGN KEY (PT_1_OU) REFERENCES R_UOM (ACRONYM)); ALTER TABLE GENERAL_WB_PT ADD (CONSTRAINT fk_GENERAL_WB_PT5 FOREIGN KEY (PT_2_OU) REFERENCES R_UOM (ACRONYM)); ALTER TABLE GENERAL_WB_PT ADD (CONSTRAINT fk_GENERAL_WB_PT6 FOREIGN KEY (PT_CS) REFERENCES COORDINATE_SYS (COORDINATE_SYS_ID)); ALTER TABLE GENERAL_WB_PT ADD (CONSTRAINT fk_GENERAL_WB_PT7 FOREIGN KEY (R_WELLBORE_PT_NAME) REFERENCES R_WELLBORE_PT (R_WELLBORE_PT_NAME)); ALTER TABLE GENERAL_WB_PT ADD (CONSTRAINT fk_GENERAL_WB_PT8 FOREIGN KEY (WELLBORE_S) REFERENCES WELLBORE (WELLBORE_S)); ALTER TABLE GENERAL_WB_PT ADD (CONSTRAINT fk_GENERAL_WB_PT9 FOREIGN KEY (WELL_CMPL_S) REFERENCES WELL_COMPLETION (WELL_COMPLETION_S)); ALTER TABLE GEN_SURF_AREA ADD (CONSTRAINT fk_GEN_SURF_AREA1 FOREIGN KEY (GEOSCIENCE_NTRP_S) REFERENCES GEOSCIENCE_NTRP (GEOSCIENCE_NTRP_S)); ALTER TABLE GEN_SURF_BND ADD (CONSTRAINT fk_GEN_SURF_BND1 FOREIGN KEY (GEOSCIENCE_NTRP_S) REFERENCES GEOSCIENCE_NTRP (GEOSCIENCE_NTRP_S)); ALTER TABLE GEN_SURF_CMPS ADD (CONSTRAINT fk_GEN_SURF_CMPS1 FOREIGN KEY (GEOSCIENCE_NTRP_S) REFERENCES GEOSCIENCE_NTRP (GEOSCIENCE_NTRP_S)); ALTER TABLE GEODETIC_DATUM ADD (CONSTRAINT fk_GEODETIC_DATUM1 FOREIGN KEY (ELLIPSOID_ID) REFERENCES ELLIPSOID (ELLIPSOID_ID)); ALTER TABLE GEODETIC_DATUM ADD (CONSTRAINT fk_GEODETIC_DATUM2 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE GEODETIC_DATUM ADD (CONSTRAINT fk_GEODETIC_DATUM3 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE GEODETIC_DATUM ADD (CONSTRAINT fk_GEODETIC_DATUM4 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE GEODETIC_DATUM ADD (CONSTRAINT fk_GEODETIC_DATUM5 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE GEODETIC_ZONE ADD (CONSTRAINT fk_GEODETIC_ZONE1 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE GEODETIC_ZONE ADD (CONSTRAINT fk_GEODETIC_ZONE2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE GEODETIC_ZONE ADD (CONSTRAINT fk_GEODETIC_ZONE3 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE GEODETIC_ZONE ADD (CONSTRAINT fk_GEODETIC_ZONE4 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE GEOD_DTM_ALIAS ADD (CONSTRAINT fk_GEOD_DTM_ALIAS1 FOREIGN KEY (GEODETIC_DATUM_ID) REFERENCES GEODETIC_DATUM (GEODETIC_DATUM_ID)); ALTER TABLE GEOD_DTM_ALIAS ADD (CONSTRAINT fk_GEOD_DTM_ALIAS2 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE GEOD_DTM_ALIAS ADD (CONSTRAINT fk_GEOD_DTM_ALIAS3 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE GEOD_DTM_ALIAS ADD (CONSTRAINT fk_GEOD_DTM_ALIAS4 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE GEOD_DTM_ALIAS ADD (CONSTRAINT fk_GEOD_DTM_ALIAS5 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE GEOGRAPHIC_FTR ADD (CONSTRAINT fk_GEOGRAPHIC_FTR1 FOREIGN KEY (R_GEOG_FTR_KIND) REFERENCES R_GEOG_FTR (R_GEOG_FTR_KIND)); ALTER TABLE GEOGRAPHIC_FTR ADD (CONSTRAINT fk_GEOGRAPHIC_FTR2 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE GEOGRAPHIC_FTR ADD (CONSTRAINT fk_GEOGRAPHIC_FTR3 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE GEOGRAPHIC_FTR ADD (CONSTRAINT fk_GEOGRAPHIC_FTR4 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE GEOGRAPHIC_FTR ADD (CONSTRAINT fk_GEOGRAPHIC_FTR5 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE GEOID ADD (CONSTRAINT fk_GEOID1 FOREIGN KEY (GEOID_MODEL_S) REFERENCES GEOID_MODEL (GEOID_MODEL_S)); ALTER TABLE GEOID ADD (CONSTRAINT fk_GEOID2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE GEOID ADD (CONSTRAINT fk_GEOID3 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE GEOID ADD (CONSTRAINT fk_GEOID4 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE GEOID_MODEL ADD (CONSTRAINT fk_GEOID_MODEL1 FOREIGN KEY (GEODETIC_DATUM_ID) REFERENCES GEODETIC_DATUM (GEODETIC_DATUM_ID)); ALTER TABLE GEOLOGIC_FAULT ADD (CONSTRAINT fk_GEOLOGIC_FAULT1 FOREIGN KEY (R_GEOLOGIC_FLT_KD) REFERENCES R_GEOLOGIC_FLT (R_GEOLOGIC_FLT_KD)); ALTER TABLE GEOLOGIC_OBJ_ASN ADD (CONSTRAINT fk_GEOLOGIC_OBJ_ASN1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE GEOLOGIC_OBJ_ASN ADD (CONSTRAINT fk_GEOLOGIC_OBJ_ASN2 FOREIGN KEY (R_GEOLOGIC_OBJ_ASN) REFERENCES R_GEOL_OBJ_ASN (KIND)); ALTER TABLE GEOLOGIC_OBJ_ASN ADD (CONSTRAINT fk_GEOLOGIC_OBJ_ASN3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE GEOLOGIC_PROC ADD (CONSTRAINT fk_GEOLOGIC_PROC1 FOREIGN KEY (TYP_GEOL_PROC_NAME) REFERENCES TYP_GEOL_PROC (TYP_GEOL_PROC_NAME)); ALTER TABLE GEOLOGIC_PROV ADD (CONSTRAINT fk_GEOLOGIC_PROV1 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE GEOLOGIC_PROV ADD (CONSTRAINT fk_GEOLOGIC_PROV2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE GEOLOGIC_PROV ADD (CONSTRAINT fk_GEOLOGIC_PROV3 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE GEOLOGIC_PROV ADD (CONSTRAINT fk_GEOLOGIC_PROV4 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE GEOL_AGE_CLSN ADD (CONSTRAINT fk_GEOL_AGE_CLSN1 FOREIGN KEY (GEOSCIENCE_NTRP_S) REFERENCES GEOSCIENCE_NTRP (GEOSCIENCE_NTRP_S)); ALTER TABLE GEOL_AGE_CLSN ADD (CONSTRAINT fk_GEOL_AGE_CLSN2 FOREIGN KEY (RSVR_FL_SYS_S) REFERENCES RSVR_FL_SYS (RSVR_FL_SYS_S)); ALTER TABLE GEOL_AGE_CLSN ADD (CONSTRAINT fk_GEOL_AGE_CLSN3 FOREIGN KEY (R_AGE_CLSN_TY_KIND) REFERENCES R_AGE_CLSN_TY (R_AGE_CLSN_TY_KIND)); ALTER TABLE GEOL_AGE_CLSN ADD (CONSTRAINT fk_GEOL_AGE_CLSN4 FOREIGN KEY (TEMPORAL_OBJECT_S) REFERENCES TEMPORAL_OBJECT (TEMPORAL_OBJECT_S)); ALTER TABLE GEOL_AGE_CLSN ADD (CONSTRAINT fk_GEOL_AGE_CLSN5 FOREIGN KEY (UNCERTAINTY_CLS_S) REFERENCES UNCERTAINTY_CLS (UNCERTAINTY_CLS_S)); ALTER TABLE GEOL_PROC_SEQ ADD (CONSTRAINT fk_GEOL_PROC_SEQ1 FOREIGN KEY (FOLW_GEOL_PROC_S) REFERENCES GEOLOGIC_PROC (GEOLOGIC_PROC_S)); ALTER TABLE GEOL_PROC_SEQ ADD (CONSTRAINT fk_GEOL_PROC_SEQ2 FOREIGN KEY (GEOSCIENCE_NTRP_S) REFERENCES GEOSCIENCE_NTRP (GEOSCIENCE_NTRP_S)); ALTER TABLE GEOL_PROC_SEQ ADD (CONSTRAINT fk_GEOL_PROC_SEQ3 FOREIGN KEY (PREC_GEOL_PROC_S) REFERENCES GEOLOGIC_PROC (GEOLOGIC_PROC_S)); ALTER TABLE GEOP_ACQ_AREA ADD (CONSTRAINT fk_GEOP_ACQ_AREA1 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE GEOSCIENCE_NTRP ADD (CONSTRAINT fk_GEOSCIENCE_NTRP1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE GEOSCIENCE_NTRP ADD (CONSTRAINT fk_GEOSCIENCE_NTRP2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE GEOSCIENCE_NTRP ADD (CONSTRAINT fk_GEOSCIENCE_NTRP3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE GEOSCIENCE_NTRP ADD (CONSTRAINT fk_GEOSCIENCE_NTRP4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE GEOSCIENCE_NTRP ADD (CONSTRAINT fk_GEOSCIENCE_NTRP5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE GEOSCIENCE_NTRP ADD (CONSTRAINT fk_GEOSCIENCE_NTRP6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE GOPL_ASN ADD (CONSTRAINT fk_GOPL_ASN1 FOREIGN KEY (CONTAINED_AREA_S) REFERENCES GOPL_FTR (GOPL_FTR_S)); ALTER TABLE GOPL_ASN ADD (CONSTRAINT fk_GOPL_ASN2 FOREIGN KEY (CONTAINING_AREA_S) REFERENCES GOPL_FTR (GOPL_FTR_S)); ALTER TABLE GOPL_ASN ADD (CONSTRAINT fk_GOPL_ASN3 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE GOPL_ASN ADD (CONSTRAINT fk_GOPL_ASN4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE GOPL_FTR ADD (CONSTRAINT fk_GOPL_FTR1 FOREIGN KEY (R_GOPL_AREA_NAME) REFERENCES R_GOPL_AREA (R_GOPL_AREA_NAME)); ALTER TABLE GOPL_FTR ADD (CONSTRAINT fk_GOPL_FTR2 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE GOPL_FTR ADD (CONSTRAINT fk_GOPL_FTR3 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE GOPL_FTR ADD (CONSTRAINT fk_GOPL_FTR4 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE GOPL_FTR ADD (CONSTRAINT fk_GOPL_FTR5 FOREIGN KEY (UNIQUE_MEMBER_OF_S) REFERENCES GOPL_FTR (GOPL_FTR_S)); ALTER TABLE GOPL_FTR ADD (CONSTRAINT fk_GOPL_FTR6 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE GRAVEL_TYPE ADD (CONSTRAINT fk_GRAVEL_TYPE1 FOREIGN KEY (GRAVEL_SIZE_MN_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE GRAVEL_TYPE ADD (CONSTRAINT fk_GRAVEL_TYPE2 FOREIGN KEY (GRAVEL_SIZE_MX_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE GRAVEL_TYPE ADD (CONSTRAINT fk_GRAVEL_TYPE3 FOREIGN KEY (MEAN_DIAMETER_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE GRAVEL_TYPE ADD (CONSTRAINT fk_GRAVEL_TYPE4 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE GRAVEL_TYPE ADD (CONSTRAINT fk_GRAVEL_TYPE5 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE GRAVEL_TYPE ADD (CONSTRAINT fk_GRAVEL_TYPE6 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE GRAVEL_TYPE ADD (CONSTRAINT fk_GRAVEL_TYPE7 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE GRAY_SCL_PALET ADD (CONSTRAINT fk_GRAY_SCL_PALET1 FOREIGN KEY (IMAGE_PALET_TY_ID) REFERENCES IMAGE_PALET_TY (IMAGE_PALET_TY_ID)); ALTER TABLE GRAY_SCL_PALET ADD (CONSTRAINT fk_GRAY_SCL_PALET2 FOREIGN KEY (SYMBOL_LIBRARY_ID) REFERENCES SYMBOL_LIBRARY (SYMBOL_LIBRARY_ID)); ALTER TABLE GRID_1D ADD (CONSTRAINT fk_GRID_1D1 FOREIGN KEY (CORD_SYS_AXIS_S) REFERENCES CORD_SYS_AXIS (CORD_SYS_AXIS_S)); ALTER TABLE GRID_1D ADD (CONSTRAINT fk_GRID_1D2 FOREIGN KEY (ORIGIN_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE GRID_1D ADD (CONSTRAINT fk_GRID_1D3 FOREIGN KEY (STEP_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE GRID_COARSE_MOD ADD (CONSTRAINT fk_GRID_COARSE_MOD1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE GRID_COARSE_MOD ADD (CONSTRAINT fk_GRID_COARSE_MOD2 FOREIGN KEY (GRID_DIMENSION) REFERENCES R_ELEMENT_KIND (GRID_DIMENSION)); ALTER TABLE GRID_COARSE_MOD ADD (CONSTRAINT fk_GRID_COARSE_MOD3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE GRID_REFINE_MOD ADD (CONSTRAINT fk_GRID_REFINE_MOD1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE GRID_REFINE_MOD ADD (CONSTRAINT fk_GRID_REFINE_MOD2 FOREIGN KEY (GRID_DIMENSION) REFERENCES R_ELEMENT_KIND (GRID_DIMENSION)); ALTER TABLE GRID_REFINE_MOD ADD (CONSTRAINT fk_GRID_REFINE_MOD3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE GUIDELINE ADD (CONSTRAINT fk_GUIDELINE1 FOREIGN KEY (DATA_VALUE_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE GUIDELINE ADD (CONSTRAINT fk_GUIDELINE2 FOREIGN KEY (GUIDELINE_SET_S) REFERENCES GUIDELINE_SET (GUIDELINE_SET_S)); ALTER TABLE GUIDELINE ADD (CONSTRAINT fk_GUIDELINE3 FOREIGN KEY (R_GUIDELINE_KIND) REFERENCES R_GUIDELINE (R_GUIDELINE_KIND)); ALTER TABLE GUIDELINE_SET ADD (CONSTRAINT fk_GUIDELINE_SET1 FOREIGN KEY (CMPS_DOC_SPEC_S) REFERENCES CMPS_DOC_SPEC (CMPS_DOC_SPEC_S)); ALTER TABLE GUIDELINE_SET ADD (CONSTRAINT fk_GUIDELINE_SET2 FOREIGN KEY (INFORMATION_CNTN_S) REFERENCES DATA_COLLECTION (DATA_COLLECTION_S)); ALTER TABLE GUIDELINE_SET ADD (CONSTRAINT fk_GUIDELINE_SET3 FOREIGN KEY (TYP_DOC_SPEC_ID) REFERENCES TYP_DOC_SPEC (TYP_DOC_SPEC_ID)); ALTER TABLE HATCH_LINE_PAT ADD (CONSTRAINT fk_HATCH_LINE_PAT1 FOREIGN KEY (LINE_OFFSET_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE HATCH_LINE_PAT ADD (CONSTRAINT fk_HATCH_LINE_PAT2 FOREIGN KEY (LINE_SPACING_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE HATCH_LINE_PAT ADD (CONSTRAINT fk_HATCH_LINE_PAT3 FOREIGN KEY (LINE_STYLE_S) REFERENCES LINE_STYLE (LINE_STYLE_S)); ALTER TABLE HATCH_LINE_PAT ADD (CONSTRAINT fk_HATCH_LINE_PAT4 FOREIGN KEY (ORIENTATION_ANGL_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE HC_MASS_FRAC ADD (CONSTRAINT fk_HC_MASS_FRAC1 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE HC_MASS_FRAC ADD (CONSTRAINT fk_HC_MASS_FRAC2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE HC_MASS_FRAC ADD (CONSTRAINT fk_HC_MASS_FRAC3 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE HC_MASS_FRAC ADD (CONSTRAINT fk_HC_MASS_FRAC4 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE HEAT_EXCHANGER ADD (CONSTRAINT fk_HEAT_EXCHANGER1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE HEAT_EXCHANGER ADD (CONSTRAINT fk_HEAT_EXCHANGER2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE HOISTING_SYSTEM ADD (CONSTRAINT fk_HOISTING_SYSTEM1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE HOISTING_SYSTEM ADD (CONSTRAINT fk_HOISTING_SYSTEM2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE HOLE_CLASS ADD (CONSTRAINT fk_HOLE_CLASS1 FOREIGN KEY (CLASSIFICATION_SYS) REFERENCES CLSN_SYS (CLSN_SYS_NAME)); ALTER TABLE HOLE_CLASS ADD (CONSTRAINT fk_HOLE_CLASS2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE HOLE_CLASS ADD (CONSTRAINT fk_HOLE_CLASS3 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE HOLE_CLASS ADD (CONSTRAINT fk_HOLE_CLASS4 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE HOLE_CLSN ADD (CONSTRAINT fk_HOLE_CLSN1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE HOLE_CLSN ADD (CONSTRAINT fk_HOLE_CLSN2 FOREIGN KEY (HOLE_CLASS_S) REFERENCES HOLE_CLASS (HOLE_CLASS_S)); ALTER TABLE HOLE_CLSN ADD (CONSTRAINT fk_HOLE_CLSN3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE HOLE_IN_TUBULAR ADD (CONSTRAINT fk_HOLE_IN_TUBULAR1 FOREIGN KEY (HOLE_SIZE_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE HOLE_IN_TUBULAR ADD (CONSTRAINT fk_HOLE_IN_TUBULAR2 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE HOLE_IN_TUBULAR ADD (CONSTRAINT fk_HOLE_IN_TUBULAR3 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE HOLE_IN_TUBULAR ADD (CONSTRAINT fk_HOLE_IN_TUBULAR4 FOREIGN KEY (WELLBORE_S) REFERENCES WELLBORE (WELLBORE_S)); ALTER TABLE HOLE_TYPE ADD (CONSTRAINT fk_HOLE_TYPE1 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE HOLE_TYPE ADD (CONSTRAINT fk_HOLE_TYPE2 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE HOLE_TYPE ADD (CONSTRAINT fk_HOLE_TYPE3 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE HOLE_TYPE_NTRP ADD (CONSTRAINT fk_HOLE_TYPE_NTRP1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE HOLE_TYPE_NTRP ADD (CONSTRAINT fk_HOLE_TYPE_NTRP2 FOREIGN KEY (HOLE_TYPE_KIND) REFERENCES HOLE_TYPE (HOLE_TYPE_KIND)); ALTER TABLE HOLE_TYPE_NTRP ADD (CONSTRAINT fk_HOLE_TYPE_NTRP3 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE HOR_PIPE_FLWMDL ADD (CONSTRAINT fk_HOR_PIPE_FLWMDL1 FOREIGN KEY (INITIAL_PORT_S) REFERENCES PFNU_PORT (PFNU_PORT_S)); ALTER TABLE HOR_PIPE_FLWMDL ADD (CONSTRAINT fk_HOR_PIPE_FLWMDL2 FOREIGN KEY (TERMINAL_PORT_S) REFERENCES PFNU_PORT (PFNU_PORT_S)); ALTER TABLE HYDROCYCLONE ADD (CONSTRAINT fk_HYDROCYCLONE1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE HYDROCYCLONE ADD (CONSTRAINT fk_HYDROCYCLONE2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE IMAGE_PALET_TY ADD (CONSTRAINT fk_IMAGE_PALET_TY1 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE IMAGE_PALET_TY ADD (CONSTRAINT fk_IMAGE_PALET_TY2 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE IMAGE_PALET_TY ADD (CONSTRAINT fk_IMAGE_PALET_TY3 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE INCDT_OF_NCOM ADD (CONSTRAINT fk_INCDT_OF_NCOM1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE INCDT_OF_NCOM ADD (CONSTRAINT fk_INCDT_OF_NCOM2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE INCDT_OF_NCOM ADD (CONSTRAINT fk_INCDT_OF_NCOM3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE INCDT_OF_NCOM ADD (CONSTRAINT fk_INCDT_OF_NCOM4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE INCDT_OF_NCOM ADD (CONSTRAINT fk_INCDT_OF_NCOM5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE INCDT_OF_NCOM ADD (CONSTRAINT fk_INCDT_OF_NCOM6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE INCELL ADD (CONSTRAINT fk_INCELL1 FOREIGN KEY (CELL_HEIGHT_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE INCELL ADD (CONSTRAINT fk_INCELL2 FOREIGN KEY (CELL_OFFSET_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE INCELL ADD (CONSTRAINT fk_INCELL3 FOREIGN KEY (CELL_ORNT_ANGL_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE INCELL ADD (CONSTRAINT fk_INCELL4 FOREIGN KEY (CELL_S) REFERENCES CELL (CELL_S)); ALTER TABLE INCELL ADD (CONSTRAINT fk_INCELL5 FOREIGN KEY (CELL_SPACING_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE INCELL ADD (CONSTRAINT fk_INCELL6 FOREIGN KEY (CELL_WIDTH_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE INCIDENT_INVG ADD (CONSTRAINT fk_INCIDENT_INVG1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE INCIDENT_INVG ADD (CONSTRAINT fk_INCIDENT_INVG2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE INCIDENT_INVG ADD (CONSTRAINT fk_INCIDENT_INVG3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE INCIDENT_INVG ADD (CONSTRAINT fk_INCIDENT_INVG4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE INCIDENT_INVG ADD (CONSTRAINT fk_INCIDENT_INVG5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE INCIDENT_INVG ADD (CONSTRAINT fk_INCIDENT_INVG6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE INCIDENT_REPORT ADD (CONSTRAINT fk_INCIDENT_REPORT1 FOREIGN KEY (CMPS_DOC_SPEC_S) REFERENCES CMPS_DOC_SPEC (CMPS_DOC_SPEC_S)); ALTER TABLE INCIDENT_REPORT ADD (CONSTRAINT fk_INCIDENT_REPORT2 FOREIGN KEY (INFORMATION_CNTN_S) REFERENCES DATA_COLLECTION (DATA_COLLECTION_S)); ALTER TABLE INCIDENT_REPORT ADD (CONSTRAINT fk_INCIDENT_REPORT3 FOREIGN KEY (TYP_DOC_SPEC_ID) REFERENCES TYP_DOC_SPEC (TYP_DOC_SPEC_ID)); ALTER TABLE INJECTION_FCL ADD (CONSTRAINT fk_INJECTION_FCL1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE INJECTION_FCL ADD (CONSTRAINT fk_INJECTION_FCL2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE INSL_GRVL_PACK ADD (CONSTRAINT fk_INSL_GRVL_PACK1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE INSL_GRVL_PACK ADD (CONSTRAINT fk_INSL_GRVL_PACK2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE INSL_GRVL_PACK ADD (CONSTRAINT fk_INSL_GRVL_PACK3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE INSL_GRVL_PACK ADD (CONSTRAINT fk_INSL_GRVL_PACK4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE INSL_GRVL_PACK ADD (CONSTRAINT fk_INSL_GRVL_PACK5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE INSL_GRVL_PACK ADD (CONSTRAINT fk_INSL_GRVL_PACK6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE INSL_GRVL_PACK ADD (CONSTRAINT fk_INSL_GRVL_PACK7 FOREIGN KEY (WELLBORE_S) REFERENCES WELLBORE (WELLBORE_S)); ALTER TABLE INSTALL_PLUG ADD (CONSTRAINT fk_INSTALL_PLUG1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE INSTALL_PLUG ADD (CONSTRAINT fk_INSTALL_PLUG2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE INSTALL_PLUG ADD (CONSTRAINT fk_INSTALL_PLUG3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE INSTALL_PLUG ADD (CONSTRAINT fk_INSTALL_PLUG4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE INSTALL_PLUG ADD (CONSTRAINT fk_INSTALL_PLUG5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE INSTALL_PLUG ADD (CONSTRAINT fk_INSTALL_PLUG6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE INSTALL_PLUG ADD (CONSTRAINT fk_INSTALL_PLUG7 FOREIGN KEY (WELLBORE_S) REFERENCES WELLBORE (WELLBORE_S)); ALTER TABLE INTEXT ADD (CONSTRAINT fk_INTEXT1 FOREIGN KEY (INLINE_DSPL_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE INTEXT ADD (CONSTRAINT fk_INTEXT2 FOREIGN KEY (OFFLINE_DSPL_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE INTEXT ADD (CONSTRAINT fk_INTEXT3 FOREIGN KEY (TEXT_STYLE_S) REFERENCES TEXT_STYLE (TEXT_STYLE_S)); ALTER TABLE INV_OBJ_ALIAS ADD (CONSTRAINT fk_INV_OBJ_ALIAS1 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE INV_OBJ_STOR ADD (CONSTRAINT fk_INV_OBJ_STOR1 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE INV_OBJ_STOR ADD (CONSTRAINT fk_INV_OBJ_STOR2 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE ISOLINE ADD (CONSTRAINT fk_ISOLINE1 FOREIGN KEY (ISOLINE_SET_S) REFERENCES ISOLINE_SET (ISOLINE_SET_S)); ALTER TABLE ISOLINE_SET ADD (CONSTRAINT fk_ISOLINE_SET1 FOREIGN KEY (ACRONYM) REFERENCES R_UOM (ACRONYM)); ALTER TABLE ISOLINE_SET ADD (CONSTRAINT fk_ISOLINE_SET2 FOREIGN KEY (R_PROPERTY_KIND_S) REFERENCES R_PROPERTY_KIND (R_PROPERTY_KIND_S)); ALTER TABLE ISOTOPE_TYPE ADD (CONSTRAINT fk_ISOTOPE_TYPE1 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE ISOTOPE_TYPE ADD (CONSTRAINT fk_ISOTOPE_TYPE2 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE ISOTOPE_TYPE ADD (CONSTRAINT fk_ISOTOPE_TYPE3 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE ISOTOPE_TYPE ADD (CONSTRAINT fk_ISOTOPE_TYPE4 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE JACKING_SYSTEM ADD (CONSTRAINT fk_JACKING_SYSTEM1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE JACKING_SYSTEM ADD (CONSTRAINT fk_JACKING_SYSTEM2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE JV_AGREEMENT ADD (CONSTRAINT fk_JV_AGREEMENT1 FOREIGN KEY (BSASC_S) REFERENCES BSASC (BSASC_S)); ALTER TABLE JV_AGREEMENT ADD (CONSTRAINT fk_JV_AGREEMENT2 FOREIGN KEY (CMPS_DOC_SPEC_S) REFERENCES CMPS_DOC_SPEC (CMPS_DOC_SPEC_S)); ALTER TABLE JV_AGREEMENT ADD (CONSTRAINT fk_JV_AGREEMENT3 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE JV_AGREEMENT ADD (CONSTRAINT fk_JV_AGREEMENT4 FOREIGN KEY (INFORMATION_CNTN_S) REFERENCES DATA_COLLECTION (DATA_COLLECTION_S)); ALTER TABLE JV_AGREEMENT ADD (CONSTRAINT fk_JV_AGREEMENT5 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE JV_AGREEMENT ADD (CONSTRAINT fk_JV_AGREEMENT6 FOREIGN KEY (TYP_DOC_SPEC_ID) REFERENCES TYP_DOC_SPEC (TYP_DOC_SPEC_ID)); ALTER TABLE LAND_PPRC ADD (CONSTRAINT fk_LAND_PPRC1 FOREIGN KEY (GROSS_ACREAGE_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE LAND_PPRC ADD (CONSTRAINT fk_LAND_PPRC2 FOREIGN KEY (NET_ACREAGE_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE LAND_PPRC ADD (CONSTRAINT fk_LAND_PPRC3 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE LAND_PPRC ADD (CONSTRAINT fk_LAND_PPRC4 FOREIGN KEY (SURFACE_RIGHT_S) REFERENCES SURFACE_RIGHT (SURFACE_RIGHT_S)); ALTER TABLE LAND_PPRC_ALIAS ADD (CONSTRAINT fk_LAND_PPRC_ALIAS1 FOREIGN KEY (LAND_PPRC_S) REFERENCES LAND_PPRC (LAND_PPRC_S)); ALTER TABLE LAND_PPRC_ALIAS ADD (CONSTRAINT fk_LAND_PPRC_ALIAS2 FOREIGN KEY (R_NAMING_SYSTEM_KD) REFERENCES R_NAMING_SYSTEM (R_NAMING_SYSTEM_KD)); ALTER TABLE LAND_PTY_VOL ADD (CONSTRAINT fk_LAND_PTY_VOL1 FOREIGN KEY (FLUID_COMPONENT_S) REFERENCES SPECIFIC_FL_CMPN (SPECIFIC_FL_CMPN_S)); ALTER TABLE LAND_PTY_VOL ADD (CONSTRAINT fk_LAND_PTY_VOL2 FOREIGN KEY (LAND_PPRC_S) REFERENCES LAND_PPRC (LAND_PPRC_S)); ALTER TABLE LAND_PTY_VOL ADD (CONSTRAINT fk_LAND_PTY_VOL3 FOREIGN KEY (MINERAL_RIGHT_S) REFERENCES MINERAL_RIGHT (MINERAL_RIGHT_S)); ALTER TABLE LAND_PTY_VOL ADD (CONSTRAINT fk_LAND_PTY_VOL4 FOREIGN KEY (MINERAL_ZONE_S) REFERENCES MINERAL_ZONE (MINERAL_ZONE_S)); ALTER TABLE LAND_PTY_VOL ADD (CONSTRAINT fk_LAND_PTY_VOL5 FOREIGN KEY (TYPICAL_MTRL_NAME) REFERENCES MINERAL_TYPE (TYPICAL_MTRL_NAME)); ALTER TABLE LAND_VEHICLE ADD (CONSTRAINT fk_LAND_VEHICLE1 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE LAND_VEHICLE ADD (CONSTRAINT fk_LAND_VEHICLE2 FOREIGN KEY (TYPICAL_FCL_NAME) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME)); ALTER TABLE LIFT_SYS_ANAL ADD (CONSTRAINT fk_LIFT_SYS_ANAL1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE LIFT_SYS_ANAL ADD (CONSTRAINT fk_LIFT_SYS_ANAL2 FOREIGN KEY (DURATION_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE LIFT_SYS_ANAL ADD (CONSTRAINT fk_LIFT_SYS_ANAL3 FOREIGN KEY (R_EXISTENCE_KD_NM) REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM)); ALTER TABLE LIFT_SYS_ANAL ADD (CONSTRAINT fk_LIFT_SYS_ANAL4 FOREIGN KEY (R_TRANSIENT_PERIOD) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM)); ALTER TABLE LIFT_SYS_ANAL ADD (CONSTRAINT fk_LIFT_SYS_ANAL5 FOREIGN KEY (TYPICAL_ACT_NAME) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME)); ALTER TABLE LIFT_SYS_ANAL ADD (CONSTRAINT fk_LIFT_SYS_ANAL6 FOREIGN KEY (UTILIZE_EQP_S) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S)); ALTER TABLE LIMITATION ADD (CONSTRAINT fk_LIMITATION1 FOREIGN KEY (DATA_VALUE_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE LIMITATION ADD (CONSTRAINT fk_LIMITATION2 FOREIGN KEY (LIMITATION_SET_S) REFERENCES LIMITATION_SET (LIMITATION_SET_S)); ALTER TABLE LIMITATION ADD (CONSTRAINT fk_LIMITATION3 FOREIGN KEY (R_LIMITATION_KIND) REFERENCES R_LIMITATION (R_LIMITATION_KIND)); ALTER TABLE LIMITATION_SET ADD (CONSTRAINT fk_LIMITATION_SET1 FOREIGN KEY (CMPS_DOC_SPEC_S) REFERENCES CMPS_DOC_SPEC (CMPS_DOC_SPEC_S)); ALTER TABLE LIMITATION_SET ADD (CONSTRAINT fk_LIMITATION_SET2 FOREIGN KEY (INFORMATION_CNTN_S) REFERENCES DATA_COLLECTION (DATA_COLLECTION_S)); ALTER TABLE LIMITATION_SET ADD (CONSTRAINT fk_LIMITATION_SET3 FOREIGN KEY (TYP_DOC_SPEC_ID) REFERENCES TYP_DOC_SPEC (TYP_DOC_SPEC_ID)); ALTER TABLE LINE_ELEMENT ADD (CONSTRAINT fk_LINE_ELEMENT1 FOREIGN KEY (CELL_S) REFERENCES CELL (CELL_S)); ALTER TABLE LINE_ELEMENT ADD (CONSTRAINT fk_LINE_ELEMENT2 FOREIGN KEY (GRAPH_ELE_CMPN_S) REFERENCES CMPS_GRAPH_ELE (CMPS_GRAPH_ELE_S)); ALTER TABLE LINE_ELEMENT ADD (CONSTRAINT fk_LINE_ELEMENT3 FOREIGN KEY (LINE_STYLE_TYPE_ID) REFERENCES LINE_STYLE_TYPE (LINE_STYLE_TYPE_ID)); ALTER TABLE LINE_ELEMENT ADD (CONSTRAINT fk_LINE_ELEMENT4 FOREIGN KEY (TEXT_STYLE_TYPE_ID) REFERENCES TEXT_STYLE_TYPE (TEXT_STYLE_TYPE_ID)); ALTER TABLE LINE_PATTERN ADD (CONSTRAINT fk_LINE_PATTERN1 FOREIGN KEY (LINE_PATTERN_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE LINE_STYLE ADD (CONSTRAINT fk_LINE_STYLE1 FOREIGN KEY (LINE_PATTERN_S) REFERENCES LINE_PATTERN (LINE_PATTERN_S)); ALTER TABLE LINE_STYLE ADD (CONSTRAINT fk_LINE_STYLE2 FOREIGN KEY (LINE_STYLE_TYPE_ID) REFERENCES LINE_STYLE_TYPE (LINE_STYLE_TYPE_ID)); ALTER TABLE LINE_STYLE ADD (CONSTRAINT fk_LINE_STYLE3 FOREIGN KEY (LINE_WIDTH_U) REFERENCES R_UOM (ACRONYM)); ALTER TABLE LINE_STYLE ADD (CONSTRAINT fk_LINE_STYLE4 FOREIGN KEY (R_COLOR_NAME) REFERENCES R_COLOR (R_COLOR_NAME)); ALTER TABLE LINE_STYLE ADD (CONSTRAINT fk_LINE_STYLE5 FOREIGN KEY (SYMBOL_LIBRARY_ID) REFERENCES SYMBOL_LIBRARY (SYMBOL_LIBRARY_ID)); ALTER TABLE LINE_STYLE_TYPE ADD (CONSTRAINT fk_LINE_STYLE_TYPE1 FOREIGN KEY (SOURCE) REFERENCES R_SOURCE (R_SOURCE_NAME)); ALTER TABLE LINE_STYLE_TYPE ADD (CONSTRAINT fk_LINE_STYLE_TYPE2 FOREIGN KEY (SOURCE_REFERENCE_S) REFERENCES R_SOURCE_REF (R_SOURCE_REF_S)); ALTER TABLE LINE_STYLE_TYPE ADD (CONSTRAINT fk_LINE_STYLE_TYPE3 FOREIGN KEY (VERSION) REFERENCES R_EPCNT_VERSION (NAME)); ALTER TABLE LITHOLOGIC_ANAL ADD (CONSTRAINT fk_LITHOLOGIC_ANAL1 FOREIGN KEY (COST_U) REFERENCES R_CURRENCY_UNIT (ACRONYM)); ALTER TABLE LITHOLOGIC_ANAL ADD (CONSTRAINT fk_LITHOLOGIC_ANAL2 FOREIGN KEY (DURAT