DRILLCORE_BOX
Contents: detailed information of drill core by boxes
Referencing tables: attachment | attachment_link | drillcore_image |
| 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 | ||
| id | int(auto increment) | Automatically generated unique sequential primary key (record ID) | |
| drillcore | int | FK drillcore(id) | drillcore |
| number | varchar | ||
| number_meters | int | ||
| diameter | int | ||
| depth_start | double | ||
| depth_end | double | ||
| depth_other | varchar | referentssügavus näit. birka, proovi jms tase, kasut. juhul kui dep ja dep1 puuduvad | |
| stratigraphy_base | int | stratigraphy | |
| stratigraphy_base_free | varchar | ||
| stratigraphy_top | int | stratigraphy | |
| stratigraphy_top_free | varchar | ||
| stratigraphy_free | varchar | stratigraafilised piirid mis jäävad kasti piiridesse mitte seotud tabeliga STRAT | |
| location | int | südamiku asukoha kood säilituskohas enamasti hoidla (näit. h6a) | location |
| storage | int | location | |
| sort | int | ||
| remarks | text | lisainfo vabas vormis | |
| database | int | database | |
| timestamp | datetime | ajatempel, mis kajastab samuti andmete viimast muutmist, sisestab andmebaasimootor | |
| attachments | int | attachment |
