Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| sign_interpretation_attribute_id | INT UNSIGNED | 10 | √ | null |
|
|
||||
| sign_interpretation_id | INT UNSIGNED | 10 | null |
|
|
Id of the sign interpretation being descibed. |
||||
| attribute_value_id | INT UNSIGNED | 10 | null |
|
|
Id of the attribute to apply to this sign interpretation. |
||||
| sequence | TINYINT | 3 | √ | NULL |
|
|
Absolute ordering of this record. This is used to define the order of all records for the same sign_char_id. |
|||
| numeric_value | FLOAT | 12 | √ | NULL |
|
|
Contains the width of a character (normally 1), space (dto.), or vacat (normally > 1) or the level of probability. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | sign_interpretation_attribute_id |
| fk_sign_interpretation_attr_to_attr_value_idx | Performance | Asc | attribute_value_id |
| fk_sign_interpretation_attr_to_sign_interpretation_idx | Performance | Asc | sign_interpretation_id |
| unique_sign_interpretation_id_attribute_value_id_sequence | Must be unique | Asc/Asc/Asc | attribute_value_id + sequence + sign_interpretation_id |