BDNA Discover Publish version 7.7.2 with 201708
BDNA_IPNIC_MACNIC_REL - IPNIC/MACNIC Relationship

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
INTERNETADDRESS_ID number 22
BDNA_IPS_FROM_NICS.INTERNETADDRESS_ID FKM0_BDNAIPNICMACNIC R
IP Address Id
MACADDRESS_ID number 22
BDNA_MACS_FROM_NICS.MACADDRESS_ID FKM1_BDNAIPNICMACNIC R
MAC Address Id
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNAIPNICMACNICRE_INVENTORY_ID R
BDNA_MACS_FROM_NICS.INVENTORY_ID FKM1_BDNAIPNICMACNIC R
BDNA_IPS_FROM_NICS.INVENTORY_ID FKM0_BDNAIPNICMACNIC R
Inventory Id

Analyzed at Wed Jul 12 12:54 CST 2017

Indexes:
Column(s) Type Sort Constraint Name
MACADDRESS_ID + INTERNETADDRESS_ID + INVENTORY_ID Primary key Asc/Asc/Asc PK_BDNA_IPNIC_MACNIC_REL

Close relationships  within of separation:
Confidential and Proprietary to BDNA