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:Class Attributes table

From OmegaWiki
Jump to: navigation, search
Help:Index Database layout Class Attributes table



The Class Attributes table defines class attributes... In the OmegaWiki user interface, class attributes are called "annotations". To understand what are classes and class attributes, have a look at Help:Class.

+-----------------------+---------+------+-----+---------+-------+
| Field                 | Type    | Null | Key | Default | Extra |
+-----------------------+---------+------+-----+---------+-------+
| object_id             | int(11) | NO   |     | NULL    |       | 
| class_mid             | int(11) | NO   |     | 0       |       | 
| level_mid             | int(11) | NO   |     | NULL    |       | 
| attribute_mid         | int(11) | NO   |     | 0       |       | 
| attribute_type        | char(4) | NO   |     | TEXT    |       | 
| add_transaction_id    | int(11) | NO   | MUL | NULL    |       | 
| remove_transaction_id | int(11) | YES  | MUL | NULL    |       | 
+-----------------------+---------+------+-----+---------+-------+

Fields[edit]

object_id 
An id that identifies the current attribute.
class_mid 
A link to a defined_meaning_id in the Defined Meaning table that identifies the class (and further gives link to its name).
level_mid 
A link to a defined_meaning_id in the Defined Meaning table that identifies the level on which the attribute applies (e.g. 401995 for Syntrans).
attribute_mid 
A link to a defined_meaning_id in the Defined Meaning table that identifies the attribute that is being defined (and its name, etc.).
attribute_type 
The type of the attribute. See below.
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.

Types of attributes[edit]

select distinct attribute_type from uw_class_attributes limit 10 ;

+----------------+
| attribute_type |
+----------------+
| TEXT           | 
| OPTN           | 
| DM             | 
| URL            | 
| TRNS           | 
+----------------+