Constraints

82 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
TRAINING_FACILITY_DOCUMEN_FK2
TRAINING_FACILITY_DOCUMENT.DOCUMENT_ID
DOCUMENT.DOCUMENT_ID
Restrict delete
TRAINING_FACILITY_DOCUMEN_FK1
TRAINING_FACILITY_DOCUMENT.TRAINING_FACILITY_ID
TRAINING_FACILITY.TRAINING_FACILITY_ID
Restrict delete
MET_PROGRAMM_STCW_REFEREN_FK1
MET_PROGRAMM.STCW_REFERENCE_ID_1
STCW_REFERENCE.STCW_REFERENCE_ID
Restrict delete
MET_PROGRAMM_ENUM_UNIT_FK1
MET_PROGRAMM.ENUM_UNIT_ID
ENUM_UNIT.ENUM_UNIT_ID
Restrict delete
MET_PROGRAMM_S_FK2
MET_PROGRAMM.STCW_REFERENCE_ID_2
STCW_REFERENCE.STCW_REFERENCE_ID
Restrict delete
MET_PROGRAMM_S_FK3
MET_PROGRAMM.STCW_REFERENCE_ID_3
STCW_REFERENCE.STCW_REFERENCE_ID
Restrict delete
MET_PROGRAMM_LEGAL_ENTITY_FK1
MET_PROGRAMM.LEGAL_ENTITY_ID
LEGAL_ENTITY.LEGAL_ENTITY_ID
Restrict delete
RECOGNISED_COUNTRY_COUNTR_FK1
RECOGNISED_COUNTRY.COUNTRY_ID
COUNTRY.COUNTRY_ID
Restrict delete
RECOGNISED_COUNTRY_COUNTR_FK2
RECOGNISED_COUNTRY.COUNTRY_REF_ID
COUNTRY.COUNTRY_ID
Restrict delete
PROCESS_PROCESS_COLLECTIO_FK1
PROCESS_PROCESS_COLLECTION.PROCESS_ID
PROCESS.PROCESS_ID
Restrict delete
PROCESS_PROCESS_COLLECTIO_FK2
PROCESS_PROCESS_COLLECTION.PROCESS_COLLECTION_ID
PROCESS_COLLECTION.PROCESS_COLLECTION_ID
Restrict delete
CERT_ENDORSEMENT_DOCUMENT_FK1
CERT_ENDORSEMENT_DOCUMENT.CERTIFICATE_ENDORSEMENT_ID
CERTIFICATE_ENDORSEMENT.CERTIFICATE_ENDORSEMENT_ID
Restrict delete
CERT_ENDORSEMENT_DOCUMENT_FK2
CERT_ENDORSEMENT_DOCUMENT.DOCUMENT_ID
DOCUMENT.DOCUMENT_ID
Restrict delete
QUALITY_SYSTEM_DOCUMENT_D_FK1
QUALITY_SYSTEM_DOCUMENT.DOCUMENT_ID
DOCUMENT.DOCUMENT_ID
Restrict delete
QUALITY_SYSTEM_DOCUMENT_Q_FK1
QUALITY_SYSTEM_DOCUMENT.QUALITY_SYSTEM_ID
QUALITY_SYSTEM.QUALITY_SYSTEM_ID
Restrict delete
COUNTRY_ENUM_CURRENCY_FK1
COUNTRY.ENUM_CURRENCY_ID
ENUM_CURRENCY.ENUM_CURRENCY_ID
Restrict delete
COUNTRY_DOCUMENT_FK1
COUNTRY.DOCUMENT_ID
DOCUMENT.DOCUMENT_ID
Restrict delete
COUNTRY_ENUM_TIMEZONE_FK1
COUNTRY.ENUM_TIMEZONE_ID
ENUM_TIMEZONE.ENUM_TIMEZONE_ID
Restrict delete
COUNTRY_COUNTRY_FK1
COUNTRY.ENUM_COUNTRY_GROUP_ID
ENUM_COUNTRY_GROUP.ENUM_COUNTRY_GROUP_ID
Restrict delete
PROCESS_ENUM_STATUS_FK1
PROCESS.ENUM_STATUS_ID
ENUM_STATUS.ENUM_STATUS_ID
Restrict delete
PROCESS_ENUM_LEGAL_ENTITY_FK
PROCESS.ENUM_LEGAL_ENTITY_ID
ENUM_LEGAL_ENTITY.ENUM_LEGAL_ENTITY_ID
Restrict delete
FINDING_INSP_L_ENTITY_FK
FINDING.INSPECTION_LEGAL_ENTITY_ID
INSPECTION_LEGAL_ENTITY.INSPECTION_LEGAL_ENTITY_ID
Restrict delete
FINDING_ENUM_FINDING_TYPE_FK1
FINDING.ENUM_FINDING_TYPE_ID
ENUM_FINDING_TYPE.ENUM_FINDING_TYPE_ID
Restrict delete
FINDING_PROCESS_L_REQ_FK1
FINDING.LEGAL_REQUIREMENT_PROCESS_ID
LEGAL_REQUIREMENT_PROCESS.LEGAL_REQUIREMENT_PROCESS_ID
Restrict delete
FINDING_ENUM_STATUS_FK1
FINDING.ENUM_STATUS_ID
ENUM_STATUS.ENUM_STATUS_ID
Restrict delete
TRAINING_FACILITY_LEGAL_E_FK1
TRAINING_FACILITY.LEGAL_ENTITY_ID
LEGAL_ENTITY.LEGAL_ENTITY_ID
Restrict delete
TRAINING_FACILITY_ENUM_FA_FK1
TRAINING_FACILITY.ENUM_FACILITY_TYPE_ID
ENUM_FACILITY_TYPE.ENUM_FACILITY_TYPE_ID
Restrict delete
DISPENSATION_COUNTRY_FK1
DISPENSATION.COUNTRY_ID
COUNTRY.COUNTRY_ID
Restrict delete
DISPENSATION_STCW_REFEREN_FK1
DISPENSATION.STCW_REFERENCE_ID
STCW_REFERENCE.STCW_REFERENCE_ID
Restrict delete
INSPECTION_ENUM_STATUS_FK1
INSPECTION.ENUM_STATUS_ID
ENUM_STATUS.ENUM_STATUS_ID
Restrict delete
INSPECTION_PROCESS_COLLEC_FK2
INSPECTION.PROCESS_COLLECTION_MET_ID
PROCESS_COLLECTION.PROCESS_COLLECTION_ID
Restrict delete
INSPECTION_PROCESS_COLLEC_FK1
INSPECTION.PROCESS_COLLECTION_ID
PROCESS_COLLECTION.PROCESS_COLLECTION_ID
Restrict delete
COUNTRY_EXTERNAL_LINK_COU_FK1
COUNTRY_EXTERNAL_LINK.COUNTRY_ID
COUNTRY.COUNTRY_ID
Restrict delete
PROCESS_LEGAL_ENTITY_PROC_FK1
PROCESS_ENUM_LEGAL_ENTITY.PROCESS_ID
PROCESS.PROCESS_ID
Restrict delete
PROCESS_LEGAL_ENTITY_ENUM_FK1
PROCESS_ENUM_LEGAL_ENTITY.ENUM_LEGAL_ENTITY_ID
ENUM_LEGAL_ENTITY.ENUM_LEGAL_ENTITY_ID
Restrict delete
LEGAL_REQUIREMENT_PROCESS_FK2
LEGAL_REQUIREMENT_PROCESS.LEGAL_REQUIREMENT_ID
LEGAL_REQUIREMENT.LEGAL_REQUIREMENT_ID
Restrict delete
LEGAL_REQUIREMENT_PROCESS_FK1
LEGAL_REQUIREMENT_PROCESS.PROCESS_ID
PROCESS.PROCESS_ID
Restrict delete
INSPECTION_LEGAL_ENTITY_FK1
INSPECTION_LEGAL_ENTITY.LEGAL_ENTITY_ID
LEGAL_ENTITY.LEGAL_ENTITY_ID
Restrict delete
INSPECTION_LEGAL_ENTITY_FK2
INSPECTION_LEGAL_ENTITY.INSPECTION_ID
INSPECTION.INSPECTION_ID
Restrict delete
LEGAL_DOCUMENT_ENUM_STATU_FK1
LEGAL_DOCUMENT.ENUM_STATUS_ID
ENUM_STATUS.ENUM_STATUS_ID
Restrict delete
LEGAL_DOCUMENT_LEGAL_DOCU_FK1
LEGAL_DOCUMENT.PARENT_ID
LEGAL_DOCUMENT.LEGAL_DOCUMENT_ID
Restrict delete
CERTIFICATE_ENDORSEMENT_E_FK1
CERTIFICATE_ENDORSEMENT.ENUM_CERTIFICATE_TYPE_ID
ENUM_CERTIFICATE_TYPE.ENUM_CERTIFICATE_TYPE_ID
Restrict delete
CERTIFICATE_ENDORSEMENT_D_FK1
CERTIFICATE_ENDORSEMENT.DOCUMENT_ID
DOCUMENT.DOCUMENT_ID
Restrict delete
CERTIFICATE_ENDORSEMENT_S_FK1
CERTIFICATE_ENDORSEMENT.STCW_REFERENCE_ID_1
STCW_REFERENCE.STCW_REFERENCE_ID
Restrict delete
CERTIFICATE_ENDORSEMENT_S_FK3
CERTIFICATE_ENDORSEMENT.STCW_REFERENCE_ID_3
STCW_REFERENCE.STCW_REFERENCE_ID
Restrict delete
CERTIFICATE_ENDORSEMENT_S_FK2
CERTIFICATE_ENDORSEMENT.STCW_REFERENCE_ID_2
STCW_REFERENCE.STCW_REFERENCE_ID
Restrict delete
CERTIFICATE_ENDORSEMENT_L_FK1
CERTIFICATE_ENDORSEMENT.LEGAL_ENTITY_ID
LEGAL_ENTITY.LEGAL_ENTITY_ID
Restrict delete
ENUM_STATUS_ENUM_RECORD_T_FK1
ENUM_STATUS.ENUM_RECORD_TYPE_ID
ENUM_RECORD_TYPE.ENUM_RECORD_TYPE_ID
Restrict delete
LEGAL_REQUIREMENT_LEGAL_R_FK2
LEGAL_REQUIREMENT.CHILD_OF_ID
LEGAL_REQUIREMENT.LEGAL_REQUIREMENT_ID
Restrict delete
LEGAL_REQUIREMENT_LEGAL_R_FK1
LEGAL_REQUIREMENT.LEGAL_REQUIREMENT_TYPE_ID
LEGAL_REQUIREMENT_TYPE.LEGAL_REQUIREMENT_TYPE_ID
Restrict delete
LEGAL_REQUIREMENT_LEGAL_D_FK1
LEGAL_REQUIREMENT.LEGAL_DOCUMENT_ID
LEGAL_DOCUMENT.LEGAL_DOCUMENT_ID
Restrict delete
PROCESS_COLLECTION_ENUM_L_FK1
PROCESS_COLLECTION.ENUM_LEGAL_ENTITY_ID
ENUM_LEGAL_ENTITY.ENUM_LEGAL_ENTITY_ID
Restrict delete
FRAUDULENT_CERTIFICATE_ST_FK1
FRAUDULENT_CERTIFICATE.STCW_REFERENCE_ID
STCW_REFERENCE.STCW_REFERENCE_ID
Restrict delete
FRAUDULENT_CERTIFICATE_CO_FK1
FRAUDULENT_CERTIFICATE.COUNTRY_ID
COUNTRY.COUNTRY_ID
Restrict delete
FRAUDULENT_CERTIFICATE_EN_FK1
FRAUDULENT_CERTIFICATE.ENUM_ACTION_TAKEN_ID
ENUM_ACTION_TAKEN.ENUM_ACTION_TAKEN_ID
Restrict delete
FRAUDULENT_CERTIFICATE_EN_FK2
FRAUDULENT_CERTIFICATE.ENUM_METHOD_DETECTION_ID
ENUM_METHOD_DETECTION.ENUM_METHOD_DETECTION_ID
Restrict delete
FRAUDULENT_CERTIFICATE_EN_FK3
FRAUDULENT_CERTIFICATE.ENUM_FRAUD_TYPE_ID
ENUM_FRAUD_TYPE.ENUM_FRAUD_TYPE_ID
Restrict delete
FRAUDULENT_CERTIFICATE_EN_FK4
FRAUDULENT_CERTIFICATE.ENUM_CERTIFICATE_TYPE_ID
ENUM_CERTIFICATE_TYPE.ENUM_CERTIFICATE_TYPE_ID
Restrict delete
LEGAL_ENTITY_COUNTRY_FK1
LEGAL_ENTITY.COUNTRY_ID
COUNTRY.COUNTRY_ID
Restrict delete
LEGAL_ENTITY_ENUM_LEGAL_E_FK1
LEGAL_ENTITY.ENUM_LEGAL_ENTITY_ID
ENUM_LEGAL_ENTITY.ENUM_LEGAL_ENTITY_ID
Restrict delete
LEGISLATION_ENUM_STATUS_FK1
LEGISLATION.ENUM_STATUS_ID
ENUM_STATUS.ENUM_STATUS_ID
Restrict delete
LEGISLATION_COUNTRY_FK1
LEGISLATION.COUNTRY_ID
COUNTRY.COUNTRY_ID
Restrict delete
STCW_REFERENCE_ENUM_STCW__FK1
STCW_REFERENCE.ENUM_STCW_REFERENCE_TYPE_ID
ENUM_STCW_REFERENCE_TYPE.ENUM_STCW_REFERENCE_TYPE_ID
Restrict delete
STUDENT_LEGAL_ENTITY_FK1
STUDENT.LEGAL_ENTITY_ID
LEGAL_ENTITY.LEGAL_ENTITY_ID
Restrict delete
STUDENT_MTP_FK2
STUDENT.MET_PROGRAMM_ID
MET_PROGRAMM.MET_PROGRAMM_ID
Restrict delete
MET_PROGRAMM_DOCUMENT_FK2
MET_PROGRAMM_DOCUMENT.DOCUMENT_ID
DOCUMENT.DOCUMENT_ID
Restrict delete
MET_PROGRAMM_DOC_FK1
MET_PROGRAMM_DOCUMENT.MET_PROGRAMM_ID
MET_PROGRAMM.MET_PROGRAMM_ID
Restrict delete
STRUCTURE_LEGAL_ENTITY_FK1
STRUCTURE.LEGAL_ENTITY_ID
LEGAL_ENTITY.LEGAL_ENTITY_ID
Restrict delete
LEGAL_ENTITY_DOCUMENT_DOC_FK1
LEGAL_ENTITY_DOCUMENT.DOCUMENT_ID
DOCUMENT.DOCUMENT_ID
Restrict delete
LEGAL_ENTITY_DOCUMENT_LEG_FK1
LEGAL_ENTITY_DOCUMENT.LEGAL_ENTITY_ID
LEGAL_ENTITY.LEGAL_ENTITY_ID
Restrict delete
METC_SYSTEM_COUNTRY_FK1
METC_SYSTEM.COUNTRY_ID
COUNTRY.COUNTRY_ID
Restrict delete
METC_SYSTEM_DOCUMENT_FK1
METC_SYSTEM.DOCUMENT_ID
DOCUMENT.DOCUMENT_ID
Restrict delete
QUALITY_SYSTEM_LEGAL_ENTI_FK1
QUALITY_SYSTEM.LEGAL_ENTITY_ID
LEGAL_ENTITY.LEGAL_ENTITY_ID
Restrict delete
FINDING_LEGAL_REQUIREMENT_FK1
FINDING_LEGAL_REQUIREMENT.LEGAL_REQUIREMENT_ID
LEGAL_REQUIREMENT.LEGAL_REQUIREMENT_ID
Restrict delete
FINDING_LEGAL_REQUIREMENT_FK2
FINDING_LEGAL_REQUIREMENT.FINDING_ID
FINDING.FINDING_ID
Restrict delete
FRAUDULENT_CERTIFICATE_DO_FK2
FRAUDULENT_CERTIFICATE_DOC.FRAUDULENT_CERTIFICATE_ID
FRAUDULENT_CERTIFICATE.FRAUDULENT_CERTIFICATE_ID
Restrict delete
FRAUDULENT_CERTIFICATE_DO_FK1
FRAUDULENT_CERTIFICATE_DOC.DOCUMENT_ID
DOCUMENT.DOCUMENT_ID
Restrict delete
LEGAL_REQUIREMENT_ASSOCIA_FK2
LEGAL_REQUIREMENT_ASSOCIATION.LEGAL_REQUIREMENT_PARENT_ID
LEGAL_REQUIREMENT.LEGAL_REQUIREMENT_ID
Restrict delete
LEGAL_REQUIREMENT_ASSOCIA_FK1
LEGAL_REQUIREMENT_ASSOCIATION.LEGAL_REQUIREMENT_ID
LEGAL_REQUIREMENT.LEGAL_REQUIREMENT_ID
Restrict delete
LEGAL_REQUIREMENT_CORRELA_FK1
LEGAL_REQUIREMENT_CORRELATION.LEGAL_REQUIREMENT_ID
LEGAL_REQUIREMENT.LEGAL_REQUIREMENT_ID
Restrict delete
LEGAL_REQUIREMENT_CORRELA_FK2
LEGAL_REQUIREMENT_CORRELATION.REQUIREMENT_CORRELATED_ID
LEGAL_REQUIREMENT.LEGAL_REQUIREMENT_ID
Restrict delete
INSPECTION_TEAM_INSPECTIO_FK1
INSPECTION_TEAM.INSPECTION_ID
INSPECTION.INSPECTION_ID
Restrict delete

Check Constraints

Table Constraint Name Constraint