Help:Text Attribute Values table

↑ Help:Index

Database layout

Text Attribute Values table

The Text Attribute Values table gives the values of the text attributes defined in the Class Attributes table.

+-----------------------+------------+------+-----+---------+-------+
| Field                 | Type       | Null | Key | Default | Extra |
+-----------------------+------------+------+-----+---------+-------+
| value_id              | int(11)    | NO   |     | NULL    |       | 
| object_id             | int(11)    | NO   |     | NULL    |       | 
| attribute_mid         | int(11)    | NO   |     | NULL    |       | 
| text                  | mediumblob | YES  |     | NULL    |       | 
| add_transaction_id    | int(11)    | NO   | MUL | NULL    |       | 
| remove_transaction_id | int(11)    | YES  | MUL | NULL    |       | 
+-----------------------+------------+------+-----+---------+-------+

Fields

value_id 

An id that identifies the current table entry.

object_id 

A link to an object to which the annotation is associated. Can be a syntrans_sid, defined_meaning_id, etc. Cf. Objects table

attribute_mid 

a link to an attribute_mid in the Class Attributes table, i.e. which attribute is being used (e.g. "IPA").

text 

the text itself

add_transaction_id 

Indicates when and by who the syntrans was added. See Transactions table.

remove_transaction_id 

Indicates when and by who the syntrans was removed. NULL if the syntrans is still valid.