Help:Objects table

↑ 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

• a defined_meaning_id in the Defined Meaning table
• a expression_id in the Expression table
• ... (See below).

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

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

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                | 
+----------------------------------------+