attribute

9 rows


Description

This table stores attributes that can be used to describe a sign_interpretation. They are used in conjunction with a string value in the attribute_value, and any related numeric value can be added in the numeric_value column of the sign_interpretation_attribute table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
attribute_id INT UNSIGNED 10 √ null
attribute_owner.attribute_id fk_attribute_owner_to_attributeR
attribute_value.attribute_id fk_att_val_to_attR
sign_interpretation_commentary.attribute_id fk_sign_interpretation_commentary_to_attributeR
name VARCHAR 255 √ NULL

Designation of the attribute.
description VARCHAR 1000 √ NULL

A concise description of the nature of the attribute.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc attribute_id
attribute_name_index Must be unique Asc name

Relationships

Close relationships within degrees of separation