Contents: lokaliteedi illustratsioonide info
Description: tabelis talletatakse konkreetsele lokaliteedi fotode ja joonistega kaasnev lisainfo, vaated, fotografeerimise aeg jne.
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 | ||
| locality | int | lokaliteedi kood | locality |
| attachment | int | attachment | |
| sort | int | ||
| title | varchar | ||
| title_en | varchar | ||
| remarks | varchar | illustratsiooniga seonduv lisainfo | |
| is_private | tinyint | ||
| id | int(auto increment) | Automatically generated unique sequential primary key (record ID) |