Table HLPDTEST.STATEGPS.T_HTML_NODE_PROPSHEET_VERSION 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
PROPSHEET_VERSION_ID number 22
NODETYPE_STATE_ID number 22  √  null
T_GPS_NODETYPE_STATES.NODETYPE_STATE_ID FK_VERSION_NODETYPE_STATE_ID C
VERSION number 22  √  null
IS_CURRENT_VERSION varchar2 5  √  'FALSE'
GENERATED_BY varchar2 255 'AUTO'
GENERATED_DATE timestamp(6) with time zone 13,6 SYSTIMESTAMP
LAST_UPDATED_BY varchar2 255  √  null
LAST_UPDATED_DATE timestamp(6) with time zone 13,6  √  null

Table contained 551 rows at Sun Jan 17 01:06 IST 2021

Indexes:
Column(s) Type Sort Constraint Name
PROPSHEET_VERSION_ID Primary key Asc SYS_C0034622

Close relationships  within of separation: