SITE
Referencing tables: attachment_link | dataset_geolocation | doi_geolocation | locality_description | locality_reference | project_site | sample |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| project | int | project | |
| locality | int | locality | |
| area | int | area | |
| site_type | int | site_type | |
| name | varchar | ||
| name_en | varchar | ||
| number | varchar | ||
| latitude | double | ||
| longitude | double | ||
| location_accuracy | double | ||
| elevation | double | ||
| elevation_accuracy | double | ||
| coord_det_precision | int | list_coordinate_precision | |
| coord_det_method | int | list_coordinate_method | |
| coord_det_agent | int | agent | |
| epsg | int | ||
| coordx | int | ||
| coordy | int | ||
| extent | int | ||
| depth | double | ||
| date_start | datetime | ||
| date_end | datetime | ||
| date_free | varchar | ||
| remarks_location | varchar | ||
| description | text | ||
| remarks | text | ||
| is_private | tinyint | ||
| database | int | database | |
| id | int(auto increment) | ||
| timestamp | datetime | ||
| attachments | int | attachment |
