BDNA Discover Publish version 7.7.0 with 201605 Sequence
BDNA_VIRT_DEVICES - All Virtualized Devices

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
DEVICE_ID number 22
BDNA_DEV_VIRTENT_REL.DEVICE_ID FKM0_BDNADEVVIRTENTR R
BDNA_VIRT_DEV_OS_REL.DEVICE_ID FKM0_BDNAVIRTDEVOSRE R
BDNA_VIRT_DEV_PAR_REL.DEVICE_ID FKM1_BDNAVIRTDEVPARR R
BDNA_VIRT_DEV_VM_REL.DEVICE_ID FKM0_BDNAVIRTDEVVMRE R
BDNA_VIRT_DEV_ZONE_REL.DEVICE_ID FKM0_BDNAVIRTDEVZONE R
Virtualized Computer System Device Id
DEVICE_LABEL varchar2 1024  √  null Virtualized Computer System Device Label
DEVICE_VIRT_TECH varchar2 4000  √  null Device Virtualization Technology
DEVICE_VIRT_SOFTWARE varchar2 4000  √  null Virtualization Software installed on Device
DEVICE_MODEL varchar2 4000  √  null Device Model
DEVICE_SERIAL_NUMBER varchar2 4000  √  null Device Serial Number
IS_PARTITIONED varchar2 4000  √  null Is Device Partitioned for Virtualization
DEVICE_OS_ID number 22  √  null
BDNA_VIRT_OS.OPERATINGSYSTEM_ID FKM0_BDNAVIRTDEVICES R
Base Operating Systems Id
INVENTORY_ID number 22 -1
BDNA_DEV_VIRTENT_REL.INVENTORY_ID FKM0_BDNADEVVIRTENTR R
BDNA_VIRT_DEV_OS_REL.INVENTORY_ID FKM0_BDNAVIRTDEVOSRE R
BDNA_VIRT_DEV_PAR_REL.INVENTORY_ID FKM1_BDNAVIRTDEVPARR R
BDNA_VIRT_DEV_VM_REL.INVENTORY_ID FKM0_BDNAVIRTDEVVMRE R
BDNA_VIRT_DEV_ZONE_REL.INVENTORY_ID FKM0_BDNAVIRTDEVZONE R
BDNA_INVENTORY_INFO.INVENTORY_ID BDNAVIRTDEVICES0_INVENTORY_ID R
BDNA_VIRT_OS.INVENTORY_ID FKM0_BDNAVIRTDEVICES R
Inventory Id

Analyzed at Sat Mar 05 19:14 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
DEVICE_ID + INVENTORY_ID Primary key Asc/Asc PK_BDNA_VIRT_DEVICES

Close relationships  within of separation:
Confidential and Proprietary to BDNA