Referencing tables: None
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| specimen | int | specimen | |
| current | tinyint | ||
| class_field | varchar | ||
| class_id | int | ||
| species_id | int | ||
| taxon | int | taxon | |
| taxon_id_old | int | ||
| name | varchar | ||
| agent | int | agent | |
| date_identified | date | ||
| date_identified_free | varchar | ||
| reference | int | reference | |
| type | int | list_identification_type | |
| identification_type | int | list_identification_type | |
| remarks | text | ||
| id | int(auto increment) | ||
| timestamp | datetime |