CLASSIFICATION
Referencing tables: collection | specimen |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| class_field | varchar | ||
| class_en | varchar | ||
| class_lat | varchar | ||
| class_synonym | varchar | ||
| class_en_synonym | varchar | ||
| author | varchar | ||
| year | int | ||
| primary_fossil_group | int | ||
| stratigraphy_base | int | stratigraphy | |
| stratigraphy_top | int | stratigraphy | |
| hierarchy_string | varchar | ||
| parent | int | classification | |
| rank | int | list_classification_rank | |
| sort | int | ||
| node_editor | varchar | ||
| remarks | text | ||
| approved | int | ||
| id | int(auto increment) | ||
| timestamp | datetime |
