Help:Class Attributes table

↑ 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

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

select distinct attribute_type from uw_class_attributes limit 10 ;

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

• a "TEXT" attribute is a simple text (e.g. hyphenation, IPA).
  • They are defined in the Text Attribute Values table.
• a "OPTN" attribute is a list of predefined options (e.g. part of speeches).
  • The list of possible options for a given attribute are defined in the Option Attribute Options table
  • The list of options associated with another object will be found in the Option Attribute Values table
• a "DM" attribute is a relation to another DM (e.g. antonym, hyperonym).
  • They are defined in the Meaning Relations table.
• a "URL" attribute is a link to an external url (e.g. links to Wikipedia).
  • They are defined in the Url Attribute Values table
• a "TRNS" attribute is a multilingual text that can be translated in several languages (e.g. etymology can be described in several languages).
  • They are defined in the Translated Content Attribute Values table.