Object_Attribute

Definition

CREATE   VIEW
  [mr].[Object_Attribute] AS
SELECT
  [Attribute_Id],
  [a].[Attribute_Type_Id],
  [att].[Enum_Key],
  [a].[Start_Version_Id],
  [a].[End_Version_Id],
  [a].[Text_Value] [Attribute_Value],
  [a].[Object_Id],
  [o].[Name] [Object_Name],
  [ot].[Enum_Key] [Object_Type]
FROM
  [dbo].[MR_Attribute] [a]
  INNER JOIN [dbo].[C_Attribute_Type] [att] ON [att].[Attribute_Type_Id] = [a].[Attribute_Type_Id]
  INNER JOIN [dbo].[MR_Object] [o] ON [o].[Object_Id] = [a].[Object_Id]
  INNER JOIN [dbo].[C_Object_Type] [ot] ON [ot].[Object_Type_Id] = [o].[Object_Type_Id]

Columns

#	Column	Data Type	Nullable	Source
1	Attribute_Id	int	No
2	Attribute_Type_Id	int	No
3	Enum_Key	nvarchar	No	C_Attribute_Type.Enum_Key
4	Start_Version_Id	int	No	MR_Attribute.Start_Version_Id
5	End_Version_Id	int	Yes	MR_Attribute.End_Version_Id
6	Attribute_Value	nvarchar	No	MR_Attribute.Text_Value
7	Object_Id	int	No	MR_Attribute.Object_Id
8	Object_Name	nvarchar	No	MR_Object.Name
9	Object_Type	nvarchar	No	C_Object_Type.Enum_Key

graph LR
  n1533["Object_Attribute"]
  n1253["MR_Attribute"]
  n1256["MR_Object"]
  n1267["C_Object_Type"]
  n1274["C_Attribute_Type"]
  n1253 --> n1533
  n1256 --> n1533
  n1267 --> n1533
  n1274 --> n1533
  style n1533 fill:#00A081,stroke:#008068,color:#fff
  click n1533 href "/actual/objectattribute/"
  click n1253 href "/actual/mrattribute/"
  click n1256 href "/actual/mrobject/"
  click n1267 href "/actual/cobjecttype/"
  click n1274 href "/actual/cattributetype/"