Table HLPDTEST.STATEGPS.T_PROJECTPLAN_CONFIG 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
PROJECTPLAN_ID number 22
APPLICTION_NAME varchar2 255  √  null
WORKLFOW_NAME varchar2 255  √  null
NODETYPE varchar2 255  √  null
ROLE_NAME varchar2 255  √  null
NODETYPE_STATE_ID number 22  √  null
T_GPS_NODETYPE_STATES.NODETYPE_STATE_ID Implied Constraint R
PROJECT_ID number 22  √  null
T_PROJECT_DETAILS.PROJECT_ID Implied Constraint R
PROJECTTASK_ID number 22  √  null
PARENTTASK_NAME varchar2 255  √  null
ENABLE_INSTANCE varchar2 10  √  null

Table contained 1,025 rows at Fri Aug 14 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
PROJECTPLAN_ID Primary key Asc PK_T_PROJECTPLAN_CONFIG

Close relationships: