DATABASE SCHEMA

Explore data model:

SOIL_SITE

Referencing tables: sample | soil_horizon |


Field Database column Data type Description Referenced table
agro_group agro_group varchar
area_name area_name varchar
coord_det_agent coord_det_agent int agent
coord_det_method coord_det_method int list_coordinate_method
coord_det_precision coord_det_precision int list_coordinate_precision
coord_system coord_system varchar
coordx x int
coordy y int
date date date
date_added date_added datetime
date_changed date_changed datetime
date_free date_free varchar
depth depth double
description_link description_link varchar
elevation elevation double
id id int(auto increment)
k_aste_a k_aste_a varchar
k_aste_b k_aste_b varchar
k_size_a k_size_a varchar
k_size_b k_size_b varchar
land_use land_use varchar
latitude latitude double
longitude longitude double
remarks remarks text
remarks_location remarks_location text
site site varchar
site_en site_en varchar
soil soil varchar
user_added user_added varchar
user_changed user_changed varchar