Help:Option Attribute Values table

↑ Help:Index

Database layout

Option Attribute Values table

The Option Attribute Values table gives the values of the option attributes defined in the Class Attributes table, where the value is one from a list of possible values defined in the Option Attribute Options table.

+-----------------------+---------+------+-----+---------+-------+
| Field                 | Type    | Null | Key | Default | Extra |
+-----------------------+---------+------+-----+---------+-------+
| value_id              | int(11) | NO   |     | 0       |       | 
| object_id             | int(11) | NO   |     | 0       |       | 
| option_id             | int(11) | NO   |     | 0       |       | 
| add_transaction_id    | int(11) | NO   | MUL | 0       |       | 
| 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

option_id 

A link to an option_id from the Option Attribute Options table, which identifies both the attribute (e.g. "part of speech") and the selected value (e.g. "noun").

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.