SAMPLE_SERIES
Contents: prooviseeria
Description: Tabel SAMPLE_SERIES sisaldab andmeid prooviseeriate st. teatud ühiseid tunnuseid omavate proovide hulkade kohta. Lihtsustab hiljem proovide sisestamist, sest iga proovi puhul tuleb siis sisestada ainult sügavused ja stratigraafia. Samuti kaob siis vajadus teatud seeriat puudutvat infot (näit. null-tase) pidevalt korrata.
Referencing tables: attachment_link | sample | sample_series_reference |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| name | varchar | seeria nimi | |
| sampling_purpose | varchar | proovimise eesmärk | |
| sample_count | int | proovide arv | |
| 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_top | int | stratigraphy | |
| stratigraphy_top_free | varchar | ||
| stratigraphy_base | int | stratigraphy | |
| stratigraphy_base_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) | ||
| timestamp | datetime | ||
| attachments | int | attachment |
