Table: Gofileroom_Workflow
Stores information about GoFileRoom Workflows. Field lengths match the field lengths defined in GoFileRoom Workflow.
Columns
NameTypeConstraintsDescription
gofileroom_workflow_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
folder_idnvarchar (10)NOT NULLOne of four required fields that uniquely identify a workflow, not intended to be viewed by users.
workflow_idintNOT NULLOne of four required fields that uniquely identify a workflow, not intended to be viewed by users.
workflow_template_idintNOT NULLOne of four required fields that uniquely identify a workflow, not intended to be viewed by users.
service_type_idintNOT NULLOne of four required fields that uniquely identify a workflow, not intended to be viewed by users.
client_namenvarchar (255)NOT NULLGoFileRoom Client name of this workflow.
client_numbernvarchar (255)NOT NULLGoFileRoom Client number of this workflow.
engagementnvarchar (255)NOT NULLGoFileRoom engagement of this workflow.
workflow_yearnvarchar (255)NOT NULLGoFileRoom year of this workflow.
period_endnvarchar (255)NOT NULLGoFileRoom period end date part of this workflow.
workflownvarchar (255)NOT NULLGoFileRoom workflow template description of this workflow.
workflow_descriptionnvarchar (255)NOT NULLGoFileRoom workflow description of this workflow.
service_typenvarchar (255)NOT NULLGoFileRoom folder name in which this workflow exists.
person_in_chargenvarchar (100)NOT NULLGoFileRoom name of the person in charge of this workflow.
Primary key
NameColumnsDescription
PK_Gofileroom_Workflow$gofileroom_workflow_KEYgofileroom_workflow_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Gofileroom_Workflow$folder_id$workflow_id$workflow_template_id$service_type_idfolder_id, workflow_id, workflow_template_id, service_type_idGoFileRoom Workflows are uniquely identified by the combination of these four fields.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Project__Gofileroom_Workflow__gofileroom_workflow_KEYgofileroom_workflow_KEYProject

Schema diagram