Object_Type

Definition

CREATE   VIEW
  [mr].[Object_Type] AS
SELECT
  [ot].[Object_Type_Id],
  [ot].[Enum_Key] [Object_Type_Key],
  [t].[Translation] [Object_Type],
  [ta].[Translation] [State],
  [td].[Translation] [Description]
FROM
  [dbo].[C_Object_Type] [ot]
  LEFT JOIN [dbo].[C_Object_State] [os]  ON [os].[State_Id] = [ot].[State_Id]
  LEFT JOIN [fw].[Translation] [t] ON [t].[Translation_key] = [ot].[Name_Key]
  LEFT JOIN [fw].[Translation] [ta] ON [ta].[Translation_key] = [os].[Name_Key]
  LEFT JOIN [fw].[Translation] [td] ON [td].[Translation_key] = [ot].[Description_Key]

Columns

#	Column	Data Type	Nullable	Source
1	Object_Type_Id	int	No	C_Object_Type.Object_Type_Id
2	Object_Type_Key	nvarchar	No	C_Object_Type.Enum_Key
3	Object_Type	nvarchar	Yes	Translation.TRANSLATION
4	State	nvarchar	Yes	Translation.TRANSLATION
5	Description	nvarchar	Yes	Translation.TRANSLATION

graph LR
  n1552["Object_Type"]
  n1267["C_Object_Type"]
  n1543["Translation"]
  n1270["C_Translation_Key"]
  n1282["C_Translation"]
  n1287["C_Language"]
  n1267 --> n1552
  n1543 --> n1552
  n1270 --> n1543
  n1282 --> n1543
  n1287 --> n1543
  style n1552 fill:#00A081,stroke:#008068,color:#fff
  click n1552 href "/actual/objecttype/"
  click n1267 href "/actual/cobjecttype/"
  click n1543 href "/actual/translation/"
  click n1270 href "/actual/ctranslationkey/"
  click n1282 href "/actual/ctranslation/"
  click n1287 href "/actual/clanguage/"