Definition
CREATE VIEW
[mr].[Application_In_Space] AS
SELECT
[r].[Application_Id],
[a].[Enum_Key] [Application],
[r].[Space_Id],
[s].[Name] [Space]
FROM
[dbo].[R_Application_In_Space] [r]
JOIN [dbo].[MR_Space] [s] ON [s].[Space_Id] = [r].[Space_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_Application_In_Space.Application_Id |
| 2 | Application | nvarchar | No | C_Application.Enum_Key |
| 3 | Space_Id | int | No | |
| 4 | Space | nvarchar | No | MR_Space.Name |