sign_interpretation_commentary

0 rows


Description

This table allows editors to attach commentary to a specific attribute of a sign interpretation.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
sign_interpretation_commentary_id INT UNSIGNED 10 null
sign_interpretation_commentary_owner.sign_interpretation_commentary_id fk_sign_interpretation_commentary_onwer_to_sccR
sign_interpretation_id INT UNSIGNED 10 null
sign_interpretation.sign_interpretation_id fk_sign_interpretation_commentary_to_sign_charR

Id of the sign interpretation being commented on.

attribute_id INT UNSIGNED 10 NULL
attribute.attribute_id fk_sign_interpretation_commentary_to_attributeR

Id of the attrivute describing the aspect of this sign interpretation being commented on.

commentary LONGTEXT 2147483647 NULL

Editorial comments.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc sign_interpretation_commentary_id
fk_sic_to_attribute_idx Performance Asc attribute_id
sign_interpretation_id Performance Asc sign_interpretation_id

Relationships