SOIL_SITE
Referencing tables: sample | soil_horizon |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| site | varchar | ||
| site_en | varchar | ||
| number | varchar | ||
| code | varchar | ||
| type | int | ||
| parent_id | int | ||
| coord_system | varchar | ||
| coordx | int | ||
| coordy | int | ||
| latitude | double | ||
| longitude | double | ||
| elevation | double | ||
| coord_det_precision | int | list_coordinate_precision | |
| coord_det_method | int | list_coordinate_method | |
| coord_det_agent | int | agent | |
| extent | int | ||
| depth | double | ||
| transect | varchar | ||
| transect_point | int | ||
| remarks_location | varchar | ||
| is_deep | tinyint | ||
| date | date | ||
| date_free | varchar | ||
| area_name | varchar | ||
| land_use | varchar | ||
| agro_group | varchar | ||
| soil | varchar | ||
| k_aste_a | varchar | ||
| k_aste_b | varchar | ||
| k_size_a | varchar | ||
| k_size_b | varchar | ||
| description_link | varchar | ||
| remarks | text | ||
| id | int(auto increment) | ||
| timestamp | datetime |
