User_Space_Application

Definition

CREATE   VIEW
  [sec].[User_Space_Application] AS
SELECT
  [r].[User_Id],
  [u].[Login] [User],
  [r].[Space_Id],
  [s].[Name] [Space],
  [a].[Application_Id],
  [a].[Enum_Key] [Application],
  [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].[R_Application_In_Space] [as] ON [as].[Space_Id] = [r].[Space_Id]
  JOIN [dbo].[C_Application] [a] ON [a].[Application_Id] = [as].[Application_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	Application_Id	int	No	C_Application.Application_Id
6	Application	nvarchar	No	C_Application.Enum_Key
7	User_Object_Relation_Type_Id	int	No	R_User_Space.User_Object_Relation_Type_Id
8	User_Object_Relation_Type	nvarchar	No	C_User_Object_Relation_Type.Enum_Key

graph LR
  n1560["User_Space_Application"]
  n1259["C_Application"]
  n1260["MR_Space"]
  n1265["R_User_Space"]
  n1286["C_User_Object_Relation_Type"]
  n1288["APP_User"]
  n1259 --> n1560
  n1260 --> n1560
  n1265 --> n1560
  n1286 --> n1560
  n1288 --> n1560
  style n1560 fill:#00A081,stroke:#008068,color:#fff
  click n1560 href "/actual/userspaceapplication/"
  click n1259 href "/actual/capplication/"
  click n1260 href "/actual/mrspace/"
  click n1265 href "/actual/ruserspace/"
  click n1286 href "/actual/cuserobjectrelationtype/"
  click n1288 href "/actual/appuser/"