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

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



The Collection table defines which defined meaning (or concept) is a collection.

+-----------------------+------------------+------+-----+---------+-------+
| Field                 | Type             | Null | Key | Default | Extra |
+-----------------------+------------------+------+-----+---------+-------+
| collection_id         | int(10) unsigned | NO   |     | NULL    |       |                                              
| collection_mid        | int(10)          | NO   |     | 0       |       |                                              
| collection_type       | char(4)          | YES  |     | NULL    |       |                                              
| add_transaction_id    | int(11)          | NO   | MUL | NULL    |       |                                              
| remove_transaction_id | int(11)          | YES  | MUL | NULL    |       | 
+-----------------------+------------------+------+-----+---------+-------+

Fields[edit]

collection_id 
An id that identifies this entry in the table. It is used in the Collection Contents table
collection_mid 
A link to a defined_meaning_id in the Defined Meaning table that identifies the collection (e.g. 725301 for the collection DefinedMeaning:Community_Database_class_(725301)).
collection_type 
A string given to the collection, if it has a particular use for the OmegaWiki software. The values (RELT, LEVL, CLAS and MAPP) are found in the database, but I am not sure if it is used. The value call also be null.
CLAS - Any DM that is added to a collection of type "CLAS" becomes a class.
LANG - For languages. Languages should be added to a collection of type "LANG" if you want to be able to define language-specific annotations.
add_transaction_id 
Indicates when and by whom the collection was added. See Transactions table.
remove_transaction_id 
Indicates when and by whom the collection was removed. NULL if the syntrans is still valid.