Table HLPDTEST.STATEGPS.T_GPS_STATE_OPERATIONS 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
FROM_STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID FK_T_GPS_STATE_OPER_FROM_STATE C
OPERATION_ID number 22
T_GPS_CONDITIONAL_STATE_TRACK.OPERATION_ID FK_CST_OPERATION_ID C
T_GPS_NOTIFICATION_DETAILS.OPERATION_ID FK_T_GPS_NOTIFICATION_DETAILS C
T_GPS_OPERATION_ALGORITHM.OPERATION_ID FK_T_GPS_OPERATION_ALG C
T_GPS_OPERATION_ELBOWS.OPERATION_ID FK_T_GPS_OPER_ID C
T_GPS_OPERATION_PROPERTIES.OPERATION_ID FK_T_GPS_OPERATION_PROPS C
T_GPS_OPERATION_TO_STATES.OPERATION_ID FK_T_GPS_OPERATION_TO_STATES C
T_GPS_ROLE_OPERATIONS.OPERATION_ID CON_OPERATION_ID C
T_GPS_ROUTING_NOTIFICATION.OPERATION_ID FK_T_GPS_ROUTING_NOTIF C
T_GPS_STATE_EDIT_OPERATIONS.OPERATION_ID FK_STATE_OPERATION C
T_GPS_USER_OPERATIONS.OPERATION_ID CON_FK_OPERATION_ID C
T_GPS_WF_DISABLED_OPERATIONS.OPERATION_ID Implied Constraint R
T_GPS_WFMOVE_STATEOPERATIONS.OPERATION_ID FK_OPERATION_ID C
OPERATION_NAME varchar2 255  √  null
PUT_CONTROLLER_NAME varchar2 255  √  null
DESCRIPTION varchar2 1000  √  null
ICON_FILE varchar2 255  √  null
WORKFLOW_TYPE_ID number 22  √  null
T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID FK_WORKFLOW_TYPE_ID C
VIEWER_INSTANCE_SET varchar2 255  √  null
VIEWER_INSTANCE varchar2 255  √  null
EFFECTIVE_END_DATE date 7  √  null
EFFECTIVE_START_DATE date 7  √  null
OPERATION_TYPE varchar2 25  √  null
WEB_SERVICE_TYPE varchar2 10  √  null
WEB_SERVICE_URL varchar2 500  √  null
INVOCATION_TYPE varchar2 50  √  null
CALL_BACK_URL varchar2 500  √  null
DISPLAY_NAME varchar2 255  √  null
VALIDATE_MODEL varchar2 255  √  null
SAVE_MODEL_AS_IMAGE varchar2 10  √  null
ENABLE_ESIGNATURE varchar2 10  √  null
DISABLE_CONFIRMATION varchar2 10  √  null Used to disable confirmation dialog when Action is performed
ACTION_CONFIRMATION_MESSAGE varchar2 4000  √  null

Table contained 19,170 rows at Fri Sep 25 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
OPERATION_ID + WORKFLOW_TYPE_ID Performance Asc/Asc T_GPS_ST_OP_WF_ID_INDEX
WORKFLOW_TYPE_ID Performance Asc T_GPS_ST_WF_ID_INDEX
OPERATION_ID + OPERATION_NAME + WORKFLOW_TYPE_ID + FROM_STATE_ID Performance Asc/Asc/Asc/Asc T_GPS_STATE_OPERATIONS_INDEX

Close relationships  within of separation: