BDNA Discover Publish version 7.7.1 with 201612 Sequence
BDNA_WEBSPHERE_INSTANCES - WebSphere App Server Instances

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
WEBSPHERE_INSTANCE_ID number 22
BDNA_WEBSPHERE_APPMODSTATS.WEBSPHERE_INSTANCE_ID FKM0_BDNAWEBSPHEREA1 R
BDNA_WEBSPHERE_APPS.WEBSPHERE_INSTANCE_ID FKM0_BDNAWEBSPHEREAP R
BDNA_WEBSPHERE_CONN_POOLS.WEBSPHERE_INSTANCE_ID FKM0_BDNAWEBSPHERECO R
BDNA_WEBSPHERE_ENV_VARS.WEBSPHERE_INSTANCE_ID FKM0_BDNAWEBSPHEREEN R
BDNA_WEBSPHERE_JVMS.WEBSPHERE_INSTANCE_ID FKM0_BDNAWEBSPHEREJV R
BDNA_WEBSPHERE_PORTS.WEBSPHERE_INSTANCE_ID FKM0_BDNAWEBSPHEREPO R
BDNA_WEBSPHERE_THRD_POOLS.WEBSPHERE_INSTANCE_ID FKM0_BDNAWEBSPHERETH R
BDNA_WEBSPHERE_TRANS.WEBSPHERE_INSTANCE_ID FKM0_BDNAWEBSPHERETR R
WebSphere Application Server Instance Id
WEBSPHERE_INSTANCE_LABEL varchar2 1024  √  null WebSphere App Server Instance Label
NODE_NAME varchar2 256  √  null Node Name
NODE_GROUP varchar2 256  √  null Node Group
CORE_GROUP varchar2 4000  √  null Core Group
CELL_NAME varchar2 256  √  null Cell Name
CELL_TYPE varchar2 256  √  null Cell Type
PROFILE_NAME varchar2 4000  √  null Profile Name
PROFILE_PATH varchar2 256  √  null Path to WebSphere profile for the server
SERVER_NAME varchar2 256  √  null Server Name
SERVER_TYPE varchar2 256  √  null Server Type Configured
INSTANCE_RUNNING char 1  √  null Instance Running
PMI_STATE varchar2 256  √  null PMI State
PMI_STAT_LEVEL varchar2 4000  √  null PMI Statistics Level
CLUSTER_NAME varchar2 4000  √  null Cluster Name
MEMBER_WEIGHT varchar2 4000  √  null Cluster Member Weight
OPERATINGSYSTEM_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNAWEBSPHEREI1 R
Operating Systems Id
WEBSPHERE_INSTALL_ID number 22  √  null
BDNA_WEBSPHERE_INSTALLS.WEBSPHERE_INSTALL_ID FKM1_BDNAWEBSPHEREIN R
WebSphere Application Server Installation Id
INVENTORY_ID number 22 -1
BDNA_WEBSPHERE_APPMODSTATS.INVENTORY_ID FKM0_BDNAWEBSPHEREA1 R
BDNA_WEBSPHERE_APPS.INVENTORY_ID FKM0_BDNAWEBSPHEREAP R
BDNA_WEBSPHERE_CONN_POOLS.INVENTORY_ID FKM0_BDNAWEBSPHERECO R
BDNA_WEBSPHERE_ENV_VARS.INVENTORY_ID FKM0_BDNAWEBSPHEREEN R
BDNA_WEBSPHERE_JVMS.INVENTORY_ID FKM0_BDNAWEBSPHEREJV R
BDNA_WEBSPHERE_PORTS.INVENTORY_ID FKM0_BDNAWEBSPHEREPO R
BDNA_WEBSPHERE_THRD_POOLS.INVENTORY_ID FKM0_BDNAWEBSPHERETH R
BDNA_WEBSPHERE_TRANS.INVENTORY_ID FKM0_BDNAWEBSPHERETR R
BDNA_INVENTORY_INFO.INVENTORY_ID BDNAWEBSPHEREINST_INVENTORY_ID R
BDNA_WEBSPHERE_INSTALLS.INVENTORY_ID FKM1_BDNAWEBSPHEREIN R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNAWEBSPHEREI1 R
Inventory Id

Analyzed at Fri Oct 21 21:10 PDT 2016

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA