BDNA Discover Publish version 7.7.2 with 201708
BDNA_WINDOWS_NICS - Windows NICs

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
NIC_ID number 22 NIC ID
NIC_LABEL varchar2 256  √  null NIC Label
NIC_NAME varchar2 256  √  null NIC Name
NIC_MANUF varchar2 256  √  null NIC Manufacturer
MACADDRESS varchar2 256  √  null MAC Address
IP_ADDRESS varchar2 256  √  null IP Address
DEFAULT_ROUTE varchar2 256  √  null Default Route
NETWORK_MASK varchar2 256  √  null Network Mask
DHCP_ENABLED varchar2 256  √  null DHCP Enabled
DHCP_LEASE_EXPR varchar2 256  √  null DHCP Lease Expires
DHCP_SERVER varchar2 256  √  null DHCP Server
DNS varchar2 256  √  null DNS
DNS_SEARCH varchar2 256  √  null DNS Search Order
DNS_PRIMARY varchar2 256  √  null Primary DNS Server
DNS_SECONDARY varchar2 256  √  null Secondary DNS Server
DNS_TERTIARY varchar2 256  √  null Tertiary DNS Server
DNS_OTHER varchar2 256  √  null Other DNS Servers
WINS_PRIMARY varchar2 256  √  null WINS Primary Server
WINS_SECONDARY varchar2 256  √  null WINS Secondary Server
PNP_DEVICEID varchar2 256  √  null PNP Device ID
OPERATINGSYSTEM_ID number 22  √  null
BDNA_WINDOWS_OS.OPERATINGSYSTEM_ID FKM0_BDNAWINDOWSNICS R
Operating System ID
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNAWINDOWSNICS0_INVENTORY_ID R
BDNA_WINDOWS_OS.INVENTORY_ID FKM0_BDNAWINDOWSNICS R
Inventory Id

Analyzed at Wed Jul 12 12:54 CST 2017

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA