Object_User

Definition

CREATE   VIEW
  [mr].[Object_User] AS
SELECT
  [r].[Object_Id],
  [o].[Name] [Object],
  [r].[User_Id],
  [a].[Name],
  [rt].[Enum_Key] User_Relation_Type_Key,
  [u].[Login] [Creator],
  [v].[Created] [Created]
FROM
  [dbo].[R_User_Object]  [r]
  JOIN [dbo].[C_User_Object_Relation_Type]  [rt] ON [rt].[User_Object_Relation_Type_Id] = [r].[User_Object_Relation_Type_Id]
  JOIN [dbo].[MR_Object] [o] ON [o].[Object_Id] = [r].[Object_Id]
  JOIN [dbo].[MR_Version] [v] ON [v].[Version_Id] = [r].[Start_Version_Id]
  JOIN [dbo].[APP_User] [u] ON [u].[User_Id] = [v].[Creator_Id]
  JOIN [dbo].[APP_User] [a] ON [a].[User_Id] = [r].[User_Id]

Columns

#	Column	Data Type	Nullable	Source
1	Object_Id	int	No
2	Object	nvarchar	No	MR_Object.Name
3	User_Id	int	No
4	Name	nvarchar	No	APP_User.Name
5	User_Relation_Type_Key	nvarchar	No	C_User_Object_Relation_Type.Enum_Key
6	Creator	nvarchar	Yes	APP_User.Login
7	Created	datetime2	No	MR_Version.Created

graph LR
  n1532["Object_User"]
  n1251["MR_Version"]
  n1256["MR_Object"]
  n1286["C_User_Object_Relation_Type"]
  n1288["APP_User"]
  n1251 --> n1532
  n1256 --> n1532
  n1286 --> n1532
  n1288 --> n1532
  style n1532 fill:#00A081,stroke:#008068,color:#fff
  click n1532 href "/actual/objectuser/"
  click n1251 href "/actual/mrversion/"
  click n1256 href "/actual/mrobject/"
  click n1286 href "/actual/cuserobjectrelationtype/"
  click n1288 href "/actual/appuser/"