tbl_environmental

1615 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
site_code varchar 200 √ null
sample_number int4 10 √ null
tbl_monolith.sample_number tbl_monolith_sample_number_fkeyC
context_number int4 10 √ null
feature_type varchar 50 √ null
period varchar 50 √ null
sample_type varchar 50 √ null
volume_processed_litres int4 10 √ null
whole_of_deposit bool 1 √ null
sample_in_lancaster bool 1 √ null
bulk_charred_remains bool 1 √ null
assessed_for_cpr bool 1 √ null
bulk_waterlogged_remains bool 1 √ null
bulk_cremated_bone bool 1 √ null
bulk_bone_or_artefacts bool 1 √ null
monolith_pollen bool 1 √ null
monolith_soil_micromorphology bool 1 √ null
series_snails bool 1 √ null
series_waterlogged bool 1 √ null
other_dating_chemical_geotechnical bool 1 √ null
comments varchar 250 √ null
flot_size_ml varchar 50 √ null
charred_cereal int4 10 √ null
charred_chaff int4 10 √ null
charred_weed_seeds int4 10 √ null
charcoal_comments varchar 100 √ null
wpr int4 10 √ null
potential_cpr varchar 50 √ null
potential_wpr_comments varchar 50 √ null
potential_charcoal varchar 50 √ null
enviro_id serial 10 √ nextval('tbl_environmental_enviro_id_seq'::regclass)
tbl_charcoal_b.enviro_id tbl_charcoal_b_enviro_id_fkeyC
tbl_cpr_b.enviro_id tbl_cpr_b_enviro_id_fkeyC
tbl_cpr_matrix.enviro_id tbl_cpr_matrix_enviro_id_fkeyC
tbl_wpr_matrix_b.enviro_id tbl_wpr_matrix_b_enviro_id_fkeyC
tbl_wpr_species_b.enviro_id tbl_wpr_species_b_enviro_id_fkeyC
pollen_recovery varchar 2147483647 √ null
cpr_present bool 1 √ null
otherremains_present bool 1 √ null
overview_notes text 2147483647 √ null
potential_pollen varchar 2147483647 √ null
cpr_contam int4 10 √ null
sample_volume_notes varchar 2147483647 √ null
potential_wpr numeric 2,1 √ null
sample_volume_litres int4 10 √ null
cut_number int4 10 √ null
group_no int4 10 √ null
charred_other int4 10 √ null
charcoal_greater2mm int4 10 √ null
charcoal_less2mm int4 10 √ null
date_transported date 13 √ null
wpr_analysis bool 1 √ false
charcoal_analysis bool 1 √ false
cpr_analysis bool 1 √ false
analyised_2mm_proc numeric 6,2 √ null
analyised_4mm_proc numeric 6,2 √ null
wpr_vol_proc_analysis_liters numeric 5,2 √ null
monolith_analysis bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
pkey_environmental Primary key Asc enviro_id
tbl_environmental_sample_number_key Must be unique Asc sample_number

Relationships

Close relationships within degrees of separation