DRILLCORE
Contents: drill cores
Referencing tables: attachment | attachment_link | drillcore_box | drillcore_image | drillcore_study |
| 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 | ||
| locality | int | locality | |
| drillcore | varchar | ||
| drillcore_en | varchar | ||
| year | varchar | puurimise aasta | |
| agent | int | puurimise eest vastutav isiku/asutuse kood | agent |
| depository | int | säilituskoht, kodeeritud valik: (Särghaua, Arbavere, ...) | list_drillcore_storage |
| location | int | südamiku asukoha kood säilituskohas enamasti hoidla (näit. h6a) | location |
| storage | int | location | |
| boxes | int | kastide arv | |
| box_numbers | varchar | kastide numbrid | |
| number_meters | int | meetrite arv kastis (keskmine), kasutada juhul kui kastid ühe kaupa arvele võtmata | |
| direction_lr | tinyint | ||
| depth | varchar | sügavuste intervallid | |
| igsn | varchar | ||
| remarks | text | lisainfo vabas vormis | |
| database | int | database | |
| uid | int | ||
| gid | int | ||
| is_private | tinyint | ||
| id | int(auto increment) | Automatically generated unique sequential primary key (record ID) | |
| timestamp | datetime | ajatempel, mis kajastab samuti andmete viimast muutmist, sisestab andmebaasimootor | |
| attachments | int | attachment |
