Referencing tables: attachment_link | preparation_taxa | taxon_list |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| preparation_number | varchar | ||
| sample_number | varchar | ||
| sample | int | sample | |
| sample_palaeontology_id | int | ||
| analysis | int | analysis | |
| taxon | int | taxon | |
| agent | int | agent | |
| agent_txt | varchar | ||
| date_prepared | date | ||
| date_prepared_txt | varchar | ||
| identification_agent | int | agent | |
| identification_date | date | ||
| identification_remarks | varchar | ||
| location | varchar | ||
| storage | int | location | |
| remarks | text | ||
| owner | int | agent | |
| public | tinyint | ||
| is_private | tinyint | ||
| id | int(auto increment) | ||
| database | int | database | |
| timestamp | datetime | ||
| attachments | int | attachment |