User_Space

Definition

CREATE   VIEW
  [sec].[User_Space] AS
SELECT
  [r].[User_Id],
  [u].[Login] [User],
  [r].[Space_Id],
  [s].[Name] [Space],
  [r].[User_Object_Relation_Type_Id],
  [ur].[Enum_Key] [User_Object_Relation_Type]
FROM
  [dbo].[R_User_Space]  [r]
  JOIN [dbo].[APP_User] [u] ON [u].[User_Id] = [r].[User_Id]
  JOIN [dbo].[MR_Space] [s] ON [s].[Space_Id] = [r].[Space_Id]
  JOIN [dbo].[C_User_Object_Relation_Type] [ur] ON [ur].[User_Object_Relation_Type_Id] = [r].[User_Object_Relation_Type_Id]

Columns

#	Column	Data Type	Nullable	Source
1	User_Id	int	No	R_User_Space.User_Id
2	User	nvarchar	Yes	APP_User.Login
3	Space_Id	int	No	R_User_Space.Space_Id
4	Space	nvarchar	No	MR_Space.Name
5	User_Object_Relation_Type_Id	int	No	R_User_Space.User_Object_Relation_Type_Id
6	User_Object_Relation_Type	nvarchar	No	C_User_Object_Relation_Type.Enum_Key

graph LR
  n1549["User_Space"]
  n1260["MR_Space"]
  n1265["R_User_Space"]
  n1286["C_User_Object_Relation_Type"]
  n1288["APP_User"]
  n1260 --> n1549
  n1265 --> n1549
  n1286 --> n1549
  n1288 --> n1549
  style n1549 fill:#00A081,stroke:#008068,color:#fff
  click n1549 href "/actual/userspace/"
  click n1260 href "/actual/mrspace/"
  click n1265 href "/actual/ruserspace/"
  click n1286 href "/actual/cuserobjectrelationtype/"
  click n1288 href "/actual/appuser/"