Definition


CREATE   VIEW
  [mr].[Relation] AS
SELECT
  [r].[Object_Relation_Id],
  [r].[From_Object_Id],
  [fo].[Name] [From_Object],
  [r].[To_Object_Id],
  [to].[Name] [TO_Object],
  [r].[Relation_Type_Id],
  [rt].[Relation_Type_Key],
  [rt].[Relation_Type],
  [r].[Source_Type_Id],
  [st].[Source_Type],
  [u].[Login] [Creator],
  [v].[Created] [Created]
FROM
  [dbo].[MR_Object_Relation] [r]
  JOIN [dbo].[MR_Object] [fo] ON [fo].[Object_Id] = [r].[From_Object_Id]
  JOIN [dbo].[MR_Object] [to] ON [to].[Object_Id] = [r].[To_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]
  LEFT JOIN [mr].[Source_Type] st ON st.Source_Type_Id = r.[Source_Type_Id]
  LEFT JOIN [mr].[Relation_Type] rt ON rt.Relation_Type_Id = r.[Relation_Type_Id]

Columns

#ColumnData TypeNullableSource
1Object_Relation_IdintNoMR_Object_Relation.Object_Relation_Id
2From_Object_IdintNoMR_Object_Relation.From_Object_Id
3From_ObjectnvarcharNoMR_Object.Name
4To_Object_IdintNoMR_Object_Relation.To_Object_Id
5TO_ObjectnvarcharNoMR_Object.Name
6Relation_Type_IdintNoMR_Object_Relation.Relation_Type_Id
7Relation_Type_KeynvarcharYesRelation_Type.Relation_Type_Key
8Relation_TypenvarcharYesRelation_Type.Relation_Type
9Source_Type_IdsmallintNoMR_Object_Relation.Source_Type_Id
10Source_TypenvarcharYesSource_Type.Source_Type
11CreatornvarcharYesAPP_User.Login
12Createddatetime2NoMR_Version.Created