SchemaSpy Analysis of opm - Constraints Generated by
SchemaSpy
25 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
capacityTierAnalysis_ResourceType_fk capacity_tier_analysis.resourceType element_type_definition.id Restrict delete 
change_event_attribute_ibfk_1 change_event_attribute.changeEventId change_event.id Cascade on delete 
change_event_workload_ibfk_1 change_event_workload.changeEventId change_event.id Cascade on delete 
changeTypeDefinition change_event.changeTypeId change_type_definition.id Restrict delete 
continuous_event_participant_ibfk_1 continuous_event_participant.occurrenceId event.id Cascade on delete 
continuous_eventParticipantId_fk_1 continuous_event_participant_stats.eventParticipantId continuous_event_participant.id Cascade on delete 
counterType threshold.statType stat_type_definition.id Restrict delete 
dynStateDefinition_ibfk_1 continuous_event_participant_stats.dynState dyn_state_definition.id Restrict delete 
elementType_threshold threshold.elementType element_type_definition.id Restrict delete 
elementTypeDependency threshold_policy_mapping.elementType element_type_definition.id Restrict delete 
ext_data_config_ibfk_1 ext_data_config.serverId ext_server_config.id Restrict delete 
fk_preferredStorageServiceLevelId resource_capability_stats.preferredStorageServiceLevelId storage_service_level.id Null on delete 
fk_resourceType resource_capability_stats.resourceType element_type_definition.id Cascade on delete 
fk_storageServiceLevelId workload_provision_mapping.storageServiceLevelId storage_service_level.id Null on delete 
fk_suggestedStorageServiceLevelId workload_provision_mapping.suggestedStorageServiceLevelId storage_service_level.id Null on delete 
fk_workloadType workload_provision_mapping.workloadType element_type_definition.id Cascade on delete 
FKtenant_id active_directory.tenant_id tenant.id Cascade on delete 
mappedObjType_cr coherence_change_record.mappedObjType element_type_definition.id Restrict delete 
objectTypeDefinition change_event.objectTypeId element_type_definition.id Restrict delete 
objType_cr coherence_change_record.objType element_type_definition.id Restrict delete 
policyId_threshold threshold.policyId threshold_policy.id Cascade on delete 
policyId_thresholdpolicy threshold_policy_mapping.policyId threshold_policy.id Cascade on delete 
statTypeDefinition_ibfk_1 continuous_event_participant_stats.statType stat_type_definition.id Restrict delete 
thresholdPolicy_elementType threshold_policy.elementType element_type_definition.id Restrict delete 
workloadType change_event_workload.workloadTypeId element_type_definition.id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected