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:Translated Content Attribute Values table

From OmegaWiki
Jump to: navigation, search
Help:Index Database layout Translated Content Attribute Values table



The Url Attribute Values table gives the values of the translated content attributes defined in the Class Attributes table.

+-----------------------+---------+------+-----+---------+-------+
| Field                 | Type    | Null | Key | Default | Extra |
+-----------------------+---------+------+-----+---------+-------+
| value_id              | int(11) | NO   |     | 0       |       | 
| object_id             | int(11) | NO   |     | NULL    |       | 
| attribute_mid         | int(11) | NO   |     | 0       |       | 
| value_tcid            | int(11) | NO   |     | 0       |       | 
| 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. "etymology").
value_tcid 
a link to a multilingual text, i.e. a translated_content_id in the Translated Content table.
add_transaction_id 
Indicates when and by who the annotation was added. See Transactions table.
remove_transaction_id 
Indicates when and by who the annotation was removed. NULL if still valid.