Object_Type_Attribute_Type

Definition

CREATE   VIEW
  [mr].[Object_Type_Attribute_Type] AS
SELECT
  [r].[Attribute_Type_Id],
  [a].[Enum_Key] [Attribute_Type],
  [r].[Object_Type_Id],
  [o].[Enum_Key] [Object_Type],
  [r].[Has_User_Autofill],
  [r].[Is_Read_Only]
FROM
  [dbo].[R_Object_Attribute] [r]
  JOIN [dbo].[C_Attribute_Type] [a] ON [a].[Attribute_Type_Id] = [r].[Attribute_Type_Id]
  JOIN [dbo].[C_Object_Type] [o] ON [o].[Object_Type_Id] = [r].[Object_Type_Id]

Columns

#	Column	Data Type	Nullable	Source
1	Attribute_Type_Id	int	No	R_Object_Attribute.Attribute_Type_Id
2	Attribute_Type	nvarchar	No	C_Attribute_Type.Enum_Key
3	Object_Type_Id	int	No	R_Object_Attribute.Object_Type_Id
4	Object_Type	nvarchar	No	C_Object_Type.Enum_Key
5	Has_User_Autofill	bit	No	R_Object_Attribute.Has_User_Autofill
6	Is_Read_Only	bit	No	R_Object_Attribute.Is_Read_Only

graph LR
  n1541["Object_Type_Attribute_Type"]
  n1267["C_Object_Type"]
  n1274["C_Attribute_Type"]
  n1281["R_Object_Attribute"]
  n1267 --> n1541
  n1274 --> n1541
  n1281 --> n1541
  style n1541 fill:#00A081,stroke:#008068,color:#fff
  click n1541 href "/actual/objecttypeattributetype/"
  click n1267 href "/actual/cobjecttype/"
  click n1274 href "/actual/cattributetype/"
  click n1281 href "/actual/robjectattribute/"