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
↑ 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.