Table HLPDTEST.STATEGPS.T_GPS_VIEWER_AUDITTRAIL 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
AUDIT_ID number 22
T_GPS_VIEWER_AUDITTRAIL_INFO.AUDIT_ID FK_VIEWER_AUDITTRIAL_INFO C
T_GPS_QUERIES_AUDIT.AUDIT_ID Implied Constraint R
VIEWER_INSTANCES_ID number 22
T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID Implied Constraint R
USER_NAME varchar2 200  √  null
ROLE_NAME varchar2 200  √  null
UPDATED_DATE date 7  √  null

Table contained 774,046 rows at Thu Sep 24 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
AUDIT_ID Primary key Asc SYS_C0010111
VIEWER_INSTANCES_ID Performance Asc T_GPS_VIEWER_AUDIT_VID_IDX

Close relationships: