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 Contents table

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



The Collection Contents table defines which defined meaning (or concept) is a member of which collection. Collections are defined in the Collection table.

+------------------------+--------------+------+-----+---------+-------+
| Field                  | Type         | Null | Key | Default | Extra |
+------------------------+--------------+------+-----+---------+-------+
| object_id              | int(11)      | YES  |     | NULL    |       | 
| collection_id          | int(10)      | NO   | MUL | 0       |       | 
| member_mid             | int(10)      | NO   | MUL | 0       |       | 
| internal_member_id     | varchar(255) | YES  |     | NULL    |       | 
| applicable_language_id | int(10)      | YES  |     | NULL    |       | 
| add_transaction_id     | int(11)      | NO   | MUL | NULL    |       | 
| remove_transaction_id  | int(11)      | YES  | MUL | NULL    |       | 
+------------------------+--------------+------+-----+---------+-------+

Fields[edit]

object_id 
An id that identifies this entry in the table. See Help:Objects table
collection_id 
The collection ID as defined in the Collection table
member_mid 
A link to a defined_meaning_id in the Defined Meaning table that identifies the member of the collection (e.g. "animal" is a member of the collection "Community Database Class")
internal_member_id 
A further string that can be used to identify the member inside the collection. It is used for example for the collection "ISO 639-3", where the internal_member_id is set to the actual ISO code.
applicable_language_id 
 ?? not used, I don't know what it is for. to remove?
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.