Table workflow_node
Legend:
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
type bpchar 1
id int8 19
task_history.task_id fk608e6bda96112c19 R
workflow_node.parent_id fk440e8e826d1a7dc3 R
workflow_node_auto_assigns.workflow_node_id fkd2200171cbacd5fc R
workflow_node_groups.workflow_node_id fkaf1c5231cbacd5fc R
workflow_node_roles.workflow_node_id fkbbed16c0cbacd5fc R
workflow_node_status.wnode_id fkc3ac484fb9679514 R
workflow_node_users.workflow_node_id fkbc19160bcbacd5fc R
child_index int4 10
reject_point bool 1
uuid varchar 40
collection_uuid varchar 40  √  null
script text 2147483647  √  null
action_days int4 10  √  null
allow_editing bool 1  √  null
auto_action bool 1  √  null
auto_assign_node varchar 512  √  null
auto_assign_schema_uuid varchar 40  √  null
due_date_path varchar 512  √  null
due_date_schema_uuid varchar 40  √  null
escalate bool 1  √  null
escalationdays int4 10  √  null
movelive bool 1  √  null
movelive_accept bool 1  √  null
priority int4 10  √  null
unanimousacceptance bool 1  √  null
user_path varchar 512  √  null
user_schema_uuid varchar 40  √  null
name_id int8 19  √  null
language_bundle.id fk440e8e82d4838ffb R
parent_id int8 19  √  null
workflow_node.id fk440e8e826d1a7dc3 R
workflow_id int8 19
workflow.id fk440e8e82cbffa4b4 R
description_id int8 19  √  null
language_bundle.id fk440e8e82888c44ea R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc workflow_node_pkey
description_id Performance Asc workflownodedesc
name_id Performance Asc workflownodename
parent_id Performance Asc workflownodeparent
workflow_id Performance Asc workflownodeworkflow

Close relationships  within of separation: