LOCALITY_REFERENCE
Contents: references to localities
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 | Timestamp of last change | |
| locality | int | lokaliteedi kood | locality |
| site | int | site | |
| area | int | area | |
| reference | int | viite kood | reference |
| type | int | publikatsioonis lokaliteeti puudutava info tüüp valik: detailkirjeldus / läbilõige, üldkirjeldus / läbilõige, .. | list_locality_reference_type |
| pages | varchar | leheküljed kus lokaliteeti mainitud | |
| figures | varchar | joonised kus lokaliteet kujutatud (foto, profiil jm.) | |
| remarks | text | lisainfo lokaliteedi kohta | |
| id | int(auto increment) | Automatically generated unique sequential primary key (record ID) | |
| timestamp | datetime | ajatempel, mis kajastab samuti andmete viimast muutmist, sisestab andmebaasimootor |
