BDNA Discover Publish version 7.7.2 with 201708
BDNA_VIRT_OS - Virtualized Operating Systems Scanned by BDNA at Level2

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
OPERATINGSYSTEM_ID number 22
BDNA_MICROSOFT_VMS.PARENT_OS_ID FKM2_BDNAMICROSOFTVM R
BDNA_MICROSOFT_VMS.VM_OS_ID FKM1_BDNAMICROSOFTVM R
BDNA_ORACLE_VMS.PARENT_OS_ID FKM2_BDNA_ORACLE_VMS R
BDNA_ORACLE_VMS.VM_OS_ID FKM1_BDNA_ORACLE_VMS R
BDNA_PARTITION_OS_REL.PARTITION_OS_ID FKM0_BDNAPARTITIONOS R
BDNA_SOLZONE_OS_REL.OPERATINGSYSTEM_ID FKM1_BDNASOLZONEOSRE R
BDNA_VIRT_DEV_OS_REL.OPERATINGSYSTEM_ID FKM1_BDNAVIRTDEVOSRE R
BDNA_VIRT_DEVICES.DEVICE_OS_ID FKM0_BDNAVIRTDEVICES R
BDNA_VIRT_MACHINES.PARENT_OS_ID FKM1_BDNAVIRTMACHINE R
BDNA_VIRT_MACHINES.VM_OS_ID FKM0_BDNAVIRTMACHINE R
BDNA_VMWARE_VMS.PARENT_OS_ID FKM2_BDNA_VMWARE_VMS R
BDNA_VMWARE_VMS.VM_OS_ID FKM1_BDNA_VMWARE_VMS R
BDNA_XEN_OR_ORACLE_VMS.VM_OS_ID FKM1_BDNAXENORORACLE R
BDNA_XEN_VMS.PARENT_OS_ID FKM2_BDNA_XEN_VMS R
BDNA_XEN_VMS.VM_OS_ID FKM1_BDNA_XEN_VMS R
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNA_VIRT_OS R
Operating Systems Id
OPERATINGSYSTEM_LABEL varchar2 1024  √  null Operating Systems Label
OPERATINGSYSTEM_TYPE number 22  √  null
BDNA_TYPES.TYPE_ID BDNA_VIRT_OS0_OPERATINGSYSTEMT R
Operating Systems Type
IS_DEVICE_OS varchar2 4000  √  null Is Device OS?
IS_HOST_OS varchar2 3  √  null Is Host OS?
IS_VM_OS varchar2 3  √  null Is Virtual Machine OS?
IS_PARTITION_OS varchar2 3  √  null Is Partition OS?
IS_ZONE_OS varchar2 3  √  null Is Solaris Zone OS?
HOST_OS_ID number 22  √  null Host OS Id
VIRT_TECHNOLOGY varchar2 4000  √  null Virtualization Technology
INVENTORY_ID number 22 -1
BDNA_MICROSOFT_VMS.INVENTORY_ID FKM1_BDNAMICROSOFTVM R
BDNA_ORACLE_VMS.INVENTORY_ID FKM1_BDNA_ORACLE_VMS R
BDNA_PARTITION_OS_REL.INVENTORY_ID FKM0_BDNAPARTITIONOS R
BDNA_SOLZONE_OS_REL.INVENTORY_ID FKM1_BDNASOLZONEOSRE R
BDNA_VIRT_DEV_OS_REL.INVENTORY_ID FKM1_BDNAVIRTDEVOSRE R
BDNA_VIRT_DEVICES.INVENTORY_ID FKM0_BDNAVIRTDEVICES R
BDNA_VIRT_MACHINES.INVENTORY_ID FKM0_BDNAVIRTMACHINE R
BDNA_VMWARE_VMS.INVENTORY_ID FKM1_BDNA_VMWARE_VMS R
BDNA_XEN_OR_ORACLE_VMS.INVENTORY_ID FKM1_BDNAXENORORACLE R
BDNA_XEN_VMS.INVENTORY_ID FKM1_BDNA_XEN_VMS R
BDNA_INVENTORY_INFO.INVENTORY_ID BDNA_VIRT_OS1_INVENTORY_ID R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNA_VIRT_OS R
Inventory Id

Analyzed at Wed Jul 12 12:54 CST 2017

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA