DRILLCORE_STUDY
Contents: studies of drill core
Referencing tables: None
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | User who first saved record | |
| date_added | datetime | Timestamp when record was created | |
| user_changed | varchar | User who last saved record | |
| date_changed | datetime | ||
| drillcore | int | puursüdamiku kood | drillcore |
| depth_start | double | ||
| depth_end | double | ||
| stratigraphy_free | varchar | ||
| agent | int | uurija kood | agent |
| other_persons | varchar | töös osalenud teised uurijad | |
| date | date | puursüdamiku uurimise aeg | |
| observation | int | vaatamine (jah / ei) | |
| description | int | kirjeldamine (jah / ei) | |
| sampling | int | proovimine (jah / ei) | |
| number_samples | int | proovide arv | |
| photography | int | pildistamine (jah / ei) | |
| ordering | int | korrastamine (jah / ei) | |
| planned_analyses | varchar | ||
| aim | varchar | südamiku uurimise eesmärk artikkel, projekt, jne. | |
| remarks | text | lisainfo vabas vormis | |
| database | int | database | |
| id | int(auto increment) | Automatically generated unique sequential primary key (record ID) | |
| timestamp | datetime | ajatempel, mis kajastab samuti andmete viimast muutmist, sisestab andmebaasimootor |
