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

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



The Url Attribute Values table gives the values of the url 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    |       | 
| url                   | varchar(255) | YES  |     | NULL    |       | 
| label                 | varchar(255) | 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. "link to Wikipedia").
url 
the url given as a string.
label 
what will be displayed in the interface. Basically, <a href="$url">$label</a>
add_transaction_id 
Indicates when and by whom the annotation was added. See Transactions table.
remove_transaction_id 
Indicates when and by whom the annotation was removed. NULL if still valid.