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:Option Attribute Options table

From OmegaWiki
Jump to: navigation, search
Help:Index Database layout Option Attribute Options table



The Option Attribute Options table gives the list of possible values that an option attribute can take. Option attributes are defined in the Class Attributes table. The selected values from the list are then defined in the Option Attribute Values table.

+-----------------------+---------+------+-----+---------+-------+
| Field                 | Type    | Null | Key | Default | Extra |
+-----------------------+---------+------+-----+---------+-------+
| option_id             | int(11) | NO   |     | 0       |       | 
| attribute_id          | int(11) | NO   |     | 0       |       | 
| option_mid            | int(11) | NO   |     | 0       |       | 
| language_id           | int(11) | NO   |     | 0       |       | 
| add_transaction_id    | int(11) | NO   | MUL | 0       |       | 
| remove_transaction_id | int(11) | YES  | MUL | NULL    |       | 
+-----------------------+---------+------+-----+---------+-------+

Fields[edit]

option_id 
An id that identifies the current table entry.
attribute_id 
a link to an object_id in the Class Attributes table, i.e. which attribute is being used (e.g. "part of speech").
option_mid 
a link to an defined_meaning_id in the Defined Meaning table that identifies a possible value for that option (e.g. "noun", "adjective", etc.)
language_id 
if not 0, it is a restriction that a given option in the list is valid only for a given language (e.g. "classifiers" as part of speech exist in Chinese, but not in many other languages). there is a better way to implement this, and we will get rid of that field eventually.. For the given language_id, the corresponding language name can be found in the Language table (iso codes) and the Language Names table (names).
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.