Help:Collection Contents table

↑ 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

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.