BDNA Discover Publish version 7.7.2 with 201708
BDNA_WEBSPHERE_PORTS - WebSphere App Server Instance Ports

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
PORT_ID number 22 WebSphere App Server Port ID
WEBSPHERE_INSTANCE_ID number 22  √  null
BDNA_WEBSPHERE_INSTANCES.WEBSPHERE_INSTANCE_ID FKM0_BDNAWEBSPHEREPO R
WebSphere Application Server Instance Id
OPERATINGSYSTEM_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM1_BDNAWEBSPHEREPO R
Operating Systems Id
PORT_NAME varchar2 256  √  null Port Name
PORT_NUMBER number 22  √  null Port Number
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNAWEBSPHEREPORT_INVENTORY_ID R
BDNA_ALL_OS.INVENTORY_ID FKM1_BDNAWEBSPHEREPO R
BDNA_WEBSPHERE_INSTANCES.INVENTORY_ID FKM0_BDNAWEBSPHEREPO R
Inventory Id

Analyzed at Wed Jul 12 12:54 CST 2017

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA