SAMPLE_SERIES
Referencing tables: agent | attachment | attachment_link | database | locality | sample | sample_series_reference | stratigraphy |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| name | varchar | ||
| sampling_purpose | varchar | ||
| sample_count | int | ||
| sample_numbers | varchar | ||
| number_prefix | varchar | ||
| number_start | int | ||
| locality | int | locality | |
| locality_free | varchar | ||
| zero_level | varchar | ||
| depth_top | double | ||
| depth_base | double | ||
| stratigraphy_base | int | stratigraphy | |
| stratigraphy_top | int | stratigraphy | |
| stratigraphy_base_free | varchar | ||
| stratigraphy_top_free | varchar | ||
| agent_collected | int | agent | |
| date_collected | date | ||
| date_collected_free | varchar | ||
| location | varchar | ||
| remarks | text | ||
| owner | int | agent | |
| public | tinyint | ||
| is_private | tinyint | ||
| database | int | database | |
| id | int(auto increment) | ||
| attachments | int | attachment |
