View mapping workflow state IDs to translated names and enum keys.
CREATE VIEW
[mr].[Workflow_State] AS
SELECT
[ws].[Workflow_State_Id],
[ws].[Enum_Key] Workflow_State_Key,
[t].[Translation] Workflow_State
FROM
[dbo].[C_Workflow_State] [ws]
LEFT JOIN [fw].[Translation] [t] ON [t].[Translation_key] = [ws].[Name_Key]
| # | Column | Data Type | Nullable | Source |
|---|---|---|---|---|
| 1 | Workflow_State_Id | int | No | C_Workflow_State.Workflow_State_Id |
| 2 | Workflow_State_Key | nvarchar | No | C_Workflow_State.Enum_Key |
| 3 | Workflow_State | nvarchar | Yes | Translation.TRANSLATION |
graph LR n1542["Workflow_State"] n1264["C_Workflow_State"] n1543["Translation"] n1270["C_Translation_Key"] n1282["C_Translation"] n1287["C_Language"] n1264 --> n1542 n1543 --> n1542 n1270 --> n1543 n1282 --> n1543 n1287 --> n1543 style n1542 fill:#00A081,stroke:#008068,color:#fff click n1542 href "/actual/workflowstate/" click n1264 href "/actual/cworkflowstate/" click n1543 href "/actual/translation/" click n1270 href "/actual/ctranslationkey/" click n1282 href "/actual/ctranslation/" click n1287 href "/actual/clanguage/"