Table workflow_node_status
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
acttype varchar 31
id int8 19
workflow_message.node_id fk94de4f876b3d7505 R
workflow_node_status.cause_id fkc3ac484ff2b1413e R
workflow_node_status_accepted.workflow_node_status_id fk2dc27197c9e397e9 R
status bpchar 1
assigned_to varchar 40  √  null
date_due timestamp 29,6  √  null
overdue bool 1  √  null
started timestamp 29,6  √  null
mod_status_id int8 19
moderation_status.id fkc3ac484fb7ba8b05 R
wnode_id int8 19
workflow_node.id fkc3ac484fb9679514 R
cause_id int8 19  √  null
workflow_node_status.id fkc3ac484ff2b1413e R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc workflow_node_status_pkey
cause_id Performance Asc cause_idx
date_due Performance Asc datedue_idx
mod_status_id Performance Asc nodestatusmodstatusindex
wnode_id Performance Asc nodestatusnodeindex

Close relationships  within of separation: