Attribute_Type

Definition

CREATE   VIEW
  [mr].[Attribute_Type] AS
SELECT
  [att].[Attribute_Type_Id],
  [att].[Enum_Key] Attribute_Type_Key,
  [tatt].[Translation] Attribute_Type,
  [att].[Default_Value],
  [tos].[Translation] [State],
  [attd].[Translation]
FROM
  [dbo].[C_Attribute_Type] [att]
  LEFT JOIN [dbo].[C_Object_State] [os]  ON [os].[State_Id] = [att].[Object_State_Id]
  LEFT JOIN [fw].[Translation] [tatt] ON [tatt].[Translation_key] = [att].[Name_Key]
  LEFT JOIN [fw].[Translation] [tos] ON [tos].[Translation_key] = [os].[Name_Key]
  LEFT JOIN [fw].[Translation] [attd] ON [attd].[Translation_key] = [att].[Description_Key]

Columns

#	Column	Data Type	Nullable	Source
1	Attribute_Type_Id	int	No	C_Attribute_Type.Attribute_Type_Id
2	Attribute_Type_Key	nvarchar	No	C_Attribute_Type.Enum_Key
3	Attribute_Type	nvarchar	Yes	Translation.TRANSLATION
4	Default_Value	nvarchar	Yes	C_Attribute_Type.Default_Value
5	State	nvarchar	Yes	Translation.TRANSLATION
6	Translation	nvarchar	Yes	Translation.TRANSLATION

graph LR
  n1553["Attribute_Type"]
  n1274["C_Attribute_Type"]
  n1543["Translation"]
  n1270["C_Translation_Key"]
  n1282["C_Translation"]
  n1287["C_Language"]
  n1274 --> n1553
  n1543 --> n1553
  n1270 --> n1543
  n1282 --> n1543
  n1287 --> n1543
  style n1553 fill:#00A081,stroke:#008068,color:#fff
  click n1553 href "/actual/attributetype/"
  click n1274 href "/actual/cattributetype/"
  click n1543 href "/actual/translation/"
  click n1270 href "/actual/ctranslationkey/"
  click n1282 href "/actual/ctranslation/"
  click n1287 href "/actual/clanguage/"