C_Attribute_Type

This table defines all attribute types - each object type has attributes types that describe objects of that type using those attributes, and all of these attributes can be used in configuration assigned to the specific object type. Creator_Id tracks trought User_Id at APP_User who created the attribute type for users to use. Default_Value provides an exact value that is inserted for the attribute when the object with this attribute is created.The table reffers trought identifiers Name_Key and Description_Key to the Key_Name at C_Translation_Key for name, and description key. State of the attribute is tracked through Object_State_Id -> State_Id in C_Object_State. The Enum_Key provides a unique identifier for each attribute type key that you can use to identify specific attributes within your configuration.

Columns

#	Column	Data Type	Nullable	PK	Identity	Computed	Collation
1	Attribute_Type_Id	int	No	Yes	Yes	No
2	Creator_Id	int	Yes	No	No	No
3	Name_Key	nvarchar	No	No	No	No	Czech_CI_AS
4	Description_Key	nvarchar	No	No	No	No	Czech_CI_AS
5	Default_Value	nvarchar	Yes	No	No	No	Czech_CI_AS
6	Enum_Key	nvarchar	No	No	No	No	Czech_CI_AS
7	Object_State_Id	int	No	No	No	No

Referenced By

Column	Referenced By
Attribute_Type_Id	MR_Attribute.Attribute_Type_Id
Attribute_Type_Id	R_Object_Attribute.Attribute_Type_Id

Is Data Source For

View	Columns
Attribute_Type	Attribute_Type_Id, Enum_Key, Default_Value
Object_Attribute	Enum_Key
Object_Type_Attribute_Type	Enum_Key

graph LR
  n1274["C_Attribute_Type"]
  n1533["Object_Attribute"]
  n1541["Object_Type_Attribute_Type"]
  n1553["Attribute_Type"]
  n1274 --> n1533
  n1274 --> n1541
  n1274 --> n1553
  style n1274 fill:#00A081,stroke:#008068,color:#fff
  click n1274 href "/actual/cattributetype/"
  click n1533 href "/actual/objectattribute/"
  click n1541 href "/actual/objecttypeattributetype/"
  click n1553 href "/actual/attributetype/"