As an anonymous user, you can only add new data. If you would like to also modify existing data, please create an account and indicate your languages on your user page.

Help:Text Attribute Values table

From OmegaWiki
Jump to: navigation, search
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[edit]

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.