Referencing tables: analysis | attachment_link | drillcore | drillcore_box | image | imageset | preparation | sample | sample_palaeontology | specimen | specimen_location |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| location | varchar | ||
| location_new | varchar | ||
| location_old | varchar | ||
| location_location | varchar | ||
| parent_location | int | location | |
| contents | text | ||
| agent | int | agent | |
| date_collected_free | varchar | ||
| stratigraphy_free | varchar | ||
| number_items | int | ||
| number_items_registered | int | ||
| selected | tinyint | ||
| remarks | text | ||
| database | int | database | |
| id | int(auto increment) | ||
| timestamp | datetime | ||
| attachments | int | attachment |