DRILLCORE_IMAGE
Contents: drill core illustration information
Description: table contains additional information of photos and figures of specific drill core, views, time of photo taken etc.
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_box | int | drillcore_box | |
| drillcore | int | lokaliteedi kood | drillcore |
| drillcore_box_number | varchar | kasti number | |
| image | varchar | faili nimi | |
| source | varchar | ||
| type | int | illustratsiooni tüüp (pilt skaneeritud, digipilt, ...) | |
| agent | int | illustratsiooni autori kood | agent |
| image_date | date | ||
| view | varchar | vaate kirjeldus kasutatakse juhul kui tegemist on lähivaatega st. mitte tavalise üldvaatega | |
| camera | varchar | ||
| location | varchar | originaali (negatiivi jms) asukoht | |
| remarks | text | lisainfo vabas vormis | |
| is_preferred | int | ||
| public | int | ||
| is_private | int | ||
| database | int | database | |
| uuid | varchar | ||
| uuid_filename | varchar | ||
| timestamp | datetime | ajatempel, mis kajastab samuti andmete viimast muutmist, sisestab andmebaasimootor |
