Object_Data

Definition

CREATE   VIEW
  [mr].[Object_Data] AS
SELECT
  [od].[Object_Data_Id],
  [od].[Object_Id],
  [o].[Name] [Object_Name],
  [od].[Start_Version_Id],
  [od].[End_Version_Id],
  [od].[Name] [Attachment_Name],
  [od].[Content_Type],
  [od].[Description]
FROM
  [dbo].[MR_Object_Data] [od]
  LEFT JOIN [dbo].[MR_Object] [o]  ON [o].[Object_Id] = [od].[Object_Id]

Columns

#	Column	Data Type	Nullable	Source
1	Object_Data_Id	int	No	MR_Object_Data.Object_Data_Id
2	Object_Id	int	No	MR_Object_Data.Object_Id
3	Object_Name	nvarchar	Yes	MR_Object.Name
4	Start_Version_Id	int	No	MR_Object_Data.Start_Version_Id
5	End_Version_Id	int	Yes	MR_Object_Data.End_Version_Id
6	Attachment_Name	nvarchar	No	MR_Object_Data.Name
7	Content_Type	nvarchar	Yes	MR_Object_Data.Content_Type
8	Description	nvarchar	Yes	MR_Object_Data.Description

graph LR
  n1561["Object_Data"]
  n1256["MR_Object"]
  n1269["MR_Object_Data"]
  n1256 --> n1561
  n1269 --> n1561
  style n1561 fill:#00A081,stroke:#008068,color:#fff
  click n1561 href "/actual/objectdata/"
  click n1256 href "/actual/mrobject/"
  click n1269 href "/actual/mrobjectdata/"