SchemaSpy Analysis of BDNA_PUBLISH.dbo - ConstraintsBDNA_Normalize_pbulish_ERD SQL Server | Generated by SchemaSpy |
67 Foreign Key Constraints: |
Constraint Name | Child Column | Parent Column | Delete Rule |
---|---|---|---|
FK0_CAT_CPU_PRODUCT | CAT_CPU_PRODUCT.MANUFACTURER_ID | CAT_MANUFACTURER.ID | Restrict delete |
FK0_CAT_HARDWARE_LIFECYCLE | CAT_HARDWARE_LIFECYCLE.MODEL_ID | CAT_HARDWARE_MODEL.ID | Restrict delete |
FK0_CAT_HARDWARE_MODEL | CAT_HARDWARE_MODEL.MANUFACTURER_ID | CAT_MANUFACTURER.ID | Restrict delete |
FK0_CAT_HARDWARE_PRODUCT | CAT_HARDWARE_PRODUCT.MANUFACTURER_ID | CAT_MANUFACTURER.ID | Restrict delete |
FK0_CAT_HW_MODEL_PROFILE | CAT_HW_MODEL_PROFILE.MANUFACTURER_ID | CAT_MANUFACTURER.ID | Restrict delete |
FK0_CAT_SOFTWARE | CAT_SOFTWARE.MANUFACTURER_ID | CAT_MANUFACTURER.ID | Restrict delete |
FK0_CAT_SOFTWARE_LIFECYCLE | CAT_SOFTWARE_LIFECYCLE.RELEASE_ID | CAT_SOFTWARE_RELEASE.ID | Restrict delete |
FK0_CAT_SOFTWARE_RELEASE | CAT_SOFTWARE_RELEASE.MANUFACTURER_ID | CAT_MANUFACTURER.ID | Restrict delete |
FK0_CAT_SUPPORT_POLICY | CAT_SUPPORT_POLICY.MANUFACTURER_ID | CAT_MANUFACTURER.ID | Restrict delete |
FK0_CAT_SUPPORT_STAGE | CAT_SUPPORT_STAGE.SUPPORT_POLICY_ID | CAT_SUPPORT_POLICY.ID | Restrict delete |
FK0_CAT_SW_EDITION | CAT_SOFTWARE_EDITION.PRODUCT_ID | CAT_SOFTWARE.ID | Restrict delete |
FK0_CAT_SW_REL_PLATFORM | CAT_SW_REL_PLATFORM.RELEASE_ID | CAT_SOFTWARE_RELEASE.ID | Restrict delete |
FK0_CAT_SW_REL_SUPP_STAGE | CAT_SW_REL_SUPP_STAGE.RELEASE_ID | CAT_SOFTWARE_RELEASE.ID | Restrict delete |
FK0_CAT_SW_VERSION | CAT_SOFTWARE_VERSION.PRODUCT_ID | CAT_SOFTWARE.ID | Restrict delete |
FK0_CAT_SW_VERSION_GROUP | CAT_SW_VERSION_GROUP.PRODUCT_ID | CAT_SOFTWARE.ID | Restrict delete |
FK0_DISC_ALL_OS | DISC_ALL_OS.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK0_DISC_CDROMS | DISC_CDROMS.OPERATINGSYSTEM_ID DISC_CDROMS.TASK_ID DISC_CDROMS.INVENTORY_ID |
DISC_ALL_OS.OPERATINGSYSTEM_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.INVENTORY_ID |
Restrict delete |
FK0_DISC_COMPUTERSYSTEM | DISC_COMPUTERSYSTEM.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK0_DISC_CPUS | DISC_CPUS.OPERATINGSYSTEM_ID DISC_CPUS.TASK_ID DISC_CPUS.INVENTORY_ID |
DISC_ALL_OS.OPERATINGSYSTEM_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.INVENTORY_ID |
Restrict delete |
FK0_DISC_CS_CAT_MAP | DISC_CS_CAT_MAP.COMPUTERSYSTEM_ID DISC_CS_CAT_MAP.TASK_ID DISC_CS_CAT_MAP.INVENTORY_ID |
DISC_COMPUTERSYSTEM.COMPUTERSYSTEM_ID DISC_COMPUTERSYSTEM.TASK_ID DISC_COMPUTERSYSTEM.INVENTORY_ID |
Restrict delete |
FK0_DISC_DISK_PARTITIONS | DISC_DISK_PARTITIONS.OPERATINGSYSTEM_ID DISC_DISK_PARTITIONS.TASK_ID DISC_DISK_PARTITIONS.INVENTORY_ID |
DISC_ALL_OS.OPERATINGSYSTEM_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.INVENTORY_ID |
Restrict delete |
FK0_DISC_HDDS | DISC_HDDS.OPERATINGSYSTEM_ID DISC_HDDS.TASK_ID DISC_HDDS.INVENTORY_ID |
DISC_ALL_OS.OPERATINGSYSTEM_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.INVENTORY_ID |
Restrict delete |
FK0_DISC_HOSTS | DISC_HOSTS.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK0_DISC_LOGICAL_DISKS | DISC_LOGICAL_DISKS.OPERATINGSYSTEM_ID DISC_LOGICAL_DISKS.TASK_ID DISC_LOGICAL_DISKS.INVENTORY_ID |
DISC_ALL_OS.OPERATINGSYSTEM_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.INVENTORY_ID |
Restrict delete |
FK0_DISC_OS_CAT_MAP | DISC_OS_CAT_MAP.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK0_DISC_VIDEO_CONTROLLERSS | DISC_VIDEO_CONTROLLERS.OPERATINGSYSTEM_ID DISC_VIDEO_CONTROLLERS.TASK_ID DISC_VIDEO_CONTROLLERS.INVENTORY_ID |
DISC_ALL_OS.OPERATINGSYSTEM_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.INVENTORY_ID |
Restrict delete |
FK0_DISC_WINDOWS_MONITORS | DISC_WINDOWS_MONITORS.OPERATINGSYSTEM_ID DISC_WINDOWS_MONITORS.TASK_ID DISC_WINDOWS_MONITORS.INVENTORY_ID |
DISC_ALL_OS.OPERATINGSYSTEM_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.INVENTORY_ID |
Restrict delete |
FK0_DISC_WINDOWS_NICS | DISC_WINDOWS_NICS.OPERATINGSYSTEM_ID DISC_WINDOWS_NICS.TASK_ID DISC_WINDOWS_NICS.INVENTORY_ID |
DISC_ALL_OS.OPERATINGSYSTEM_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.INVENTORY_ID |
Restrict delete |
FK0_DISC_WINDOWS_SERVICES | DISC_WINDOWS_SERVICES.OPERATINGSYSTEM_ID DISC_WINDOWS_SERVICES.TASK_ID DISC_WINDOWS_SERVICES.INVENTORY_ID |
DISC_ALL_OS.OPERATINGSYSTEM_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.INVENTORY_ID |
Restrict delete |
FK0_MATCH_ALL_ADDREMOVE | MATCH_ALL_ADDREMOVE.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK0_MATCH_ALL_EXE | MATCH_ALL_EXE.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK0_MATCH_HOST_HW_PROD_MODEL | MATCH_HOST_HW_PROD_MODEL.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK0_MATCH_TASK_DET | MATCH_TASK_DET.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK1_CAT_HARDWARE_MODEL | CAT_HARDWARE_MODEL.TAXONOMY_ID | CAT_TAXONOMY.ID | Restrict delete |
FK1_CAT_HARDWARE_PRODUCT | CAT_HARDWARE_PRODUCT.TAXONOMY_ID | CAT_TAXONOMY.ID | Restrict delete |
FK1_CAT_HW_MODEL_PROFILE | CAT_HW_MODEL_PROFILE.TAXONOMY_ID | CAT_TAXONOMY.ID | Restrict delete |
FK1_CAT_SOFTWARE | CAT_SOFTWARE.TAXONOMY_ID | CAT_TAXONOMY.ID | Restrict delete |
FK1_CAT_SOFTWARE_RELEASE | CAT_SOFTWARE_RELEASE.PRODUCT_ID | CAT_SOFTWARE.ID | Restrict delete |
FK1_CAT_SW_EDITION | CAT_SOFTWARE_EDITION.TAXONOMY_ID | CAT_TAXONOMY.ID | Restrict delete |
FK1_CAT_SW_REL_SUPP_STAGE | CAT_SW_REL_SUPP_STAGE.SUPPORT_STAGE_ID | CAT_SUPPORT_STAGE.ID | Restrict delete |
FK1_CAT_SW_VERSION | CAT_SOFTWARE_VERSION.VERSION_GROUP_ID | CAT_SW_VERSION_GROUP.ID | Restrict delete |
FK1_DISC_ALL_OS | DISC_ALL_OS.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK1_DISC_COMPUTERSYSTEM | DISC_COMPUTERSYSTEM.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK1_DISC_CS_CAT_MAP | DISC_CS_CAT_MAP.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK1_DISC_HOSTS | DISC_HOSTS.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK1_DISC_OS_CAT_MAP | DISC_OS_CAT_MAP.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK1_MATCH_ALL_ADDREMOVE | MATCH_ALL_ADDREMOVE.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK1_MATCH_ALL_EXE | MATCH_ALL_EXE.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK1_MATCH_HOST_HW_PROD_MODEL | MATCH_HOST_HW_PROD_MODEL.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK2_CAT_HARDWARE_MODEL | CAT_HARDWARE_MODEL.HW_PRODUCT_ID | CAT_HARDWARE_PRODUCT.ID | Restrict delete |
FK2_CAT_HW_MODEL_PROFILE | CAT_HW_MODEL_PROFILE.HW_PRODUCT_ID | CAT_HARDWARE_PRODUCT.ID | Restrict delete |
FK2_CAT_SOFTWARE_RELEASE | CAT_SOFTWARE_RELEASE.EDITION_ID | CAT_SOFTWARE_EDITION.ID | Restrict delete |
FK2_DISC_ALL_OS | DISC_ALL_OS.HOST_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.INVENTORY_ID |
DISC_HOSTS.HOST_ID DISC_HOSTS.TASK_ID DISC_HOSTS.INVENTORY_ID |
Restrict delete |
FK2_DISC_COMPUTERSYSTEM | DISC_COMPUTERSYSTEM.COMPUTERSYSTEM_ID DISC_COMPUTERSYSTEM.TASK_ID DISC_COMPUTERSYSTEM.INVENTORY_ID |
DISC_HOSTS.HOST_ID DISC_HOSTS.TASK_ID DISC_HOSTS.INVENTORY_ID |
Restrict delete |
FK2_DISC_CS_CAT_MAP | DISC_CS_CAT_MAP.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK3_CAT_HW_MODEL_PROFILE | CAT_HW_MODEL_PROFILE.HW_MODEL_ID | CAT_HARDWARE_MODEL.ID | Restrict delete |
FK3_CAT_SOFTWARE_RELEASE | CAT_SOFTWARE_RELEASE.VERSION_GROUP_ID | CAT_SW_VERSION_GROUP.ID | Restrict delete |
FK4_CAT_SOFTWARE_RELEASE | CAT_SOFTWARE_RELEASE.VERSION_ID | CAT_SOFTWARE_VERSION.ID | Restrict delete |
FK4_MATCH_SOFTWARE_METERING | MATCH_SOFTWARE_METERING.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK5_MATCH_SOFTWARE_METERING | MATCH_SOFTWARE_METERING.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK6_MATCH_HOST_SW_PROD | MATCH_HOST_SW_PROD.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK6_MATCH_HOST_SW_PROD_DET | MATCH_HOST_SW_PROD_DET.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK6_MATCH_SOFTWARE_METERING | MATCH_SOFTWARE_METERING.HOST_ID MATCH_SOFTWARE_METERING.TASK_ID MATCH_SOFTWARE_METERING.INVENTORY_ID |
DISC_HOSTS.HOST_ID DISC_HOSTS.TASK_ID DISC_HOSTS.INVENTORY_ID |
Restrict delete |
FK7_MATCH_HOST_SW_PROD | MATCH_HOST_SW_PROD.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK7_MATCH_HOST_SW_PROD_DET | MATCH_HOST_SW_PROD_DET.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK8_MATCH_HOST_SW_PROD | MATCH_HOST_SW_PROD.HOST_ID MATCH_HOST_SW_PROD.TASK_ID MATCH_HOST_SW_PROD.INVENTORY_ID |
DISC_HOSTS.HOST_ID DISC_HOSTS.TASK_ID DISC_HOSTS.INVENTORY_ID |
Restrict delete |
FK8_MATCH_HOST_SW_PROD_DET | MATCH_HOST_SW_PROD_DET.HOST_ID MATCH_HOST_SW_PROD_DET.TASK_ID MATCH_HOST_SW_PROD_DET.INVENTORY_ID |
DISC_HOSTS.HOST_ID DISC_HOSTS.TASK_ID DISC_HOSTS.INVENTORY_ID |
Restrict delete |
Check Constraints:
Table | Constraint Name | Constraint |
---|---|---|
None detected |