site_location_visit


Columns

Column Type Size Nulls Auto Default Children Parents Comments
site_location_visit_id serial 10 √ nextval('site_location_visit_site_location_visit_id_seq'::regclass)
basal_area.site_location_visit_id site_location_visit_basal_area_fk R
genetic_vouchers.site_location_visit_id site_location_visit_genetic_vouchers_fk R
lai.site_location_visit_id site_location_visit_lai_fk R
photopoints.site_location_visit_id site_location_visit_photopoints_fk R
point_intercept.site_location_visit_id site_location_visit_point_intercept_fk R
soil_bulk_density.site_location_visit_id site_location_visit_soil_bulk_density_fk R
soil_characterisation.site_location_visit_id site_location_visit_soil_characterisation_fk R
soil_subsite_observations.site_location_visit_id site_location_visit_soil_subsite_observations_fk R
structural_summary.site_location_visit_id site_location_visit_structural_summary_fk R
veg_vouchers.site_location_visit_id site_location_visit_veg_vouchers_fk R
visit_surface_coarse_frags_abundance.site_location_visit_id site_location_visit_visit_surface_coarse_frags_abundance_fk R
visit_surface_coarse_frags_lithology.site_location_visit_id site_location_visit_visit_surface_coarse_frags_lithology_fk R
visit_surface_coarse_frags_size.site_location_visit_id site_location_visit_visit_surface_coarse_frags_size_fk R
visit_surface_coarse_frags_type.site_location_visit_id site_location_visit_visit_surface_coarse_frags_shape_fk R
visit_surface_soil_conditions.site_location_visit_id site_location_visit_visit_surface_soil_conditions_fk R
site_location_id int4 10 null
site_location.site_location_id site_location_site_location_visit_fk R
visit_start_date timestamp 29,6 √ null
visit_end_date timestamp 29,6 √ null
photopoints_exists bool 1 √ false
leaf_area_index_exists bool 1 √ false
basal_wedge_has_been_collected bool 1 √ false
visit_notes text 2147483647 √ null
location_description text 2147483647 √ null
erosion_type text 2147483647 √ 'NC'::text
lut_erosion_type.id lut_erosiontype_site_location_visit_fk R
erosion_abundance text 2147483647 √ 'NC'::text
lut_erosion_abund.id lut_erosionabund_site_location_visit_fk R
erosion_state text 2147483647 √ 'NC'::text
lut_erosion_state.id lut_erosionstate_site_location_visit_fk R
microrelief text 2147483647 √ 'NC'::text
lut_microrelief.id lut_microrelief_site_location_visit_fk R
drainage_type int4 10 √ 7
lut_drainage.id lut_drainage_site_location_visit_fk R
disturbance text 2147483647 √ 'NC'::text
lut_disturbance.id lut_disturbance_site_location_visit_fk R
climatic_condition text 2147483647 √ null
vegetation_condition text 2147483647 √ null
observer_veg int4 10 √ 13
lut_observer.id lut_observer_site_location_visit_fk R
observer_soil int4 10 √ 13
lut_observer.id lut_observer_site_location_visit_fk1 R
described_by int4 10 √ 13
lut_observer.id lut_observer_site_location_visit_fk2 R
a_s_c text 2147483647 √ null
pit_marker_easting float8 17,17 √ null
pit_marker_northing float8 17,17 √ null
pit_marker_mga_zones int4 10 √ null
pit_marker_datum text 2147483647 √ null
lut_datum.datum Implied Constraint R
pit_marker_location_method text 2147483647 √ null
soil_observation_type text 2147483647 √ 'P'::text
lut_soil_obs_type.id lut_soilobstype_site_location_visit_fk R
ok_to_publish bool 1 false
sample_location_comment varchar 2147483647 √ null
site_visit_photo_name varchar 2147483647 √ null
distance_to_nearest_community int4 10 √ null
distance_to_nearest_infrastructure int4 10 √ null
comment_on_distance_to_community varchar 2147483647 √ null
comment_on_distance_to_infrastructure varchar 2147483647 √ null

Table contained 631 rows

Indexes

Constraint Name Type Sort Column(s)
site_location_visit_pkey Primary key Asc site_location_visit_id

Relationships

Close relationships within degrees of separation