CREATE VIEW
[mr].[Object_State] AS
SELECT
[os].[State_Id] [Object_State_Id],
[ta].[Translation] [Object_State]
FROM
[dbo].[C_Object_State] [os]
LEFT JOIN [fw].[Translation] [ta] ON [ta].[Translation_key] = [os].[Name_Key]
| # | Column | Data Type | Nullable | Source |
|---|---|---|---|---|
| 1 | Object_State_Id | int | No | C_Object_State.State_Id |
| 2 | Object_State | nvarchar | Yes | Translation.TRANSLATION |
graph LR n1535["Object_State"] n1271["C_Object_State"] n1543["Translation"] n1270["C_Translation_Key"] n1282["C_Translation"] n1287["C_Language"] n1271 --> n1535 n1543 --> n1535 n1270 --> n1543 n1282 --> n1543 n1287 --> n1543 style n1535 fill:#00A081,stroke:#008068,color:#fff click n1535 href "/actual/objectstate/" click n1271 href "/actual/cobjectstate/" click n1543 href "/actual/translation/" click n1270 href "/actual/ctranslationkey/" click n1282 href "/actual/ctranslation/" click n1287 href "/actual/clanguage/"