Table HLPDTEST.STATEGPS.T_SURVEYS 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
ID number 22
T_GPS_WF_STATE_FEEDBACK_FORM.SURVEY_ID FK_T_SURVEYS R
T_SURVEY_DETAILS.ID SYS_C0025030 R
T_SURVEY_RESPONSES.SURVEY_ID T_SURVEY_RESPONSES_T_SURV_FK1 R
T_DELETE_ROW_ACTION_UPDATE.ID Implied Constraint R
NAME varchar2 255
DESCRIPTION varchar2 4000  √  null
IS_RESOURCE_BASED varchar2 10  √  null
STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID FK_T_SURVEYS_ST C
ACCEPT_ONLY_ONE_RESPONSE varchar2 10  √  null
END_DATE date 7  √  null
SHOW_PREVIOUS_RESPONSE varchar2 10  √  null
SURVEY_SENT_BY varchar2 255  √  null

Table contained 1,027 rows at Sat Dec 05 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc T_SURVEYS_PK

Close relationships  within of separation: