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:Objects table

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



The Objects table contains unique identifiers that identify several types of objects. According to the value of table, the object_id can correspond to

It is particularly useful for relations to know which to types of objects are linked by the relation.

+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| object_id   | int(11)      | NO   | PRI | NULL    | auto_increment | 
| table       | varchar(100) | YES  | MUL | NULL    |                | 
| original_id | int(11)      | NO   | MUL | NULL    |                | 
| UUID        | varchar(36)  | YES  | MUL | NULL    |                | 
+-------------+--------------+------+-----+---------+----------------+

Fields[edit]

object_id 
An id that identifies the current object (primary key).
table 
the name of the table to which the object refers. See below.
original_id 
 ??
UUID 
another unique identifier...

Types of objects[edit]

select distinct uw_objects.table from uw_objects ;

+----------------------------------------+
| table                                  |
+----------------------------------------+
| translated_content                     | <= not used anymore
| uw_class_attributes                    | 
| uw_class_membership                    | 
| uw_collection                          | 
| uw_collection_ns                       | <= not used anymore
| uw_defined_meaning                     | 
| uw_expression                          | 
| uw_expression_ns                       | <= not used anymore 
| uw_meaning_relations                   | 
| uw_option_attribute_options            | 
| uw_option_attribute_values             | 
| uw_syntrans                            | 
| uw_text_attribute_values               | 
| uw_translated_content                  | 
| uw_translated_content_attribute_values | 
| uw_url_attribute_values                | 
+----------------------------------------+