BDNA Discover Publish version 7.7.1 with 201612 Sequence
BDNA_MSSQL_DBS - Microsoft SQL Server Databases

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
MSSQL_LABEL varchar2 256  √  null Database Name
STATUS varchar2 256  √  null Status
OWNER varchar2 256  √  null Owner
VERSION varchar2 256  √  null Status Version
DBSIZE varchar2 256  √  null Size
CREATEDDATE varchar2 256  √  null Created Date
RECOVERYMODEL varchar2 256  √  null Recovery Model
UPDATEABILITY varchar2 256  √  null Updateability
USERACCESS varchar2 256  √  null User Access
ISFULLTEXTENABLED varchar2 256  √  null Is Full Text Enabled?
OPERATINGSYSTEM_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNA_MSSQL_DBS R
Operating Systems Id
MSSQLSERVERINSTANCE_ID number 22  √  null
BDNA_MSSQL_INSTANCES.MSSQLSERVERINSTANCE_ID FKM1_BDNA_MSSQL_DBS R
Microsoft SQL Server Instance Id
MSSQL_ID number 22 Microsoft SQL Database Id
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNA_MSSQL_DBS0_INVENTORY_ID R
BDNA_MSSQL_INSTANCES.INVENTORY_ID FKM1_BDNA_MSSQL_DBS R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNA_MSSQL_DBS R
Inventory Id

Analyzed at Fri Oct 21 21:10 PDT 2016

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA