variable_workflow_history

-1 rows


Description

History of changes to the workflow details for a variable in a project. This table is append-only; edits to the values are represented as new rows, and the row with the highest ID for a given project and variable ID holds the current workflow details for that variable.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
project_id int8 19 null
projects.id variable_workflow_history_project_id_fkey C
variable_id int8 19 null
variables.id variable_workflow_history_variable_id_fkey R
max_variable_value_id int8 19 null
variable_values.id variable_workflow_history_max_variable_value_id_fkey R

The highest variable value ID at the time the workflow operation happened. This is to support fetching the variable value as it existed at the time of the workflow operation. This ID is not required to be a value of the variable referenced by variable_id (it can be the maximum value ID for the project as a whole).
created_by int8 19 null
users.id variable_workflow_history_created_by_fkey R
created_time timestamptz 35,6 null
variable_workflow_status_id int4 10 null
variable_workflow_statuses.id variable_workflow_history_variable_workflow_status_id_fkey R
feedback text 2147483647 √ null
internal_comment text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
variable_workflow_history_pkey Primary key Asc id
variable_workflow_history_created_by_idx Performance Asc created_by
variable_workflow_history_max_variable_value_id_idx Performance Asc max_variable_value_id
variable_workflow_history_project_id_variable_id_id_idx Performance Asc/Asc/Desc project_id + variable_id + id
variable_workflow_history_variable_id_idx Performance Asc variable_id

Relationships

Close relationships within degrees of separation