soil_subsite_observations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('soil_subsite_observations_id_seq'::regclass)
site_location_visit_id int4 10 null
site_location_visit.site_location_visit_id site_location_visit_soil_subsite_observations_fk R
subsite_id text 2147483647 √ null
zone int4 10 √ null
easting int4 10 √ null
northing int4 10 √ null
zero_to_ten_barcode text 2147483647 √ null
ten_to_twenty_barcode text 2147483647 √ null
twenty_to_thirty_barcode text 2147483647 √ null
comments text 2147483647 √ null
metagenomics_are_available bool 1 null
metagenomic_barcode text 2147483647 √ null
metagenomic_url varchar 2147483647 √ null
photo_no text 2147483647 √ null
photo_url text 2147483647 √ null
observer int4 10 null
lut_observer.id lut_observer_soil_subsite_observations_fk1 R

Table contained 5345 rows

Indexes

Constraint Name Type Sort Column(s)
soil_subsite_observations_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation