BDNA Discover Publish version 7.7.2 with 201708
BDNA_NET_SERVICES - All Network Services

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
NETWORKSERVICE_LABEL varchar2 1024  √  null Network Service Name
NETWORKSERVICE_TYPE number 22  √  null
BDNA_TYPES.TYPE_ID BDNANETSERVICES_NST R
Network Service Type
MANUFACTURER varchar2 256  √  null Network Service Manufacturer
VERSION varchar2 256  √  null Network Service Version
PORTNUMBER number 22  √  null Port Number
NETWORKSERVICE_ID number 22
BDNA_HTTP_SERVERS.NETWORKSERVICE_ID FKM1_BDNAHTTPSERVERS R
BDNA_IMAP_SERVERS.NETWORKSERVICE_ID FKM1_BDNAIMAPSERVERS R
BDNA_ORACLE_LISTENERS.NETWORKSERVICE_ID FKM1_BDNAORACLELISTE R
BDNA_POP_SERVERS.NETWORKSERVICE_ID FKM1_BDNAPOPSERVERS R
BDNA_SMTP_SERVERS.NETWORKSERVICE_ID FKM1_BDNASMTPSERVERS R
Network Services Id
OPERATINGSYSTEM_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNANETSERVICES R
Operating Systems Id
INVENTORY_ID number 22 -1
BDNA_HTTP_SERVERS.INVENTORY_ID FKM1_BDNAHTTPSERVERS R
BDNA_IMAP_SERVERS.INVENTORY_ID FKM1_BDNAIMAPSERVERS R
BDNA_ORACLE_LISTENERS.INVENTORY_ID FKM1_BDNAORACLELISTE R
BDNA_POP_SERVERS.INVENTORY_ID FKM1_BDNAPOPSERVERS R
BDNA_SMTP_SERVERS.INVENTORY_ID FKM1_BDNASMTPSERVERS R
BDNA_INVENTORY_INFO.INVENTORY_ID BDNANETSERVICES1_INVENTORY_ID R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNANETSERVICES R
Inventory Id

Analyzed at Wed Jul 12 12:54 CST 2017

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA