soil_characterisation


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('soil_characterisation_id_seq'::regclass)
characterisation_coarse_frags_abundance.soil_characterisation_id soil_characterisation_test_fk C
characterisation_coarse_frags_lithology.soil_characterisation_id soil_characterisation_characterisation_coarse_frags_litholog863 C
characterisation_coarse_frags_shape.soil_characterisation_id soil_characterisation_characterisation_coarse_frags_shape_fk C
characterisation_coarse_frags_size.soil_characterisation_id soil_characterisation_bob_fk C
site_location_visit_id int4 10 null
site_location_visit.site_location_visit_id site_location_visit_soil_characterisation_fk R
layer_barcode text 2147483647 √ null
upper_depth float8 17,17 √ null
lower_depth float8 17,17 √ null
horizon text 2147483647 √ null
texture_grade text 2147483647 √ null
lut_soil_tex_grade.code lut_soiltexgrade_soil_characterisation_fk R
texture_qualifier text 2147483647 √ null
lut_soil_tex_qual.id lut_soiltexqual_soil_characterisation_fk R
texture_modifier text 2147483647 √ null
lut_soil_tex_mod.id lut_soiltexmod_soil_characterisation_fk R
colour_when_moist text 2147483647 √ null
colour_when_dry text 2147483647 √ null
mottles_colour text 2147483647 null
mottles_abundance text 2147483647 null
lut_mottle_abund.id lut_mottleabund_soil_characterisation_fk R
mottles_size text 2147483647 null
lut_mottle_size.id lut_mottlesize_soil_characterisation_fk R
segregations_abundance text 2147483647 null
lut_seg_abundance.id lut_segabundance_soil_characterisation_fk R
segregations_size text 2147483647 null
lut_seg_size.id lut_segsize_soil_characterisation_fk R
segregations_nature text 2147483647 null
lut_seg_nature.id lut_segnature_soil_characterisation_fk R
segregations_form text 2147483647 null
lut_seg_form.id lut_segform_soil_characterisation_fk R
comments text 2147483647 √ null
collected_by int4 10 √ null
lut_observer.id lut_observer_soil_subsite_characterisation_fk1 R
smallest_size_1 text 2147483647 √ null
lut_structure_size.id lut_structure_size_soil_characterisation_smallest_1_fk R
smallest_size_2 text 2147483647 √ null
next_size_1 text 2147483647 √ null
next_size_2 text 2147483647 √ null
smallest_size_type_1 text 2147483647 null
lut_pedality_type.id lut_pedality_type_soil_characterisation_fk R
smallest_size_type_2 text 2147483647 √ null
lut_pedality_type.id lut_pedality_type_soil_characterisation_fk1 R
next_size_type_1 text 2147483647 null
lut_pedality_type.id lut_pedality_type_soil_characterisation_fk2 R
next_size_type_2 text 2147483647 √ null
lut_pedality_type.id lut_pedality_type_soil_characterisation_fk3 R
pedality_fabric text 2147483647 null
lut_pedality_fabric.id lut_pedalityfabric_soil_characterisation_fk R
pedality_grade text 2147483647 null
lut_pedality_grade.id lut_pedalitygrade_soil_characterisation_fk R
ph float8 17,17 √ null
ec float8 17,17 √ null
effervescence text 2147483647 null
lut_effervescence.id lut_effervscence_soil_characterisation_fk R

Table contained 2279 rows

Indexes

Constraint Name Type Sort Column(s)
soil_characterisation_pkey Primary key Asc id
soil_characterisation_id_key Must be unique Asc id

Relationships

Close relationships within degrees of separation