Definition
CREATE VIEW
[mr].[Application_Object_Type] AS
SELECT
[r].[Application_Id],
[a].[Enum_Key] [Application],
[r].[Object_Type_Id],
[o].[Enum_Key] [Object_Type]
FROM
[dbo].[R_Object_In_Application] [r]
JOIN [dbo].[C_Object_Type] [o] ON [o].[Object_Type_Id] = [r].[Object_Type_Id]
JOIN [dbo].[C_Application] [a] ON [a].[Application_Id] = [r].[Application_Id]
Columns
| # | Column | Data Type | Nullable | Source |
|---|---|---|---|---|
| 1 | Application_Id | int | No | R_Object_In_Application.Application_Id |
| 2 | Application | nvarchar | No | C_Application.Enum_Key |
| 3 | Object_Type_Id | int | No | R_Object_In_Application.Object_Type_Id |
| 4 | Object_Type | nvarchar | No | C_Object_Type.Enum_Key |