COLLECTION
Referencing tables: attachment_link | specimen |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| acronym | varchar | ||
| number | varchar | ||
| collection_id | |||
| collection_number | varchar | ||
| name | varchar | ||
| name_long | varchar | ||
| name_en | varchar | ||
| name_long_en | varchar | ||
| type | int | list_collection_type | |
| classification | int | classification | |
| agent | int | agent | |
| locality | int | locality | |
| stratigraphy | int | stratigraphy | |
| number_objects | int | ||
| number_types | int | ||
| reference | int | reference | |
| remarks | text | ||
| publication_exists | int | ||
| is_private | tinyint | ||
| uid | int | ||
| gid | int | ||
| permissions | int | ||
| database | int | database | |
| id_tug | int | ||
| id_elm | int | ||
| timestamp | datetime | ||
| id | int(auto increment) | ||
| attachments | int | attachment |
