BDNA Data Platform 5.4 July 2017 (Oracle) |
58 Foreign Key Constraints: |
|
Constraint Name | Child Column | Parent Column | Delete Rule |
---|---|---|---|
FK0_DISC_ALL_OS | DISC_ALL_OS.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK0_DISC_CDROMS | DISC_CDROMS.INVENTORY_ID DISC_CDROMS.TASK_ID DISC_CDROMS.OPERATINGSYSTEM_ID |
DISC_ALL_OS.INVENTORY_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.OPERATINGSYSTEM_ID |
Restrict delete |
FK0_DISC_COMPUTERSYSTEM | DISC_COMPUTERSYSTEM.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK0_DISC_CPUS | DISC_CPUS.INVENTORY_ID DISC_CPUS.TASK_ID DISC_CPUS.OPERATINGSYSTEM_ID |
DISC_ALL_OS.INVENTORY_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.OPERATINGSYSTEM_ID |
Restrict delete |
FK0_DISC_CS_CAT_MAP | DISC_CS_CAT_MAP.INVENTORY_ID DISC_CS_CAT_MAP.TASK_ID DISC_CS_CAT_MAP.COMPUTERSYSTEM_ID |
DISC_COMPUTERSYSTEM.INVENTORY_ID DISC_COMPUTERSYSTEM.TASK_ID DISC_COMPUTERSYSTEM.COMPUTERSYSTEM_ID |
Restrict delete |
FK0_DISC_DEDUP_STATS | DISC_DEDUPING_STATS.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK0_DISC_DISK_PARTITIONS | DISC_DISK_PARTITIONS.INVENTORY_ID DISC_DISK_PARTITIONS.TASK_ID DISC_DISK_PARTITIONS.OPERATINGSYSTEM_ID |
DISC_ALL_OS.INVENTORY_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.OPERATINGSYSTEM_ID |
Restrict delete |
FK0_DISC_EXT_REC_STATS | DISC_EXTRACTED_RECORDS_STATS.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK0_DISC_HDDS | DISC_HDDS.INVENTORY_ID DISC_HDDS.TASK_ID DISC_HDDS.OPERATINGSYSTEM_ID |
DISC_ALL_OS.INVENTORY_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.OPERATINGSYSTEM_ID |
Restrict delete |
FK0_DISC_HOSTS | DISC_HOSTS.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK0_DISC_LOGICAL_DISKS | DISC_LOGICAL_DISKS.INVENTORY_ID DISC_LOGICAL_DISKS.TASK_ID DISC_LOGICAL_DISKS.OPERATINGSYSTEM_ID |
DISC_ALL_OS.INVENTORY_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.OPERATINGSYSTEM_ID |
Restrict delete |
FK0_DISC_MISS_HOSTS | DISC_MISSING_HOSTS.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK0_DISC_MONITORS | DISC_MONITORS.INVENTORY_ID DISC_MONITORS.TASK_ID DISC_MONITORS.OPERATINGSYSTEM_ID |
DISC_ALL_OS.INVENTORY_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.OPERATINGSYSTEM_ID |
Restrict delete |
FK0_DISC_NICS | DISC_NICS.INVENTORY_ID DISC_NICS.TASK_ID DISC_NICS.OPERATINGSYSTEM_ID |
DISC_ALL_OS.INVENTORY_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.OPERATINGSYSTEM_ID |
Restrict delete |
FK0_DISC_OS_CAT_MAP | DISC_OS_CAT_MAP.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK0_DISC_PUB_REC_STATS | DISC_PUBLISHED_RECORDS_STATS.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK0_DISC_VIDEO_CONTROLLERSS | DISC_VIDEO_CONTROLLERS.INVENTORY_ID DISC_VIDEO_CONTROLLERS.TASK_ID DISC_VIDEO_CONTROLLERS.OPERATINGSYSTEM_ID |
DISC_ALL_OS.INVENTORY_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.OPERATINGSYSTEM_ID |
Restrict delete |
FK0_DISC_WINDOWS_SERVICES | DISC_WINDOWS_SERVICES.INVENTORY_ID DISC_WINDOWS_SERVICES.TASK_ID DISC_WINDOWS_SERVICES.OPERATINGSYSTEM_ID |
DISC_ALL_OS.INVENTORY_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.OPERATINGSYSTEM_ID |
Restrict delete |
FK0_MATCH_ADDRM_STATS_DET | MATCH_ADDREMOVE_MANF_STAT_DET.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK0_MATCH_ADDRM_STATS_SUM | MATCH_ADDREMOVE_MANF_STAT_SUMM.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK0_MATCH_ADDRM_TSTATS_SUM | MATCH_ADDREMOVE_TIER_STAT_SUMM.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK0_MATCH_ALL_ADDREMOVE | MATCH_ALL_ADDREMOVE.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK0_MATCH_ALL_ADDRM_KW | MATCH_ADDREMOVE_MANF_KWD.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_EXE_KW | MATCH_EXE_MANF_KWD.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK0_MATCH_EXE_ST_DET | MATCH_EXE_MANF_STAT_DET.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK0_MATCH_EXE_ST_SUM | MATCH_EXE_MANF_STAT_SUMM.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK0_MATCH_EXE_TST_SUM | MATCH_EXE_TIER_STAT_SUMM.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_STATS_DETAIL | MATCH_STATS_DETAIL.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_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_DEDUP_STATS | DISC_DEDUPING_STATS.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK1_DISC_EXT_REC_STATS | DISC_EXTRACTED_RECORDS_STATS.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK1_DISC_HOSTS | DISC_HOSTS.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK1_DISC_MISS_HOSTS | DISC_MISSING_HOSTS.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK1_DISC_OS_CAT_MAP | DISC_OS_CAT_MAP.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_ID | Restrict delete |
FK1_DISC_PUB_REC_STATS | DISC_PUBLISHED_RECORDS_STATS.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK1_MATCH_ADDRM_STATS_DET | MATCH_ADDREMOVE_MANF_STAT_DET.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK1_MATCH_ADDRM_STATS_SUM | MATCH_ADDREMOVE_MANF_STAT_SUMM.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK1_MATCH_ADDRM_TSTATS_SUM | MATCH_ADDREMOVE_TIER_STAT_SUMM.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK1_MATCH_ALL_ADDREMOVE | MATCH_ALL_ADDREMOVE.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK1_MATCH_ALL_ADDRM_KW | MATCH_ADDREMOVE_MANF_KWD.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_EXE_KW | MATCH_EXE_MANF_KWD.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK1_MATCH_EXE_ST_DET | MATCH_EXE_MANF_STAT_DET.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK1_MATCH_EXE_ST_SUM | MATCH_EXE_MANF_STAT_SUMM.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK1_MATCH_EXE_TST_SUM | MATCH_EXE_TIER_STAT_SUMM.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 |
FK1_MATCH_STATS_DETAIL | MATCH_STATS_DETAIL.TASK_ID | MATCH_TASK_DET.TASK_ID | Restrict delete |
FK2_DISC_ALL_OS | DISC_ALL_OS.INVENTORY_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.HOST_ID |
DISC_HOSTS.INVENTORY_ID DISC_HOSTS.TASK_ID DISC_HOSTS.HOST_ID |
Restrict delete |
FK2_DISC_COMPUTERSYSTEM | DISC_COMPUTERSYSTEM.INVENTORY_ID DISC_COMPUTERSYSTEM.TASK_ID DISC_COMPUTERSYSTEM.COMPUTERSYSTEM_ID |
DISC_ALL_OS.INVENTORY_ID DISC_ALL_OS.TASK_ID DISC_ALL_OS.OPERATINGSYSTEM_ID |
Restrict delete |
FK2_DISC_CS_CAT_MAP | DISC_CS_CAT_MAP.INVENTORY_ID | MATCH_INVENTORY.INVENTORY_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_SOFTWARE_METERING | MATCH_SOFTWARE_METERING.INVENTORY_ID MATCH_SOFTWARE_METERING.TASK_ID MATCH_SOFTWARE_METERING.HOST_ID |
DISC_HOSTS.INVENTORY_ID DISC_HOSTS.TASK_ID DISC_HOSTS.HOST_ID |
Restrict delete |
TECH_TABS_META_TECH_OBJ | TECHNOPEDIA_TABS_METADATA.TECHNOPEDIA_OBJECT_ID | TECHNOPEDIA_OBJECTS.TECHNOPEDIA_OBJECT_ID | Restrict delete |
Check Constraints:
Table | Constraint Name | Constraint |
---|---|---|
None detected |