BDNA Discover Publish version 7.7.0 with 201605 Sequence
BDNA_LMS_OPTIONS - LMS_OPTIONS

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
MACHINE_ID varchar2 256  √  null MACHINE_ID
DB_NAME varchar2 265  √  null DB_NAME
TIMESTAMP varchar2 256  √  null TIMESTAMP
HOST_NAME varchar2 256  √  null HOST_NAME
INSTANCE_NAME varchar2 256  √  null INSTANCE_NAME
OPTION_NAME varchar2 256  √  null OPTION_NAME
OPTION_QUERY varchar2 256  √  null OPTION_QUERY
SQL_ERR_CODE varchar2 256  √  null SQL_ERR_CODE
SQL_ERR_MESSAGE varchar2 256  √  null SQL_ERR_MESSAGE
COL010 varchar2 4000  √  null COL010
COL020 varchar2 256  √  null COL020
COL030 varchar2 256  √  null COL030
COL040 varchar2 256  √  null COL040
COL050 varchar2 256  √  null COL050
COL060 varchar2 256  √  null COL060
COL070 varchar2 256  √  null COL070
COL080 varchar2 256  √  null COL080
COL090 varchar2 256  √  null COL090
COL100 varchar2 256  √  null COL100
COL110 varchar2 256  √  null COL110
COL120 varchar2 256  √  null COL120
COL130 varchar2 256  √  null COL130
COL140 varchar2 256  √  null COL140
COL150 varchar2 256  √  null COL150
COL160 varchar2 256  √  null COL160
LMS_OPTIONS_ID number 22 LMS_OPTIONS_ID
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNA_LMS_OPTIONS0_INVENTORY_ID R
Inventory Id

Analyzed at Sat Mar 05 19:14 PST 2016

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA