attribute_value

44 rows


Description

The specific string value associated with an attribute to describe some aspect of a sign_interpretation.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
attribute_value_id INT UNSIGNED 10 √ null
attribute_value_css.attribute_value_id fk_attribute_value_css_to_attribute_valueR
attribute_value_owner.attribute_value_id fk_attribute_value_owner_to_attribute_valueR
sign_interpretation_attribute.attribute_value_id fk_sign_interpretation_attr_to_attr_valueR
attribute_id INT UNSIGNED 10 null
attribute.attribute_id fk_att_val_to_attR

The id of the attribute to which a string value is to be assigned.
string_value VARCHAR 255 √ NULL

A unique string value that can be applied as an attribute to a sign interpretation.
description VARCHAR 1000 √ NULL

A concise description of the attribute value.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc attribute_value_id
fk_att_val_to_att_idx Performance Asc attribute_id
unique_attribute_and_value Must be unique Asc/Asc attribute_id + string_value

Relationships

Close relationships within degrees of separation