SchemaSpy Analysis of ocum - Constraints | Generated by SchemaSpy |
146 Foreign Key Constraints: |
|
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 |