Space

Definition

CREATE   VIEW
  [mr].[Space] AS
SELECT
  [s].[Space_Id],
  [s].[Name] [Space],
  [s].[Parent_Space_Id],
  [p].[Name] [Parent_Space],
  [s].[Hierarchy_Path],
  [s].[Creator_Id],
  [uc].[Login] [Creator],
  [s].[Created],
  [s].[Updater_Id],
  [uu].[Login] [Updater],
  [s].[Updated],
  [s].[Is_Public],
  [s].[Short_Description],
  [s].[Sort_Order]
FROM
  [dbo].[MR_Space] [s]
  LEFT JOIN [dbo].[APP_User] [uc] ON [uc].[User_Id] = [s].[Creator_Id]
  LEFT JOIN [dbo].[APP_User] [uu] ON [uu].[User_Id] = [s].[Updater_Id]
  LEFT JOIN [dbo].[MR_Space] [p] ON [p].[Space_Id] = [s].[Parent_Space_Id]

Columns

#	Column	Data Type	Nullable	Source
1	Space_Id	int	No	MR_Space.Space_Id
2	Space	nvarchar	No	MR_Space.Name
3	Parent_Space_Id	int	Yes	MR_Space.Parent_Space_Id
4	Parent_Space	nvarchar	Yes	MR_Space.Name
5	Hierarchy_Path	nvarchar	Yes	MR_Space.Hierarchy_Path
6	Creator_Id	int	No	MR_Space.Creator_Id
7	Creator	nvarchar	Yes	APP_User.Login
8	Created	datetime	No	MR_Space.Created
9	Updater_Id	int	No	MR_Space.Updater_Id
10	Updater	nvarchar	Yes	APP_User.Login
11	Updated	datetime	No	MR_Space.Updated
12	Is_Public	bit	No	MR_Space.Is_Public
13	Short_Description	nvarchar	Yes	MR_Space.Short_Description
14	Sort_Order	int	No	MR_Space.Sort_Order

graph LR
  n1557["Space"]
  n1260["MR_Space"]
  n1288["APP_User"]
  n1260 --> n1557
  n1288 --> n1557
  style n1557 fill:#00A081,stroke:#008068,color:#fff
  click n1557 href "/actual/space/"
  click n1260 href "/actual/mrspace/"
  click n1288 href "/actual/appuser/"