SchemaSpy Analysis of ocum - Constraints Generated by
SchemaSpy
146 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
AggregateGrowthRateInfo_aggregate_id_FK aggregategrowthrateinfo.aggregate_id aggregate.id Cascade on delete 
AggregateHistoryMonth_aggregateId_FK aggregatehistorymonth.aggregateId aggregate.id Cascade on delete 
AggregateHistoryWeek_aggregateId_FK aggregatehistoryweek.aggregateId aggregate.id Cascade on delete 
AggregateHistoryYear_aggregateId_FK aggregatehistoryyear.aggregateId aggregate.id Cascade on delete 
AggregateRegressionInfo_aggregate_id_FK aggregateregressioninfo.aggregate_id aggregate.id Cascade on delete 
Alert_emailAddressRecipients_alert_id_FK alert_emailaddressrecipients.alert_id alert.id Cascade on delete 
Alert_emailAdminRecipients_alert_id_FK alert_emailadminrecipients.alert_id alert.id Cascade on delete 
Alert_emailAdminRecipients_authorizationUnit_id_FK alert_emailadminrecipients.authorizationUnit_id authorizationunit.id Cascade on delete 
Alert_eventSeverities_alert_id_FK alert_eventseverities.alert_id alert.id Cascade on delete 
alert_script_audit_eventId_FK alert_script_audit.eventId event.id Cascade on delete 
Alert_scriptId_FK alert.scriptId script.id Null on delete 
AlertEventTypeValues_alert_id_FK alerteventtypevalues.alert_id alert.id Cascade on delete 
AlertEventTypeValues_eventTypeValue_id_FK alerteventtypevalues.eventTypeValue_id eventtypevalue.id Cascade on delete 
AlertResourceObjects_alert_id_FK alertresourceobjects.alert_id alert.id Cascade on delete 
Annotation_type_id_FK annotation.type_id annotationtype.id Cascade on delete 
AnnotationManualResourceMapping_annotationValueId_FK annotationmanualresourcemapping.annotationValueId annotation.id Cascade on delete 
AnnotationResourceObject_annotation_id_FK annotationresourceobject.annotation_id annotation.id Cascade on delete 
AnnotationRule_annotationTypeId_FK annotationrule.annotationTypeId annotationtype.id Cascade on delete 
AnnotationRule_annotationValueId_FK annotationrule.annotationValueId annotation.id Cascade on delete 
AuthorizationUnit_role_id_FK authorizationunit.role_id role.id Restrict delete 
BridgeStackConnection_bridge_id_FK bridgestackconnection.bridge_id bridge.id Restrict delete 
BridgeStackLink_bridgeStackConnection_id_FK bridgestacklink.bridgeStackConnection_id bridgestackconnection.id Cascade on delete 
ClientEventDetails_event_id_FK clienteventdetails.event_id event.id Cascade on delete 
ClusterHistoryMonth_clusterId_FK clusterhistorymonth.clusterId cluster.id Cascade on delete 
ClusterHistoryWeek_clusterId_FK clusterhistoryweek.clusterId cluster.id Cascade on delete 
ClusterHistoryYear_clusterId_FK clusterhistoryyear.clusterId cluster.id Cascade on delete 
ClusterNodeHistoryMonth_clusterNodeId_FK clusternodehistorymonth.clusterNodeId clusternode.id Cascade on delete 
ClusterNodeHistoryWeek_clusterNodeId_FK clusternodehistoryweek.clusterNodeId clusternode.id Cascade on delete 
ClusterNodeHistoryYear_clusterNodeId_FK clusternodehistoryyear.clusterNodeId clusternode.id Cascade on delete 
ConditionGroup_selectionCriterionId_FK conditiongroup.selectionCriterionId selectioncriterion.id Cascade on delete 
ConditionTable_conditionGroupId_FK conditiontable.conditionGroupId conditiongroup.id Cascade on delete 
CustomEventType_id_FK customeventtype.id eventtype.id Cascade on delete 
CustomEventTypeValue_id_FK customeventtypevalue.id eventtypevalue.id Cascade on delete 
DataPolicy_vserver_id_FK datapolicy.vserver_id vserver.id Cascade on delete 
DeferredMccResource_cluster_id_FK deferredmccresource.cluster_id cluster.id Cascade on delete 
DeferredOntapAlert_cluster_id_FK deferredontapalert.cluster_id cluster.id Cascade on delete 
DiskAggregateRelationship_lastKnownAggregateId_FK diskaggregaterelationship.lastKnownAggregateId aggregate.id Cascade on delete 
DiskAggregateRelationship_lastKnownDiskId_FK diskaggregaterelationship.lastKnownDiskId wafldisk.id Cascade on delete 
Event_obsoleteCauseEvent_id_FK event.obsoleteCauseEvent_id event.id Null on delete 
Event_obsoleteCauseValue_id_FK event.obsoleteCauseValue_id eventtypevalue.id Cascade on delete 
Event_value_id_FK event.value_id eventtypevalue.id Cascade on delete 
EventNote_event_id_FK eventnote.event_id event.id Cascade on delete 
EventOntapSystemHealthAlertMapping_alert_cluster_id_FK eventontapsystemhealthalertmapping.alert_cluster_id cluster.id Cascade on delete 
EventOntapSystemHealthAlertMapping_event_id_FK eventontapsystemhealthalertmapping.event_id event.id Cascade on delete 
EventType_parentCategory_id_FK eventtype.parentCategory_id eventtypecategorycontainer.id Null on delete 
EventTypeCategoryClosureAssociation_container_id_FK eventtypecategoryclosureassociation.container_id eventtypecategorycontainer.id Cascade on delete 
EventTypeCategoryClosureAssociation_eventType_id_FK eventtypecategoryclosureassociation.eventType_id eventtype.id Cascade on delete 
EventTypeCategoryContainer_parentCategory_id_FK eventtypecategorycontainer.parentCategory_id eventtypecategorycontainer.id Null on delete 
EventTypeSourceTypes_eventType_id_FK eventtypesourcetypes.eventType_id eventtype.id Cascade on delete 
EventTypeValue_type_id_FK eventtypevalue.type_id eventtype.id Cascade on delete 
ExternalCache_clusterNode_id_FK externalcache.clusterNode_id clusternode.id Restrict delete 
ExternalCacheHistoryMonth_clusterNodeId_FK externalcachehistorymonth.clusterNodeId clusternode.id Cascade on delete 
ExternalCacheHistoryWeek_clusterNodeId_FK externalcachehistoryweek.clusterNodeId clusternode.id Cascade on delete 
ExternalCacheHistoryYear_clusterNodeId_FK externalcachehistoryyear.clusterNodeId clusternode.id Cascade on delete 
GroupAction_groupId_FK groupaction.groupId groups.id Null on delete 
GroupActionArgument_groupActionId_FK groupactionargument.groupActionId groupaction.id Cascade on delete 
GroupMembership_groupId_FK groupmembership.groupId groups.id Cascade on delete 
GroupMembership_groupMembershipRuleId_FK groupmembership.groupMembershipRuleId groupmembershiprule.id Cascade on delete 
GroupMembershipRule_groupId_FK groupmembershiprule.groupId groups.id Cascade on delete 
InfiniteVolHistoryMonth_volumeId_FK infinitevolhistorymonth.volumeId volume.id Cascade on delete 
InfiniteVolHistoryWeek_volumeId_FK infinitevolhistoryweek.volumeId volume.id Cascade on delete 
InfiniteVolHistoryYear_volumeId_FK infinitevolhistoryyear.volumeId volume.id Cascade on delete 
InterNodeLink_InterNodeConnection_id_FK internodelink.InterNodeConnection_id internodeconnection.id Cascade on delete 
InterSwitchConnection_firstSwitch_id_FK interswitchconnection.firstSwitch_id switch.id Restrict delete 
InterSwitchConnection_secondSwitch_id_FK interswitchconnection.secondSwitch_id switch.id Restrict delete 
InterSwitchLink_interSwitchConnection_id_FK interswitchlink.interSwitchConnection_id interswitchconnection.id Cascade on delete 
InventoryViewSchedule_viewId_FK inventoryviewschedule.viewId inventoryview.id Cascade on delete 
Job_compensationJob_id_FK job.compensationJob_id job.id Null on delete 
maintenance_window_object_mapping_maintenanceWindowId_FK maintenance_window_object_mapping.maintenanceWindowId maintenance_window.id Cascade on delete 
NodeBridgeConnection_bridge_id_FK nodebridgeconnection.bridge_id bridge.id Restrict delete 
NodeBridgeLink_nodeBridgeConnection_id_FK nodebridgelink.nodeBridgeConnection_id nodebridgeconnection.id Cascade on delete 
NodeStackLink_nodeStackConnection_id_FK nodestacklink.nodeStackConnection_id nodestackconnection.id Cascade on delete 
NodeSwitchConnection_switch_id_FK nodeswitchconnection.switch_id switch.id Restrict delete 
NodeSwitchLink_nodeSwitchConnection_id_FK nodeswitchlink.nodeSwitchConnection_id nodeswitchconnection.id Cascade on delete 
OcumMonitoringStatus_cluster_id_FK ocummonitoringstatus.cluster_id cluster.id Cascade on delete 
OntapEms_cluster_id_FK ontapems.cluster_id cluster.id Cascade on delete 
OntapEmsParameter_ontapEms_id_FK ontapemsparameter.ontapEms_id ontapems.id Cascade on delete 
qrtz_blob_triggers_ibfk_1 qrtz_blob_triggers.SCHED_NAME
qrtz_blob_triggers.TRIGGER_NAME
qrtz_blob_triggers.TRIGGER_GROUP
qrtz_triggers.SCHED_NAME
qrtz_triggers.TRIGGER_NAME
qrtz_triggers.TRIGGER_GROUP
Restrict delete 
qrtz_cron_triggers_ibfk_1 qrtz_cron_triggers.SCHED_NAME
qrtz_cron_triggers.TRIGGER_NAME
qrtz_cron_triggers.TRIGGER_GROUP
qrtz_triggers.SCHED_NAME
qrtz_triggers.TRIGGER_NAME
qrtz_triggers.TRIGGER_GROUP
Restrict delete 
qrtz_simple_triggers_ibfk_1 qrtz_simple_triggers.SCHED_NAME
qrtz_simple_triggers.TRIGGER_NAME
qrtz_simple_triggers.TRIGGER_GROUP
qrtz_triggers.SCHED_NAME
qrtz_triggers.TRIGGER_NAME
qrtz_triggers.TRIGGER_GROUP
Restrict delete 
qrtz_simprop_triggers_ibfk_1 qrtz_simprop_triggers.SCHED_NAME
qrtz_simprop_triggers.TRIGGER_NAME
qrtz_simprop_triggers.TRIGGER_GROUP
qrtz_triggers.SCHED_NAME
qrtz_triggers.TRIGGER_NAME
qrtz_triggers.TRIGGER_GROUP
Restrict delete 
qrtz_triggers_ibfk_1 qrtz_triggers.SCHED_NAME
qrtz_triggers.JOB_NAME
qrtz_triggers.JOB_GROUP
qrtz_job_details.SCHED_NAME
qrtz_job_details.JOB_NAME
qrtz_job_details.JOB_GROUP
Restrict delete 
ResourcePoolAggregates_aggregate_id_FK resourcepoolaggregates.aggregate_id aggregate.id Cascade on delete 
ResourcePoolAggregates_resourcePool_id_FK resourcepoolaggregates.resourcePool_id resourcepool.id Cascade on delete 
SelectionCriterion_annotationRuleId_FK selectioncriterion.annotationRuleId annotationrule.id Cascade on delete 
SelectionCriterion_groupMembershipRuleId_FK selectioncriterion.groupMembershipRuleId groupmembershiprule.id Cascade on delete 
SnapMirrorTransfer_snapMirrorRelationshipId_FK snapmirrortransfer.snapMirrorRelationshipId snapmirrorrelationship.id Cascade on delete 
StorageArrayClusterAssociation_cluster_id_FK storagearrayclusterassociation.cluster_id cluster.id Restrict delete 
StorageArrayClusterAssociation_storageArray_id_FK storagearrayclusterassociation.storageArray_id storagearray.id Restrict delete 
StorageArrayLUNPath_storageArrayPort_id_FK storagearraylunpath.storageArrayPort_id storagearrayport.id Restrict delete 
StorageArrayPort_storageArray_id_FK storagearrayport.storageArray_id storagearray.id Restrict delete 
StorageArrayPortClusterAssociation_cluster_id_FK storagearrayportclusterassociation.cluster_id cluster.id Restrict delete 
StorageArrayPortClusterAssociation_storageArrayPort_id_FK storagearrayportclusterassociation.storageArrayPort_id storagearrayport.id Restrict delete 
StorageService_contacts_storageService_id_FK storageservice_contacts.storageService_id storageservice.id Cascade on delete 
StorageServiceConnection_destinationNode_id_FK storageserviceconnection.destinationNode_id storageservicenode.id Cascade on delete 
StorageServiceConnection_sourceNode_id_FK storageserviceconnection.sourceNode_id storageservicenode.id Cascade on delete 
StorageServiceConnection_storageService_id_FK storageserviceconnection.storageService_id storageservice.id Cascade on delete 
StorageServiceConnectionMember_connection_id_FK storageserviceconnectionmember.connection_id storageserviceconnection.id Cascade on delete 
StorageServiceConnectionMember_destinationNodeMember_id_FK storageserviceconnectionmember.destinationNodeMember_id storageservicenodemember.id Cascade on delete 
StorageServiceConnectionMember_relationship_id_FK storageserviceconnectionmember.relationship_id snapmirrorrelationship.id Null on delete 
StorageServiceConnectionMember_rootMemberInfo_id_FK storageserviceconnectionmember.rootMemberInfo_id storageservicerootmemberinfo.id Cascade on delete 
StorageServiceConnectionMember_sourceNodeMember_id_FK storageserviceconnectionmember.sourceNodeMember_id storageservicenodemember.id Cascade on delete 
StorageServiceNode_serviceWorkflow_id_FK storageservicenode.serviceWorkflow_id serviceworkflow.id Cascade on delete 
StorageServiceNode_storageService_id_FK storageservicenode.storageService_id storageservice.id Cascade on delete 
StorageServiceNodeMember_node_id_FK storageservicenodemember.node_id storageservicenode.id Cascade on delete 
StorageServiceNodeMember_rootMemberInfo_id_FK storageservicenodemember.rootMemberInfo_id storageservicerootmemberinfo.id Cascade on delete 
StorageServiceNodeMember_volume_id_FK storageservicenodemember.volume_id volume.id Null on delete 
StorageServiceNodeResourcePool_resourcePool_id_FK storageservicenoderesourcepool.resourcePool_id resourcepool.id Cascade on delete 
StorageServiceNodeResourcePool_storageServiceNode_id_FK storageservicenoderesourcepool.storageServiceNode_id storageservicenode.id Cascade on delete 
StorageServiceRootMemberInfo_rootNodeMember_id_FK storageservicerootmemberinfo.rootNodeMember_id storageservicenodemember.id Null on delete 
StorageServiceRootMemberInfo_storageService_id_FK storageservicerootmemberinfo.storageService_id storageservice.id Cascade on delete 
StorageServiceSubscription_metaDataFlds_StorageServiceSubId_FK storageservicesubscription_metadatafields.StorageServiceSubscription_id storageservicesubscription.id Cascade on delete 
StorageServiceSubscription_storageService_id_FK storageservicesubscription.storageService_id storageservice.id Cascade on delete 
StorageServiceSubscriptionRootMember_rootMemberInfo_id_FK storageservicesubscriptionrootmember.rootMemberInfo_id storageservicerootmemberinfo.id Cascade on delete 
StorageServiceSubscriptionRootMember_subscription_id_FK storageservicesubscriptionrootmember.subscription_id storageservicesubscription.id Cascade on delete 
StorageServiceVserverDestination_destinationVserver_id_FK storageservicevserverdestination.destinationVserver_id vserver.id Cascade on delete 
StorageServiceVserverDestination_sourceVserver_id_FK storageservicevserverdestination.sourceVserver_id vserver.id Cascade on delete 
SwitchBridgeConnection_bridge_id_FK switchbridgeconnection.bridge_id bridge.id Restrict delete 
SwitchBridgeConnection_switch_id_FK switchbridgeconnection.switch_id switch.id Restrict delete 
SwitchBridgeLink_switchBridgeConnection_id_FK switchbridgelink.switchBridgeConnection_id switchbridgeconnection.id Cascade on delete 
SwitchInterSwitchRelationship_interSwitchConnection_id_FK switchinterswitchrelationship.interSwitchConnection_id interswitchconnection.id Cascade on delete 
SwitchInterSwitchRelationship_switch_id_FK switchinterswitchrelationship.switch_id switch.id Cascade on delete 
Task_job_id_FK task.job_id job.id Cascade on delete 
TaskMessage_task_id_FK taskmessage.task_id task.id Cascade on delete 
TaskObjectInteraction_task_id_FK taskobjectinteraction.task_id task.id Cascade on delete 
TaskPredecessor_task_id_FK taskpredecessor.task_id task.id Cascade on delete 
TaskPredecessor_taskPredecessor_id_FK taskpredecessor.taskPredecessor_id task.id Cascade on delete 
TaskRetry_job_id_FK taskretry.job_id job.id Cascade on delete 
TaskRetry_task_id_FK taskretry.task_id task.id Cascade on delete 
TaskStatusChange_task_id_FK taskstatuschange.task_id task.id Cascade on delete 
Trap_event_id_FK trap.event_id event.id Cascade on delete 
Trap_source_id_FK trap.source_id cluster.id Cascade on delete 
TrapVarBinding_trap_id_FK trapvarbinding.trap_id trap.id Cascade on delete 
Volume_namespaceConstituent_id_FK volume.namespaceConstituent_id volume.id Null on delete 
Volume_systemStorageClass_id_FK volume.systemStorageClass_id storageclass.id Null on delete 
Volume_unAvailableParentVolumeId_FK volume.unAvailableParentVolumeId volume.id Null on delete 
VolumeGrowthRateInfo_volume_id_FK volumegrowthrateinfo.volume_id volume.id Cascade on delete 
VolumeHistoryMonth_volumeId_FK volumehistorymonth.volumeId volume.id Cascade on delete 
VolumeHistoryWeek_volumeId_FK volumehistoryweek.volumeId volume.id Cascade on delete 
VolumeHistoryYear_volumeId_FK volumehistoryyear.volumeId volume.id Cascade on delete 
VolumeJunctionPathHistory_volume_id_FK volumejunctionpathhistory.volume_id volume.id Cascade on delete 
VolumeRegressionInfo_volume_id_FK volumeregressioninfo.volume_id volume.id Cascade on delete 
Vserver_metadataVolumeId_FK vserver.metadataVolumeId volume.id Cascade on delete 
VserverHistoryMonth_vserverId_FK vserverhistorymonth.vserverId vserver.id Cascade on delete 
VserverHistoryWeek_vserverId_FK vserverhistoryweek.vserverId vserver.id Cascade on delete 
VserverHistoryYear_vserverId_FK vserverhistoryyear.vserverId vserver.id Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected