SET FEEDBACK OFF
ALTER TABLE DATA_VALUE_A ADD (CONSTRAINT fk_DATA_VALUE_A1
   FOREIGN KEY (P_GEOMETRY_2D_GIS_S)
   REFERENCES P_GEOMETRY_2D_GIS (INSTANCE_S));
ALTER TABLE ACTIVITY ADD (CONSTRAINT fk_ACTIVITY1
   FOREIGN KEY (CONTAINING_ACTIVITY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY ADD (CONSTRAINT fk_ACTIVITY2
   FOREIGN KEY (COST_U)
   REFERENCES R_CURRENCY_UNIT (ACRONYM));
ALTER TABLE ACTIVITY ADD (CONSTRAINT fk_ACTIVITY3
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE ACTIVITY ADD (CONSTRAINT fk_ACTIVITY4
   FOREIGN KEY (KIND_S)
   REFERENCES ACTIVITY_CLASS (INSTANCE_S));
ALTER TABLE ACTIVITY ADD (CONSTRAINT fk_ACTIVITY5
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE ACTIVITY ADD (CONSTRAINT fk_ACTIVITY6
   FOREIGN KEY (R_EXISTENCE_KIND)
   REFERENCES R_EXISTENCE_KIND (IDENTIFIER));
ALTER TABLE ACTIVITY ADD (CONSTRAINT fk_ACTIVITY7
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE ACTIVITY_ACTIVITY_INVOLVEMENT ADD (CONSTRAINT fk_ACTIVITY_ACTIVITY_INVOLVE1
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY_ACTIVITY_INVOLVEMENT ADD (CONSTRAINT fk_ACTIVITY_ACTIVITY_INVOLVE2
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE ACTIVITY_ACTIVITY_INVOLVEMENT ADD (CONSTRAINT fk_ACTIVITY_ACTIVITY_INVOLVE3
   FOREIGN KEY (INVOLVED_ACTIVITY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY_ACTIVITY_INVOLVEMENT ADD (CONSTRAINT fk_ACTIVITY_ACTIVITY_INVOLVE4
   FOREIGN KEY (INVOLVEMENT_ROLE)
   REFERENCES R_ACTIVITY_INVOLVEMENT_ROLE (IDENTIFIER));
ALTER TABLE ACTIVITY_ACTIVITY_INVOLVEMENT ADD (CONSTRAINT fk_ACTIVITY_ACTIVITY_INVOLVE5
   FOREIGN KEY (INVOLVING_ACTIVITY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY_ACTIVITY_INVOLVEMENT ADD (CONSTRAINT fk_ACTIVITY_ACTIVITY_INVOLVE6
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE ACTIVITY_ACTIVITY_INVOLVEMENT ADD (CONSTRAINT fk_ACTIVITY_ACTIVITY_INVOLVE7
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY_ALIAS ADD (CONSTRAINT fk_ACTIVITY_ALIAS1
   FOREIGN KEY (ALIASED_OBJECT_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY_ALIAS ADD (CONSTRAINT fk_ACTIVITY_ALIAS2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE ACTIVITY_ALIAS ADD (CONSTRAINT fk_ACTIVITY_ALIAS3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE ACTIVITY_CAUSE_AND_EFFECT ADD (CONSTRAINT fk_ACTIVITY_CAUSE_AND_EFFECT1
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY_CAUSE_AND_EFFECT ADD (CONSTRAINT fk_ACTIVITY_CAUSE_AND_EFFECT2
   FOREIGN KEY (RESULT_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY_CLASS ADD (CONSTRAINT fk_ACTIVITY_CLASS1
   FOREIGN KEY (ARCHETYPE_TYPICAL_S)
   REFERENCES TYPICAL_ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY_CLASS ADD (CONSTRAINT fk_ACTIVITY_CLASS2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE ACTIVITY_CLASS ADD (CONSTRAINT fk_ACTIVITY_CLASS3
   FOREIGN KEY (PARENT_CLASS_S)
   REFERENCES ACTIVITY_CLASS (INSTANCE_S));
ALTER TABLE ACTIVITY_CLASS ADD (CONSTRAINT fk_ACTIVITY_CLASS4
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE ACTIVITY_CLASSIFICATION ADD (CONSTRAINT fk_ACTIVITY_CLASSIFICATION1
   FOREIGN KEY (ACTIVITY_CLASS_S)
   REFERENCES ACTIVITY_CLASS (INSTANCE_S));
ALTER TABLE ACTIVITY_CLASSIFICATION ADD (CONSTRAINT fk_ACTIVITY_CLASSIFICATION2
   FOREIGN KEY (ACTIVITY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY_CLASSIFICATION ADD (CONSTRAINT fk_ACTIVITY_CLASSIFICATION3
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY_CLASSIFICATION ADD (CONSTRAINT fk_ACTIVITY_CLASSIFICATION4
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE ACTIVITY_CLASSIFICATION ADD (CONSTRAINT fk_ACTIVITY_CLASSIFICATION5
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE ACTIVITY_CLASSIFICATION ADD (CONSTRAINT fk_ACTIVITY_CLASSIFICATION6
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY_CLASS_CLASSIFICATION ADD (CONSTRAINT fk_ACTIVITY_CLASS_CLASSIFICA1
   FOREIGN KEY (BE_CLASSIFIED_AS_S)
   REFERENCES ACTIVITY_CLASS (INSTANCE_S));
ALTER TABLE ACTIVITY_CLASS_CLASSIFICATION ADD (CONSTRAINT fk_ACTIVITY_CLASS_CLASSIFICA2
   FOREIGN KEY (HAVE_AS_A_MEMBER_S)
   REFERENCES ACTIVITY_CLASS (INSTANCE_S));
ALTER TABLE ACTIVITY_CLASS_CLASSIFICATION ADD (CONSTRAINT fk_ACTIVITY_CLASS_CLASSIFICA3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE ACTIVITY_FULFILLMENT ADD (CONSTRAINT fk_ACTIVITY_FULFILLMENT1
   FOREIGN KEY (FULFILLMENT_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY_FULFILLMENT ADD (CONSTRAINT fk_ACTIVITY_FULFILLMENT2
   FOREIGN KEY (FULFILL_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY_FULFILLMENT ADD (CONSTRAINT fk_ACTIVITY_FULFILLMENT3
   FOREIGN KEY (RELATIVE_TIME_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE ACTIVITY_SUBJECT_TO_GUIDELINE ADD (CONSTRAINT fk_ACTIVITY_SUBJECT_TO_GUIDE1
   FOREIGN KEY (ACTIVITY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY_SUBJECT_TO_GUIDELINE ADD (CONSTRAINT fk_ACTIVITY_SUBJECT_TO_GUIDE2
   FOREIGN KEY (GUIDELINE_OR_PRIVILEGE_S)
   REFERENCES GUIDELINE_OR_PRIVILEGE (INSTANCE_S));
ALTER TABLE ACTIVITY_TEMPLATE ADD (CONSTRAINT fk_ACTIVITY_TEMPLATE1
   FOREIGN KEY (DESCRIBED_ACTIVITY_S)
   REFERENCES TYPICAL_ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY_TEMPLATE ADD (CONSTRAINT fk_ACTIVITY_TEMPLATE2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE ACTIVITY_TEMPLATE ADD (CONSTRAINT fk_ACTIVITY_TEMPLATE3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE ACTIVITY_TEMPLATE_COMPOSITION ADD (CONSTRAINT fk_ACTIVITY_TEMPLATE_COMPOSI1
   FOREIGN KEY (ACTIVITY_TEMPLATE_S)
   REFERENCES ACTIVITY_TEMPLATE (INSTANCE_S));
ALTER TABLE ACTIVITY_TEMPLATE_COMPOSITION ADD (CONSTRAINT fk_ACTIVITY_TEMPLATE_COMPOSI2
   FOREIGN KEY (TYPICAL_ACTIVITY_S)
   REFERENCES TYPICAL_ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY_TEMPLATE_CONSTRAINT ADD (CONSTRAINT fk_ACTIVITY_TEMPLATE_CONSTRA1
   FOREIGN KEY (ACTIVITY_TEMPLATE_S)
   REFERENCES ACTIVITY_TEMPLATE (INSTANCE_S));
ALTER TABLE ACTIVITY_TEMPLATE_CONSTRAINT ADD (CONSTRAINT fk_ACTIVITY_TEMPLATE_CONSTRA2
   FOREIGN KEY (CONSTRAINED_BY_S)
   REFERENCES TYPICAL_ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY_TEMPLATE_CONSTRAINT ADD (CONSTRAINT fk_ACTIVITY_TEMPLATE_CONSTRA3
   FOREIGN KEY (CONSTRAINT_FOR_S)
   REFERENCES TYPICAL_ACTIVITY (INSTANCE_S));
ALTER TABLE ACTIVITY_TEMPLATE_CONSTRAINT ADD (CONSTRAINT fk_ACTIVITY_TEMPLATE_CONSTRA4
   FOREIGN KEY (R_TEMPLATE_CONSTRAINT_KIND)
   REFERENCES R_TEMPLATE_CONSTRAINT_KIND (IDENTIFIER));
ALTER TABLE ADDRESS ADD (CONSTRAINT fk_ADDRESS1
   FOREIGN KEY (BUSINESS_ASSOCIATE_S)
   REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S));
ALTER TABLE ADDRESS ADD (CONSTRAINT fk_ADDRESS2
   FOREIGN KEY (PHYSICAL_ADDRESS_S)
   REFERENCES ADDRESS (INSTANCE_S));
ALTER TABLE ADDRESS ADD (CONSTRAINT fk_ADDRESS3
   FOREIGN KEY (POSTAL_CODE_S)
   REFERENCES R_POSTAL_CODE (INSTANCE_S));
ALTER TABLE ADDRESS ADD (CONSTRAINT fk_ADDRESS4
   FOREIGN KEY (R_ADDRESS_QUALIFIER)
   REFERENCES R_ADDRESS_QUALIFIER (IDENTIFIER));
ALTER TABLE ALLOCATED_FLOW_STREAM ADD (CONSTRAINT fk_ALLOCATED_FLOW_STREAM1
   FOREIGN KEY (PFNU_PORT_S)
   REFERENCES PFNU_PORT (INSTANCE_S));
ALTER TABLE ALLOWABLE_FLOW_STREAM ADD (CONSTRAINT fk_ALLOWABLE_FLOW_STREAM1
   FOREIGN KEY (PFNU_PORT_S)
   REFERENCES PFNU_PORT (INSTANCE_S));
ALTER TABLE ALLOWABLE_FLOW_STREAM ADD (CONSTRAINT fk_ALLOWABLE_FLOW_STREAM2
   FOREIGN KEY (R_ALLOWABLE)
   REFERENCES R_ALLOWABLE (IDENTIFIER));
ALTER TABLE APPLICATION_FOR_PERMIT ADD (CONSTRAINT fk_APPLICATION_FOR_PERMIT1
   FOREIGN KEY (KIND_S)
   REFERENCES DOCUMENT_SPECIFICATION_CLASS (INSTANCE_S));
ALTER TABLE APPLICATION_FOR_PERMIT ADD (CONSTRAINT fk_APPLICATION_FOR_PERMIT2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE AREA_CELL ADD (CONSTRAINT fk_AREA_CELL1
   FOREIGN KEY (CELL_HEIGHT_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE AREA_CELL ADD (CONSTRAINT fk_AREA_CELL2
   FOREIGN KEY (CELL_ORIENTATION_ANGLE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE AREA_CELL ADD (CONSTRAINT fk_AREA_CELL3
   FOREIGN KEY (CELL_S)
   REFERENCES CELL (INSTANCE_S));
ALTER TABLE AREA_CELL ADD (CONSTRAINT fk_AREA_CELL4
   FOREIGN KEY (CELL_WIDTH_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE AREA_CELL ADD (CONSTRAINT fk_AREA_CELL5
   FOREIGN KEY (HORIZONTAL_OFFSET_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE AREA_CELL ADD (CONSTRAINT fk_AREA_CELL6
   FOREIGN KEY (HORIZONTAL_SPACING_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE AREA_CELL ADD (CONSTRAINT fk_AREA_CELL7
   FOREIGN KEY (VERTICAL_OFFSET_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE AREA_CELL ADD (CONSTRAINT fk_AREA_CELL8
   FOREIGN KEY (VERTICAL_SPACING_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE AREA_ELEMENT ADD (CONSTRAINT fk_AREA_ELEMENT1
   FOREIGN KEY (CELL_S)
   REFERENCES CELL (INSTANCE_S));
ALTER TABLE AREA_ELEMENT ADD (CONSTRAINT fk_AREA_ELEMENT2
   FOREIGN KEY (GRAPHICAL_ELEMENT_COMPONENT_S)
   REFERENCES COMPOSITE_GRAPHICAL_ELEMENT (INSTANCE_S));
ALTER TABLE AREA_ELEMENT ADD (CONSTRAINT fk_AREA_ELEMENT3
   FOREIGN KEY (IMAGE_PALETTE_TYPE)
   REFERENCES R_IMAGE_PALETTE_TYPE (IDENTIFIER));
ALTER TABLE AREA_ELEMENT ADD (CONSTRAINT fk_AREA_ELEMENT4
   FOREIGN KEY (PATTERN_FILL_TYPE)
   REFERENCES R_PATTERN_FILL_TYPE (IDENTIFIER));
ALTER TABLE AREA_ELEMENT ADD (CONSTRAINT fk_AREA_ELEMENT5
   FOREIGN KEY (PATTERN_ORIENTATION_ANGLE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE AREA_PATTERN_CELL_INCLUSION ADD (CONSTRAINT fk_AREA_PATTERN_CELL_INCLUSI1
   FOREIGN KEY (AREA_CELL_S)
   REFERENCES AREA_CELL (INSTANCE_S));
ALTER TABLE AREA_PATTERN_CELL_INCLUSION ADD (CONSTRAINT fk_AREA_PATTERN_CELL_INCLUSI2
   FOREIGN KEY (AREA_PATTERN_FILL_S)
   REFERENCES AREA_PATTERN_FILL (INSTANCE_S));
ALTER TABLE AREA_PATTERN_FILL ADD (CONSTRAINT fk_AREA_PATTERN_FILL1
   FOREIGN KEY (PATTERN_FILL_TYPE)
   REFERENCES R_PATTERN_FILL_TYPE (IDENTIFIER));
ALTER TABLE AREA_PATTERN_FILL ADD (CONSTRAINT fk_AREA_PATTERN_FILL2
   FOREIGN KEY (R_COLOR)
   REFERENCES R_COLOR (IDENTIFIER));
ALTER TABLE AREA_PATTERN_FILL ADD (CONSTRAINT fk_AREA_PATTERN_FILL3
   FOREIGN KEY (SYMBOL_LIBRARY_S)
   REFERENCES SYMBOL_LIBRARY (INSTANCE_S));
ALTER TABLE AREA_PATTERN_FILL_COMPOSITION ADD (CONSTRAINT fk_AREA_PATTERN_FILL_COMPOSI1
   FOREIGN KEY (AREA_PATTERN_FILL_S)
   REFERENCES AREA_PATTERN_FILL (INSTANCE_S));
ALTER TABLE AREA_PATTERN_FILL_COMPOSITION ADD (CONSTRAINT fk_AREA_PATTERN_FILL_COMPOSI2
   FOREIGN KEY (HATCH_LINE_PATTERN_S)
   REFERENCES HATCH_LINE_PATTERN (INSTANCE_S));
ALTER TABLE AXIS_TYPE_ALTERNATIVE ADD (CONSTRAINT fk_AXIS_TYPE_ALTERNATIVE1
   FOREIGN KEY (AXIS_TYPE)
   REFERENCES R_AXIS_TYPE (IDENTIFIER));
ALTER TABLE AXIS_TYPE_ALTERNATIVE ADD (CONSTRAINT fk_AXIS_TYPE_ALTERNATIVE2
   FOREIGN KEY (PROPERTY_KIND_S)
   REFERENCES PROPERTY_KIND (INSTANCE_S));
ALTER TABLE AXIS_TYPE_ALTERNATIVE ADD (CONSTRAINT fk_AXIS_TYPE_ALTERNATIVE3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE BINSET_GRID_UID_USAGE ADD (CONSTRAINT fk_BINSET_GRID_UID_USAGE1
   FOREIGN KEY (BINSET_GRID_S)
   REFERENCES GEOPHYSICAL_PROCESSING_GRID (INSTANCE_S));
ALTER TABLE BINSET_GRID_UID_USAGE ADD (CONSTRAINT fk_BINSET_GRID_UID_USAGE2
   FOREIGN KEY (SEISMIC_GEOMETRY_SET_S)
   REFERENCES GEOPHYSICAL_GEOMETRY_SET (INSTANCE_S));
ALTER TABLE BOREHOLE_COMPONENT ADD (CONSTRAINT fk_BOREHOLE_COMPONENT1
   FOREIGN KEY (BOREHOLE_COMPONENT_LENGTH_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BOREHOLE_COMPONENT ADD (CONSTRAINT fk_BOREHOLE_COMPONENT2
   FOREIGN KEY (DIAMETER_CRUSH_ZONE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BOREHOLE_COMPONENT ADD (CONSTRAINT fk_BOREHOLE_COMPONENT3
   FOREIGN KEY (KIND_S)
   REFERENCES FACILITY_CLASS (INSTANCE_S));
ALTER TABLE BOREHOLE_COMPONENT ADD (CONSTRAINT fk_BOREHOLE_COMPONENT4
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE BOREHOLE_COMPONENT ADD (CONSTRAINT fk_BOREHOLE_COMPONENT5
   FOREIGN KEY (OUTER_DIAMETER_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BOREHOLE_COMPONENT ADD (CONSTRAINT fk_BOREHOLE_COMPONENT6
   FOREIGN KEY (R_DIAMETER)
   REFERENCES R_DIAMETER (IDENTIFIER));
ALTER TABLE BOREHOLE_COMPONENT ADD (CONSTRAINT fk_BOREHOLE_COMPONENT7
   FOREIGN KEY (R_EXISTENCE_KIND)
   REFERENCES R_EXISTENCE_KIND (IDENTIFIER));
ALTER TABLE BOREHOLE_COMPONENT ADD (CONSTRAINT fk_BOREHOLE_COMPONENT8
   FOREIGN KEY (R_PERFORATION)
   REFERENCES R_PERFORATION (IDENTIFIER));
ALTER TABLE BOREHOLE_COMPONENT ADD (CONSTRAINT fk_BOREHOLE_COMPONENT9
   FOREIGN KEY (SHOT_ANGLE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BOREHOLE_COMPONENT ADD (CONSTRAINT fk_BOREHOLE_COMPONENT10
   FOREIGN KEY (SHOT_DENSITY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BOREHOLE_COMPONENT ADD (CONSTRAINT fk_BOREHOLE_COMPONENT11
   FOREIGN KEY (SHOT_DIAMETER_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BOREHOLE_COMPONENT ADD (CONSTRAINT fk_BOREHOLE_COMPONENT12
   FOREIGN KEY (SHOT_LENGTH_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BOREHOLE_COMPONENT ADD (CONSTRAINT fk_BOREHOLE_COMPONENT13
   FOREIGN KEY (SHOT_PHASE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BOREHOLE_COMPONENT ADD (CONSTRAINT fk_BOREHOLE_COMPONENT14
   FOREIGN KEY (WELLBORE_S)
   REFERENCES WELLBORE (INSTANCE_S));
ALTER TABLE BOREHOLE_COMPONENT ADD (CONSTRAINT fk_BOREHOLE_COMPONENT15
   FOREIGN KEY (WELL_COMPLETION_S)
   REFERENCES WELL_COMPLETION (INSTANCE_S));
ALTER TABLE BULK_MATERIAL ADD (CONSTRAINT fk_BULK_MATERIAL1
   FOREIGN KEY (BASE_MISSING_SECTION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BULK_MATERIAL ADD (CONSTRAINT fk_BULK_MATERIAL2
   FOREIGN KEY (COMBINED_TO_CREATE_S)
   REFERENCES BULK_MATERIAL (INSTANCE_S));
ALTER TABLE BULK_MATERIAL ADD (CONSTRAINT fk_BULK_MATERIAL3
   FOREIGN KEY (DRILLSTRING_S)
   REFERENCES WELLBORE_TUBULAR (INSTANCE_S));
ALTER TABLE BULK_MATERIAL ADD (CONSTRAINT fk_BULK_MATERIAL4
   FOREIGN KEY (FLUID_SYSTEM_S)
   REFERENCES BULK_MATERIAL (INSTANCE_S));
ALTER TABLE BULK_MATERIAL ADD (CONSTRAINT fk_BULK_MATERIAL5
   FOREIGN KEY (KIND_S)
   REFERENCES MATERIAL_CLASS (INSTANCE_S));
ALTER TABLE BULK_MATERIAL ADD (CONSTRAINT fk_BULK_MATERIAL6
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE BULK_MATERIAL ADD (CONSTRAINT fk_BULK_MATERIAL7
   FOREIGN KEY (OUTCROP_S)
   REFERENCES GEOLOGIC_FEATURE (INSTANCE_S));
ALTER TABLE BULK_MATERIAL ADD (CONSTRAINT fk_BULK_MATERIAL8
   FOREIGN KEY (ROCK_MATERIAL_S)
   REFERENCES BULK_MATERIAL (INSTANCE_S));
ALTER TABLE BULK_MATERIAL ADD (CONSTRAINT fk_BULK_MATERIAL9
   FOREIGN KEY (R_DIAMETER)
   REFERENCES R_DIAMETER (IDENTIFIER));
ALTER TABLE BULK_MATERIAL ADD (CONSTRAINT fk_BULK_MATERIAL10
   FOREIGN KEY (R_EXISTENCE_KIND)
   REFERENCES R_EXISTENCE_KIND (IDENTIFIER));
ALTER TABLE BULK_MATERIAL ADD (CONSTRAINT fk_BULK_MATERIAL11
   FOREIGN KEY (SAMPLE_THICKNESS_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BULK_MATERIAL ADD (CONSTRAINT fk_BULK_MATERIAL12
   FOREIGN KEY (TIME_TO_SURFACE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BULK_MATERIAL ADD (CONSTRAINT fk_BULK_MATERIAL13
   FOREIGN KEY (TOP_MISSING_SECTION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BULK_MATERIAL ADD (CONSTRAINT fk_BULK_MATERIAL14
   FOREIGN KEY (WELLBORE_S)
   REFERENCES WELLBORE (INSTANCE_S));
ALTER TABLE BULK_MATERIAL ADD (CONSTRAINT fk_BULK_MATERIAL15
   FOREIGN KEY (WELL_TEST_RECOVERY_S)
   REFERENCES BULK_MATERIAL (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOCIATE ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE1
   FOREIGN KEY (KIND)
   REFERENCES R_BUSINESS_ASSOCIATE (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOCIATE ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOCIATE_ALIAS ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_ALIAS1
   FOREIGN KEY (ALIASED_OBJECT_S)
   REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOCIATE_ALIAS ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_ALIAS2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOCIATE_ALIAS ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_ALIAS3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOCIATE_INJURY ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_INJURY1
   FOREIGN KEY (BUSINESS_ASSOCIATE_S)
   REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOCIATE_INJURY ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_INJURY2
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOCIATE_INJURY ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_INJURY3
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BUSINESS_ASSOCIATE_INJURY ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_INJURY4
   FOREIGN KEY (LOST_TIME_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BUSINESS_ASSOCIATE_INJURY ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_INJURY5
   FOREIGN KEY (MONETARY_LOSS_U)
   REFERENCES R_CURRENCY_UNIT (ACRONYM));
ALTER TABLE BUSINESS_ASSOCIATE_INJURY ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_INJURY6
   FOREIGN KEY (R_BUSINESS_ASSOCIATE_INJURY)
   REFERENCES R_BUSINESS_ASSOCIATE_INJURY (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOCIATE_INJURY ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_INJURY7
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOCIATE_INJURY ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_INJURY8
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOCIATE_JOB_TITLE ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_JOB_TI1
   FOREIGN KEY (BUSINESS_ASSOCIATION_S)
   REFERENCES BUSINESS_ASSOCIATION (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOCIATE_JOB_TITLE ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_JOB_TI2
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOCIATE_JOB_TITLE ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_JOB_TI3
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BUSINESS_ASSOCIATE_JOB_TITLE ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_JOB_TI4
   FOREIGN KEY (R_BUSINESS_ASSOC_JOB_TITLE)
   REFERENCES R_BUSINESS_ASSOC_JOB_TITLE (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOCIATE_JOB_TITLE ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_JOB_TI5
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOCIATE_JOB_TITLE ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_JOB_TI6
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOCIATE_SERVICE ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_SERVIC1
   FOREIGN KEY (BUSINESS_ASSOCIATE_S)
   REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOCIATE_SERVICE ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_SERVIC2
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOCIATE_SERVICE ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_SERVIC3
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BUSINESS_ASSOCIATE_SERVICE ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_SERVIC4
   FOREIGN KEY (R_BUSINESS_ASSOCIATE_SERVICE)
   REFERENCES R_BUSINESS_ASSOCIATE_SERVICE (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOCIATE_SERVICE ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_SERVIC5
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOCIATE_SERVICE ADD (CONSTRAINT fk_BUSINESS_ASSOCIATE_SERVIC6
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOCIATION ADD (CONSTRAINT fk_BUSINESS_ASSOCIATION1
   FOREIGN KEY (ASSOCIATED_WITH_S)
   REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOCIATION ADD (CONSTRAINT fk_BUSINESS_ASSOCIATION2
   FOREIGN KEY (BUSINESS_ASSOCIATE_S)
   REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOCIATION ADD (CONSTRAINT fk_BUSINESS_ASSOCIATION3
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOCIATION ADD (CONSTRAINT fk_BUSINESS_ASSOCIATION4
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BUSINESS_ASSOCIATION ADD (CONSTRAINT fk_BUSINESS_ASSOCIATION5
   FOREIGN KEY (R_BUSINESS_ASSOCIATION_ROLE)
   REFERENCES R_BUSINESS_ASSOCIATION_ROLE (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOCIATION ADD (CONSTRAINT fk_BUSINESS_ASSOCIATION6
   FOREIGN KEY (R_BUS_ASSN_STRUCTURE)
   REFERENCES R_BUS_ASSN_STRUCTURE (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOCIATION ADD (CONSTRAINT fk_BUSINESS_ASSOCIATION7
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOCIATION ADD (CONSTRAINT fk_BUSINESS_ASSOCIATION8
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOC_EARTH_FTR_ROLE ADD (CONSTRAINT fk_BUSINESS_ASSOC_EARTH_FTR_1
   FOREIGN KEY (BUSINESS_ASSOCIATE_S)
   REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOC_EARTH_FTR_ROLE ADD (CONSTRAINT fk_BUSINESS_ASSOC_EARTH_FTR_2
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOC_EARTH_FTR_ROLE ADD (CONSTRAINT fk_BUSINESS_ASSOC_EARTH_FTR_3
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BUSINESS_ASSOC_EARTH_FTR_ROLE ADD (CONSTRAINT fk_BUSINESS_ASSOC_EARTH_FTR_4
   FOREIGN KEY (R_BUSINESS_ASSOC_EARTH_FTR)
   REFERENCES R_BUSINESS_ASSOC_EARTH_FTR (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOC_EARTH_FTR_ROLE ADD (CONSTRAINT fk_BUSINESS_ASSOC_EARTH_FTR_5
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOC_EARTH_FTR_ROLE ADD (CONSTRAINT fk_BUSINESS_ASSOC_EARTH_FTR_6
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOC_FACILITY_INVOLV ADD (CONSTRAINT fk_BUSINESS_ASSOC_FACILITY_I1
   FOREIGN KEY (BUSINESS_ASSOCIATE_S)
   REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOC_FACILITY_INVOLV ADD (CONSTRAINT fk_BUSINESS_ASSOC_FACILITY_I2
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOC_FACILITY_INVOLV ADD (CONSTRAINT fk_BUSINESS_ASSOC_FACILITY_I3
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BUSINESS_ASSOC_FACILITY_INVOLV ADD (CONSTRAINT fk_BUSINESS_ASSOC_FACILITY_I4
   FOREIGN KEY (INVOLVEMENT_ROLE)
   REFERENCES R_BUSINESS_ASSOC_FCL_ROLE (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOC_FACILITY_INVOLV ADD (CONSTRAINT fk_BUSINESS_ASSOC_FACILITY_I5
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOC_FACILITY_INVOLV ADD (CONSTRAINT fk_BUSINESS_ASSOC_FACILITY_I6
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOC_SECURITY_STATUS ADD (CONSTRAINT fk_BUSINESS_ASSOC_SECURITY_S1
   FOREIGN KEY (BUSINESS_ASSOCIATE_S)
   REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOC_SECURITY_STATUS ADD (CONSTRAINT fk_BUSINESS_ASSOC_SECURITY_S2
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE BUSINESS_ASSOC_SECURITY_STATUS ADD (CONSTRAINT fk_BUSINESS_ASSOC_SECURITY_S3
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BUSINESS_ASSOC_SECURITY_STATUS ADD (CONSTRAINT fk_BUSINESS_ASSOC_SECURITY_S4
   FOREIGN KEY (R_BUSINESS_ASSOCIATION_ROLE)
   REFERENCES R_BUSINESS_ASSOCIATION_ROLE (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOC_SECURITY_STATUS ADD (CONSTRAINT fk_BUSINESS_ASSOC_SECURITY_S5
   FOREIGN KEY (R_BUS_ASSOC_SECURITY_CLASS)
   REFERENCES R_BUS_ASSOC_SECURITY_CLASS (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOC_SECURITY_STATUS ADD (CONSTRAINT fk_BUSINESS_ASSOC_SECURITY_S6
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE BUSINESS_ASSOC_SECURITY_STATUS ADD (CONSTRAINT fk_BUSINESS_ASSOC_SECURITY_S7
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE BUSINESS_CONTACT ADD (CONSTRAINT fk_BUSINESS_CONTACT1
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE BUSINESS_CONTACT ADD (CONSTRAINT fk_BUSINESS_CONTACT2
   FOREIGN KEY (CONTACTEE_S)
   REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S));
ALTER TABLE BUSINESS_CONTACT ADD (CONSTRAINT fk_BUSINESS_CONTACT3
   FOREIGN KEY (CONTACTOR_S)
   REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S));
ALTER TABLE BUSINESS_CONTACT ADD (CONSTRAINT fk_BUSINESS_CONTACT4
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE BUSINESS_CONTACT ADD (CONSTRAINT fk_BUSINESS_CONTACT5
   FOREIGN KEY (R_BUSINESS_CONTACT_PURPOSE)
   REFERENCES R_BUSINESS_CONTACT_PURPOSE (IDENTIFIER));
ALTER TABLE BUSINESS_CONTACT ADD (CONSTRAINT fk_BUSINESS_CONTACT6
   FOREIGN KEY (R_BUSINESS_CONTACT_RESULT)
   REFERENCES R_BUSINESS_CONTACT_RESULT (IDENTIFIER));
ALTER TABLE BUSINESS_CONTACT ADD (CONSTRAINT fk_BUSINESS_CONTACT7
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE BUSINESS_CONTACT ADD (CONSTRAINT fk_BUSINESS_CONTACT8
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE CAPILLARY_PRESSURE_CURVE ADD (CONSTRAINT fk_CAPILLARY_PRESSURE_CURVE1
   FOREIGN KEY (R_CAPILLARY_PRESSURE)
   REFERENCES R_CAPILLARY_PRESSURE (IDENTIFIER));
ALTER TABLE CAPILLARY_PRESSURE_POINT ADD (CONSTRAINT fk_CAPILLARY_PRESSURE_POINT1
   FOREIGN KEY (CAPILLARY_PRESSURE_CURVE_S)
   REFERENCES CAPILLARY_PRESSURE_CURVE (INSTANCE_S));
ALTER TABLE CAPILLARY_PRESSURE_POINT ADD (CONSTRAINT fk_CAPILLARY_PRESSURE_POINT2
   FOREIGN KEY (R_CAPILLARY_PRESSURE)
   REFERENCES R_CAPILLARY_PRESSURE (IDENTIFIER));
ALTER TABLE CAPILLARY_PRESSURE_POINT ADD (CONSTRAINT fk_CAPILLARY_PRESSURE_POINT3
   FOREIGN KEY (R_CAPILLARY_PRESSURE_USAGE)
   REFERENCES R_CAPILLARY_PRESSURE_USAGE (IDENTIFIER));
ALTER TABLE CARTER_LEGAL_SURVEY_AREA ADD (CONSTRAINT fk_CARTER_LEGAL_SURVEY_AREA1
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE CARTER_LEGAL_SURVEY_AREA ADD (CONSTRAINT fk_CARTER_LEGAL_SURVEY_AREA2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE CARTER_LEGAL_SURVEY_AREA ADD (CONSTRAINT fk_CARTER_LEGAL_SURVEY_AREA3
   FOREIGN KEY (R_EAST_OR_WEST)
   REFERENCES R_EAST_OR_WEST (IDENTIFIER));
ALTER TABLE CARTER_LEGAL_SURVEY_AREA ADD (CONSTRAINT fk_CARTER_LEGAL_SURVEY_AREA4
   FOREIGN KEY (R_NORTH_OR_SOUTH)
   REFERENCES R_NORTH_OR_SOUTH (IDENTIFIER));
ALTER TABLE CARTER_LEGAL_SURVEY_AREA ADD (CONSTRAINT fk_CARTER_LEGAL_SURVEY_AREA5
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE CELL ADD (CONSTRAINT fk_CELL1
   FOREIGN KEY (SYMBOL_LIBRARY_S)
   REFERENCES SYMBOL_LIBRARY (INSTANCE_S));
ALTER TABLE CELL ADD (CONSTRAINT fk_CELL2
   FOREIGN KEY (SYMBOL_TYPE)
   REFERENCES R_SYMBOL_TYPE (IDENTIFIER));
ALTER TABLE CODE_ALIAS ADD (CONSTRAINT fk_CODE_ALIAS1
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE CODE_ALIAS ADD (CONSTRAINT fk_CODE_ALIAS2
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE COMMON_ACTIVITY_COMPOSITION ADD (CONSTRAINT fk_COMMON_ACTIVITY_COMPOSITI1
   FOREIGN KEY (COMPOSITION_TYPE)
   REFERENCES R_COMPOSITION_TYPE (IDENTIFIER));
ALTER TABLE COMMON_ACTIVITY_COMPOSITION ADD (CONSTRAINT fk_COMMON_ACTIVITY_COMPOSITI2
   FOREIGN KEY (PART_S)
   REFERENCES ACTIVITY_CLASS (INSTANCE_S));
ALTER TABLE COMMON_ACTIVITY_COMPOSITION ADD (CONSTRAINT fk_COMMON_ACTIVITY_COMPOSITI3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE COMMON_ACTIVITY_COMPOSITION ADD (CONSTRAINT fk_COMMON_ACTIVITY_COMPOSITI4
   FOREIGN KEY (WHOLE_S)
   REFERENCES ACTIVITY_CLASS (INSTANCE_S));
ALTER TABLE COMMON_ACTIVITY_INVOLVEMENT ADD (CONSTRAINT fk_COMMON_ACTIVITY_INVOLVEME1
   FOREIGN KEY (INVOLVED_ENTITY)
   REFERENCES R_ENTITY (IDENTIFIER));
ALTER TABLE COMMON_ACTIVITY_INVOLVEMENT ADD (CONSTRAINT fk_COMMON_ACTIVITY_INVOLVEME2
   FOREIGN KEY (INVOLVEMENT_ROLE)
   REFERENCES R_ACTIVITY_INVOLVEMENT_ROLE (IDENTIFIER));
ALTER TABLE COMMON_ACTIVITY_INVOLVEMENT ADD (CONSTRAINT fk_COMMON_ACTIVITY_INVOLVEME3
   FOREIGN KEY (INVOLVING_CLASS_S)
   REFERENCES ACTIVITY_CLASS (INSTANCE_S));
ALTER TABLE COMMON_ACTIVITY_INVOLVEMENT ADD (CONSTRAINT fk_COMMON_ACTIVITY_INVOLVEME4
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE COMMON_ACTIVITY_PROPERTY ADD (CONSTRAINT fk_COMMON_ACTIVITY_PROPERTY1
   FOREIGN KEY (ACTIVITY_CLASS_S)
   REFERENCES ACTIVITY_CLASS (INSTANCE_S));
ALTER TABLE COMMON_ACTIVITY_PROPERTY ADD (CONSTRAINT fk_COMMON_ACTIVITY_PROPERTY2
   FOREIGN KEY (PROPERTY_KIND_S)
   REFERENCES PROPERTY_KIND (INSTANCE_S));
ALTER TABLE COMMON_ACTIVITY_PROPERTY ADD (CONSTRAINT fk_COMMON_ACTIVITY_PROPERTY3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE COMMON_FACILITY_COMPOSITION ADD (CONSTRAINT fk_COMMON_FACILITY_COMPOSITI1
   FOREIGN KEY (COMPOSITION_TYPE)
   REFERENCES R_COMPOSITION_TYPE (IDENTIFIER));
ALTER TABLE COMMON_FACILITY_COMPOSITION ADD (CONSTRAINT fk_COMMON_FACILITY_COMPOSITI2
   FOREIGN KEY (PART_S)
   REFERENCES FACILITY_CLASS (INSTANCE_S));
ALTER TABLE COMMON_FACILITY_COMPOSITION ADD (CONSTRAINT fk_COMMON_FACILITY_COMPOSITI3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE COMMON_FACILITY_COMPOSITION ADD (CONSTRAINT fk_COMMON_FACILITY_COMPOSITI4
   FOREIGN KEY (WHOLE_S)
   REFERENCES FACILITY_CLASS (INSTANCE_S));
ALTER TABLE COMMON_FACILITY_PROPERTY ADD (CONSTRAINT fk_COMMON_FACILITY_PROPERTY1
   FOREIGN KEY (FACILITY_CLASS_S)
   REFERENCES FACILITY_CLASS (INSTANCE_S));
ALTER TABLE COMMON_FACILITY_PROPERTY ADD (CONSTRAINT fk_COMMON_FACILITY_PROPERTY2
   FOREIGN KEY (PROPERTY_KIND_S)
   REFERENCES PROPERTY_KIND (INSTANCE_S));
ALTER TABLE COMMON_FACILITY_PROPERTY ADD (CONSTRAINT fk_COMMON_FACILITY_PROPERTY3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE COMMON_GEOLOGIC_PROCESS_COMP ADD (CONSTRAINT fk_COMMON_GEOLOGIC_PROCESS_C1
   FOREIGN KEY (COMPONENT_OF_PROCESS_S)
   REFERENCES GEOLOGIC_PROCESS_CLASS (INSTANCE_S));
ALTER TABLE COMMON_GEOLOGIC_PROCESS_COMP ADD (CONSTRAINT fk_COMMON_GEOLOGIC_PROCESS_C2
   FOREIGN KEY (PROCESS_COMPONENT_S)
   REFERENCES GEOLOGIC_PROCESS_CLASS (INSTANCE_S));
ALTER TABLE COMMON_GEOLOGIC_PROCESS_COMP ADD (CONSTRAINT fk_COMMON_GEOLOGIC_PROCESS_C3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE COMMON_GUIDELINE_OR_PRIVILEGE ADD (CONSTRAINT fk_COMMON_GUIDELINE_OR_PRIVI1
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE COMMON_MATERIAL_COMPOSITION ADD (CONSTRAINT fk_COMMON_MATERIAL_COMPOSITI1
   FOREIGN KEY (AMOUNT_Q)
   REFERENCES R_QUANTITY_TYPE (IDENTIFIER));
ALTER TABLE COMMON_MATERIAL_COMPOSITION ADD (CONSTRAINT fk_COMMON_MATERIAL_COMPOSITI2
   FOREIGN KEY (AMOUNT_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE COMMON_MATERIAL_COMPOSITION ADD (CONSTRAINT fk_COMMON_MATERIAL_COMPOSITI3
   FOREIGN KEY (COMPOSITION_TYPE)
   REFERENCES R_COMPOSITION_TYPE (IDENTIFIER));
ALTER TABLE COMMON_MATERIAL_COMPOSITION ADD (CONSTRAINT fk_COMMON_MATERIAL_COMPOSITI4
   FOREIGN KEY (PART_S)
   REFERENCES MATERIAL_CLASS (INSTANCE_S));
ALTER TABLE COMMON_MATERIAL_COMPOSITION ADD (CONSTRAINT fk_COMMON_MATERIAL_COMPOSITI5
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE COMMON_MATERIAL_COMPOSITION ADD (CONSTRAINT fk_COMMON_MATERIAL_COMPOSITI6
   FOREIGN KEY (WHOLE_S)
   REFERENCES MATERIAL_CLASS (INSTANCE_S));
ALTER TABLE COMMON_MATERIAL_PROPERTY ADD (CONSTRAINT fk_COMMON_MATERIAL_PROPERTY1
   FOREIGN KEY (MATERIAL_CLASS_S)
   REFERENCES MATERIAL_CLASS (INSTANCE_S));
ALTER TABLE COMMON_MATERIAL_PROPERTY ADD (CONSTRAINT fk_COMMON_MATERIAL_PROPERTY2
   FOREIGN KEY (PROPERTY_KIND_S)
   REFERENCES PROPERTY_KIND (INSTANCE_S));
ALTER TABLE COMMON_MATERIAL_PROPERTY ADD (CONSTRAINT fk_COMMON_MATERIAL_PROPERTY3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE COMPOSITE_GRAPHICAL_ELEMENT ADD (CONSTRAINT fk_COMPOSITE_GRAPHICAL_ELEME1
   FOREIGN KEY (CELL_S)
   REFERENCES CELL (INSTANCE_S));
ALTER TABLE COMPOSITE_GRAPHICAL_ELEMENT ADD (CONSTRAINT fk_COMPOSITE_GRAPHICAL_ELEME2
   FOREIGN KEY (GRAPHICAL_ELEMENT_COMPONENT_S)
   REFERENCES COMPOSITE_GRAPHICAL_ELEMENT (INSTANCE_S));
ALTER TABLE COMPOSITE_SPATIAL_OBJECT_COMP ADD (CONSTRAINT fk_COMPOSITE_SPATIAL_OBJECT_1
   FOREIGN KEY (COMPOSITE_SPATIAL_OBJECT_S)
   REFERENCES SPATIAL_OBJECT (INSTANCE_S));
ALTER TABLE COMPOSITE_SPATIAL_OBJECT_COMP ADD (CONSTRAINT fk_COMPOSITE_SPATIAL_OBJECT_2
   FOREIGN KEY (SPATIAL_OBJECT_S)
   REFERENCES SPATIAL_OBJECT (INSTANCE_S));
ALTER TABLE CONGRESSIONAL_LEGAL_SRVY_AREA ADD (CONSTRAINT fk_CONGRESSIONAL_LEGAL_SRVY_1
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE CONGRESSIONAL_LEGAL_SRVY_AREA ADD (CONSTRAINT fk_CONGRESSIONAL_LEGAL_SRVY_2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE CONGRESSIONAL_LEGAL_SRVY_AREA ADD (CONSTRAINT fk_CONGRESSIONAL_LEGAL_SRVY_3
   FOREIGN KEY (R_EAST_OR_WEST)
   REFERENCES R_EAST_OR_WEST (IDENTIFIER));
ALTER TABLE CONGRESSIONAL_LEGAL_SRVY_AREA ADD (CONSTRAINT fk_CONGRESSIONAL_LEGAL_SRVY_4
   FOREIGN KEY (R_NORTH_OR_SOUTH)
   REFERENCES R_NORTH_OR_SOUTH (IDENTIFIER));
ALTER TABLE CONGRESSIONAL_LEGAL_SRVY_AREA ADD (CONSTRAINT fk_CONGRESSIONAL_LEGAL_SRVY_5
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE CONTRACT ADD (CONSTRAINT fk_CONTRACT1
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE CONTRACT ADD (CONSTRAINT fk_CONTRACT2
   FOREIGN KEY (KIND_S)
   REFERENCES DOCUMENT_SPECIFICATION_CLASS (INSTANCE_S));
ALTER TABLE CONTRACT ADD (CONSTRAINT fk_CONTRACT3
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE CONTRACT ADD (CONSTRAINT fk_CONTRACT4
   FOREIGN KEY (TOTAL_COST_U)
   REFERENCES R_CURRENCY_UNIT (ACRONYM));
ALTER TABLE CONTRACTUAL_OBLIGATION ADD (CONSTRAINT fk_CONTRACTUAL_OBLIGATION1
   FOREIGN KEY (CONTRACT_S)
   REFERENCES CONTRACT (INSTANCE_S));
ALTER TABLE CONTRACTUAL_OBLIGATION ADD (CONSTRAINT fk_CONTRACTUAL_OBLIGATION2
   FOREIGN KEY (R_CONTRACT_OBLIGATION)
   REFERENCES R_CONTRACT_OBLIGATION (IDENTIFIER));
ALTER TABLE CONTRACTUAL_OBLIGATION ADD (CONSTRAINT fk_CONTRACTUAL_OBLIGATION3
   FOREIGN KEY (R_OBLIGATION_FREQUENCY)
   REFERENCES R_OBLIGATION_FREQUENCY (IDENTIFIER));
ALTER TABLE CONTRACT_ACTIVITY ADD (CONSTRAINT fk_CONTRACT_ACTIVITY1
   FOREIGN KEY (ACTIVITY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE CONTRACT_ACTIVITY ADD (CONSTRAINT fk_CONTRACT_ACTIVITY2
   FOREIGN KEY (CONTRACT_S)
   REFERENCES CONTRACT (INSTANCE_S));
ALTER TABLE CONTRACT_ACTIVITY_TYPE ADD (CONSTRAINT fk_CONTRACT_ACTIVITY_TYPE1
   FOREIGN KEY (ACTIVITY_CLASS_S)
   REFERENCES ACTIVITY_CLASS (INSTANCE_S));
ALTER TABLE CONTRACT_ACTIVITY_TYPE ADD (CONSTRAINT fk_CONTRACT_ACTIVITY_TYPE2
   FOREIGN KEY (CONTRACTUAL_OBLIGATION_S)
   REFERENCES CONTRACTUAL_OBLIGATION (INSTANCE_S));
ALTER TABLE CONTRACT_ACTIVITY_TYPE ADD (CONSTRAINT fk_CONTRACT_ACTIVITY_TYPE3
   FOREIGN KEY (CONTRACT_S)
   REFERENCES CONTRACT (INSTANCE_S));
ALTER TABLE CONTRACT_ASSOC_FACILITY_ASSN ADD (CONSTRAINT fk_CONTRACT_ASSOC_FACILITY_A1
   FOREIGN KEY (BUSINESS_ASSOC_FACILITY_ASSN_S)
   REFERENCES BUSINESS_ASSOC_FACILITY_INVOLV (INSTANCE_S));
ALTER TABLE CONTRACT_ASSOC_FACILITY_ASSN ADD (CONSTRAINT fk_CONTRACT_ASSOC_FACILITY_A2
   FOREIGN KEY (CONTRACT_S)
   REFERENCES CONTRACT (INSTANCE_S));
ALTER TABLE CONTRACT_DESIGNATION ADD (CONSTRAINT fk_CONTRACT_DESIGNATION1
   FOREIGN KEY (ADDRESS_S)
   REFERENCES ADDRESS (INSTANCE_S));
ALTER TABLE CONTRACT_DESIGNATION ADD (CONSTRAINT fk_CONTRACT_DESIGNATION2
   FOREIGN KEY (AMOUNT_U)
   REFERENCES R_CURRENCY_UNIT (ACRONYM));
ALTER TABLE CONTRACT_DESIGNATION ADD (CONSTRAINT fk_CONTRACT_DESIGNATION3
   FOREIGN KEY (BUSINESS_ASSOCIATE_ROLE)
   REFERENCES R_CONTRACT_DESIGNATION (IDENTIFIER));
ALTER TABLE CONTRACT_DESIGNATION ADD (CONSTRAINT fk_CONTRACT_DESIGNATION4
   FOREIGN KEY (BUSINESS_ASSOCIATE_S)
   REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S));
ALTER TABLE CONTRACT_DESIGNATION ADD (CONSTRAINT fk_CONTRACT_DESIGNATION5
   FOREIGN KEY (CONTRACTUAL_OBLIGATION_S)
   REFERENCES CONTRACTUAL_OBLIGATION (INSTANCE_S));
ALTER TABLE CONTRACT_DESIGNATION ADD (CONSTRAINT fk_CONTRACT_DESIGNATION6
   FOREIGN KEY (CONTRACT_S)
   REFERENCES CONTRACT (INSTANCE_S));
ALTER TABLE CONTRACT_DESIGNATION ADD (CONSTRAINT fk_CONTRACT_DESIGNATION7
   FOREIGN KEY (DEPOSITORY_DESIGNATION_S)
   REFERENCES CONTRACT_DESIGNATION (INSTANCE_S));
ALTER TABLE CONTRACT_DESIGNATION ADD (CONSTRAINT fk_CONTRACT_DESIGNATION8
   FOREIGN KEY (INTEREST_KIND)
   REFERENCES R_INTEREST_DESIGNATION (IDENTIFIER));
ALTER TABLE CONTRACT_DESIGNATION ADD (CONSTRAINT fk_CONTRACT_DESIGNATION9
   FOREIGN KEY (OWNERSHIP_KIND)
   REFERENCES R_OWNERSHIP (IDENTIFIER));
ALTER TABLE CONTRACT_DESIGNATION ADD (CONSTRAINT fk_CONTRACT_DESIGNATION10
   FOREIGN KEY (R_HOLD_OR_PAY)
   REFERENCES R_HOLD_OR_PAY (IDENTIFIER));
ALTER TABLE CONTRACT_OBJECT_DESIGNATION ADD (CONSTRAINT fk_CONTRACT_OBJECT_DESIGNATI1
   FOREIGN KEY (CONTRACT_DESIGNATION_S)
   REFERENCES CONTRACT_DESIGNATION (INSTANCE_S));
ALTER TABLE CONTRACT_OBLIG_ACTIVITY_FULFIL ADD (CONSTRAINT fk_CONTRACT_OBLIG_ACTIVITY_F1
   FOREIGN KEY (ACTIVITY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE CONTRACT_OBLIG_ACTIVITY_FULFIL ADD (CONSTRAINT fk_CONTRACT_OBLIG_ACTIVITY_F2
   FOREIGN KEY (CONTRACTUAL_OBLIGATION_S)
   REFERENCES CONTRACTUAL_OBLIGATION (INSTANCE_S));
ALTER TABLE CONTRACT_OBLIG_OBJECT_FULFIL ADD (CONSTRAINT fk_CONTRACT_OBLIG_OBJECT_FUL1
   FOREIGN KEY (CONTRACTUAL_OBLIGATION_S)
   REFERENCES CONTRACTUAL_OBLIGATION (INSTANCE_S));
ALTER TABLE COORDINATE_AXIS_CONSTRAINT ADD (CONSTRAINT fk_COORDINATE_AXIS_CONSTRAIN1
   FOREIGN KEY (AXIS_TYPE)
   REFERENCES R_AXIS_TYPE (IDENTIFIER));
ALTER TABLE COORDINATE_AXIS_CONSTRAINT ADD (CONSTRAINT fk_COORDINATE_AXIS_CONSTRAIN2
   FOREIGN KEY (COORDINATE_SYSTEM_CONSTRAINT)
   REFERENCES R_COORDINATE_SYS_CONSTRAINT (IDENTIFIER));
ALTER TABLE COORDINATE_AXIS_CONSTRAINT ADD (CONSTRAINT fk_COORDINATE_AXIS_CONSTRAIN3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM1
   FOREIGN KEY (FIRST_SYSTEM_S)
   REFERENCES COORDINATE_SYSTEM (INSTANCE_S));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM2
   FOREIGN KEY (GEODETIC_DATUM_S)
   REFERENCES GEODETIC_DATUM (INSTANCE_S));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM3
   FOREIGN KEY (GEOGRAPHIC_2D_COORD_SYSTEM_S)
   REFERENCES COORDINATE_SYSTEM (INSTANCE_S));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM4
   FOREIGN KEY (MAP_PROJECTION_S)
   REFERENCES COORDINATE_TRANSFORMATION (INSTANCE_S));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM5
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM6
   FOREIGN KEY (ORIGIN_LOCATION_1_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM7
   FOREIGN KEY (ORIGIN_LOCATION_2_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM8
   FOREIGN KEY (ORIGIN_LOCATION_3_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM9
   FOREIGN KEY (ORIGIN_LOCATION_4_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM10
   FOREIGN KEY (ORIGIN_LOCATION_5_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM11
   FOREIGN KEY (ORIGIN_LOCATION_CS_S)
   REFERENCES COORDINATE_SYSTEM (INSTANCE_S));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM12
   FOREIGN KEY (ORIGIN_LOCATION_O_S)
   REFERENCES SPATIAL_OBJECT (INSTANCE_S));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM13
   FOREIGN KEY (R_COORDINATE_SYS_CONSTRAINT)
   REFERENCES R_COORDINATE_SYS_CONSTRAINT (IDENTIFIER));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM14
   FOREIGN KEY (R_DISPLAY_ORIENTATION)
   REFERENCES R_DISPLAY_ORIENTATION (IDENTIFIER));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM15
   FOREIGN KEY (SECOND_SYSTEM_S)
   REFERENCES COORDINATE_SYSTEM (INSTANCE_S));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM16
   FOREIGN KEY (SOURCE_GEODETIC_SYSTEM_S)
   REFERENCES COORDINATE_SYSTEM (INSTANCE_S));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM17
   FOREIGN KEY (SPATIAL_REFERENCE_S)
   REFERENCES SPATIAL_OBJECT (INSTANCE_S));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM18
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE COORDINATE_SYSTEM ADD (CONSTRAINT fk_COORDINATE_SYSTEM19
   FOREIGN KEY (VERTICAL_DATUM_S)
   REFERENCES VERTICAL_DATUM (INSTANCE_S));
ALTER TABLE COORDINATE_SYSTEM_AXIS ADD (CONSTRAINT fk_COORDINATE_SYSTEM_AXIS1
   FOREIGN KEY (CONSTRAINED_TO_UNIT)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE COORDINATE_SYSTEM_AXIS ADD (CONSTRAINT fk_COORDINATE_SYSTEM_AXIS2
   FOREIGN KEY (COORDINATE_SYSTEM_S)
   REFERENCES COORDINATE_SYSTEM (INSTANCE_S));
ALTER TABLE COORDINATE_SYSTEM_AXIS ADD (CONSTRAINT fk_COORDINATE_SYSTEM_AXIS3
   FOREIGN KEY (PROPERTY_KIND_S)
   REFERENCES PROPERTY_KIND (INSTANCE_S));
ALTER TABLE COORDINATE_SYSTEM_AXIS ADD (CONSTRAINT fk_COORDINATE_SYSTEM_AXIS4
   FOREIGN KEY (R_AXIS_ORIENTATION)
   REFERENCES R_AXIS_ORIENTATION (IDENTIFIER));
ALTER TABLE COORDINATE_SYSTEM_AXIS ADD (CONSTRAINT fk_COORDINATE_SYSTEM_AXIS5
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE COORDINATE_SYSTEM_EARTH_USAGE ADD (CONSTRAINT fk_COORDINATE_SYSTEM_EARTH_U1
   FOREIGN KEY (COORDINATE_SYSTEM_S)
   REFERENCES COORDINATE_SYSTEM (INSTANCE_S));
ALTER TABLE COORDINATE_SYSTEM_EARTH_USAGE ADD (CONSTRAINT fk_COORDINATE_SYSTEM_EARTH_U2
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE COORDINATE_TRANSFORMATION ADD (CONSTRAINT fk_COORDINATE_TRANSFORMATION1
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE COORDINATE_TRANSFORMATION ADD (CONSTRAINT fk_COORDINATE_TRANSFORMATION2
   FOREIGN KEY (SOURCE_COORDINATE_SYSTEM_S)
   REFERENCES COORDINATE_SYSTEM (INSTANCE_S));
ALTER TABLE COORDINATE_TRANSFORMATION ADD (CONSTRAINT fk_COORDINATE_TRANSFORMATION3
   FOREIGN KEY (SOURCE_OFFSET_UNIT)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE COORDINATE_TRANSFORMATION ADD (CONSTRAINT fk_COORDINATE_TRANSFORMATION4
   FOREIGN KEY (TARGET_COORDINATE_SYSTEM_S)
   REFERENCES COORDINATE_SYSTEM (INSTANCE_S));
ALTER TABLE COORDINATE_TRANSFORMATION ADD (CONSTRAINT fk_COORDINATE_TRANSFORMATION5
   FOREIGN KEY (TARGET_OFFSET_UNIT)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE COORDINATE_TRANSFORMATION ADD (CONSTRAINT fk_COORDINATE_TRANSFORMATION6
   FOREIGN KEY (TRANSFORMATION_METHOD_S)
   REFERENCES TRANSFORMATION_METHOD (INSTANCE_S));
ALTER TABLE COORDINATE_TRANSFORMATION ADD (CONSTRAINT fk_COORDINATE_TRANSFORMATION7
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE DAMAGE_AREA ADD (CONSTRAINT fk_DAMAGE_AREA1
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE DAMAGE_AREA ADD (CONSTRAINT fk_DAMAGE_AREA2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE DAMAGE_AREA ADD (CONSTRAINT fk_DAMAGE_AREA3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE DATA_COLLECTION ADD (CONSTRAINT fk_DATA_COLLECTION1
   FOREIGN KEY (ACTIVITY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE DATA_COLLECTION ADD (CONSTRAINT fk_DATA_COLLECTION2
   FOREIGN KEY (BUSINESS_ASSOCIATE_S)
   REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S));
ALTER TABLE DATA_COLLECTION ADD (CONSTRAINT fk_DATA_COLLECTION3
   FOREIGN KEY (POPULATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE DATA_COLLECTION ADD (CONSTRAINT fk_DATA_COLLECTION4
   FOREIGN KEY (PROCESS_PARAMETER_S)
   REFERENCES PROCESS_PARAMETER (INSTANCE_S));
ALTER TABLE DATA_COLLECTION ADD (CONSTRAINT fk_DATA_COLLECTION5
   FOREIGN KEY (R_DATA_COLLECTION_TYPE)
   REFERENCES R_DATA_COLLECTION_TYPE (IDENTIFIER));
ALTER TABLE DATA_COLLECTION ADD (CONSTRAINT fk_DATA_COLLECTION6
   FOREIGN KEY (UPDATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE DATA_COLLECTION_CONTENT ADD (CONSTRAINT fk_DATA_COLLECTION_CONTENT1
   FOREIGN KEY (PART_OF_S)
   REFERENCES DATA_COLLECTION (INSTANCE_S));
ALTER TABLE DATA_TRACE_ALIAS ADD (CONSTRAINT fk_DATA_TRACE_ALIAS1
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE DATA_TRACE_ALIAS ADD (CONSTRAINT fk_DATA_TRACE_ALIAS2
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE DERIVED_INTEREST_BASIS ADD (CONSTRAINT fk_DERIVED_INTEREST_BASIS1
   FOREIGN KEY (CONTRACT_DESIGNATION_S)
   REFERENCES CONTRACT_DESIGNATION (INSTANCE_S));
ALTER TABLE DERIVED_INTEREST_BASIS ADD (CONSTRAINT fk_DERIVED_INTEREST_BASIS2
   FOREIGN KEY (DERIVED_INTEREST_MAKEUP_S)
   REFERENCES DERIVED_INTEREST_MAKEUP (INSTANCE_S));
ALTER TABLE DERIVED_INTEREST_MAKEUP ADD (CONSTRAINT fk_DERIVED_INTEREST_MAKEUP1
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE DERIVED_INTEREST_MAKEUP ADD (CONSTRAINT fk_DERIVED_INTEREST_MAKEUP2
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE DERIVED_INTEREST_MAKEUP ADD (CONSTRAINT fk_DERIVED_INTEREST_MAKEUP3
   FOREIGN KEY (INTEREST_OF_S)
   REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S));
ALTER TABLE DERIVED_INTEREST_MAKEUP ADD (CONSTRAINT fk_DERIVED_INTEREST_MAKEUP4
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE DERIVED_INTEREST_MAKEUP ADD (CONSTRAINT fk_DERIVED_INTEREST_MAKEUP5
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE DIAGRAM_SPECIFICATION ADD (CONSTRAINT fk_DIAGRAM_SPECIFICATION1
   FOREIGN KEY (KIND_S)
   REFERENCES DOCUMENT_SPECIFICATION_CLASS (INSTANCE_S));
ALTER TABLE DIAGRAM_SPECIFICATION ADD (CONSTRAINT fk_DIAGRAM_SPECIFICATION2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE DISCOVERY_AREA ADD (CONSTRAINT fk_DISCOVERY_AREA1
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE DISCOVERY_AREA ADD (CONSTRAINT fk_DISCOVERY_AREA2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE DISCOVERY_AREA ADD (CONSTRAINT fk_DISCOVERY_AREA3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE DIVESTMENT_EQUIPMENT_INCLUSION ADD (CONSTRAINT fk_DIVESTMENT_EQUIPMENT_INCL1
   FOREIGN KEY (DIVESTMENT_PACKAGE_S)
   REFERENCES DIVESTMENT_PACKAGE (INSTANCE_S));
ALTER TABLE DIVESTMENT_EQUIPMENT_INCLUSION ADD (CONSTRAINT fk_DIVESTMENT_EQUIPMENT_INCL2
   FOREIGN KEY (EQUIPMENT_ITEM_S)
   REFERENCES EQUIPMENT_ITEM (INSTANCE_S));
ALTER TABLE DIVESTMENT_PACKAGE ADD (CONSTRAINT fk_DIVESTMENT_PACKAGE1
   FOREIGN KEY (PART_OF_S)
   REFERENCES DIVESTMENT_PACKAGE (INSTANCE_S));
ALTER TABLE DIVESTMENT_PACKAGE ADD (CONSTRAINT fk_DIVESTMENT_PACKAGE2
   FOREIGN KEY (R_SALE)
   REFERENCES R_SALE (IDENTIFIER));
ALTER TABLE DIVESTMENT_RIGHT_INCLUSION ADD (CONSTRAINT fk_DIVESTMENT_RIGHT_INCLUSIO1
   FOREIGN KEY (DIVESTMENT_PACKAGE_S)
   REFERENCES DIVESTMENT_PACKAGE (INSTANCE_S));
ALTER TABLE DIVESTMENT_RIGHT_INCLUSION ADD (CONSTRAINT fk_DIVESTMENT_RIGHT_INCLUSIO2
   FOREIGN KEY (LICENSE_RIGHT_S)
   REFERENCES LICENSE_RIGHT (INSTANCE_S));
ALTER TABLE DOCUMENT ADD (CONSTRAINT fk_DOCUMENT1
   FOREIGN KEY (KIND_S)
   REFERENCES MATERIAL_CLASS (INSTANCE_S));
ALTER TABLE DOCUMENT ADD (CONSTRAINT fk_DOCUMENT2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE DOCUMENT ADD (CONSTRAINT fk_DOCUMENT3
   FOREIGN KEY (R_DIGITAL_FILE_FORMAT)
   REFERENCES R_DIGITAL_FILE_FORMAT (IDENTIFIER));
ALTER TABLE DOCUMENT ADD (CONSTRAINT fk_DOCUMENT4
   FOREIGN KEY (R_EXISTENCE_KIND)
   REFERENCES R_EXISTENCE_KIND (IDENTIFIER));
ALTER TABLE DOCUMENT ADD (CONSTRAINT fk_DOCUMENT5
   FOREIGN KEY (R_HARDCOPY_DOCUMENT)
   REFERENCES R_HARDCOPY_DOCUMENT (IDENTIFIER));
ALTER TABLE DOCUMENT_SCHEMA ADD (CONSTRAINT fk_DOCUMENT_SCHEMA1
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE DOCUMENT_SCHEMA ADD (CONSTRAINT fk_DOCUMENT_SCHEMA2
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE DOCUMENT_SCHEMA_ENTITY_CONTENT ADD (CONSTRAINT fk_DOCUMENT_SCHEMA_ENTITY_CO1
   FOREIGN KEY (DOCUMENT_CONTENT_S)
   REFERENCES DOCUMENT_SPECIFICATION_PART (INSTANCE_S));
ALTER TABLE DOCUMENT_SCHEMA_ENTITY_CONTENT ADD (CONSTRAINT fk_DOCUMENT_SCHEMA_ENTITY_CO2
   FOREIGN KEY (DOCUMENT_SCHEMA_ENTITY_S)
   REFERENCES DOCUMENT_SCHEMA_PART (INSTANCE_S));
ALTER TABLE DOCUMENT_SCHEMA_PART ADD (CONSTRAINT fk_DOCUMENT_SCHEMA_PART1
   FOREIGN KEY (DOCUMENT_SCHEMA_ELEMENT_S)
   REFERENCES DOCUMENT_SCHEMA_PART (INSTANCE_S));
ALTER TABLE DOCUMENT_SCHEMA_PART ADD (CONSTRAINT fk_DOCUMENT_SCHEMA_PART2
   FOREIGN KEY (DOCUMENT_SCHEMA_S)
   REFERENCES DOCUMENT_SCHEMA (INSTANCE_S));
ALTER TABLE DOCUMENT_SCHEMA_PART ADD (CONSTRAINT fk_DOCUMENT_SCHEMA_PART3
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE DOCUMENT_SCHEMA_PART ADD (CONSTRAINT fk_DOCUMENT_SCHEMA_PART4
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE DOCUMENT_SCHEMA_PART ADD (CONSTRAINT fk_DOCUMENT_SCHEMA_PART5
   FOREIGN KEY (WHOLE_ATTRIBUTE_S)
   REFERENCES DOCUMENT_SCHEMA_PART (INSTANCE_S));
ALTER TABLE DOCUMENT_SCHEMA_PART ADD (CONSTRAINT fk_DOCUMENT_SCHEMA_PART6
   FOREIGN KEY (WHOLE_ELEMENT_S)
   REFERENCES DOCUMENT_SCHEMA_PART (INSTANCE_S));
ALTER TABLE DOCUMENT_SPECIFICATION_ALIAS ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_AL1
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE DOCUMENT_SPECIFICATION_ALIAS ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_AL2
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE DOCUMENT_SPECIFICATION_CLASS ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_CL1
   FOREIGN KEY (DOCUMENT_SCHEMA_S)
   REFERENCES DOCUMENT_SCHEMA (INSTANCE_S));
ALTER TABLE DOCUMENT_SPECIFICATION_CLASS ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_CL2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE DOCUMENT_SPECIFICATION_CLASS ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_CL3
   FOREIGN KEY (PARENT_CLASS_S)
   REFERENCES DOCUMENT_SPECIFICATION_CLASS (INSTANCE_S));
ALTER TABLE DOCUMENT_SPECIFICATION_CLASS ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_CL4
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE DOCUMENT_SPECIFICATION_CLSN ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_CL1
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE DOCUMENT_SPECIFICATION_CLSN ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_CL2
   FOREIGN KEY (DOCUMENT_SPECIFICATION_CLASS_S)
   REFERENCES DOCUMENT_SPECIFICATION_CLASS (INSTANCE_S));
ALTER TABLE DOCUMENT_SPECIFICATION_CLSN ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_CL3
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE DOCUMENT_SPECIFICATION_CLSN ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_CL4
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE DOCUMENT_SPECIFICATION_CLSN ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_CL5
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE DOCUMENT_SPECIFICATION_PART ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_PA1
   FOREIGN KEY (AXIS_ROTATION_ANGLE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE DOCUMENT_SPECIFICATION_PART ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_PA2
   FOREIGN KEY (DOCUMENT_SCHEMA_PART_S)
   REFERENCES DOCUMENT_SCHEMA_PART (INSTANCE_S));
ALTER TABLE DOCUMENT_SPECIFICATION_PART ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_PA3
   FOREIGN KEY (MAXIMUM_SCALE_Q)
   REFERENCES R_QUANTITY_TYPE (IDENTIFIER));
ALTER TABLE DOCUMENT_SPECIFICATION_PART ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_PA4
   FOREIGN KEY (MAXIMUM_SCALE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE DOCUMENT_SPECIFICATION_PART ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_PA5
   FOREIGN KEY (MINIMUM_SCALE_Q)
   REFERENCES R_QUANTITY_TYPE (IDENTIFIER));
ALTER TABLE DOCUMENT_SPECIFICATION_PART ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_PA6
   FOREIGN KEY (MINIMUM_SCALE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE DOCUMENT_SPECIFICATION_PART ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_PA7
   FOREIGN KEY (REFERENCE_CONTENT_S)
   REFERENCES DOCUMENT_SPECIFICATION_PART (INSTANCE_S));
ALTER TABLE DOCUMENT_SPECIFICATION_PART ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_PA8
   FOREIGN KEY (ROLE)
   REFERENCES R_DOCUMENT_SPEC_REFERENCE (IDENTIFIER));
ALTER TABLE DOCUMENT_SPECIFICATION_PART ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_PA9
   FOREIGN KEY (X_OFFSET_Q)
   REFERENCES R_QUANTITY_TYPE (IDENTIFIER));
ALTER TABLE DOCUMENT_SPECIFICATION_PART ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_PA10
   FOREIGN KEY (X_OFFSET_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE DOCUMENT_SPECIFICATION_PART ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_PA11
   FOREIGN KEY (X_SCALE_Q)
   REFERENCES R_QUANTITY_TYPE (IDENTIFIER));
ALTER TABLE DOCUMENT_SPECIFICATION_PART ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_PA12
   FOREIGN KEY (X_SCALE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE DOCUMENT_SPECIFICATION_PART ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_PA13
   FOREIGN KEY (Y_OFFSET_Q)
   REFERENCES R_QUANTITY_TYPE (IDENTIFIER));
ALTER TABLE DOCUMENT_SPECIFICATION_PART ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_PA14
   FOREIGN KEY (Y_OFFSET_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE DOCUMENT_SPECIFICATION_PART ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_PA15
   FOREIGN KEY (Y_SCALE_Q)
   REFERENCES R_QUANTITY_TYPE (IDENTIFIER));
ALTER TABLE DOCUMENT_SPECIFICATION_PART ADD (CONSTRAINT fk_DOCUMENT_SPECIFICATION_PA16
   FOREIGN KEY (Y_SCALE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE DOCUMENT_SPEC_BUSINESS_ASSOC ADD (CONSTRAINT fk_DOCUMENT_SPEC_BUSINESS_AS1
   FOREIGN KEY (BUSINESS_ASSOCIATE_S)
   REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S));
ALTER TABLE DOCUMENT_SPEC_BUSINESS_ASSOC ADD (CONSTRAINT fk_DOCUMENT_SPEC_BUSINESS_AS2
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE DOCUMENT_SPEC_BUSINESS_ASSOC ADD (CONSTRAINT fk_DOCUMENT_SPEC_BUSINESS_AS3
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE DOCUMENT_SPEC_BUSINESS_ASSOC ADD (CONSTRAINT fk_DOCUMENT_SPEC_BUSINESS_AS4
   FOREIGN KEY (ROLE)
   REFERENCES R_DOCUMENT_SPEC_BUS_ASSOC (IDENTIFIER));
ALTER TABLE DOCUMENT_SPEC_BUSINESS_ASSOC ADD (CONSTRAINT fk_DOCUMENT_SPEC_BUSINESS_AS5
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE DOCUMENT_SPEC_BUSINESS_ASSOC ADD (CONSTRAINT fk_DOCUMENT_SPEC_BUSINESS_AS6
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE DOCUMENT_SPEC_CLASS_CLSN ADD (CONSTRAINT fk_DOCUMENT_SPEC_CLASS_CLSN1
   FOREIGN KEY (BE_CLASSIFIED_AS_S)
   REFERENCES DOCUMENT_SPECIFICATION_CLASS (INSTANCE_S));
ALTER TABLE DOCUMENT_SPEC_CLASS_CLSN ADD (CONSTRAINT fk_DOCUMENT_SPEC_CLASS_CLSN2
   FOREIGN KEY (HAVE_AS_A_MEMBER_S)
   REFERENCES DOCUMENT_SPECIFICATION_CLASS (INSTANCE_S));
ALTER TABLE DOCUMENT_SPEC_CLASS_CLSN ADD (CONSTRAINT fk_DOCUMENT_SPEC_CLASS_CLSN3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE DOMINION_LAND_LEGAL_SRVY_AREA ADD (CONSTRAINT fk_DOMINION_LAND_LEGAL_SRVY_1
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE DOMINION_LAND_LEGAL_SRVY_AREA ADD (CONSTRAINT fk_DOMINION_LAND_LEGAL_SRVY_2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE DOMINION_LAND_LEGAL_SRVY_AREA ADD (CONSTRAINT fk_DOMINION_LAND_LEGAL_SRVY_3
   FOREIGN KEY (R_EAST_OR_WEST)
   REFERENCES R_EAST_OR_WEST (IDENTIFIER));
ALTER TABLE DOMINION_LAND_LEGAL_SRVY_AREA ADD (CONSTRAINT fk_DOMINION_LAND_LEGAL_SRVY_4
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE DYNAMIC_GRAPHICAL_ELEMENT ADD (CONSTRAINT fk_DYNAMIC_GRAPHICAL_ELEMENT1
   FOREIGN KEY (CELL_S)
   REFERENCES CELL (INSTANCE_S));
ALTER TABLE DYNAMIC_GRAPHICAL_ELEMENT ADD (CONSTRAINT fk_DYNAMIC_GRAPHICAL_ELEMENT2
   FOREIGN KEY (GRAPHICAL_ELEMENT_COMPONENT_S)
   REFERENCES COMPOSITE_GRAPHICAL_ELEMENT (INSTANCE_S));
ALTER TABLE DYNAMIC_GRAPHICAL_ELEMENT ADD (CONSTRAINT fk_DYNAMIC_GRAPHICAL_ELEMENT3
   FOREIGN KEY (PREDICATE_TYPE_S)
   REFERENCES PREDICATE_TYPE (INSTANCE_S));
ALTER TABLE EARTH_FEATURE_ALIAS ADD (CONSTRAINT fk_EARTH_FEATURE_ALIAS1
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE EARTH_FEATURE_ALIAS ADD (CONSTRAINT fk_EARTH_FEATURE_ALIAS2
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE EARTH_FEATURE_CLASS ADD (CONSTRAINT fk_EARTH_FEATURE_CLASS1
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE EARTH_FEATURE_CLASS ADD (CONSTRAINT fk_EARTH_FEATURE_CLASS2
   FOREIGN KEY (PARENT_CLASS_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE EARTH_FEATURE_CLASS ADD (CONSTRAINT fk_EARTH_FEATURE_CLASS3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE EARTH_FEATURE_CLASSIFICATION ADD (CONSTRAINT fk_EARTH_FEATURE_CLASSIFICAT1
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE EARTH_FEATURE_CLASSIFICATION ADD (CONSTRAINT fk_EARTH_FEATURE_CLASSIFICAT2
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE EARTH_FEATURE_CLASSIFICATION ADD (CONSTRAINT fk_EARTH_FEATURE_CLASSIFICAT3
   FOREIGN KEY (EARTH_FEATURE_CLASS_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE EARTH_FEATURE_CLASSIFICATION ADD (CONSTRAINT fk_EARTH_FEATURE_CLASSIFICAT4
   FOREIGN KEY (MATERIAL_CLASS_S)
   REFERENCES MATERIAL_CLASS (INSTANCE_S));
ALTER TABLE EARTH_FEATURE_CLASSIFICATION ADD (CONSTRAINT fk_EARTH_FEATURE_CLASSIFICAT5
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE EARTH_FEATURE_CLASSIFICATION ADD (CONSTRAINT fk_EARTH_FEATURE_CLASSIFICAT6
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE EARTH_FEATURE_CLASS_CLSN ADD (CONSTRAINT fk_EARTH_FEATURE_CLASS_CLSN1
   FOREIGN KEY (BE_CLASSIFIED_AS_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE EARTH_FEATURE_CLASS_CLSN ADD (CONSTRAINT fk_EARTH_FEATURE_CLASS_CLSN2
   FOREIGN KEY (HAVE_AS_A_MEMBER_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE EARTH_FEATURE_CLASS_CLSN ADD (CONSTRAINT fk_EARTH_FEATURE_CLASS_CLSN3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE EARTH_MODEL ADD (CONSTRAINT fk_EARTH_MODEL1
   FOREIGN KEY (KIND)
   REFERENCES R_EARTH_MODEL (IDENTIFIER));
ALTER TABLE EARTH_MODEL_COMPOSITION ADD (CONSTRAINT fk_EARTH_MODEL_COMPOSITION1
   FOREIGN KEY (EARTH_MODEL_S)
   REFERENCES EARTH_MODEL (INSTANCE_S));
ALTER TABLE EARTH_MODEL_COMPOSITION ADD (CONSTRAINT fk_EARTH_MODEL_COMPOSITION2
   FOREIGN KEY (SPATIAL_OBJECT_S)
   REFERENCES SPATIAL_OBJECT (INSTANCE_S));
ALTER TABLE EARTH_PARCEL ADD (CONSTRAINT fk_EARTH_PARCEL1
   FOREIGN KEY (GROSS_ACREAGE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE EARTH_PARCEL ADD (CONSTRAINT fk_EARTH_PARCEL2
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE EARTH_PARCEL ADD (CONSTRAINT fk_EARTH_PARCEL3
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE EARTH_PARCEL ADD (CONSTRAINT fk_EARTH_PARCEL4
   FOREIGN KEY (NET_ACREAGE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE EARTH_PARCEL ADD (CONSTRAINT fk_EARTH_PARCEL5
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE ELLIPSOID ADD (CONSTRAINT fk_ELLIPSOID1
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE ELLIPSOID ADD (CONSTRAINT fk_ELLIPSOID2
   FOREIGN KEY (SEMIMAJOR_AXIS_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE ELLIPSOID ADD (CONSTRAINT fk_ELLIPSOID3
   FOREIGN KEY (SEMIMINOR_AXIS_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE ELLIPSOID ADD (CONSTRAINT fk_ELLIPSOID4
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE ENCUMBRANCE ADD (CONSTRAINT fk_ENCUMBRANCE1
   FOREIGN KEY (KIND_S)
   REFERENCES DOCUMENT_SPECIFICATION_CLASS (INSTANCE_S));
ALTER TABLE ENCUMBRANCE ADD (CONSTRAINT fk_ENCUMBRANCE2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE EQUIPMENT_ITEM ADD (CONSTRAINT fk_EQUIPMENT_ITEM1
   FOREIGN KEY (KIND_S)
   REFERENCES MATERIAL_CLASS (INSTANCE_S));
ALTER TABLE EQUIPMENT_ITEM ADD (CONSTRAINT fk_EQUIPMENT_ITEM2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE EQUIPMENT_ITEM ADD (CONSTRAINT fk_EQUIPMENT_ITEM3
   FOREIGN KEY (R_EXISTENCE_KIND)
   REFERENCES R_EXISTENCE_KIND (IDENTIFIER));
ALTER TABLE EQUIPMENT_ITEM_CONNECTION ADD (CONSTRAINT fk_EQUIPMENT_ITEM_CONNECTION1
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE EQUIPMENT_ITEM_CONNECTION ADD (CONSTRAINT fk_EQUIPMENT_ITEM_CONNECTION2
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE EQUIPMENT_ITEM_CONNECTION ADD (CONSTRAINT fk_EQUIPMENT_ITEM_CONNECTION3
   FOREIGN KEY (FROM_EQUIPMENT_S)
   REFERENCES EQUIPMENT_ITEM (INSTANCE_S));
ALTER TABLE EQUIPMENT_ITEM_CONNECTION ADD (CONSTRAINT fk_EQUIPMENT_ITEM_CONNECTION4
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE EQUIPMENT_ITEM_CONNECTION ADD (CONSTRAINT fk_EQUIPMENT_ITEM_CONNECTION5
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE EQUIPMENT_ITEM_CONNECTION ADD (CONSTRAINT fk_EQUIPMENT_ITEM_CONNECTION6
   FOREIGN KEY (TO_EQUIPMENT_S)
   REFERENCES EQUIPMENT_ITEM (INSTANCE_S));
ALTER TABLE EUROPEAN_LEGAL_SURVEY_AREA ADD (CONSTRAINT fk_EUROPEAN_LEGAL_SURVEY_ARE1
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE EUROPEAN_LEGAL_SURVEY_AREA ADD (CONSTRAINT fk_EUROPEAN_LEGAL_SURVEY_ARE2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE EUROPEAN_LEGAL_SURVEY_AREA ADD (CONSTRAINT fk_EUROPEAN_LEGAL_SURVEY_ARE3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE EVALUATED_FLOW_STREAM ADD (CONSTRAINT fk_EVALUATED_FLOW_STREAM1
   FOREIGN KEY (KIND)
   REFERENCES R_EVALUATED_FLOW_STREAM (IDENTIFIER));
ALTER TABLE EVALUATED_FLOW_STREAM ADD (CONSTRAINT fk_EVALUATED_FLOW_STREAM2
   FOREIGN KEY (PFNU_PORT_S)
   REFERENCES PFNU_PORT (INSTANCE_S));
ALTER TABLE EXPLORATION_AREA ADD (CONSTRAINT fk_EXPLORATION_AREA1
   FOREIGN KEY (BUSINESS_ASSOCIATE_S)
   REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S));
ALTER TABLE EXPLORATION_AREA ADD (CONSTRAINT fk_EXPLORATION_AREA2
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE EXPLORATION_AREA ADD (CONSTRAINT fk_EXPLORATION_AREA3
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE EXPLORATION_AREA ADD (CONSTRAINT fk_EXPLORATION_AREA4
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE FACILITY_ALIAS ADD (CONSTRAINT fk_FACILITY_ALIAS1
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE FACILITY_ALIAS ADD (CONSTRAINT fk_FACILITY_ALIAS2
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE FACILITY_CLASS ADD (CONSTRAINT fk_FACILITY_CLASS1
   FOREIGN KEY (ARCHETYPE_TYPICAL_S)
   REFERENCES TYPICAL_FACILITY (INSTANCE_S));
ALTER TABLE FACILITY_CLASS ADD (CONSTRAINT fk_FACILITY_CLASS2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE FACILITY_CLASS ADD (CONSTRAINT fk_FACILITY_CLASS3
   FOREIGN KEY (PARENT_CLASS_S)
   REFERENCES FACILITY_CLASS (INSTANCE_S));
ALTER TABLE FACILITY_CLASS ADD (CONSTRAINT fk_FACILITY_CLASS4
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE FACILITY_CLASSIFICATION ADD (CONSTRAINT fk_FACILITY_CLASSIFICATION1
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE FACILITY_CLASSIFICATION ADD (CONSTRAINT fk_FACILITY_CLASSIFICATION2
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FACILITY_CLASSIFICATION ADD (CONSTRAINT fk_FACILITY_CLASSIFICATION3
   FOREIGN KEY (FACILITY_CLASS_S)
   REFERENCES FACILITY_CLASS (INSTANCE_S));
ALTER TABLE FACILITY_CLASSIFICATION ADD (CONSTRAINT fk_FACILITY_CLASSIFICATION4
   FOREIGN KEY (MATERIAL_CLASS_S)
   REFERENCES MATERIAL_CLASS (INSTANCE_S));
ALTER TABLE FACILITY_CLASSIFICATION ADD (CONSTRAINT fk_FACILITY_CLASSIFICATION5
   FOREIGN KEY (OBJECT_ABUNDANCE_CLASS_S)
   REFERENCES OBJECT_ABUNDANCE_CLASS (INSTANCE_S));
ALTER TABLE FACILITY_CLASSIFICATION ADD (CONSTRAINT fk_FACILITY_CLASSIFICATION6
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE FACILITY_CLASSIFICATION ADD (CONSTRAINT fk_FACILITY_CLASSIFICATION7
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE FACILITY_CLASS_CLASSIFICATION ADD (CONSTRAINT fk_FACILITY_CLASS_CLASSIFICA1
   FOREIGN KEY (BE_CLASSIFIED_AS_FACILITY_S)
   REFERENCES FACILITY_CLASS (INSTANCE_S));
ALTER TABLE FACILITY_CLASS_CLASSIFICATION ADD (CONSTRAINT fk_FACILITY_CLASS_CLASSIFICA2
   FOREIGN KEY (BE_CLASSIFIED_AS_MATERIAL_S)
   REFERENCES MATERIAL_CLASS (INSTANCE_S));
ALTER TABLE FACILITY_CLASS_CLASSIFICATION ADD (CONSTRAINT fk_FACILITY_CLASS_CLASSIFICA3
   FOREIGN KEY (HAVE_AS_A_MEMBER_S)
   REFERENCES FACILITY_CLASS (INSTANCE_S));
ALTER TABLE FACILITY_CLASS_CLASSIFICATION ADD (CONSTRAINT fk_FACILITY_CLASS_CLASSIFICA4
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE FACILITY_COMPOSITION ADD (CONSTRAINT fk_FACILITY_COMPOSITION1
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE FACILITY_COMPOSITION ADD (CONSTRAINT fk_FACILITY_COMPOSITION2
   FOREIGN KEY (COMPOSITION_TYPE)
   REFERENCES R_COMPOSITION_TYPE (IDENTIFIER));
ALTER TABLE FACILITY_COMPOSITION ADD (CONSTRAINT fk_FACILITY_COMPOSITION3
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FACILITY_COMPOSITION ADD (CONSTRAINT fk_FACILITY_COMPOSITION4
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE FACILITY_COMPOSITION ADD (CONSTRAINT fk_FACILITY_COMPOSITION5
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE FACILITY_COMPOSITION ADD (CONSTRAINT fk_FACILITY_COMPOSITION6
   FOREIGN KEY (TYPE_PART_S)
   REFERENCES FACILITY_CLASS (INSTANCE_S));
ALTER TABLE FACILITY_COMPOSITION ADD (CONSTRAINT fk_FACILITY_COMPOSITION7
   FOREIGN KEY (WHOLE_S)
   REFERENCES GENERAL_FACILITY (INSTANCE_S));
ALTER TABLE FACILITY_CONNECTION ADD (CONSTRAINT fk_FACILITY_CONNECTION1
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE FACILITY_CONNECTION ADD (CONSTRAINT fk_FACILITY_CONNECTION2
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FACILITY_CONNECTION ADD (CONSTRAINT fk_FACILITY_CONNECTION3
   FOREIGN KEY (FROM_FACILITY_S)
   REFERENCES GENERAL_FACILITY (INSTANCE_S));
ALTER TABLE FACILITY_CONNECTION ADD (CONSTRAINT fk_FACILITY_CONNECTION4
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE FACILITY_CONNECTION ADD (CONSTRAINT fk_FACILITY_CONNECTION5
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE FACILITY_CONNECTION ADD (CONSTRAINT fk_FACILITY_CONNECTION6
   FOREIGN KEY (TO_FACILITY_S)
   REFERENCES GENERAL_FACILITY (INSTANCE_S));
ALTER TABLE FACILITY_VERSION ADD (CONSTRAINT fk_FACILITY_VERSION1
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE FACILITY_VERSION ADD (CONSTRAINT fk_FACILITY_VERSION2
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FACILITY_VERSION ADD (CONSTRAINT fk_FACILITY_VERSION3
   FOREIGN KEY (ORIGINAL_FACILITY_S)
   REFERENCES GENERAL_FACILITY (INSTANCE_S));
ALTER TABLE FACILITY_VERSION ADD (CONSTRAINT fk_FACILITY_VERSION4
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE FACILITY_VERSION ADD (CONSTRAINT fk_FACILITY_VERSION5
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE FACILITY_VERSION ADD (CONSTRAINT fk_FACILITY_VERSION6
   FOREIGN KEY (VERSION_FACILITY_S)
   REFERENCES GENERAL_FACILITY (INSTANCE_S));
ALTER TABLE FED_PERMIT_SYS_LEGAL_SRVY_AREA ADD (CONSTRAINT fk_FED_PERMIT_SYS_LEGAL_SRVY1
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE FED_PERMIT_SYS_LEGAL_SRVY_AREA ADD (CONSTRAINT fk_FED_PERMIT_SYS_LEGAL_SRVY2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE FED_PERMIT_SYS_LEGAL_SRVY_AREA ADD (CONSTRAINT fk_FED_PERMIT_SYS_LEGAL_SRVY3
   FOREIGN KEY (REFERENCE_LATITUDE_1_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FED_PERMIT_SYS_LEGAL_SRVY_AREA ADD (CONSTRAINT fk_FED_PERMIT_SYS_LEGAL_SRVY4
   FOREIGN KEY (REFERENCE_LATITUDE_CS_S)
   REFERENCES COORDINATE_SYSTEM (INSTANCE_S));
ALTER TABLE FED_PERMIT_SYS_LEGAL_SRVY_AREA ADD (CONSTRAINT fk_FED_PERMIT_SYS_LEGAL_SRVY5
   FOREIGN KEY (REFERENCE_LATITUDE_O_S)
   REFERENCES SPATIAL_OBJECT (INSTANCE_S));
ALTER TABLE FED_PERMIT_SYS_LEGAL_SRVY_AREA ADD (CONSTRAINT fk_FED_PERMIT_SYS_LEGAL_SRVY6
   FOREIGN KEY (REFERENCE_LONGITUDE_1_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FED_PERMIT_SYS_LEGAL_SRVY_AREA ADD (CONSTRAINT fk_FED_PERMIT_SYS_LEGAL_SRVY7
   FOREIGN KEY (REFERENCE_LONGITUDE_CS_S)
   REFERENCES COORDINATE_SYSTEM (INSTANCE_S));
ALTER TABLE FED_PERMIT_SYS_LEGAL_SRVY_AREA ADD (CONSTRAINT fk_FED_PERMIT_SYS_LEGAL_SRVY8
   FOREIGN KEY (REFERENCE_LONGITUDE_O_S)
   REFERENCES SPATIAL_OBJECT (INSTANCE_S));
ALTER TABLE FED_PERMIT_SYS_LEGAL_SRVY_AREA ADD (CONSTRAINT fk_FED_PERMIT_SYS_LEGAL_SRVY9
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE FIELD ADD (CONSTRAINT fk_FIELD1
   FOREIGN KEY (COUNTRY_S)
   REFERENCES GEOPOLITICAL_FEATURE (INSTANCE_S));
ALTER TABLE FIELD ADD (CONSTRAINT fk_FIELD2
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE FIELD ADD (CONSTRAINT fk_FIELD3
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE FIELD ADD (CONSTRAINT fk_FIELD4
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE FLUID_CARGO ADD (CONSTRAINT fk_FLUID_CARGO1
   FOREIGN KEY (CONTAINING_FACILITY_S)
   REFERENCES GENERAL_FACILITY (INSTANCE_S));
ALTER TABLE FLUID_CARGO ADD (CONSTRAINT fk_FLUID_CARGO2
   FOREIGN KEY (PFNU_CARGO_CONNECTION_S)
   REFERENCES PFNU_EXTERNAL_CONNECTION (INSTANCE_S));
ALTER TABLE FLUID_CARGO_TRANSFER ADD (CONSTRAINT fk_FLUID_CARGO_TRANSFER1
   FOREIGN KEY (CARGO_SOURCE_S)
   REFERENCES FLUID_CARGO (INSTANCE_S));
ALTER TABLE FLUID_CARGO_TRANSFER ADD (CONSTRAINT fk_FLUID_CARGO_TRANSFER2
   FOREIGN KEY (CARGO_TARGET_S)
   REFERENCES FLUID_CARGO (INSTANCE_S));
ALTER TABLE FLUID_CARGO_TRANSFER ADD (CONSTRAINT fk_FLUID_CARGO_TRANSFER3
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE FLUID_CARGO_TRANSFER ADD (CONSTRAINT fk_FLUID_CARGO_TRANSFER4
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_CARGO_TRANSFER ADD (CONSTRAINT fk_FLUID_CARGO_TRANSFER5
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE FLUID_CARGO_TRANSFER ADD (CONSTRAINT fk_FLUID_CARGO_TRANSFER6
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE FLUID_COMPONENT_INTERACTION ADD (CONSTRAINT fk_FLUID_COMPONENT_INTERACTI1
   FOREIGN KEY (I_COMPONENT_S)
   REFERENCES BULK_MATERIAL (INSTANCE_S));
ALTER TABLE FLUID_COMPONENT_INTERACTION ADD (CONSTRAINT fk_FLUID_COMPONENT_INTERACTI2
   FOREIGN KEY (J_COMPONENT_S)
   REFERENCES BULK_MATERIAL (INSTANCE_S));
ALTER TABLE FLUID_FLOW_STREAM_ALLOCATION ADD (CONSTRAINT fk_FLUID_FLOW_STREAM_ALLOCAT1
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE FLUID_FLOW_STREAM_ALLOCATION ADD (CONSTRAINT fk_FLUID_FLOW_STREAM_ALLOCAT2
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_FLOW_STREAM_ALLOCATION ADD (CONSTRAINT fk_FLUID_FLOW_STREAM_ALLOCAT3
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE FLUID_FLOW_STREAM_ALLOCATION ADD (CONSTRAINT fk_FLUID_FLOW_STREAM_ALLOCAT4
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE FLUID_FLOW_STREAM_CONTAMINANT ADD (CONSTRAINT fk_FLUID_FLOW_STREAM_CONTAMI1
   FOREIGN KEY (CONTAMINANT_TYPE_S)
   REFERENCES MATERIAL_CLASS (INSTANCE_S));
ALTER TABLE FLUID_INTERACTION_MATERIAL ADD (CONSTRAINT fk_FLUID_INTERACTION_MATERIA1
   FOREIGN KEY (ROCK_MATERIAL_S)
   REFERENCES BULK_MATERIAL (INSTANCE_S));
ALTER TABLE FLUID_PHASE_AQUEOUS ADD (CONSTRAINT fk_FLUID_PHASE_AQUEOUS1
   FOREIGN KEY (FLUID_SYSTEM_S)
   REFERENCES BULK_MATERIAL (INSTANCE_S));
ALTER TABLE FLUID_PHASE_AQUEOUS ADD (CONSTRAINT fk_FLUID_PHASE_AQUEOUS2
   FOREIGN KEY (FLUID_SYSTEM_STATE_S)
   REFERENCES FLUID_SYSTEM_STATE (INSTANCE_S));
ALTER TABLE FLUID_PHASE_AQUEOUS_PVT ADD (CONSTRAINT fk_FLUID_PHASE_AQUEOUS_PVT1
   FOREIGN KEY (ACTIVITY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE FLUID_PHASE_AQUEOUS_PVT ADD (CONSTRAINT fk_FLUID_PHASE_AQUEOUS_PVT2
   FOREIGN KEY (COMPRESSIBILITY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_AQUEOUS_PVT ADD (CONSTRAINT fk_FLUID_PHASE_AQUEOUS_PVT3
   FOREIGN KEY (DENSITY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_AQUEOUS_PVT ADD (CONSTRAINT fk_FLUID_PHASE_AQUEOUS_PVT4
   FOREIGN KEY (FLUID_PHASE_AQUEOUS_S)
   REFERENCES FLUID_PHASE_AQUEOUS (INSTANCE_S));
ALTER TABLE FLUID_PHASE_AQUEOUS_PVT ADD (CONSTRAINT fk_FLUID_PHASE_AQUEOUS_PVT5
   FOREIGN KEY (FLUID_PROPERTY_SET_S)
   REFERENCES FLUID_PROPERTY_SET (INSTANCE_S));
ALTER TABLE FLUID_PHASE_AQUEOUS_PVT ADD (CONSTRAINT fk_FLUID_PHASE_AQUEOUS_PVT6
   FOREIGN KEY (FORMATION_VOLUME_FACTOR_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_AQUEOUS_PVT ADD (CONSTRAINT fk_FLUID_PHASE_AQUEOUS_PVT7
   FOREIGN KEY (MOLAR_DENSITY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_AQUEOUS_PVT ADD (CONSTRAINT fk_FLUID_PHASE_AQUEOUS_PVT8
   FOREIGN KEY (PRESSURE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_AQUEOUS_PVT ADD (CONSTRAINT fk_FLUID_PHASE_AQUEOUS_PVT9
   FOREIGN KEY (SHRINKAGE_FACTOR_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_AQUEOUS_PVT ADD (CONSTRAINT fk_FLUID_PHASE_AQUEOUS_PVT10
   FOREIGN KEY (SOLUTION_GAS_WATER_RATIO_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_AQUEOUS_PVT ADD (CONSTRAINT fk_FLUID_PHASE_AQUEOUS_PVT11
   FOREIGN KEY (SPECIFIC_MOLAR_VOLUME_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_AQUEOUS_PVT ADD (CONSTRAINT fk_FLUID_PHASE_AQUEOUS_PVT12
   FOREIGN KEY (SPECIFIC_VOLUME_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_AQUEOUS_PVT ADD (CONSTRAINT fk_FLUID_PHASE_AQUEOUS_PVT13
   FOREIGN KEY (TEMPERATURE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_AQUEOUS_PVT ADD (CONSTRAINT fk_FLUID_PHASE_AQUEOUS_PVT14
   FOREIGN KEY (VISCOSITY_KINEMATIC_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_AQUEOUS_PVT ADD (CONSTRAINT fk_FLUID_PHASE_AQUEOUS_PVT15
   FOREIGN KEY (VISCOSITY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_AQUEOUS_PVT ADD (CONSTRAINT fk_FLUID_PHASE_AQUEOUS_PVT16
   FOREIGN KEY (VISCOUS_COMPRESSIBILITY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_COMPOSITION ADD (CONSTRAINT fk_FLUID_PHASE_COMPOSITION1
   FOREIGN KEY (FLUID_SYSTEM_STATE_S)
   REFERENCES FLUID_SYSTEM_STATE (INSTANCE_S));
ALTER TABLE FLUID_PHASE_INTERFACE ADD (CONSTRAINT fk_FLUID_PHASE_INTERFACE1
   FOREIGN KEY (FLUID_COMPONENT_S)
   REFERENCES BULK_MATERIAL (INSTANCE_S));
ALTER TABLE FLUID_PHASE_INTERFACE ADD (CONSTRAINT fk_FLUID_PHASE_INTERFACE2
   FOREIGN KEY (FLUID_SYSTEM_S)
   REFERENCES BULK_MATERIAL (INSTANCE_S));
ALTER TABLE FLUID_PHASE_INTERFACE_PHASE ADD (CONSTRAINT fk_FLUID_PHASE_INTERFACE_PHA1
   FOREIGN KEY (FLUID_PHASE_INTERFACE_S)
   REFERENCES FLUID_PHASE_INTERFACE (INSTANCE_S));
ALTER TABLE FLUID_PHASE_LIQUID ADD (CONSTRAINT fk_FLUID_PHASE_LIQUID1
   FOREIGN KEY (FLUID_SYSTEM_S)
   REFERENCES BULK_MATERIAL (INSTANCE_S));
ALTER TABLE FLUID_PHASE_LIQUID ADD (CONSTRAINT fk_FLUID_PHASE_LIQUID2
   FOREIGN KEY (FLUID_SYSTEM_STATE_S)
   REFERENCES FLUID_SYSTEM_STATE (INSTANCE_S));
ALTER TABLE FLUID_PHASE_OLEIC ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC1
   FOREIGN KEY (FLUID_SYSTEM_S)
   REFERENCES BULK_MATERIAL (INSTANCE_S));
ALTER TABLE FLUID_PHASE_OLEIC ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC2
   FOREIGN KEY (FLUID_SYSTEM_STATE_S)
   REFERENCES FLUID_SYSTEM_STATE (INSTANCE_S));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT1
   FOREIGN KEY (ACTIVITY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT2
   FOREIGN KEY (BUBBLE_POINT_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT3
   FOREIGN KEY (COMPRESSIBILITY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT4
   FOREIGN KEY (DENSITY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT5
   FOREIGN KEY (FLUID_PHASE_OLEIC_S)
   REFERENCES FLUID_PHASE_OLEIC (INSTANCE_S));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT6
   FOREIGN KEY (FLUID_PROPERTY_SET_S)
   REFERENCES FLUID_PROPERTY_SET (INSTANCE_S));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT7
   FOREIGN KEY (FORMATION_VOLUME_FACTOR_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT8
   FOREIGN KEY (GAS_OIL_PSEUDO_PRESSURE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT9
   FOREIGN KEY (MOLAR_DENSITY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT10
   FOREIGN KEY (PRESSURE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT11
   FOREIGN KEY (SHRINKAGE_FACTOR_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT12
   FOREIGN KEY (SOLUTION_GAS_OIL_RATIO_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT13
   FOREIGN KEY (SPECIFIC_MOLAR_VOLUME_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT14
   FOREIGN KEY (SPECIFIC_VOLUME_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT15
   FOREIGN KEY (TEMPERATURE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT16
   FOREIGN KEY (TOTAL_FORMATION_VOLUME_FACT_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT17
   FOREIGN KEY (VISCOSITY_KINEMATIC_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT18
   FOREIGN KEY (VISCOSITY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_OLEIC_PVT ADD (CONSTRAINT fk_FLUID_PHASE_OLEIC_PVT19
   FOREIGN KEY (VISCOUS_COMPRESSIBILITY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_VAPOR_PVT ADD (CONSTRAINT fk_FLUID_PHASE_VAPOR_PVT1
   FOREIGN KEY (ACTIVITY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE FLUID_PHASE_VAPOR_PVT ADD (CONSTRAINT fk_FLUID_PHASE_VAPOR_PVT2
   FOREIGN KEY (COMPRESSIBILITY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_VAPOR_PVT ADD (CONSTRAINT fk_FLUID_PHASE_VAPOR_PVT3
   FOREIGN KEY (DENSITY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_VAPOR_PVT ADD (CONSTRAINT fk_FLUID_PHASE_VAPOR_PVT4
   FOREIGN KEY (DEW_POINT_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_VAPOR_PVT ADD (CONSTRAINT fk_FLUID_PHASE_VAPOR_PVT5
   FOREIGN KEY (FLUID_PHASE_VAPOR_S)
   REFERENCES SPECIFIC_FLUID_PHASE (INSTANCE_S));
ALTER TABLE FLUID_PHASE_VAPOR_PVT ADD (CONSTRAINT fk_FLUID_PHASE_VAPOR_PVT6
   FOREIGN KEY (FLUID_PROPERTY_SET_S)
   REFERENCES FLUID_PROPERTY_SET (INSTANCE_S));
ALTER TABLE FLUID_PHASE_VAPOR_PVT ADD (CONSTRAINT fk_FLUID_PHASE_VAPOR_PVT7
   FOREIGN KEY (FORMATION_VOLUME_FACTOR_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_VAPOR_PVT ADD (CONSTRAINT fk_FLUID_PHASE_VAPOR_PVT8
   FOREIGN KEY (GAS_PSEUDO_PRESSURE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_VAPOR_PVT ADD (CONSTRAINT fk_FLUID_PHASE_VAPOR_PVT9
   FOREIGN KEY (MOLAR_DENSITY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_VAPOR_PVT ADD (CONSTRAINT fk_FLUID_PHASE_VAPOR_PVT10
   FOREIGN KEY (PRESSURE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_VAPOR_PVT ADD (CONSTRAINT fk_FLUID_PHASE_VAPOR_PVT11
   FOREIGN KEY (SHRINKAGE_FACTOR_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_VAPOR_PVT ADD (CONSTRAINT fk_FLUID_PHASE_VAPOR_PVT12
   FOREIGN KEY (SPECIFIC_MOLAR_VOLUME_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_VAPOR_PVT ADD (CONSTRAINT fk_FLUID_PHASE_VAPOR_PVT13
   FOREIGN KEY (SPECIFIC_VOLUME_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_VAPOR_PVT ADD (CONSTRAINT fk_FLUID_PHASE_VAPOR_PVT14
   FOREIGN KEY (TEMPERATURE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_VAPOR_PVT ADD (CONSTRAINT fk_FLUID_PHASE_VAPOR_PVT15
   FOREIGN KEY (VISCOSITY_KINEMATIC_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_VAPOR_PVT ADD (CONSTRAINT fk_FLUID_PHASE_VAPOR_PVT16
   FOREIGN KEY (VISCOSITY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_VAPOR_PVT ADD (CONSTRAINT fk_FLUID_PHASE_VAPOR_PVT17
   FOREIGN KEY (VISCOUS_COMPRESSIBILITY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PHASE_VAPOR_PVT ADD (CONSTRAINT fk_FLUID_PHASE_VAPOR_PVT18
   FOREIGN KEY (VOLATILE_OIL_GAS_RATIO_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_PROPERTY_SET ADD (CONSTRAINT fk_FLUID_PROPERTY_SET1
   FOREIGN KEY (ACTIVITY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE FLUID_PROPERTY_SET ADD (CONSTRAINT fk_FLUID_PROPERTY_SET2
   FOREIGN KEY (FLUID_SYSTEM_S)
   REFERENCES BULK_MATERIAL (INSTANCE_S));
ALTER TABLE FLUID_SAMPLE_SOURCE ADD (CONSTRAINT fk_FLUID_SAMPLE_SOURCE1
   FOREIGN KEY (FLUID_SAMPLE_S)
   REFERENCES BULK_MATERIAL (INSTANCE_S));
ALTER TABLE FLUID_SAMPLE_SOURCE ADD (CONSTRAINT fk_FLUID_SAMPLE_SOURCE2
   FOREIGN KEY (ROCK_FLUID_FEATURE_S)
   REFERENCES GEOLOGIC_FEATURE (INSTANCE_S));
ALTER TABLE FLUID_SYSTEM_STATE ADD (CONSTRAINT fk_FLUID_SYSTEM_STATE1
   FOREIGN KEY (FLUID_SYSTEM_S)
   REFERENCES BULK_MATERIAL (INSTANCE_S));
ALTER TABLE FLUID_SYSTEM_STATE ADD (CONSTRAINT fk_FLUID_SYSTEM_STATE2
   FOREIGN KEY (PRESSURE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE FLUID_SYSTEM_STATE ADD (CONSTRAINT fk_FLUID_SYSTEM_STATE3
   FOREIGN KEY (TEMPERATURE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY1
   FOREIGN KEY (ARRAY_BASE_LENGTH_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY2
   FOREIGN KEY (ARRAY_BASE_WIDTH_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY3
   FOREIGN KEY (DIAMETER_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY4
   FOREIGN KEY (DYNAMITE_CHARGE_SIZE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY5
   FOREIGN KEY (ELEMENT_SPACING_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY6
   FOREIGN KEY (GUN_PRESSURE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY7
   FOREIGN KEY (GUN_VOLUME_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY8
   FOREIGN KEY (HEIGHT_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY9
   FOREIGN KEY (IDENTIFYING_CONTEXT_S)
   REFERENCES GEOPHYSICAL_GEOMETRY_SET (INSTANCE_S));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY10
   FOREIGN KEY (INNER_DIAMETER_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY11
   FOREIGN KEY (KIND_S)
   REFERENCES FACILITY_CLASS (INSTANCE_S));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY12
   FOREIGN KEY (LINEAR_CAPACITY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY13
   FOREIGN KEY (MAXIMUM_OUTLET_PRESSURE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY14
   FOREIGN KEY (MINIMUM_INLET_PRESSURE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY15
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY16
   FOREIGN KEY (NOMINAL_CAPACITY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY17
   FOREIGN KEY (NOMINAL_DIAMETER_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY18
   FOREIGN KEY (NOMINAL_RECEIVER_DEPTH_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY19
   FOREIGN KEY (NOMINAL_SOURCE_DEPTH_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY20
   FOREIGN KEY (NOMINAL_THROUGHPUT_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY21
   FOREIGN KEY (OUTER_DIAMETER_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY22
   FOREIGN KEY (PRESSURE_RATING_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY23
   FOREIGN KEY (RECORDING_TIME_DELAY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY24
   FOREIGN KEY (RECORDING_TIME_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY25
   FOREIGN KEY (ROW_SPACING_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY26
   FOREIGN KEY (R_CASE_ELEMENT_ORIENTATION)
   REFERENCES R_CASE_ELEMENT_ORIENTATION (IDENTIFIER));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY27
   FOREIGN KEY (R_EXISTENCE_KIND)
   REFERENCES R_EXISTENCE_KIND (IDENTIFIER));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY28
   FOREIGN KEY (R_GAIN_MODE)
   REFERENCES R_GAIN_MODE (IDENTIFIER));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY29
   FOREIGN KEY (R_SEISMIC_POLARITY)
   REFERENCES R_SEISMIC_POLARITY (IDENTIFIER));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY30
   FOREIGN KEY (R_SEISMIC_VIBRATOR_SWEEP)
   REFERENCES R_SEISMIC_VIBRATOR_SWEEP (IDENTIFIER));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY31
   FOREIGN KEY (SAMPLE_INTERVAL_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY32
   FOREIGN KEY (SECTION_LENGTH_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY33
   FOREIGN KEY (STREAMER_LENGTH_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY34
   FOREIGN KEY (TIME_OFFSET_WRT_MASTER_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY35
   FOREIGN KEY (TIME_OFFSET_WRT_STANDARD_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY36
   FOREIGN KEY (VIBRATOR_MOVEUP_DISTANCE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY37
   FOREIGN KEY (VIBRATOR_SWEEP_DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY38
   FOREIGN KEY (VIBRATOR_SWEEP_END_FREQUENCY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY39
   FOREIGN KEY (VIBRATOR_SWEEP_START_FREQ_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERAL_FACILITY ADD (CONSTRAINT fk_GENERAL_FACILITY40
   FOREIGN KEY (VIBRATOR_SWEEP_TAPER_LENGTH_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GENERIC_ENUMERATION ADD (CONSTRAINT fk_GENERIC_ENUMERATION1
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GENERIC_ENUMERATION ADD (CONSTRAINT fk_GENERIC_ENUMERATION2
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GEODETIC_DATUM ADD (CONSTRAINT fk_GEODETIC_DATUM1
   FOREIGN KEY (ELLIPSOID_S)
   REFERENCES ELLIPSOID (INSTANCE_S));
ALTER TABLE GEODETIC_DATUM ADD (CONSTRAINT fk_GEODETIC_DATUM2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEODETIC_DATUM ADD (CONSTRAINT fk_GEODETIC_DATUM3
   FOREIGN KEY (PRIME_MERIDIAN_S)
   REFERENCES PRIME_MERIDIAN (INSTANCE_S));
ALTER TABLE GEODETIC_DATUM ADD (CONSTRAINT fk_GEODETIC_DATUM4
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GEODETIC_ZONE ADD (CONSTRAINT fk_GEODETIC_ZONE1
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE GEODETIC_ZONE ADD (CONSTRAINT fk_GEODETIC_ZONE2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEODETIC_ZONE ADD (CONSTRAINT fk_GEODETIC_ZONE3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GEOGRAPHIC_FEATURE ADD (CONSTRAINT fk_GEOGRAPHIC_FEATURE1
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE GEOGRAPHIC_FEATURE ADD (CONSTRAINT fk_GEOGRAPHIC_FEATURE2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEOGRAPHIC_FEATURE ADD (CONSTRAINT fk_GEOGRAPHIC_FEATURE3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GEOLOGIC_AGE_CLASSIFICATION ADD (CONSTRAINT fk_GEOLOGIC_AGE_CLASSIFICATI1
   FOREIGN KEY (GEOLOGIC_FEATURE_S)
   REFERENCES GEOLOGIC_FEATURE (INSTANCE_S));
ALTER TABLE GEOLOGIC_AGE_CLASSIFICATION ADD (CONSTRAINT fk_GEOLOGIC_AGE_CLASSIFICATI2
   FOREIGN KEY (MATERIAL_CLASS_S)
   REFERENCES MATERIAL_CLASS (INSTANCE_S));
ALTER TABLE GEOLOGIC_AGE_CLASSIFICATION ADD (CONSTRAINT fk_GEOLOGIC_AGE_CLASSIFICATI3
   FOREIGN KEY (RESERVOIR_FLUID_SYSTEM_S)
   REFERENCES BULK_MATERIAL (INSTANCE_S));
ALTER TABLE GEOLOGIC_AGE_CLASSIFICATION ADD (CONSTRAINT fk_GEOLOGIC_AGE_CLASSIFICATI4
   FOREIGN KEY (ROCK_MATERIAL_S)
   REFERENCES BULK_MATERIAL (INSTANCE_S));
ALTER TABLE GEOLOGIC_AGE_CLASSIFICATION ADD (CONSTRAINT fk_GEOLOGIC_AGE_CLASSIFICATI5
   FOREIGN KEY (R_AGE_CLASSIFICATION_TYPE)
   REFERENCES R_AGE_CLASSIFICATION_TYPE (IDENTIFIER));
ALTER TABLE GEOLOGIC_AGE_CLASSIFICATION ADD (CONSTRAINT fk_GEOLOGIC_AGE_CLASSIFICATI6
   FOREIGN KEY (UNCERTAINTY_CLASS_S)
   REFERENCES UNCERTAINTY_CLASS (INSTANCE_S));
ALTER TABLE GEOLOGIC_AGE_CLASSIFICATION ADD (CONSTRAINT fk_GEOLOGIC_AGE_CLASSIFICATI7
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE ADD (CONSTRAINT fk_GEOLOGIC_FEATURE1
   FOREIGN KEY (FEATURE_BOUNDARY_S)
   REFERENCES GEOLOGIC_FEATURE (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE ADD (CONSTRAINT fk_GEOLOGIC_FEATURE2
   FOREIGN KEY (FIELD_S)
   REFERENCES FIELD (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE ADD (CONSTRAINT fk_GEOLOGIC_FEATURE3
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE ADD (CONSTRAINT fk_GEOLOGIC_FEATURE4
   FOREIGN KEY (LITHOSTRATIGRAPHIC_FORMATION_S)
   REFERENCES GEOLOGIC_FEATURE (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE ADD (CONSTRAINT fk_GEOLOGIC_FEATURE5
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEOLOGIC_FEATURE ADD (CONSTRAINT fk_GEOLOGIC_FEATURE6
   FOREIGN KEY (RESERVOIR_S)
   REFERENCES GEOLOGIC_FEATURE (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE ADD (CONSTRAINT fk_GEOLOGIC_FEATURE7
   FOREIGN KEY (R_FLUID_CONTACT)
   REFERENCES R_FLUID_CONTACT (IDENTIFIER));
ALTER TABLE GEOLOGIC_FEATURE ADD (CONSTRAINT fk_GEOLOGIC_FEATURE8
   FOREIGN KEY (R_POOL)
   REFERENCES R_POOL (IDENTIFIER));
ALTER TABLE GEOLOGIC_FEATURE ADD (CONSTRAINT fk_GEOLOGIC_FEATURE9
   FOREIGN KEY (R_RESERVOIR_ZONE)
   REFERENCES R_RESERVOIR_ZONE (IDENTIFIER));
ALTER TABLE GEOLOGIC_FEATURE ADD (CONSTRAINT fk_GEOLOGIC_FEATURE10
   FOREIGN KEY (SEISMIC_GEOMETRY_SET_S)
   REFERENCES GEOPHYSICAL_GEOMETRY_SET (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE ADD (CONSTRAINT fk_GEOLOGIC_FEATURE11
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE ADD (CONSTRAINT fk_GEOLOGIC_FEATURE12
   FOREIGN KEY (WELL_COMPLETION_S)
   REFERENCES WELL_COMPLETION (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE ADD (CONSTRAINT fk_GEOLOGIC_FEATURE13
   FOREIGN KEY (WELL_PATTERN_S)
   REFERENCES PFNU_GROUP (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE ADD (CONSTRAINT fk_GEOLOGIC_FEATURE14
   FOREIGN KEY (WELL_S)
   REFERENCES WELL (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE ADD (CONSTRAINT fk_GEOLOGIC_FEATURE15
   FOREIGN KEY (WHOLE_S)
   REFERENCES GEOLOGIC_FEATURE (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE_ASSOCIATION ADD (CONSTRAINT fk_GEOLOGIC_FEATURE_ASSOCIAT1
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE_ASSOCIATION ADD (CONSTRAINT fk_GEOLOGIC_FEATURE_ASSOCIAT2
   FOREIGN KEY (CONSEQUENCE)
   REFERENCES R_GEOLOGIC_FEATURE_ASSOC (IDENTIFIER));
ALTER TABLE GEOLOGIC_FEATURE_ASSOCIATION ADD (CONSTRAINT fk_GEOLOGIC_FEATURE_ASSOCIAT3
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GEOLOGIC_FEATURE_ASSOCIATION ADD (CONSTRAINT fk_GEOLOGIC_FEATURE_ASSOCIAT4
   FOREIGN KEY (PRIMARY_GEOLOGIC_FEATURE_S)
   REFERENCES GEOLOGIC_FEATURE (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE_ASSOCIATION ADD (CONSTRAINT fk_GEOLOGIC_FEATURE_ASSOCIAT5
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE GEOLOGIC_FEATURE_ASSOCIATION ADD (CONSTRAINT fk_GEOLOGIC_FEATURE_ASSOCIAT6
   FOREIGN KEY (SECONDARY_GEOLOGIC_FEATURE_S)
   REFERENCES GEOLOGIC_FEATURE (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE_ASSOCIATION ADD (CONSTRAINT fk_GEOLOGIC_FEATURE_ASSOCIAT7
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE_PROCESS_ASSN ADD (CONSTRAINT fk_GEOLOGIC_FEATURE_PROCESS_1
   FOREIGN KEY (GEOLOGIC_FEATURE_S)
   REFERENCES GEOLOGIC_FEATURE (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE_PROCESS_ASSN ADD (CONSTRAINT fk_GEOLOGIC_FEATURE_PROCESS_2
   FOREIGN KEY (GEOLOGIC_PROCESS_S)
   REFERENCES GEOLOGIC_PROCESS (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE_PROVINCE_ASSN ADD (CONSTRAINT fk_GEOLOGIC_FEATURE_PROVINCE1
   FOREIGN KEY (GEOLOGIC_FEATURE_S)
   REFERENCES GEOLOGIC_FEATURE (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE_PROVINCE_ASSN ADD (CONSTRAINT fk_GEOLOGIC_FEATURE_PROVINCE2
   FOREIGN KEY (GEOLOGIC_PROVINCE_S)
   REFERENCES GEOLOGIC_PROVINCE (INSTANCE_S));
ALTER TABLE GEOLOGIC_FEATURE_PROVINCE_ASSN ADD (CONSTRAINT fk_GEOLOGIC_FEATURE_PROVINCE3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GEOLOGIC_PROCESS ADD (CONSTRAINT fk_GEOLOGIC_PROCESS1
   FOREIGN KEY (KIND_S)
   REFERENCES GEOLOGIC_PROCESS_CLASS (INSTANCE_S));
ALTER TABLE GEOLOGIC_PROCESS ADD (CONSTRAINT fk_GEOLOGIC_PROCESS2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEOLOGIC_PROCESS_ALIAS ADD (CONSTRAINT fk_GEOLOGIC_PROCESS_ALIAS1
   FOREIGN KEY (ALIASED_OBJECT_S)
   REFERENCES GEOLOGIC_PROCESS (INSTANCE_S));
ALTER TABLE GEOLOGIC_PROCESS_ALIAS ADD (CONSTRAINT fk_GEOLOGIC_PROCESS_ALIAS2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEOLOGIC_PROCESS_ALIAS ADD (CONSTRAINT fk_GEOLOGIC_PROCESS_ALIAS3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GEOLOGIC_PROCESS_CLASS ADD (CONSTRAINT fk_GEOLOGIC_PROCESS_CLASS1
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEOLOGIC_PROCESS_CLASS ADD (CONSTRAINT fk_GEOLOGIC_PROCESS_CLASS2
   FOREIGN KEY (PARENT_CLASS_S)
   REFERENCES GEOLOGIC_PROCESS_CLASS (INSTANCE_S));
ALTER TABLE GEOLOGIC_PROCESS_CLASS ADD (CONSTRAINT fk_GEOLOGIC_PROCESS_CLASS3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GEOLOGIC_PROCESS_COMPOSITION ADD (CONSTRAINT fk_GEOLOGIC_PROCESS_COMPOSIT1
   FOREIGN KEY (CONTAINING_ACTIVITY_S)
   REFERENCES GEOLOGIC_PROCESS (INSTANCE_S));
ALTER TABLE GEOLOGIC_PROCESS_COMPOSITION ADD (CONSTRAINT fk_GEOLOGIC_PROCESS_COMPOSIT2
   FOREIGN KEY (MEMBER_ACTIVITY_S)
   REFERENCES GEOLOGIC_PROCESS (INSTANCE_S));
ALTER TABLE GEOLOGIC_PROCESS_SEQUENCE ADD (CONSTRAINT fk_GEOLOGIC_PROCESS_SEQUENCE1
   FOREIGN KEY (FOLLOWING_GEOLOGIC_PROCESS_S)
   REFERENCES GEOLOGIC_PROCESS (INSTANCE_S));
ALTER TABLE GEOLOGIC_PROCESS_SEQUENCE ADD (CONSTRAINT fk_GEOLOGIC_PROCESS_SEQUENCE2
   FOREIGN KEY (PRECEDING_GEOLOGIC_PROCESS_S)
   REFERENCES GEOLOGIC_PROCESS (INSTANCE_S));
ALTER TABLE GEOLOGIC_PROVINCE ADD (CONSTRAINT fk_GEOLOGIC_PROVINCE1
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE GEOLOGIC_PROVINCE ADD (CONSTRAINT fk_GEOLOGIC_PROVINCE2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEOLOGIC_PROVINCE ADD (CONSTRAINT fk_GEOLOGIC_PROVINCE3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GEOLOGIC_PROVINCE_AGE_CLSN ADD (CONSTRAINT fk_GEOLOGIC_PROVINCE_AGE_CLS1
   FOREIGN KEY (GEOLOGIC_PROVINCE_S)
   REFERENCES GEOLOGIC_PROVINCE (INSTANCE_S));
ALTER TABLE GEOLOGIC_PROVINCE_AGE_CLSN ADD (CONSTRAINT fk_GEOLOGIC_PROVINCE_AGE_CLS2
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GEOMETRICAL_RELATIONSHIP ADD (CONSTRAINT fk_GEOMETRICAL_RELATIONSHIP1
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE GEOMETRICAL_RELATIONSHIP ADD (CONSTRAINT fk_GEOMETRICAL_RELATIONSHIP2
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GEOMETRICAL_RELATIONSHIP ADD (CONSTRAINT fk_GEOMETRICAL_RELATIONSHIP3
   FOREIGN KEY (MAXIMUM_DISTANCE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GEOMETRICAL_RELATIONSHIP ADD (CONSTRAINT fk_GEOMETRICAL_RELATIONSHIP4
   FOREIGN KEY (MINIMUM_DISTANCE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GEOMETRICAL_RELATIONSHIP ADD (CONSTRAINT fk_GEOMETRICAL_RELATIONSHIP5
   FOREIGN KEY (NOMINAL_DISTANCE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GEOMETRICAL_RELATIONSHIP ADD (CONSTRAINT fk_GEOMETRICAL_RELATIONSHIP6
   FOREIGN KEY (PRIMARY_SPATIAL_OBJECT_S)
   REFERENCES SPATIAL_OBJECT (INSTANCE_S));
ALTER TABLE GEOMETRICAL_RELATIONSHIP ADD (CONSTRAINT fk_GEOMETRICAL_RELATIONSHIP7
   FOREIGN KEY (RELATIONSHIP_TYPE)
   REFERENCES R_GEOMETRICAL_RELATIONSHIP (IDENTIFIER));
ALTER TABLE GEOMETRICAL_RELATIONSHIP ADD (CONSTRAINT fk_GEOMETRICAL_RELATIONSHIP8
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE GEOMETRICAL_RELATIONSHIP ADD (CONSTRAINT fk_GEOMETRICAL_RELATIONSHIP9
   FOREIGN KEY (SECONDARY_SPATIAL_OBJECT_S)
   REFERENCES SPATIAL_OBJECT (INSTANCE_S));
ALTER TABLE GEOMETRICAL_RELATIONSHIP ADD (CONSTRAINT fk_GEOMETRICAL_RELATIONSHIP10
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_ACQUISITION_AREA ADD (CONSTRAINT fk_GEOPHYSICAL_ACQUISITION_A1
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_ACQUISITION_AREA ADD (CONSTRAINT fk_GEOPHYSICAL_ACQUISITION_A2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEOPHYSICAL_ACQUISITION_AREA ADD (CONSTRAINT fk_GEOPHYSICAL_ACQUISITION_A3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_DATA_ASSOCIATION ADD (CONSTRAINT fk_GEOPHYSICAL_DATA_ASSOCIAT1
   FOREIGN KEY (APPLIED_DATA_S)
   REFERENCES GEOPHYSICAL_DATA_SET (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_DATA_ASSOCIATION ADD (CONSTRAINT fk_GEOPHYSICAL_DATA_ASSOCIAT2
   FOREIGN KEY (APPLIED_TO_S)
   REFERENCES GEOPHYSICAL_DATA_SET (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_DATA_SET ADD (CONSTRAINT fk_GEOPHYSICAL_DATA_SET1
   FOREIGN KEY (ACTIVITY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_DATA_SET ADD (CONSTRAINT fk_GEOPHYSICAL_DATA_SET2
   FOREIGN KEY (DERIVED_FROM_S)
   REFERENCES GEOPHYSICAL_DATA_SET (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_DATA_SET ADD (CONSTRAINT fk_GEOPHYSICAL_DATA_SET3
   FOREIGN KEY (GEOMETRY_SEGMENT_S)
   REFERENCES GEOPHYSICAL_GEOMETRY_SEGMENT (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_DATA_SET ADD (CONSTRAINT fk_GEOPHYSICAL_DATA_SET4
   FOREIGN KEY (GEOMETRY_SET_S)
   REFERENCES GEOPHYSICAL_GEOMETRY_SET (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_DATA_SET ADD (CONSTRAINT fk_GEOPHYSICAL_DATA_SET5
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEOPHYSICAL_DATA_SET ADD (CONSTRAINT fk_GEOPHYSICAL_DATA_SET6
   FOREIGN KEY (SEISMIC_HEADER_S)
   REFERENCES SEISMIC_HEADER (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_DATA_SET ADD (CONSTRAINT fk_GEOPHYSICAL_DATA_SET7
   FOREIGN KEY (UTILIZED_PROCESSING_GRID_S)
   REFERENCES GEOPHYSICAL_PROCESSING_GRID (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_DATA_SET ADD (CONSTRAINT fk_GEOPHYSICAL_DATA_SET8
   FOREIGN KEY (UTILIZED_UID_GRID_S)
   REFERENCES GEOPHYSICAL_GEOMETRY_SET (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_DISPLAY ADD (CONSTRAINT fk_GEOPHYSICAL_DISPLAY1
   FOREIGN KEY (DATA_SET_S)
   REFERENCES GEOPHYSICAL_DATA_SET (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_DISPLAY ADD (CONSTRAINT fk_GEOPHYSICAL_DISPLAY2
   FOREIGN KEY (GEOMETRY_SEGMENT_S)
   REFERENCES GEOPHYSICAL_GEOMETRY_SEGMENT (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_DISPLAY ADD (CONSTRAINT fk_GEOPHYSICAL_DISPLAY3
   FOREIGN KEY (KIND_S)
   REFERENCES DOCUMENT_SPECIFICATION_CLASS (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_DISPLAY ADD (CONSTRAINT fk_GEOPHYSICAL_DISPLAY4
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEOPHYSICAL_DISPLAY ADD (CONSTRAINT fk_GEOPHYSICAL_DISPLAY5
   FOREIGN KEY (PHASE_DELAY_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GEOPHYSICAL_DISPLAY ADD (CONSTRAINT fk_GEOPHYSICAL_DISPLAY6
   FOREIGN KEY (R_SEISMIC_DISPLAY_MODE)
   REFERENCES R_SEISMIC_DISPLAY_MODE (IDENTIFIER));
ALTER TABLE GEOPHYSICAL_DISPLAY ADD (CONSTRAINT fk_GEOPHYSICAL_DISPLAY7
   FOREIGN KEY (R_SEISMIC_POLARITY)
   REFERENCES R_SEISMIC_POLARITY (IDENTIFIER));
ALTER TABLE GEOPHYSICAL_DISPLAY ADD (CONSTRAINT fk_GEOPHYSICAL_DISPLAY8
   FOREIGN KEY (SEISMIC_TRAVERSE_S)
   REFERENCES SEISMIC_TRAVERSE (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_DISPLAY ADD (CONSTRAINT fk_GEOPHYSICAL_DISPLAY9
   FOREIGN KEY (X_SCALE_Q)
   REFERENCES R_QUANTITY_TYPE (IDENTIFIER));
ALTER TABLE GEOPHYSICAL_DISPLAY ADD (CONSTRAINT fk_GEOPHYSICAL_DISPLAY10
   FOREIGN KEY (X_SCALE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GEOPHYSICAL_DISPLAY ADD (CONSTRAINT fk_GEOPHYSICAL_DISPLAY11
   FOREIGN KEY (Y_MAX_Q)
   REFERENCES R_QUANTITY_TYPE (IDENTIFIER));
ALTER TABLE GEOPHYSICAL_DISPLAY ADD (CONSTRAINT fk_GEOPHYSICAL_DISPLAY12
   FOREIGN KEY (Y_MAX_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GEOPHYSICAL_DISPLAY ADD (CONSTRAINT fk_GEOPHYSICAL_DISPLAY13
   FOREIGN KEY (Y_MIN_Q)
   REFERENCES R_QUANTITY_TYPE (IDENTIFIER));
ALTER TABLE GEOPHYSICAL_DISPLAY ADD (CONSTRAINT fk_GEOPHYSICAL_DISPLAY14
   FOREIGN KEY (Y_MIN_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GEOPHYSICAL_DISPLAY ADD (CONSTRAINT fk_GEOPHYSICAL_DISPLAY15
   FOREIGN KEY (Y_SCALE_Q)
   REFERENCES R_QUANTITY_TYPE (IDENTIFIER));
ALTER TABLE GEOPHYSICAL_DISPLAY ADD (CONSTRAINT fk_GEOPHYSICAL_DISPLAY16
   FOREIGN KEY (Y_SCALE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GEOPHYSICAL_FACILITY_UID_USAGE ADD (CONSTRAINT fk_GEOPHYSICAL_FACILITY_UID_1
   FOREIGN KEY (FACILITY_S)
   REFERENCES GENERAL_FACILITY (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_FACILITY_UID_USAGE ADD (CONSTRAINT fk_GEOPHYSICAL_FACILITY_UID_2
   FOREIGN KEY (GEOMETRY_SET_S)
   REFERENCES GEOPHYSICAL_GEOMETRY_SET (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_FCL_SPECTRAL_DESC ADD (CONSTRAINT fk_GEOPHYSICAL_FCL_SPECTRAL_1
   FOREIGN KEY (DESCRIBED_FACILITY_S)
   REFERENCES GENERAL_FACILITY (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_FCL_SPECTRAL_DESC ADD (CONSTRAINT fk_GEOPHYSICAL_FCL_SPECTRAL_2
   FOREIGN KEY (WAVELET_OR_FILTER_S)
   REFERENCES WAVELET_OR_FILTER (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SEGMENT ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SEGM1
   FOREIGN KEY (BEGIN_POINT_S)
   REFERENCES GEOPHYSICAL_POINT (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SEGMENT ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SEGM2
   FOREIGN KEY (END_POINT_S)
   REFERENCES GEOPHYSICAL_POINT (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SEGMENT ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SEGM3
   FOREIGN KEY (GEOMETRY_SET_S)
   REFERENCES GEOPHYSICAL_GEOMETRY_SET (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SEGMENT ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SEGM4
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SEGMENT ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SEGM5
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SEGMENT ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SEGM6
   FOREIGN KEY (SEGMENT_LENGTH_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SEGMENT ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SEGM7
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SET ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SET1
   FOREIGN KEY (CHANNEL_DEFINITION_S)
   REFERENCES GEOPHYSICAL_GEOMETRY_SET (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SET ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SET2
   FOREIGN KEY (CHANNEL_UID_S)
   REFERENCES GRID_1D (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SET ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SET3
   FOREIGN KEY (FIELD_TRACE_GRID_S)
   REFERENCES GRID_DEFINED_GRID (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SET ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SET4
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SET ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SET5
   FOREIGN KEY (MEASUREMENT_UID_S)
   REFERENCES GRID_1D (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SET ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SET6
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SET ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SET7
   FOREIGN KEY (PART_OF_S)
   REFERENCES GEOPHYSICAL_GEOMETRY_SET (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SET ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SET8
   FOREIGN KEY (RECEIVER_CLASS_S)
   REFERENCES FACILITY_CLASS (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SET ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SET9
   FOREIGN KEY (RECEIVER_UID_S)
   REFERENCES GRID_1D (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SET ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SET10
   FOREIGN KEY (SEISMIC_STATION_UID_S)
   REFERENCES GRID_1D (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SET ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SET11
   FOREIGN KEY (SOURCE_EVENT_UID_S)
   REFERENCES GRID_1D (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SET ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SET12
   FOREIGN KEY (STATION_UID_S)
   REFERENCES GRID_1D (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SET ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SET13
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOMETRY_SET ADD (CONSTRAINT fk_GEOPHYSICAL_GEOMETRY_SET14
   FOREIGN KEY (WELLBORE_S)
   REFERENCES WELLBORE (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOM_DERIVATION ADD (CONSTRAINT fk_GEOPHYSICAL_GEOM_DERIVATI1
   FOREIGN KEY (DERIVED_FROM_S)
   REFERENCES GEOPHYSICAL_GEOMETRY_SET (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_GEOM_DERIVATION ADD (CONSTRAINT fk_GEOPHYSICAL_GEOM_DERIVATI2
   FOREIGN KEY (USED_BY_S)
   REFERENCES GEOPHYSICAL_GEOMETRY_SET (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_OFFLINE_DATA ADD (CONSTRAINT fk_GEOPHYSICAL_OFFLINE_DATA1
   FOREIGN KEY (DATA_SET_S)
   REFERENCES GEOPHYSICAL_DATA_SET (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_OFFLINE_DATA ADD (CONSTRAINT fk_GEOPHYSICAL_OFFLINE_DATA2
   FOREIGN KEY (GEOMETRY_SET_S)
   REFERENCES GEOPHYSICAL_GEOMETRY_SET (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_OFFLINE_DATA ADD (CONSTRAINT fk_GEOPHYSICAL_OFFLINE_DATA3
   FOREIGN KEY (KIND_S)
   REFERENCES DOCUMENT_SPECIFICATION_CLASS (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_OFFLINE_DATA ADD (CONSTRAINT fk_GEOPHYSICAL_OFFLINE_DATA4
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEOPHYSICAL_POINT ADD (CONSTRAINT fk_GEOPHYSICAL_POINT1
   FOREIGN KEY (GEOMETRY_SET_S)
   REFERENCES GEOPHYSICAL_GEOMETRY_SET (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_POINT ADD (CONSTRAINT fk_GEOPHYSICAL_POINT2
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_POINT ADD (CONSTRAINT fk_GEOPHYSICAL_POINT3
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEOPHYSICAL_POINT ADD (CONSTRAINT fk_GEOPHYSICAL_POINT4
   FOREIGN KEY (PROCESSING_GRID_S)
   REFERENCES GEOPHYSICAL_PROCESSING_GRID (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_POINT ADD (CONSTRAINT fk_GEOPHYSICAL_POINT5
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_PROCESSING_GRID ADD (CONSTRAINT fk_GEOPHYSICAL_PROCESSING_GR1
   FOREIGN KEY (BINSET_GRID_S)
   REFERENCES GEOPHYSICAL_PROCESSING_GRID (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_PROCESSING_GRID ADD (CONSTRAINT fk_GEOPHYSICAL_PROCESSING_GR2
   FOREIGN KEY (GEOMETRY_SET_S)
   REFERENCES GEOPHYSICAL_GEOMETRY_SET (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_PROCESSING_GRID ADD (CONSTRAINT fk_GEOPHYSICAL_PROCESSING_GR3
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_PROCESSING_GRID ADD (CONSTRAINT fk_GEOPHYSICAL_PROCESSING_GR4
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEOPHYSICAL_PROCESSING_GRID ADD (CONSTRAINT fk_GEOPHYSICAL_PROCESSING_GR5
   FOREIGN KEY (R_GRID_VARIANT)
   REFERENCES R_GRID_VARIANT (IDENTIFIER));
ALTER TABLE GEOPHYSICAL_PROCESSING_GRID ADD (CONSTRAINT fk_GEOPHYSICAL_PROCESSING_GR6
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_PROC_INDICATOR ADD (CONSTRAINT fk_GEOPHYSICAL_PROC_INDICATO1
   FOREIGN KEY (DATA_SET_S)
   REFERENCES GEOPHYSICAL_DATA_SET (INSTANCE_S));
ALTER TABLE GEOPHYSICAL_PROC_INDICATOR ADD (CONSTRAINT fk_GEOPHYSICAL_PROC_INDICATO2
   FOREIGN KEY (R_PROCESSING_INDICATOR)
   REFERENCES R_PROCESSING_INDICATOR (IDENTIFIER));
ALTER TABLE GEOPOLITICAL_BORDER ADD (CONSTRAINT fk_GEOPOLITICAL_BORDER1
   FOREIGN KEY (BORDERING_FEATURE_S)
   REFERENCES GEOPOLITICAL_FEATURE (INSTANCE_S));
ALTER TABLE GEOPOLITICAL_BORDER ADD (CONSTRAINT fk_GEOPOLITICAL_BORDER2
   FOREIGN KEY (GEOPOLITICAL_FEATURE_S)
   REFERENCES GEOPOLITICAL_FEATURE (INSTANCE_S));
ALTER TABLE GEOPOLITICAL_BORDER ADD (CONSTRAINT fk_GEOPOLITICAL_BORDER3
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE GEOPOLITICAL_BORDER ADD (CONSTRAINT fk_GEOPOLITICAL_BORDER4
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEOPOLITICAL_BORDER ADD (CONSTRAINT fk_GEOPOLITICAL_BORDER5
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GEOPOLITICAL_BOUNDARY ADD (CONSTRAINT fk_GEOPOLITICAL_BOUNDARY1
   FOREIGN KEY (GEOPOLITICAL_FEATURE_S)
   REFERENCES GEOPOLITICAL_FEATURE (INSTANCE_S));
ALTER TABLE GEOPOLITICAL_BOUNDARY ADD (CONSTRAINT fk_GEOPOLITICAL_BOUNDARY2
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE GEOPOLITICAL_BOUNDARY ADD (CONSTRAINT fk_GEOPOLITICAL_BOUNDARY3
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEOPOLITICAL_BOUNDARY ADD (CONSTRAINT fk_GEOPOLITICAL_BOUNDARY4
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GEOPOLITICAL_FEATURE ADD (CONSTRAINT fk_GEOPOLITICAL_FEATURE1
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE GEOPOLITICAL_FEATURE ADD (CONSTRAINT fk_GEOPOLITICAL_FEATURE2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE GEOPOLITICAL_FEATURE ADD (CONSTRAINT fk_GEOPOLITICAL_FEATURE3
   FOREIGN KEY (R_GEOPOLITICAL_AREA)
   REFERENCES R_GEOPOLITICAL_AREA (IDENTIFIER));
ALTER TABLE GEOPOLITICAL_FEATURE ADD (CONSTRAINT fk_GEOPOLITICAL_FEATURE4
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE GRID_1D ADD (CONSTRAINT fk_GRID_1D1
   FOREIGN KEY (ORIGIN_Q)
   REFERENCES R_QUANTITY_TYPE (IDENTIFIER));
ALTER TABLE GRID_1D ADD (CONSTRAINT fk_GRID_1D2
   FOREIGN KEY (ORIGIN_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GRID_1D ADD (CONSTRAINT fk_GRID_1D3
   FOREIGN KEY (PROPERTY_KIND_S)
   REFERENCES PROPERTY_KIND (INSTANCE_S));
ALTER TABLE GRID_1D ADD (CONSTRAINT fk_GRID_1D4
   FOREIGN KEY (STEP_Q)
   REFERENCES R_QUANTITY_TYPE (IDENTIFIER));
ALTER TABLE GRID_1D ADD (CONSTRAINT fk_GRID_1D5
   FOREIGN KEY (STEP_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GRID_COMPOSITION ADD (CONSTRAINT fk_GRID_COMPOSITION1
   FOREIGN KEY (GRID_DEFINED_GRID_S)
   REFERENCES GRID_DEFINED_GRID (INSTANCE_S));
ALTER TABLE GRID_MODIFICATION ADD (CONSTRAINT fk_GRID_MODIFICATION1
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE GRID_MODIFICATION ADD (CONSTRAINT fk_GRID_MODIFICATION2
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GRID_MODIFICATION ADD (CONSTRAINT fk_GRID_MODIFICATION3
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE GRID_MODIFICATION ADD (CONSTRAINT fk_GRID_MODIFICATION4
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE GUIDELINE_COMPLIANCE ADD (CONSTRAINT fk_GUIDELINE_COMPLIANCE1
   FOREIGN KEY (ACTIVITY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE GUIDELINE_COMPLIANCE ADD (CONSTRAINT fk_GUIDELINE_COMPLIANCE2
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE GUIDELINE_COMPLIANCE ADD (CONSTRAINT fk_GUIDELINE_COMPLIANCE3
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GUIDELINE_COMPLIANCE ADD (CONSTRAINT fk_GUIDELINE_COMPLIANCE4
   FOREIGN KEY (GUIDELINE_OR_PRIVILEGE_S)
   REFERENCES GUIDELINE_OR_PRIVILEGE (INSTANCE_S));
ALTER TABLE GUIDELINE_COMPLIANCE ADD (CONSTRAINT fk_GUIDELINE_COMPLIANCE5
   FOREIGN KEY (R_GUIDELINE_COMPLIANCE)
   REFERENCES R_GUIDELINE_COMPLIANCE (IDENTIFIER));
ALTER TABLE GUIDELINE_COMPLIANCE ADD (CONSTRAINT fk_GUIDELINE_COMPLIANCE6
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE GUIDELINE_COMPLIANCE ADD (CONSTRAINT fk_GUIDELINE_COMPLIANCE7
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE GUIDELINE_OR_PRIVILEGE ADD (CONSTRAINT fk_GUIDELINE_OR_PRIVILEGE1
   FOREIGN KEY (BUSINESS_ASSOCIATE_S)
   REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S));
ALTER TABLE GUIDELINE_OR_PRIVILEGE ADD (CONSTRAINT fk_GUIDELINE_OR_PRIVILEGE2
   FOREIGN KEY (DATA_VALUE_Q)
   REFERENCES R_QUANTITY_TYPE (IDENTIFIER));
ALTER TABLE GUIDELINE_OR_PRIVILEGE ADD (CONSTRAINT fk_GUIDELINE_OR_PRIVILEGE3
   FOREIGN KEY (DATA_VALUE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GUIDELINE_OR_PRIVILEGE ADD (CONSTRAINT fk_GUIDELINE_OR_PRIVILEGE4
   FOREIGN KEY (GUIDELINE_SET_S)
   REFERENCES GUIDELINE_SET (INSTANCE_S));
ALTER TABLE GUIDELINE_OR_PRIVILEGE ADD (CONSTRAINT fk_GUIDELINE_OR_PRIVILEGE5
   FOREIGN KEY (LIMITATION_SET_S)
   REFERENCES LIMITATION_SET (INSTANCE_S));
ALTER TABLE GUIDELINE_OR_PRIVILEGE ADD (CONSTRAINT fk_GUIDELINE_OR_PRIVILEGE6
   FOREIGN KEY (OBJECTIVE_SET_S)
   REFERENCES OBJECTIVE_SET (INSTANCE_S));
ALTER TABLE GUIDELINE_OR_PRIVILEGE ADD (CONSTRAINT fk_GUIDELINE_OR_PRIVILEGE7
   FOREIGN KEY (R_BUSINESS_ASSOC_PRIVILEGE)
   REFERENCES R_BUSINESS_ASSOC_PRIVILEGE (IDENTIFIER));
ALTER TABLE GUIDELINE_OR_PRIVILEGE ADD (CONSTRAINT fk_GUIDELINE_OR_PRIVILEGE8
   FOREIGN KEY (R_GUIDELINE)
   REFERENCES R_GUIDELINE (IDENTIFIER));
ALTER TABLE GUIDELINE_OR_PRIVILEGE ADD (CONSTRAINT fk_GUIDELINE_OR_PRIVILEGE9
   FOREIGN KEY (R_LIMITATION)
   REFERENCES R_LIMITATION (IDENTIFIER));
ALTER TABLE GUIDELINE_OR_PRIVILEGE ADD (CONSTRAINT fk_GUIDELINE_OR_PRIVILEGE10
   FOREIGN KEY (R_OBJECTIVE)
   REFERENCES R_OBJECTIVE (IDENTIFIER));
ALTER TABLE GUIDELINE_OR_PRIVILEGE ADD (CONSTRAINT fk_GUIDELINE_OR_PRIVILEGE11
   FOREIGN KEY (R_REGULATION)
   REFERENCES R_REGULATION (IDENTIFIER));
ALTER TABLE GUIDELINE_OR_PRIVILEGE ADD (CONSTRAINT fk_GUIDELINE_OR_PRIVILEGE12
   FOREIGN KEY (R_REGULATION_PURPOSE)
   REFERENCES R_REGULATION_PURPOSE (IDENTIFIER));
ALTER TABLE GUIDELINE_OR_PRIVILEGE_REMEDY ADD (CONSTRAINT fk_GUIDELINE_OR_PRIVILEGE_RE1
   FOREIGN KEY (ACTION_VALUE_Q)
   REFERENCES R_QUANTITY_TYPE (IDENTIFIER));
ALTER TABLE GUIDELINE_OR_PRIVILEGE_REMEDY ADD (CONSTRAINT fk_GUIDELINE_OR_PRIVILEGE_RE2
   FOREIGN KEY (ACTION_VALUE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GUIDELINE_OR_PRIVILEGE_REMEDY ADD (CONSTRAINT fk_GUIDELINE_OR_PRIVILEGE_RE3
   FOREIGN KEY (ACTIVITY_CLASS_S)
   REFERENCES ACTIVITY_CLASS (INSTANCE_S));
ALTER TABLE GUIDELINE_OR_PRIVILEGE_REMEDY ADD (CONSTRAINT fk_GUIDELINE_OR_PRIVILEGE_RE4
   FOREIGN KEY (GUIDELINE_OR_PRIVILEGE_S)
   REFERENCES GUIDELINE_OR_PRIVILEGE (INSTANCE_S));
ALTER TABLE GUIDELINE_OR_PRIVILEGE_REMEDY ADD (CONSTRAINT fk_GUIDELINE_OR_PRIVILEGE_RE5
   FOREIGN KEY (TEST_VALUE_Q)
   REFERENCES R_QUANTITY_TYPE (IDENTIFIER));
ALTER TABLE GUIDELINE_OR_PRIVILEGE_REMEDY ADD (CONSTRAINT fk_GUIDELINE_OR_PRIVILEGE_RE6
   FOREIGN KEY (TEST_VALUE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE GUIDELINE_SET ADD (CONSTRAINT fk_GUIDELINE_SET1
   FOREIGN KEY (KIND_S)
   REFERENCES DOCUMENT_SPECIFICATION_CLASS (INSTANCE_S));
ALTER TABLE GUIDELINE_SET ADD (CONSTRAINT fk_GUIDELINE_SET2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE HATCH_LINE_PATTERN ADD (CONSTRAINT fk_HATCH_LINE_PATTERN1
   FOREIGN KEY (LINE_OFFSET_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE HATCH_LINE_PATTERN ADD (CONSTRAINT fk_HATCH_LINE_PATTERN2
   FOREIGN KEY (LINE_SPACING_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE HATCH_LINE_PATTERN ADD (CONSTRAINT fk_HATCH_LINE_PATTERN3
   FOREIGN KEY (LINE_STYLE_S)
   REFERENCES LINE_STYLE (INSTANCE_S));
ALTER TABLE HATCH_LINE_PATTERN ADD (CONSTRAINT fk_HATCH_LINE_PATTERN4
   FOREIGN KEY (ORIENTATION_ANGLE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE HEADER_BIN_INDEX_UTILIZATION ADD (CONSTRAINT fk_HEADER_BIN_INDEX_UTILIZAT1
   FOREIGN KEY (BINSET_S)
   REFERENCES GEOPHYSICAL_PROCESSING_GRID (INSTANCE_S));
ALTER TABLE HEADER_BIN_INDEX_UTILIZATION ADD (CONSTRAINT fk_HEADER_BIN_INDEX_UTILIZAT2
   FOREIGN KEY (SEISMIC_HEADER_S)
   REFERENCES SEISMIC_HEADER (INSTANCE_S));
ALTER TABLE HEADER_BIN_INDEX_VARIANT_UTIL ADD (CONSTRAINT fk_HEADER_BIN_INDEX_VARIANT_1
   FOREIGN KEY (BINSET_VARIANT_S)
   REFERENCES GEOPHYSICAL_PROCESSING_GRID (INSTANCE_S));
ALTER TABLE HEADER_BIN_INDEX_VARIANT_UTIL ADD (CONSTRAINT fk_HEADER_BIN_INDEX_VARIANT_2
   FOREIGN KEY (SEISMIC_HEADER_S)
   REFERENCES SEISMIC_HEADER (INSTANCE_S));
ALTER TABLE IMAGE_PALETTE ADD (CONSTRAINT fk_IMAGE_PALETTE1
   FOREIGN KEY (IMAGE_PALETTE_TYPE)
   REFERENCES R_IMAGE_PALETTE_TYPE (IDENTIFIER));
ALTER TABLE IMAGE_PALETTE ADD (CONSTRAINT fk_IMAGE_PALETTE2
   FOREIGN KEY (SYMBOL_LIBRARY_S)
   REFERENCES SYMBOL_LIBRARY (INSTANCE_S));
ALTER TABLE INCELL ADD (CONSTRAINT fk_INCELL1
   FOREIGN KEY (CELL_HEIGHT_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE INCELL ADD (CONSTRAINT fk_INCELL2
   FOREIGN KEY (CELL_OFFSET_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE INCELL ADD (CONSTRAINT fk_INCELL3
   FOREIGN KEY (CELL_ORIENTATION_ANGLE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE INCELL ADD (CONSTRAINT fk_INCELL4
   FOREIGN KEY (CELL_S)
   REFERENCES CELL (INSTANCE_S));
ALTER TABLE INCELL ADD (CONSTRAINT fk_INCELL5
   FOREIGN KEY (CELL_SPACING_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE INCELL ADD (CONSTRAINT fk_INCELL6
   FOREIGN KEY (CELL_WIDTH_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE INCIDENT_REPORT ADD (CONSTRAINT fk_INCIDENT_REPORT1
   FOREIGN KEY (KIND_S)
   REFERENCES DOCUMENT_SPECIFICATION_CLASS (INSTANCE_S));
ALTER TABLE INCIDENT_REPORT ADD (CONSTRAINT fk_INCIDENT_REPORT2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE INTERPRETED_FEATURE_ASSN ADD (CONSTRAINT fk_INTERPRETED_FEATURE_ASSN1
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE INTERPRETED_FEATURE_ASSN ADD (CONSTRAINT fk_INTERPRETED_FEATURE_ASSN2
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE INTERPRETED_FEATURE_ASSN ADD (CONSTRAINT fk_INTERPRETED_FEATURE_ASSN3
   FOREIGN KEY (GEOLOGIC_FEATURE_S)
   REFERENCES GEOLOGIC_FEATURE (INSTANCE_S));
ALTER TABLE INTERPRETED_FEATURE_ASSN ADD (CONSTRAINT fk_INTERPRETED_FEATURE_ASSN4
   FOREIGN KEY (R_TRANSIENT_PERIOD)
   REFERENCES R_TRANSIENT_PERIOD (IDENTIFIER));
ALTER TABLE INTERPRETED_FEATURE_ASSN ADD (CONSTRAINT fk_INTERPRETED_FEATURE_ASSN5
   FOREIGN KEY (SEISMIC_FEATURE_S)
   REFERENCES GEOLOGIC_FEATURE (INSTANCE_S));
ALTER TABLE INTERPRETED_FEATURE_ASSN ADD (CONSTRAINT fk_INTERPRETED_FEATURE_ASSN6
   FOREIGN KEY (TERMINATED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE INTERPROCESS_DATA ADD (CONSTRAINT fk_INTERPROCESS_DATA1
   FOREIGN KEY (ACTIVITY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE INTERPROCESS_DATA ADD (CONSTRAINT fk_INTERPROCESS_DATA2
   FOREIGN KEY (PROCESS_PARAMETER_S)
   REFERENCES PROCESS_PARAMETER (INSTANCE_S));
ALTER TABLE INTERPROCESS_DATA ADD (CONSTRAINT fk_INTERPROCESS_DATA3
   FOREIGN KEY (QUANTITY_VALUE_Q)
   REFERENCES R_QUANTITY_TYPE (IDENTIFIER));
ALTER TABLE INTERPROCESS_DATA ADD (CONSTRAINT fk_INTERPROCESS_DATA4
   FOREIGN KEY (QUANTITY_VALUE_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE INTEXT ADD (CONSTRAINT fk_INTEXT1
   FOREIGN KEY (INLINE_DISPLACEMENT_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE INTEXT ADD (CONSTRAINT fk_INTEXT2
   FOREIGN KEY (OFFLINE_DISPLACEMENT_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE INTEXT ADD (CONSTRAINT fk_INTEXT3
   FOREIGN KEY (TEXT_STYLE_S)
   REFERENCES TEXT_STYLE (INSTANCE_S));
ALTER TABLE ISOLINE ADD (CONSTRAINT fk_ISOLINE1
   FOREIGN KEY (ISOLINE_SET_S)
   REFERENCES ISOLINE_SET (INSTANCE_S));
ALTER TABLE ISOLINE_SET ADD (CONSTRAINT fk_ISOLINE_SET1
   FOREIGN KEY (PROPERTY_KIND_S)
   REFERENCES PROPERTY_KIND (INSTANCE_S));
ALTER TABLE ISOLINE_SET ADD (CONSTRAINT fk_ISOLINE_SET2
   FOREIGN KEY (R_UNIT_OF_MEASURE)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE LEGAL_SURVEY_AREA_CORNER ADD (CONSTRAINT fk_LEGAL_SURVEY_AREA_CORNER1
   FOREIGN KEY (LEGAL_SURVEY_FEATURE_S)
   REFERENCES LEGAL_SURVEY_FEATURE (INSTANCE_S));
ALTER TABLE LEGAL_SURVEY_FEATURE ADD (CONSTRAINT fk_LEGAL_SURVEY_FEATURE1
   FOREIGN KEY (KIND_S)
   REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S));
ALTER TABLE LEGAL_SURVEY_FEATURE ADD (CONSTRAINT fk_LEGAL_SURVEY_FEATURE2
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE LEGAL_SURVEY_FEATURE ADD (CONSTRAINT fk_LEGAL_SURVEY_FEATURE3
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE LICENSE_PAYMENT ADD (CONSTRAINT fk_LICENSE_PAYMENT1
   FOREIGN KEY (AMOUNT_U)
   REFERENCES R_CURRENCY_UNIT (ACRONYM));
ALTER TABLE LICENSE_PAYMENT ADD (CONSTRAINT fk_LICENSE_PAYMENT2
   FOREIGN KEY (KIND)
   REFERENCES R_LICENSE_PAYMENT (IDENTIFIER));
ALTER TABLE LICENSE_PAYMENT ADD (CONSTRAINT fk_LICENSE_PAYMENT3
   FOREIGN KEY (LICENSE_RIGHT_S)
   REFERENCES LICENSE_RIGHT (INSTANCE_S));
ALTER TABLE LICENSE_RIGHT ADD (CONSTRAINT fk_LICENSE_RIGHT1
   FOREIGN KEY (R_LICENSE_RIGHT)
   REFERENCES R_LICENSE_RIGHT (IDENTIFIER));
ALTER TABLE LICENSE_RIGHT ADD (CONSTRAINT fk_LICENSE_RIGHT2
   FOREIGN KEY (R_LICENSE_RIGHT_ACQUISITION)
   REFERENCES R_LICENSE_RIGHT_ACQUISITION (IDENTIFIER));
ALTER TABLE LICENSE_RIGHT_CLASS ADD (CONSTRAINT fk_LICENSE_RIGHT_CLASS1
   FOREIGN KEY (NAMING_SYSTEM)
   REFERENCES NAMING_SYSTEM (IDENTIFIER));
ALTER TABLE LICENSE_RIGHT_CLASS ADD (CONSTRAINT fk_LICENSE_RIGHT_CLASS2
   FOREIGN KEY (VERSION_S)
   REFERENCES R_VERSION (INSTANCE_S));
ALTER TABLE LICENSE_RIGHT_CLASSIFICATION ADD (CONSTRAINT fk_LICENSE_RIGHT_CLASSIFICAT1
   FOREIGN KEY (CAUSED_BY_S)
   REFERENCES ACTIVITY (INSTANCE_S));
ALTER TABLE LICENSE_RIGHT_CLASSIFICATION ADD (CONSTRAINT fk_LICENSE_RIGHT_CLASSIFICAT2
   FOREIGN KEY (DURATION_U)
   REFERENCES R_UNIT_OF_MEASURE (ACRONYM));
ALTER TABLE LICENSE_RIGHT_CLASSIFICATION ADD (CONSTRAINT fk_L