BDNA Discover Publish version 7.7.2 with 201708
BDNA_ORADB_SCHEMAS - Oracle DB Schemas

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
OPERATINGSYSTEM_LABEL varchar2 256  √  null Hostname
OPERATINGSYSTEM_TYPE number 22  √  null
BDNA_TYPES.TYPE_ID BDNAORADBSCHEMA_OST R
OS Type
ORACLEINSTANCE_LABEL varchar2 1024  √  null Oracle Instance Name
ORACLESCHEMA_LABEL varchar2 1024  √  null Oracle Schema Name
TOTALBYTESUSED number 22  √  null Total Bytes Used
OSCOMPUTERNAME varchar2 256  √  null OS Computer Name
NUMCPUS number 22  √  null Number of CPUs
OPERATINGSYSTEM_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNAORADBSCHEMA R
Operating Systems Id
ORACLEINSTANCE_ID number 22
BDNA_ORADB_INSTANCES.ORACLEINSTANCE_ID FKM1_BDNAORADBSCHEMA R
Oracle Instance Id
ORACLESCHEMA_ID number 22 Oracle Schema Id
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNAORADBSCHEMAS1_INVENTORY_ID R
BDNA_ORADB_INSTANCES.INVENTORY_ID FKM1_BDNAORADBSCHEMA R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNAORADBSCHEMA R
Inventory Id

Analyzed at Wed Jul 12 12:54 CST 2017

Indexes:
Column(s) Type Sort Constraint Name
ORACLEINSTANCE_ID + ORACLESCHEMA_ID + INVENTORY_ID Primary key Asc/Asc/Asc PK_BDNA_ORADB_SCHEMAS

Close relationships  within of separation:
Confidential and Proprietary to BDNA