View lawprod.MSCM.INSTRUMENT_ID_ASSEMBLY_VIEW Generated by
SchemaSpy
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
TS_INST_TK_DATA_ID number 20
TS_INST_TK_DATA.TS_INST_TK_DATA_ID Implied Constraint R
INSTRUMENT_TRACK_ID number 22  √  null
TS_ID number 22
EX_NO number 22  √  null

Analyzed at Wed May 18 12:10 CDT 2011

View Definition:
SELECT TITD.TS_INST_TK_DATA_ID, NVL(REP_INST_TRACK_ID,INSTRUMENT_TRACK_ID) INSTRUMENT_TRACK_ID, TS_ID, NVL(TITE.EX_NO,0) EX_NO FROM TS_INST_TK_DATA TITD, TS_INST_TK_EXCEPTION TITE WHERE TITD.TS_INST_TK_DATA_ID = TITE.TS_INST_TK_DATA_ID(+) AND (REP_INST_TRACK_ID IS NOT NULL OR INSTRUMENT_TRACK_ID IS NOT NULL)
 
Possibly Referenced Tables/Views:
TS_INST_TK_DATA TS_INST_TK_EXCEPTION 


Close relationships: