BDNA Discover Publish version 7.7.0 with 201605 Sequence
BDNA_LMS_VSESSION - LMS_V$SESSION

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
SADDR varchar2 256  √  null SADDR
SID varchar2 256  √  null SID
PADDR varchar2 256  √  null PADDR
USR varchar2 256  √  null USER#
USERNAME varchar2 256  √  null USERNAME
COMMAND varchar2 256  √  null COMMAND
STATUS varchar2 256  √  null STATUS
SERVER varchar2 256  √  null SERVER
SCHEMANAME varchar2 256  √  null SCHEMANAME
OSUSER varchar2 256  √  null OSUSER
PROCESS varchar2 256  √  null PROCESS
MACHINE varchar2 256  √  null MACHINE
TERMINAL varchar2 256  √  null TERMINAL
PROGRAM varchar2 256  √  null PROGRAM
TYP varchar2 256  √  null TYPE
LAST_CALL_ET varchar2 256  √  null LAST_CALL_ET
LOGON_TIME varchar2 256  √  null LOGON_TIME
MACHINE_ID varchar2 256  √  null MACHINE_ID
DB_NAME varchar2 265  √  null DB_NAME
TIMESTAMP varchar2 256  √  null TIMESTAMP
VSESSION_ID number 22 VSESSION_ID
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNALMSVSESSION0_INVENTORY_ID R
Inventory Id

Analyzed at Sat Mar 05 19:14 PST 2016

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA