Warning:
JavaScript is turned OFF. None of the links on this page will work until it is reactivated.
If you need help turning JavaScript On, click here.
The Concept Map you are trying to access has information related to:
sample tracking, tbl_sampling_event: sampling_event_ID (PK1=code&date&time) station_code date time sampling_event_comment notes all pink tables have a 1-to-1 relationship with tbl_sampling_event (i.e. they only happen once per sampling event, but not every sampling event), tbl_pCO2: sampling_event_ID (FK1) pCO2_ID (PK) analysis_status current_sample_location headspace_sampling_notes who_collected_sample sample_type_(AIR/WATER) headspace_equilibrium_method syringe_or_vial_number folder_name pCO2_file_name analysis_date analysis_time analyst_initials file_type vial_preflushed_with_NO2_(Y/N) CO2_standard_concentration_(ppm) flow_rate_(mL/min) volume_recovered_from_vial_(mL) vial_filling_method_used baseline_(ppm) peak_height_1_(ppm) peak_height_2_(ppm) peak_height_3_(ppm) peak_height_4_(ppm) peak_height_5_(ppm) estimated_pCO2_(ppm) estimate_corrected_for_vial_residual_(Y/N) pCO2_comments_1 pCO2_comments_2 1 to 1 tbl_syringe_DIC_data: pCO2_ID (PK; FK) syringe_DIC_ID DIC_file_name analysis_time bicarbonate_standard_concentration_(mM) flow_rate_(mL/min) baseline_(ppm_CO2) peak_height_1_(ppm_CO2) peak_height_2_(ppm_CO2) peak_height_3_(ppm_CO2) peak_height_4_(ppm_CO2) peak_height_5_(ppm_CO2) syringe_DIC_comment, tbl_CPOM/CSS1: sampling_event_ID (FK1; PK) CPOM_sample_ID (autonumber for lab analyses) analysis_status analysis_location analysis_date current_sample_location del_C13 del_N15 %C %N C/N CPOM_comment 1 to 1 tbl_CPOM_C14_data: sampling_event_ID (FK; PK) analysis_location CAMS_or_AA_number analysis_date del_C13 fraction_modern fraction_modern_error cap_del_C14 cap_del_C14_error C14_age CPOM_C14_comment, tlkp_analysis_location: analysis_location 1 to many tlkp_analysis_location_limits: parameter&location (PK) analytical_parameter analysis_location (FK) equipment_model detection_limit_upper detection_limit_lower precision error, tbl_FSS_grab: sampling_event_ID (FK1; PK) FSS_concentration_mean_(mg/L) FSS_concentration_stdev_(mg/L) XPS_analysis_status XPS_analysis_location XPS_analysis_date DRIFT_analysis_status DRIFT_analysis_location DRIFT_analysis_date other drift parameters FSS_grab_comment 1 to 1 tbl_FSS_OSCA_analysis: FSS_grab_sample_ID (FK; PK) analysis_status analysis_location analysis_date other osca parameters OSCA_comment, tbl_FPOM_filter: sampling_event_ID (FK1) FPOM_sample_ID (PK) relict_sample_number sample_replicate analysis_status current_sample_location analysis_location analysis_date water_volume_(mL) sediment_weight_(g) filter_preweight_(g) filter_postweight_(g) concentration_(mg/L) alternate_filter_number FPOM_comment del_N15_mean del_C13_mean %C_mean %N_mean C/N_mean analysis_priority_for_C14 1 to 1 tbl_FPOM_C-14: FPOM_sample_ID (FK; PK) analysis_location CAMS_or_AA_number analysis_date del_C13 fraction_modern fraction_modern_error cap_del_C14 cap_del_C14_error C14_age FPOM_C14_comment, tbl_FPOM_grab: sampling_event_ID (FK1; PK) particulate_C_(mg/g) particulate_N_(mg/g) particulate_P_(mg/g) FPOM_grab_comment 1 to many tbl_FPOM_filter: sampling_event_ID (FK1) FPOM_sample_ID (PK) relict_sample_number sample_replicate analysis_status current_sample_location analysis_location analysis_date water_volume_(mL) sediment_weight_(g) filter_preweight_(g) filter_postweight_(g) concentration_(mg/L) alternate_filter_number FPOM_comment del_N15_mean del_C13_mean %C_mean %N_mean C/N_mean analysis_priority_for_C14, tbl_pCO2: sampling_event_ID (FK1) pCO2_ID (PK) analysis_status current_sample_location headspace_sampling_notes who_collected_sample sample_type_(AIR/WATER) headspace_equilibrium_method syringe_or_vial_number folder_name pCO2_file_name analysis_date analysis_time analyst_initials file_type vial_preflushed_with_NO2_(Y/N) CO2_standard_concentration_(ppm) flow_rate_(mL/min) volume_recovered_from_vial_(mL) vial_filling_method_used baseline_(ppm) peak_height_1_(ppm) peak_height_2_(ppm) peak_height_3_(ppm) peak_height_4_(ppm) peak_height_5_(ppm) estimated_pCO2_(ppm) estimate_corrected_for_vial_residual_(Y/N) pCO2_comments_1 pCO2_comments_2 1 to 1 tbl_chamber_info: pCO2_ID (PK; FK) sampler_initials boat_speed_(m/s) chamber_data_file_name fan_speed_numerical time_initial_(hh:mm:ss) CO2_in_chamber_initial_(hh:mm:ss) time_final_(hh:mm:ss) CO2_in_chamber_final_(hh:mm:ss) external_chamber_temp_initial_(C) external_chamber_temp_final_(C) internal_chamber_temp_initial_(C) internal_chamber_temp_final_(C) water_temp_(C) chamber_height_(cm) elevation_(m_asl) chamber_comment, tbl_sampling_event: sampling_event_ID (PK1=code&date&time) station_code date time sampling_event_comment notes all blue tables are child tables of tbl_sampling_event (1 to many relationship), tlkp_station_information: station_code (PK) station_name other_names region river_basin site_details environment_type river_name major_river_basin country coordinate_system UTM_X UTM_Y latitude longitude elevation_(m_asl) 1 to many tbl_sampling_event: sampling_event_ID (PK1=code&date&time) station_code date time sampling_event_comment