View HLPDTEST.STATEGPS.SAMPLE_VIEWER_AUDITTRAIL_INFO Generated by
SchemaSpy
Legend: SourceForge.net
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
ROW_ID number 22
T_GPS_VIEWER_AUDITTRAIL_INFO.ROW_ID Implied Constraint R
AUDIT_ID number 22
T_GPS_QUERIES_AUDIT.AUDIT_ID Implied Constraint R
COLUMN_NAME varchar2 1000  √  null
OLD_COLUMN_VALUE varchar2 4000  √  null
NEW_COLUMN_VALUE varchar2 4000  √  null

Analyzed at Tue Sep 22 01:05 IST 2020

View Definition:
( select "ROW_ID","AUDIT_ID","COLUMN_NAME","OLD_COLUMN_VALUE","NEW_COLUMN_VALUE" from t_gps_viewer_audittrail_info where rownum < 10000 )
 
Possibly Referenced Tables/Views:


Close relationships: