Table HLPDTEST.STATEGPS.T_GPS_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
SAMPLE_VIEWER_AUDITTRAIL_INFO.ROW_ID Implied Constraint R
AUDIT_ID number 22
T_GPS_VIEWER_AUDITTRAIL.AUDIT_ID FK_VIEWER_AUDITTRIAL_INFO C
COLUMN_NAME varchar2 1000  √  null
OLD_COLUMN_VALUE varchar2 4000  √  null
NEW_COLUMN_VALUE varchar2 4000  √  null
RECORD_ID number 22  √  null

Table contained 107,641,973 rows at Tue Aug 11 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
ROW_ID Primary key Asc SYS_C0010114
AUDIT_ID Performance Asc T_GPS_VIEWER_AUDITINFO_AID_IDX

Close relationships: