-- -- PostgreSQL database dump -- SET SESSION AUTHORIZATION 'postgres'; SET search_path = public, pg_catalog; -- -- TOC entry 177 (OID 4193362159) -- Name: plpgsql_call_handler(); Type: FUNC PROCEDURAL LANGUAGE; Schema: public; Owner: postgres -- CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler AS '$libdir/plpgsql', 'plpgsql_call_handler' LANGUAGE c; SET SESSION AUTHORIZATION DEFAULT; -- -- TOC entry 176 (OID 4193362160) -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: public; Owner: -- CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler; SET SESSION AUTHORIZATION 'postgres'; -- -- TOC entry 3 (OID 2200) -- Name: public; Type: ACL; Schema: -; Owner: postgres -- REVOKE ALL ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; SET check_function_bodies = false; -- -- TOC entry 178 (OID 45664962) -- Name: get_curr_date(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION get_curr_date() RETURNS timestamp without time zone AS ' DECLARE currDate TIMESTAMP; BEGIN SELECT CURRENT_TIMESTAMP into currDate; RETURN (currDate); END; ' LANGUAGE plpgsql; -- -- TOC entry 4 (OID 464267034) -- Name: test; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE test ( test_id integer NOT NULL ); -- -- TOC entry 5 (OID 464267038) -- Name: spatial_ref_method; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE spatial_ref_method ( spatial_ref_method_id bigint NOT NULL, spatial_ref_method_na character varying(200) NOT NULL, spatial_ref_method_tx character varying(2000) ); -- -- TOC entry 6 (OID 464267045) -- Name: pnt_vector_type; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE pnt_vector_type ( pnt_vector_type_id bigint NOT NULL, pnt_vector_type character varying(200) NOT NULL, pnt_vector_type_tx character varying(2000) ); -- -- TOC entry 7 (OID 464267052) -- Name: raster_object_type; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE raster_object_type ( raster_object_type_id bigint NOT NULL, raster_object_type character varying(200) NOT NULL, raster_object_type_tx character varying(2000) ); -- -- TOC entry 8 (OID 464267059) -- Name: platform_sensor_group_dtl; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE platform_sensor_group_dtl ( platform_sensor_group_dtl_id bigint NOT NULL, platform_id bigint NOT NULL, sensor_group_id bigint NOT NULL, begin_dt timestamp without time zone NOT NULL, end_dt timestamp without time zone ); -- -- TOC entry 9 (OID 464267063) -- Name: data_set; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE data_set ( data_set_id bigint NOT NULL, metadata_id bigint NOT NULL, data_set_na character varying(200) NOT NULL, data_set_tx character varying(2000), caveat_id bigint, data_set_quality_id bigint, data_set_format_category_id bigint, file_reference_uri_tx character varying(200), missing_value_tx character varying(20), first_row_nm bigint, data_set_field_separator_id bigint, other_field_separator_tx character varying(20), start_dt timestamp without time zone, end_dt timestamp without time zone ); -- -- TOC entry 10 (OID 464267070) -- Name: caveat; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE caveat ( caveat_id bigint NOT NULL, caveat_na character varying(100) NOT NULL ); -- -- TOC entry 11 (OID 464267074) -- Name: data_set_quality; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE data_set_quality ( data_set_quality_id bigint NOT NULL, data_set_quality_na character varying(100) NOT NULL ); -- -- TOC entry 12 (OID 464267078) -- Name: data_set_row; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE data_set_row ( data_set_row_id bigint NOT NULL, data_set_id bigint NOT NULL, x_coord double precision, y_coord double precision, real_row_nm bigint NOT NULL, row_dt date ); -- -- TOC entry 13 (OID 464267082) -- Name: sensor_variable_dtl; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE sensor_variable_dtl ( sensor_variable_dtl_id bigint NOT NULL, sensor_id bigint NOT NULL, dd_variable_id bigint NOT NULL, low_rng double precision, high_rng double precision, "precision" double precision, op_low_rng double precision, op_high_rng double precision, capacity double precision ); -- -- TOC entry 14 (OID 464267086) -- Name: platform; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE platform ( platform_id bigint NOT NULL, platform_na character varying(500) NOT NULL, platform_tx text, platform_location_id bigint, platform_type_id bigint, platform_ref_url character varying(2000) ); -- -- TOC entry 15 (OID 464267094) -- Name: platform_location; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE platform_location ( platform_location_id bigint NOT NULL, platform_location_na character varying(500) NOT NULL, longitude_coord numeric(18,9), latitude_coord numeric(18,9) ); -- -- TOC entry 16 (OID 464267099) -- Name: user_role; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE user_role ( user_role_id bigint NOT NULL, user_role_na character varying(50) ); -- -- TOC entry 17 (OID 464267104) -- Name: log_type; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE log_type ( log_type_id bigint NOT NULL, log_type character varying(50) NOT NULL ); -- -- TOC entry 18 (OID 464267109) -- Name: data_set_other_info; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE data_set_other_info ( data_set_other_info_id bigint NOT NULL, data_set_id bigint NOT NULL, data_set_other_info_na character varying(50) NOT NULL, data_set_other_info_tx character varying(4000) NOT NULL, create_dt date NOT NULL, modified_dt date ); -- -- TOC entry 19 (OID 464267114) -- Name: data_set_qc; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE data_set_qc ( data_set_qc_id bigint NOT NULL, data_set_id bigint NOT NULL, agency_na character varying(50), data_set_stat_id bigint NOT NULL, last_qc_dt date, operator_na character varying(50), doc_reference_uri_tx character varying(200) ); -- -- TOC entry 20 (OID 464267120) -- Name: data_set_stat; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE data_set_stat ( data_set_stat_id bigint NOT NULL, data_set_stat_na character varying(50) NOT NULL ); -- -- TOC entry 21 (OID 464267125) -- Name: data_set_variable_dtl; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE data_set_variable_dtl ( data_set_variable_dtl_id bigint NOT NULL, data_set_id bigint NOT NULL, dd_variable_id bigint, column_nm bigint NOT NULL, upper_bound numeric(18,2), lower_bound numeric(18,2), can_be_changed_flg character(1), other_variable_na character varying(50), other_variable_unit_tx character varying(10) ); -- -- TOC entry 22 (OID 464267131) -- Name: data_set_value; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE data_set_value ( data_set_value_id bigint NOT NULL, data_set_value_tx character varying(2000), data_set_value_dt date, data_set_variable_dtl_id bigint NOT NULL, data_set_row_id bigint NOT NULL ); -- -- TOC entry 23 (OID 464267139) -- Name: data_set_flag_set; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE data_set_flag_set ( data_set_flag_set_id bigint NOT NULL, data_set_flag_set_na character varying(1000) NOT NULL, data_set_id bigint NOT NULL ); -- -- TOC entry 24 (OID 464267144) -- Name: data_set_flag; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE data_set_flag ( data_set_flag_id bigint NOT NULL, data_set_flag_set_id bigint NOT NULL, data_set_flag_na character varying(50) NOT NULL, data_set_flag_tx character varying(2000) ); -- -- TOC entry 25 (OID 464267152) -- Name: data_set_edit; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE data_set_edit ( data_set_edit_id bigint NOT NULL, data_set_id bigint NOT NULL, data_set_variable_dtl_id bigint, data_set_edit_dt date NOT NULL, previous_val_tx character varying(2000), new_val_tx character varying(2000), reason_tx character varying(2000), real_row_nm bigint NOT NULL ); -- -- TOC entry 26 (OID 464267159) -- Name: data_set_test; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE data_set_test ( data_set_test_id bigint NOT NULL, data_set_id bigint NOT NULL, data_set_variable_dtl_id bigint NOT NULL, data_set_test_na character varying(50) NOT NULL, data_set_test_tx character varying(2000), orig_file_na character varying(1000), saved_file_na character varying(1000) ); -- -- TOC entry 28 (OID 464267166) -- Name: data_set_format_category; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE data_set_format_category ( data_set_format_category_id bigint NOT NULL, data_set_format_category_na character varying(50) ); -- -- TOC entry 29 (OID 464267171) -- Name: data_set_field_separator; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE data_set_field_separator ( data_set_field_separator_id bigint NOT NULL, data_set_field_separator_na character varying NOT NULL ); -- -- TOC entry 30 (OID 464267179) -- Name: data_set_upload; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE data_set_upload ( data_set_upload_id bigint NOT NULL, data_set_id bigint NOT NULL, saved_file_na character varying(100), orig_file_na character varying(1000), upload_dt date NOT NULL, caption_tx character varying ); -- -- TOC entry 31 (OID 464267186) -- Name: identification; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE identification ( identification_id bigint NOT NULL, metadata_id bigint NOT NULL, originator_na character varying, title_tx character varying, pub_dt date, pub_tx character varying, begin_dt date, begin_tx character varying, end_dt date, end_tx character varying, currentness_ref_id bigint, currentness_ref_tx character varying, distrib_liability_tx character varying, non_digital_fmt_tx character varying, digital_format_id bigint, format_tx character varying, format_version_tx character varying, file_size_nm double precision, file_size_metric_id bigint, net_resource_na character varying, offline_media_type_id bigint, recording_format_id bigint, fees_tx character varying, abstract_tx character varying, purpose_tx character varying, credit_tx character varying, environment_tx character varying, cross_ref_tx character varying, supplemental_tx character varying, progress_id bigint, update_frequency_id bigint, access_constraints_tx character varying, use_constraints_tx character varying, theme_keywords_tx character varying, geo_keywords_tx character varying, stratum_keywords_tx character varying, temporal_keywords_tx character varying, taxonomic_keywords_tx character varying, taxonomic_coverage_tx character varying ); -- -- TOC entry 32 (OID 464267193) -- Name: data_quality; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE data_quality ( data_quality_id bigint NOT NULL, metadata_id bigint NOT NULL, method_tx character varying, method_citation_tx character varying, class_sys_citation_tx character varying, taxonomic_proc_tx character varying, process_desc_tx character varying, process_dt character varying, process_tx character varying, entity_attribute_tx character varying, attribute_accuracy_tx character varying, logical_consistency_tx character varying, completeness_tx character varying, entity_attribute_detail_citation character varying ); -- -- TOC entry 33 (OID 464267200) -- Name: spatial_data; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE spatial_data ( spatial_data_id bigint NOT NULL, metadata_id bigint NOT NULL, geographic_desc character varying, spatial_ref_method_id bigint, pnt_vector_type_id bigint, pnt_vector_cnt bigint, raster_object_type_id bigint, row_cnt bigint, column_cnt bigint, vertical_cnt bigint, north_coord double precision, south_coord double precision, east_coord double precision, west_coord double precision, horiz_accuracy character varying, vert_accuracy character varying, cloud_cvr character varying ); -- -- TOC entry 34 (OID 464267207) -- Name: app_log; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE app_log ( app_log_id bigint NOT NULL, log_type_id bigint NOT NULL, app_log_dt date NOT NULL, app_log_tx character varying NOT NULL ); -- -- TOC entry 35 (OID 464267214) -- Name: calibration_log; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE calibration_log ( calibration_log_id bigint NOT NULL, sensor_id bigint NOT NULL, calibration_dt timestamp without time zone, calibrated_by character varying, sondeid_tx character varying, do_membrane_chg_flg character(1), chlorophyll_wiper_chg_flg character(1), cal_bp_tx character varying, post_bp_tx character varying, cal_voltage_tx character varying, post_voltage_tx character varying, cal_temp_tx character varying, post_temp_tx character varying, pre_do_tx character varying, cal_do_tx character varying, post_do_tx character varying, cal_do_charge_tx character varying, do_transmission_flg character(1), do_integrity_flg character(1), pre_sp_conductivity_tx character varying, cal_sp_conductivity_tx character varying, post_sp_conductivity_tx character varying, pre_ph7_tx character varying, cal_ph7_tx character varying, post_ph7_tx character varying, cal_ph7mv_tx character varying, pre_ph10_tx character varying, cal_ph10_tx character varying, post_ph10_tx character varying, cal_ph10mv_tx character varying, pre_orb_tx character varying, cal_orb_tx character varying, post_orp_tx character varying, pre_chlorophyll_tx character varying, cal_chlorophyll_tx character varying, post_chlorophyll_tx character varying, pre_turbidity_at_0_tx character varying, cal_turbidity_at_0_tx character varying, post_turbidity_at_0_tx character varying, pre_turbidity_at_123_tx character varying, cal_turbidity_at_123_tx character varying, post_turbidity_at_123_tx character varying, pre_depth_tx character varying, cal_depth_tx character varying, conductivity_cell_const_tx character varying, do_gain_tx character varying, ph_slope_tx character varying, act_logging_dt date, act_logging_interval_tx character varying, act_logging_start_dt date, deact_logging_dt date, deact_logging_start_dt date, post_depth_tx character varying, analysis_start_dt date, analysis_end_dt date, calibration_tx text, turbidity_wiper_chg_flg character(1), post_qaqc_dt date ); -- -- TOC entry 36 (OID 464267221) -- Name: address_type; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE address_type ( address_type_id bigint NOT NULL, address_type character varying(50) NOT NULL ); -- -- TOC entry 37 (OID 464267225) -- Name: app_user; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE app_user ( app_user_id bigint NOT NULL, honorific character varying(50), given_na character varying(50) NOT NULL, middle_na character varying(50), sur_na character varying(50) NOT NULL, suffix character varying(50), friendly_na character varying(50), organization_na character varying(50), address1 character varying(50), address2 character varying(50), city character varying(50), state character varying(50), country character varying(50), zip_cd character varying(50), email character varying(50) NOT NULL, webpage character varying(50), phone_nm1 character varying(50), phone_nm2 character varying(50), fax_nm character varying(50), login_na character varying(50) NOT NULL, "password" character varying(50) NOT NULL, organization_id bigint, user_role_id bigint NOT NULL, sensor_admin_flg character(1) NOT NULL, dd_admin_flg character(1) NOT NULL ); -- -- TOC entry 38 (OID 464267229) -- Name: citation; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE citation ( citation_id bigint NOT NULL, originator_na character varying(250), publication_dt timestamp without time zone, title character varying(250), edition character varying(250), geospatial_form_tx character varying(100), series_na character varying(250), issue_ident character varying(250), pubication_place character varying(250), publisher_na character varying(250), online_linkage character varying(250), create_app_user_id bigint NOT NULL, private_flg character(1) DEFAULT 'N'::bpchar NOT NULL ); -- -- TOC entry 39 (OID 464267237) -- Name: currentness_ref; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE currentness_ref ( currentness_ref_id bigint NOT NULL, currentness_ref character varying(50) NOT NULL ); -- -- TOC entry 40 (OID 464267242) -- Name: digital_format; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE digital_format ( digital_format_id bigint NOT NULL, digital_format character varying(512) ); -- -- TOC entry 41 (OID 464267246) -- Name: file_size_metric; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE file_size_metric ( file_size_metric_id bigint NOT NULL, file_size_metric character varying(50) NOT NULL ); -- -- TOC entry 42 (OID 464267250) -- Name: logger; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE logger ( log_id bigint NOT NULL, level_tx character varying(7), message character varying(255), class_name character varying(255), file_name character varying(255), line_number character varying(5), method_name character varying(255), logger_name character varying(255), start_date timestamp without time zone, log_date timestamp without time zone, thread_name character varying(255) ); -- -- TOC entry 43 (OID 464267254) -- Name: metadata; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE metadata ( metadata_id bigint NOT NULL, app_user_id bigint NOT NULL, metadata_na character varying(50) NOT NULL, publish_flg character(1) DEFAULT 'N'::bpchar NOT NULL, publish_dt timestamp without time zone, create_dt timestamp without time zone NOT NULL, modify_dt timestamp without time zone, platform_id bigint ); -- -- TOC entry 44 (OID 464267259) -- Name: metadata_citation_dtl; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE metadata_citation_dtl ( metadata_citation_dtl_id bigint NOT NULL, metadata_id bigint NOT NULL, citation_id bigint NOT NULL, citation_type_id bigint NOT NULL ); -- -- TOC entry 45 (OID 464267264) -- Name: metadata_process_dtl; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE metadata_process_dtl ( metadata_process_dtl_id bigint NOT NULL, metadata_id bigint NOT NULL, process_id bigint NOT NULL ); -- -- TOC entry 46 (OID 464267269) -- Name: offline_media_type; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE offline_media_type ( offline_media_type_id bigint NOT NULL, offline_media_type character varying(50) NOT NULL ); -- -- TOC entry 47 (OID 464267274) -- Name: process; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE process ( process_id bigint NOT NULL, process_na character varying(50) NOT NULL, create_app_user_id bigint NOT NULL, private_flg character(1) DEFAULT 'Y'::bpchar NOT NULL ); -- -- TOC entry 48 (OID 464267280) -- Name: progress; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE progress ( progress_id bigint NOT NULL, progress character varying(50) NOT NULL ); -- -- TOC entry 49 (OID 464267284) -- Name: recording_format; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE recording_format ( recording_format_id bigint NOT NULL, recording_format character varying(50) NOT NULL ); -- -- TOC entry 50 (OID 464267289) -- Name: seq_factory; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE seq_factory ( seq_name character varying(32) NOT NULL, begin_at numeric(18,0) NOT NULL, cache_sz numeric(18,0) NOT NULL ); -- -- TOC entry 51 (OID 464267293) -- Name: update_frequency; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE update_frequency ( update_frequency_id bigint NOT NULL, update_frequency character varying(50) NOT NULL ); -- -- TOC entry 52 (OID 464267298) -- Name: classif_method_citation_dtl; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE classif_method_citation_dtl ( class_method_citation_dtl_id bigint NOT NULL, metadata_id bigint NOT NULL, citation_id bigint NOT NULL ); -- -- TOC entry 53 (OID 464267302) -- Name: contact; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE contact ( contact_id bigint NOT NULL, contact_na character varying(100), organization_na character varying(100), position_na character varying(100), address_type_id bigint, address character varying(100), city character varying(60), state character varying(60), country character varying(60), phone_nm character varying(40), cntfax character varying(40), cntemail character varying(150), hours character varying(150), cntinst character varying(255), create_dt timestamp without time zone NOT NULL, modify_dt timestamp without time zone, role_na character varying(100), service_hrs character varying(100), cntvoice character varying(40), postal character varying(40), admin_area_tx character varying(50) ); -- -- TOC entry 54 (OID 464267306) -- Name: contact_metadata_dtl; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE contact_metadata_dtl ( contact_metadata_dtl_id bigint NOT NULL, contact_id bigint NOT NULL, metadata_id bigint NOT NULL, contact_type_id bigint NOT NULL ); -- -- TOC entry 55 (OID 464267310) -- Name: citation_type; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE citation_type ( citation_type_id bigint NOT NULL, citation_type character varying(2000) NOT NULL ); -- -- TOC entry 56 (OID 464267318) -- Name: platform_type; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE platform_type ( platform_type_id bigint NOT NULL, platform_type character varying(50) ); -- -- TOC entry 57 (OID 464267323) -- Name: sensor_group_dtl; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE sensor_group_dtl ( sensor_group_dtl_id bigint NOT NULL, sensor_group_id bigint NOT NULL, sensor_id bigint NOT NULL, begin_dt timestamp without time zone NOT NULL, end_dt timestamp without time zone ); -- -- TOC entry 58 (OID 464267327) -- Name: platform_sensor_dtl; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE platform_sensor_dtl ( platform_sensor_dtl_id bigint NOT NULL, platform_id bigint NOT NULL, sensor_id bigint NOT NULL, begin_dt timestamp without time zone NOT NULL, end_dt timestamp without time zone ); -- -- TOC entry 59 (OID 464267331) -- Name: contact_type; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE contact_type ( contact_type_id bigint NOT NULL, contact_type character varying(50) NOT NULL ); -- -- TOC entry 60 (OID 464267336) -- Name: contact_sensor_dtl; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE contact_sensor_dtl ( contact_sensor_dtl_id bigint NOT NULL, contact_id bigint NOT NULL, sensor_id bigint, sensor_group_id bigint, contact_type_id bigint NOT NULL ); -- -- TOC entry 61 (OID 464267340) -- Name: dd_variable; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE dd_variable ( dd_variable_id bigint NOT NULL, sea_coos_std_na character varying(255) NOT NULL, dd_category_id bigint, definition_tx character varying(1024), glossary_tx character varying(255), abbreviation_tx character varying(255), long_na character varying(255), dd_netcdf_data_type_id bigint, dependency_tx character varying(255), cdl_coordinate_attribute_tx character varying(255), units_tx character varying(255), axis_tx character varying(255), geo_phy_valid_range_tx character varying(255), datum_tx character varying(255), equivalent_std_na character varying(255), standard_tx character varying(255), dd_variable_stat_id bigint, version_tx character varying(64), comment_tx character varying(1024), create_dt timestamp without time zone NOT NULL, created_by_user_id bigint, modify_dt timestamp without time zone, modified_by_user_id bigint, default_data_set_column_nm bigint ); -- -- TOC entry 62 (OID 464267347) -- Name: dd_category; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE dd_category ( dd_category_id bigint NOT NULL, dd_category_na character varying(255) NOT NULL ); -- -- TOC entry 63 (OID 464267352) -- Name: dd_variable_stat; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE dd_variable_stat ( dd_variable_stat_id bigint NOT NULL, dd_variable_stat character varying(64) NOT NULL ); -- -- TOC entry 64 (OID 464267357) -- Name: organization; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE organization ( organization_id bigint NOT NULL, organization_na character varying(255) NOT NULL ); -- -- TOC entry 65 (OID 464267362) -- Name: dd_user_approve; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE dd_user_approve ( dd_user_approve_id bigint NOT NULL, dd_variable_id bigint, dd_variable_stat_id bigint, create_dt timestamp without time zone, modify_dt timestamp without time zone, app_user_given_na character varying(50), app_user_middle_na character varying(50), app_user_sur_na character varying(50) ); -- -- TOC entry 66 (OID 464267366) -- Name: dd_netcdf_data_type; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE dd_netcdf_data_type ( dd_netcdf_data_type_id bigint NOT NULL, dd_netcdf_data_type character varying(255) NOT NULL ); -- -- TOC entry 67 (OID 464267371) -- Name: sensor_group; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE sensor_group ( sensor_group_id bigint NOT NULL, sensor_group_na character varying(500) NOT NULL, sensor_group_tx character varying(2000), sensor_group_type_tx character varying(2000), sensor_group_is_attached character(1) NOT NULL ); -- -- TOC entry 68 (OID 464267379) -- Name: sensor; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE sensor ( sensor_id bigint NOT NULL, sensor_na character varying(500), sensor_ref_url character varying(2000), mfg_model_tx character varying(100), mfg_id_tx character varying(100), sensor_tx character varying(2000), sensor_is_attached character(1) NOT NULL ); -- -- TOC entry 69 (OID 464267387) -- Name: user_group_dtl; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE user_group_dtl ( user_group_dtl_id bigint NOT NULL, app_user_id bigint NOT NULL, user_group_id bigint NOT NULL, group_publish_priv_flg character(1) NOT NULL, group_update_priv_flg character(1) NOT NULL, group_view_priv_flg character(1) NOT NULL, manage_user_priv_flg character(1) NOT NULL, create_dt timestamp without time zone NOT NULL, modify_dt timestamp without time zone ); -- -- TOC entry 70 (OID 464267392) -- Name: user_group; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE user_group ( user_group_id bigint NOT NULL, user_group_na character varying(100) NOT NULL ); -- -- TOC entry 71 (OID 464268096) -- Name: sensor_group_variable; Type: VIEW; Schema: public; Owner: postgres -- CREATE VIEW sensor_group_variable AS SELECT dd_variable.dd_variable_id, dd_variable.sea_coos_std_na, dd_variable.dd_category_id, dd_variable.definition_tx, dd_variable.glossary_tx, dd_variable.abbreviation_tx, dd_variable.long_na, dd_variable.dd_netcdf_data_type_id, dd_variable.dependency_tx, dd_variable.cdl_coordinate_attribute_tx, dd_variable.units_tx, dd_variable.axis_tx, dd_variable.geo_phy_valid_range_tx, dd_variable.datum_tx, dd_variable.equivalent_std_na, dd_variable.standard_tx, dd_variable.dd_variable_stat_id, dd_variable.version_tx, dd_variable.comment_tx, dd_variable.create_dt, dd_variable.created_by_user_id, dd_variable.modify_dt, dd_variable.modified_by_user_id, sensor_group_dtl.begin_dt, sensor_group_dtl.end_dt, sensor_group_dtl.sensor_group_id, sensor.sensor_na, sensor.sensor_id, sensor_variable_dtl.low_rng, sensor_variable_dtl.high_rng, sensor_variable_dtl."precision", sensor_variable_dtl.op_low_rng, sensor_variable_dtl.op_high_rng, sensor_variable_dtl.capacity FROM sensor_variable_dtl, sensor, sensor_group_dtl, dd_variable WHERE ((((sensor_variable_dtl.sensor_id = sensor.sensor_id) AND (sensor.sensor_id = sensor_group_dtl.sensor_id)) AND (sensor_group_dtl.end_dt IS NULL)) AND (sensor_variable_dtl.dd_variable_id = dd_variable.dd_variable_id)); -- -- TOC entry 72 (OID 464268100) -- Name: dd_user_variable_view; Type: VIEW; Schema: public; Owner: postgres -- CREATE VIEW dd_user_variable_view AS SELECT dd_variable.dd_variable_id, dd_variable.sea_coos_std_na, dd_variable.dd_category_id, dd_variable.definition_tx, dd_variable.glossary_tx, dd_variable.abbreviation_tx, dd_variable.long_na, dd_variable.dd_netcdf_data_type_id, dd_variable.dependency_tx, dd_variable.cdl_coordinate_attribute_tx, dd_variable.units_tx, dd_variable.axis_tx, dd_variable.geo_phy_valid_range_tx, dd_variable.datum_tx, dd_variable.equivalent_std_na, dd_variable.standard_tx, dd_variable.dd_variable_stat_id, dd_variable.create_dt, dd_variable.modify_dt, dd_variable.modified_by_user_id, dd_variable.version_tx, dd_variable.comment_tx, dd_variable.created_by_user_id, app_user.given_na, app_user.organization_na FROM dd_variable, app_user WHERE (dd_variable.created_by_user_id = app_user.app_user_id); -- -- TOC entry 73 (OID 464268104) -- Name: metadata_export; Type: VIEW; Schema: public; Owner: postgres -- CREATE VIEW metadata_export AS SELECT metadata.metadata_id, metadata.metadata_na, identification.originator_na, data_quality.completeness_tx, spatial_data.geographic_desc FROM metadata, identification, data_quality, spatial_data WHERE (((metadata.metadata_id = identification.metadata_id) AND (metadata.metadata_id = data_quality.metadata_id)) AND (metadata.metadata_id = spatial_data.metadata_id)); -- -- TOC entry 74 (OID 464268107) -- Name: currentdate; Type: VIEW; Schema: public; Owner: postgres -- CREATE VIEW currentdate AS SELECT get_curr_date() AS "current_date"; -- -- TOC entry 75 (OID 464268110) -- Name: data_set_variable_info; Type: VIEW; Schema: public; Owner: postgres -- CREATE VIEW data_set_variable_info AS SELECT data_set_variable_dtl.data_set_variable_dtl_id, data_set_variable_dtl.data_set_id, data_set_variable_dtl.dd_variable_id, data_set_variable_dtl.column_nm, data_set_variable_dtl.lower_bound, data_set_variable_dtl.upper_bound, data_set_variable_dtl.can_be_changed_flg, CASE WHEN (dd_variable.dd_variable_id IS NOT NULL) THEN dd_variable.sea_coos_std_na ELSE data_set_variable_dtl.other_variable_na END AS variable_na, CASE WHEN (dd_variable.dd_variable_id IS NOT NULL) THEN dd_variable.units_tx ELSE data_set_variable_dtl.other_variable_unit_tx END AS unit_tx FROM (data_set_variable_dtl LEFT JOIN dd_variable ON ((data_set_variable_dtl.dd_variable_id = dd_variable.dd_variable_id))); -- -- TOC entry 76 (OID 464268114) -- Name: dd_variable_summary; Type: VIEW; Schema: public; Owner: postgres -- CREATE VIEW dd_variable_summary AS SELECT dd_variable.dd_variable_id, dd_variable.sea_coos_std_na, dd_variable.units_tx FROM dd_variable; -- -- TOC entry 77 (OID 464268117) -- Name: available_users_view; Type: VIEW; Schema: public; Owner: postgres -- CREATE VIEW available_users_view AS SELECT app_user.app_user_id, app_user.given_na, app_user.organization_na, app_user.organization_id, app_user.sur_na, app_user.state FROM app_user WHERE (NOT (EXISTS (SELECT 1 FROM user_group_dtl WHERE (user_group_dtl.app_user_id = app_user.app_user_id)))); -- -- TOC entry 89 (OID 464267093) -- Name: unq_platform; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_platform ON platform USING btree (platform_na); -- -- TOC entry 91 (OID 464267098) -- Name: unq_platform_location; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_platform_location ON platform_location USING btree (platform_location_na, longitude_coord, latitude_coord); -- -- TOC entry 93 (OID 464267103) -- Name: unq_user_role; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_user_role ON user_role USING btree (user_role_na); -- -- TOC entry 95 (OID 464267108) -- Name: unq_log_type; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_log_type ON log_type USING btree (log_type); -- -- TOC entry 99 (OID 464267118) -- Name: unq_data_set_qc; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_data_set_qc ON data_set_qc USING btree (data_set_id); -- -- TOC entry 97 (OID 464267119) -- Name: ind_data_set_qc_data_set_stat; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX ind_data_set_qc_data_set_stat ON data_set_qc USING btree (data_set_stat_id); -- -- TOC entry 101 (OID 464267124) -- Name: unq_data_set_stat; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_data_set_stat ON data_set_stat USING btree (data_set_stat_na); -- -- TOC entry 104 (OID 464267129) -- Name: unq_data_set_variable_dtl; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_data_set_variable_dtl ON data_set_variable_dtl USING btree (data_set_id, column_nm); -- -- TOC entry 102 (OID 464267130) -- Name: ind_data_set_variable_dtl_variable; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX ind_data_set_variable_dtl_variable ON data_set_variable_dtl USING btree (dd_variable_id); -- -- TOC entry 106 (OID 464267138) -- Name: unq_data_set_value; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_data_set_value ON data_set_value USING btree (data_set_variable_dtl_id, data_set_row_id); -- -- TOC entry 108 (OID 464267143) -- Name: unq_data_set_flag_set; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_data_set_flag_set ON data_set_flag_set USING btree (data_set_id, data_set_flag_set_na); -- -- TOC entry 110 (OID 464267151) -- Name: unq_data_set_flag; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_data_set_flag ON data_set_flag USING btree (data_set_flag_set_id, data_set_flag_na); -- -- TOC entry 114 (OID 464267170) -- Name: unq_data_set_format_category; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_data_set_format_category ON data_set_format_category USING btree (data_set_format_category_na); -- -- TOC entry 116 (OID 464267178) -- Name: unq_data_set_field_separator; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_data_set_field_separator ON data_set_field_separator USING btree (data_set_field_separator_na); -- -- TOC entry 127 (OID 464267241) -- Name: unq_currentness_ref; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_currentness_ref ON currentness_ref USING btree (currentness_ref); -- -- TOC entry 133 (OID 464267263) -- Name: unq_metadata_citation_dtl; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_metadata_citation_dtl ON metadata_citation_dtl USING btree (metadata_id, citation_id); -- -- TOC entry 135 (OID 464267268) -- Name: unq_metadata_process_dtl; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_metadata_process_dtl ON metadata_process_dtl USING btree (metadata_id, process_id); -- -- TOC entry 137 (OID 464267273) -- Name: unq_offline_media_type; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_offline_media_type ON offline_media_type USING btree (offline_media_type); -- -- TOC entry 139 (OID 464267279) -- Name: unq_process; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_process ON process USING btree (process_na); -- -- TOC entry 142 (OID 464267288) -- Name: unq_recording_format; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_recording_format ON recording_format USING btree (recording_format); -- -- TOC entry 145 (OID 464267297) -- Name: unq_update_frequency; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_update_frequency ON update_frequency USING btree (update_frequency); -- -- TOC entry 150 (OID 464267317) -- Name: unq_citation_type; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_citation_type ON citation_type USING btree (citation_type); -- -- TOC entry 152 (OID 464267322) -- Name: unq_platform_type; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_platform_type ON platform_type USING btree (platform_type); -- -- TOC entry 156 (OID 464267335) -- Name: unq_contact_type; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_contact_type ON contact_type USING btree (contact_type); -- -- TOC entry 160 (OID 464267351) -- Name: unq_dd_category; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_dd_category ON dd_category USING btree (dd_category_na); -- -- TOC entry 162 (OID 464267356) -- Name: unq_dd_variable_stat; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_dd_variable_stat ON dd_variable_stat USING btree (dd_variable_stat); -- -- TOC entry 164 (OID 464267361) -- Name: unq_organization; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_organization ON organization USING btree (organization_na); -- -- TOC entry 167 (OID 464267370) -- Name: unq_dd_netcdf_data_type; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_dd_netcdf_data_type ON dd_netcdf_data_type USING btree (dd_netcdf_data_type); -- -- TOC entry 169 (OID 464267378) -- Name: unq_sensor_group; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_sensor_group ON sensor_group USING btree (sensor_group_na); -- -- TOC entry 171 (OID 464267386) -- Name: unq_sensor_na; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_sensor_na ON sensor USING btree (sensor_na); -- -- TOC entry 173 (OID 464267391) -- Name: unq_user_group_dtl; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_user_group_dtl ON user_group_dtl USING btree (app_user_id, user_group_id); -- -- TOC entry 175 (OID 464267396) -- Name: unq_user_group; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX unq_user_group ON user_group USING btree (user_group_na); -- -- TOC entry 78 (OID 464267036) -- Name: pky_test; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY test ADD CONSTRAINT pky_test PRIMARY KEY (test_id); -- -- TOC entry 79 (OID 464267043) -- Name: pky_spatial_ref_method; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY spatial_ref_method ADD CONSTRAINT pky_spatial_ref_method PRIMARY KEY (spatial_ref_method_id); -- -- TOC entry 80 (OID 464267050) -- Name: pky_pnt_vector_type; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY pnt_vector_type ADD CONSTRAINT pky_pnt_vector_type PRIMARY KEY (pnt_vector_type_id); -- -- TOC entry 81 (OID 464267057) -- Name: pky_raster_object_type; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY raster_object_type ADD CONSTRAINT pky_raster_object_type PRIMARY KEY (raster_object_type_id); -- -- TOC entry 82 (OID 464267061) -- Name: pky_platform_sensor_group_dtl; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY platform_sensor_group_dtl ADD CONSTRAINT pky_platform_sensor_group_dtl PRIMARY KEY (platform_sensor_group_dtl_id); -- -- TOC entry 83 (OID 464267068) -- Name: pky_data_set; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set ADD CONSTRAINT pky_data_set PRIMARY KEY (data_set_id); -- -- TOC entry 84 (OID 464267072) -- Name: pky_caveat; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY caveat ADD CONSTRAINT pky_caveat PRIMARY KEY (caveat_id); -- -- TOC entry 85 (OID 464267076) -- Name: pky_data_set_quality; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_quality ADD CONSTRAINT pky_data_set_quality PRIMARY KEY (data_set_quality_id); -- -- TOC entry 86 (OID 464267080) -- Name: pky_data_set_row; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_row ADD CONSTRAINT pky_data_set_row PRIMARY KEY (data_set_row_id); -- -- TOC entry 87 (OID 464267084) -- Name: pky_sensor_variable_dtl; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY sensor_variable_dtl ADD CONSTRAINT pky_sensor_variable_dtl PRIMARY KEY (sensor_variable_dtl_id); -- -- TOC entry 88 (OID 464267091) -- Name: pky_platform; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY platform ADD CONSTRAINT pky_platform PRIMARY KEY (platform_id); -- -- TOC entry 90 (OID 464267096) -- Name: pky_platform_location; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY platform_location ADD CONSTRAINT pky_platform_location PRIMARY KEY (platform_location_id); -- -- TOC entry 92 (OID 464267101) -- Name: pky_user_role; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY user_role ADD CONSTRAINT pky_user_role PRIMARY KEY (user_role_id); -- -- TOC entry 94 (OID 464267106) -- Name: pky_log_type; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY log_type ADD CONSTRAINT pky_log_type PRIMARY KEY (log_type_id); -- -- TOC entry 98 (OID 464267116) -- Name: pky_data_set_qc; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_qc ADD CONSTRAINT pky_data_set_qc PRIMARY KEY (data_set_qc_id); -- -- TOC entry 100 (OID 464267122) -- Name: pky_data_set_stat; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_stat ADD CONSTRAINT pky_data_set_stat PRIMARY KEY (data_set_stat_id); -- -- TOC entry 103 (OID 464267127) -- Name: pky_data_set_variable_dtl; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_variable_dtl ADD CONSTRAINT pky_data_set_variable_dtl PRIMARY KEY (data_set_variable_dtl_id); -- -- TOC entry 105 (OID 464267136) -- Name: pky_data_set_value; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_value ADD CONSTRAINT pky_data_set_value PRIMARY KEY (data_set_value_id); -- -- TOC entry 107 (OID 464267141) -- Name: pky_data_set_flag_set; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_flag_set ADD CONSTRAINT pky_data_set_flag_set PRIMARY KEY (data_set_flag_set_id); -- -- TOC entry 109 (OID 464267149) -- Name: pky_data_set_flag; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_flag ADD CONSTRAINT pky_data_set_flag PRIMARY KEY (data_set_flag_id); -- -- TOC entry 111 (OID 464267157) -- Name: pky_data_set_edit; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_edit ADD CONSTRAINT pky_data_set_edit PRIMARY KEY (data_set_edit_id); -- -- TOC entry 112 (OID 464267164) -- Name: pky_data_set_test; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_test ADD CONSTRAINT pky_data_set_test PRIMARY KEY (data_set_test_id); -- -- TOC entry 113 (OID 464267168) -- Name: pky_data_set_format_category; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_format_category ADD CONSTRAINT pky_data_set_format_category PRIMARY KEY (data_set_format_category_id); -- -- TOC entry 115 (OID 464267176) -- Name: pky_data_set_field_separator; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_field_separator ADD CONSTRAINT pky_data_set_field_separator PRIMARY KEY (data_set_field_separator_id); -- -- TOC entry 117 (OID 464267184) -- Name: pky_data_set_upload; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_upload ADD CONSTRAINT pky_data_set_upload PRIMARY KEY (data_set_upload_id); -- -- TOC entry 118 (OID 464267191) -- Name: pky_metadata; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY identification ADD CONSTRAINT pky_metadata PRIMARY KEY (identification_id); -- -- TOC entry 119 (OID 464267198) -- Name: pky_data_quality; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_quality ADD CONSTRAINT pky_data_quality PRIMARY KEY (data_quality_id); -- -- TOC entry 120 (OID 464267205) -- Name: pky_spacial_data; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY spatial_data ADD CONSTRAINT pky_spacial_data PRIMARY KEY (spatial_data_id); -- -- TOC entry 121 (OID 464267212) -- Name: pky_app_log; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY app_log ADD CONSTRAINT pky_app_log PRIMARY KEY (app_log_id); -- -- TOC entry 122 (OID 464267219) -- Name: pky_calibration_log; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY calibration_log ADD CONSTRAINT pky_calibration_log PRIMARY KEY (calibration_log_id); -- -- TOC entry 123 (OID 464267223) -- Name: pk_address_type; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY address_type ADD CONSTRAINT pk_address_type PRIMARY KEY (address_type_id); -- -- TOC entry 124 (OID 464267227) -- Name: pky_app_user; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY app_user ADD CONSTRAINT pky_app_user PRIMARY KEY (app_user_id); -- -- TOC entry 125 (OID 464267235) -- Name: pky_citation; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY citation ADD CONSTRAINT pky_citation PRIMARY KEY (citation_id); -- -- TOC entry 126 (OID 464267239) -- Name: pky_currentness_reference; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY currentness_ref ADD CONSTRAINT pky_currentness_reference PRIMARY KEY (currentness_ref_id); -- -- TOC entry 128 (OID 464267244) -- Name: pky_digital_format; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY digital_format ADD CONSTRAINT pky_digital_format PRIMARY KEY (digital_format_id); -- -- TOC entry 129 (OID 464267248) -- Name: pky_file_size_metric; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY file_size_metric ADD CONSTRAINT pky_file_size_metric PRIMARY KEY (file_size_metric_id); -- -- TOC entry 130 (OID 464267252) -- Name: pky_logger; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY logger ADD CONSTRAINT pky_logger PRIMARY KEY (log_id); -- -- TOC entry 131 (OID 464267257) -- Name: pky_metadata1; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY metadata ADD CONSTRAINT pky_metadata1 PRIMARY KEY (metadata_id); -- -- TOC entry 132 (OID 464267261) -- Name: pky_metadata_citation_dtl; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY metadata_citation_dtl ADD CONSTRAINT pky_metadata_citation_dtl PRIMARY KEY (metadata_citation_dtl_id); -- -- TOC entry 134 (OID 464267266) -- Name: pky_metadata_process_dtl; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY metadata_process_dtl ADD CONSTRAINT pky_metadata_process_dtl PRIMARY KEY (metadata_process_dtl_id); -- -- TOC entry 136 (OID 464267271) -- Name: pky_offline_media_type; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY offline_media_type ADD CONSTRAINT pky_offline_media_type PRIMARY KEY (offline_media_type_id); -- -- TOC entry 138 (OID 464267277) -- Name: pky_process; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY process ADD CONSTRAINT pky_process PRIMARY KEY (process_id); -- -- TOC entry 140 (OID 464267282) -- Name: pky_progress; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY progress ADD CONSTRAINT pky_progress PRIMARY KEY (progress_id); -- -- TOC entry 141 (OID 464267286) -- Name: pky_recording_format; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY recording_format ADD CONSTRAINT pky_recording_format PRIMARY KEY (recording_format_id); -- -- TOC entry 143 (OID 464267291) -- Name: seq_factory_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY seq_factory ADD CONSTRAINT seq_factory_pkey PRIMARY KEY (seq_name); -- -- TOC entry 144 (OID 464267295) -- Name: pky_update_frequency; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY update_frequency ADD CONSTRAINT pky_update_frequency PRIMARY KEY (update_frequency_id); -- -- TOC entry 146 (OID 464267300) -- Name: pky_class_method_citation_dtl; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY classif_method_citation_dtl ADD CONSTRAINT pky_class_method_citation_dtl PRIMARY KEY (class_method_citation_dtl_id); -- -- TOC entry 147 (OID 464267304) -- Name: pky_contact; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY contact ADD CONSTRAINT pky_contact PRIMARY KEY (contact_id); -- -- TOC entry 148 (OID 464267308) -- Name: pky_contact_metadata_dtl; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY contact_metadata_dtl ADD CONSTRAINT pky_contact_metadata_dtl PRIMARY KEY (contact_metadata_dtl_id); -- -- TOC entry 149 (OID 464267315) -- Name: pky_citation_type; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY citation_type ADD CONSTRAINT pky_citation_type PRIMARY KEY (citation_type_id); -- -- TOC entry 151 (OID 464267320) -- Name: pky_platform_type; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY platform_type ADD CONSTRAINT pky_platform_type PRIMARY KEY (platform_type_id); -- -- TOC entry 153 (OID 464267325) -- Name: pky_sensor_group_dtl; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY sensor_group_dtl ADD CONSTRAINT pky_sensor_group_dtl PRIMARY KEY (sensor_group_dtl_id); -- -- TOC entry 154 (OID 464267329) -- Name: pky_platform_sensor_dtl; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY platform_sensor_dtl ADD CONSTRAINT pky_platform_sensor_dtl PRIMARY KEY (platform_sensor_dtl_id); -- -- TOC entry 155 (OID 464267333) -- Name: pky_contact_type; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY contact_type ADD CONSTRAINT pky_contact_type PRIMARY KEY (contact_type_id); -- -- TOC entry 157 (OID 464267338) -- Name: pky_contact_sensor_operator_dtl; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY contact_sensor_dtl ADD CONSTRAINT pky_contact_sensor_operator_dtl PRIMARY KEY (contact_sensor_dtl_id); -- -- TOC entry 158 (OID 464267345) -- Name: pky_dd_variable; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY dd_variable ADD CONSTRAINT pky_dd_variable PRIMARY KEY (dd_variable_id); -- -- TOC entry 159 (OID 464267349) -- Name: pky_dd_category; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY dd_category ADD CONSTRAINT pky_dd_category PRIMARY KEY (dd_category_id); -- -- TOC entry 161 (OID 464267354) -- Name: pky_dd_variable_status; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY dd_variable_stat ADD CONSTRAINT pky_dd_variable_status PRIMARY KEY (dd_variable_stat_id); -- -- TOC entry 163 (OID 464267359) -- Name: pky_dd_organization; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY organization ADD CONSTRAINT pky_dd_organization PRIMARY KEY (organization_id); -- -- TOC entry 165 (OID 464267364) -- Name: pky_dd_user_approve; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY dd_user_approve ADD CONSTRAINT pky_dd_user_approve PRIMARY KEY (dd_user_approve_id); -- -- TOC entry 166 (OID 464267368) -- Name: pky_dd_netcdf_data_type; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY dd_netcdf_data_type ADD CONSTRAINT pky_dd_netcdf_data_type PRIMARY KEY (dd_netcdf_data_type_id); -- -- TOC entry 168 (OID 464267376) -- Name: pky_sensor_group; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY sensor_group ADD CONSTRAINT pky_sensor_group PRIMARY KEY (sensor_group_id); -- -- TOC entry 170 (OID 464267384) -- Name: pky_sensor; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY sensor ADD CONSTRAINT pky_sensor PRIMARY KEY (sensor_id); -- -- TOC entry 172 (OID 464267389) -- Name: pky_user_group_dtl; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY user_group_dtl ADD CONSTRAINT pky_user_group_dtl PRIMARY KEY (user_group_dtl_id); -- -- TOC entry 174 (OID 464267394) -- Name: pky_user_group; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY user_group ADD CONSTRAINT pky_user_group PRIMARY KEY (user_group_id); -- -- TOC entry 96 (OID 464267880) -- Name: pky_data_set_other_info; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_other_info ADD CONSTRAINT pky_data_set_other_info PRIMARY KEY (data_set_other_info_id); -- -- TOC entry 189 (OID 464267816) -- Name: fky_platform_platform_type; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY platform ADD CONSTRAINT fky_platform_platform_type FOREIGN KEY (platform_type_id) REFERENCES platform_type(platform_type_id); -- -- TOC entry 188 (OID 464267820) -- Name: fky_platform_platform_location; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY platform ADD CONSTRAINT fky_platform_platform_location FOREIGN KEY (platform_location_id) REFERENCES platform_location(platform_location_id); -- -- TOC entry 220 (OID 464267824) -- Name: fky_app_user_org; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY app_user ADD CONSTRAINT fky_app_user_org FOREIGN KEY (organization_id) REFERENCES organization(organization_id); -- -- TOC entry 219 (OID 464267828) -- Name: fky_app_user_role; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY app_user ADD CONSTRAINT fky_app_user_role FOREIGN KEY (user_role_id) REFERENCES user_role(user_role_id); -- -- TOC entry 235 (OID 464267832) -- Name: fky_sensor_group_dtl_sensor_grp; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY sensor_group_dtl ADD CONSTRAINT fky_sensor_group_dtl_sensor_grp FOREIGN KEY (sensor_group_id) REFERENCES sensor_group(sensor_group_id); -- -- TOC entry 234 (OID 464267836) -- Name: fky_sensor_group_dtl_sensor; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY sensor_group_dtl ADD CONSTRAINT fky_sensor_group_dtl_sensor FOREIGN KEY (sensor_id) REFERENCES sensor(sensor_id); -- -- TOC entry 237 (OID 464267840) -- Name: fky_platform_sensor_dtl_platform; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY platform_sensor_dtl ADD CONSTRAINT fky_platform_sensor_dtl_platform FOREIGN KEY (platform_id) REFERENCES platform(platform_id); -- -- TOC entry 236 (OID 464267844) -- Name: fky_platform_sensor_dtl_sensor; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY platform_sensor_dtl ADD CONSTRAINT fky_platform_sensor_dtl_sensor FOREIGN KEY (sensor_id) REFERENCES sensor(sensor_id); -- -- TOC entry 180 (OID 464267848) -- Name: fky_platform_sensor_group_sensor_grp; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY platform_sensor_group_dtl ADD CONSTRAINT fky_platform_sensor_group_sensor_grp FOREIGN KEY (sensor_group_id) REFERENCES sensor_group(sensor_group_id); -- -- TOC entry 179 (OID 464267852) -- Name: fky_platform_sensor_group_platform; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY platform_sensor_group_dtl ADD CONSTRAINT fky_platform_sensor_group_platform FOREIGN KEY (platform_id) REFERENCES platform(platform_id); -- -- TOC entry 241 (OID 464267856) -- Name: fky_contact_sensor_dtl_sensor; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY contact_sensor_dtl ADD CONSTRAINT fky_contact_sensor_dtl_sensor FOREIGN KEY (sensor_id) REFERENCES sensor(sensor_id); -- -- TOC entry 240 (OID 464267860) -- Name: fky_contact_sensor_dtl_sensor_group; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY contact_sensor_dtl ADD CONSTRAINT fky_contact_sensor_dtl_sensor_group FOREIGN KEY (sensor_group_id) REFERENCES sensor_group(sensor_group_id); -- -- TOC entry 239 (OID 464267864) -- Name: fky_contact_contact_dtl_type; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY contact_sensor_dtl ADD CONSTRAINT fky_contact_contact_dtl_type FOREIGN KEY (contact_type_id) REFERENCES contact_type(contact_type_id); -- -- TOC entry 233 (OID 464267868) -- Name: fky_contact_metadata_dtl_type; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY contact_metadata_dtl ADD CONSTRAINT fky_contact_metadata_dtl_type FOREIGN KEY (contact_type_id) REFERENCES contact_type(contact_type_id); -- -- TOC entry 187 (OID 464267872) -- Name: fky_sensor_variable_dtl_sensor; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY sensor_variable_dtl ADD CONSTRAINT fky_sensor_variable_dtl_sensor FOREIGN KEY (sensor_id) REFERENCES sensor(sensor_id); -- -- TOC entry 186 (OID 464267876) -- Name: fky_sensor_variable_dtl_variable; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY sensor_variable_dtl ADD CONSTRAINT fky_sensor_variable_dtl_variable FOREIGN KEY (dd_variable_id) REFERENCES dd_variable(dd_variable_id); -- -- TOC entry 190 (OID 464267882) -- Name: fky_data_set_other_info_data_set; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_other_info ADD CONSTRAINT fky_data_set_other_info_data_set FOREIGN KEY (data_set_id) REFERENCES data_set(data_set_id); -- -- TOC entry 192 (OID 464267886) -- Name: fky_data_set_qc_data_set; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_qc ADD CONSTRAINT fky_data_set_qc_data_set FOREIGN KEY (data_set_id) REFERENCES data_set(data_set_id); -- -- TOC entry 191 (OID 464267890) -- Name: fky_data_set_qc_data_set_stat; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_qc ADD CONSTRAINT fky_data_set_qc_data_set_stat FOREIGN KEY (data_set_stat_id) REFERENCES data_set_stat(data_set_stat_id); -- -- TOC entry 194 (OID 464267894) -- Name: fky_data_set_variable_dtl_data_set; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_variable_dtl ADD CONSTRAINT fky_data_set_variable_dtl_data_set FOREIGN KEY (data_set_id) REFERENCES data_set(data_set_id); -- -- TOC entry 193 (OID 464267898) -- Name: fky_data_set_variable_dtl_dd_variable; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_variable_dtl ADD CONSTRAINT fky_data_set_variable_dtl_dd_variable FOREIGN KEY (dd_variable_id) REFERENCES dd_variable(dd_variable_id); -- -- TOC entry 196 (OID 464267902) -- Name: fky_data_set_value_data_set_variable_dtl; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_value ADD CONSTRAINT fky_data_set_value_data_set_variable_dtl FOREIGN KEY (data_set_variable_dtl_id) REFERENCES data_set_variable_dtl(data_set_variable_dtl_id); -- -- TOC entry 195 (OID 464267906) -- Name: fky_data_set_value_row; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_value ADD CONSTRAINT fky_data_set_value_row FOREIGN KEY (data_set_row_id) REFERENCES data_set_row(data_set_row_id); -- -- TOC entry 200 (OID 464267910) -- Name: fky_data_set_edit_data_set; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_edit ADD CONSTRAINT fky_data_set_edit_data_set FOREIGN KEY (data_set_id) REFERENCES data_set(data_set_id); -- -- TOC entry 199 (OID 464267914) -- Name: fky_data_set_edit_data_set_variable_dtl; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_edit ADD CONSTRAINT fky_data_set_edit_data_set_variable_dtl FOREIGN KEY (data_set_variable_dtl_id) REFERENCES data_set_variable_dtl(data_set_variable_dtl_id); -- -- TOC entry 202 (OID 464267918) -- Name: fky_data_set_test_data_set_variable_dtl; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_test ADD CONSTRAINT fky_data_set_test_data_set_variable_dtl FOREIGN KEY (data_set_variable_dtl_id) REFERENCES data_set_variable_dtl(data_set_variable_dtl_id); -- -- TOC entry 201 (OID 464267922) -- Name: fky_data_set_test_data_set; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_test ADD CONSTRAINT fky_data_set_test_data_set FOREIGN KEY (data_set_id) REFERENCES data_set(data_set_id); -- -- TOC entry 197 (OID 464267926) -- Name: fky_dat_set_flag_set_data_set; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_flag_set ADD CONSTRAINT fky_dat_set_flag_set_data_set FOREIGN KEY (data_set_id) REFERENCES data_set(data_set_id); -- -- TOC entry 198 (OID 464267930) -- Name: fky_data_set_flag_data_set_flag_set; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_flag ADD CONSTRAINT fky_data_set_flag_data_set_flag_set FOREIGN KEY (data_set_flag_set_id) REFERENCES data_set_flag_set(data_set_flag_set_id); -- -- TOC entry 222 (OID 464267934) -- Name: fky_metadata_platform; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY metadata ADD CONSTRAINT fky_metadata_platform FOREIGN KEY (platform_id) REFERENCES platform(platform_id); -- -- TOC entry 221 (OID 464267938) -- Name: fky_metadata_app_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY metadata ADD CONSTRAINT fky_metadata_app_user FOREIGN KEY (app_user_id) REFERENCES app_user(app_user_id); -- -- TOC entry 185 (OID 464267942) -- Name: fky_data_set_data_set_quality; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set ADD CONSTRAINT fky_data_set_data_set_quality FOREIGN KEY (data_set_quality_id) REFERENCES data_set_quality(data_set_quality_id); -- -- TOC entry 184 (OID 464267946) -- Name: fky_data_set_data_set_format_cat; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set ADD CONSTRAINT fky_data_set_data_set_format_cat FOREIGN KEY (data_set_format_category_id) REFERENCES data_set_format_category(data_set_format_category_id); -- -- TOC entry 183 (OID 464267950) -- Name: fky_data_set_data_set_field_separator; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set ADD CONSTRAINT fky_data_set_data_set_field_separator FOREIGN KEY (data_set_field_separator_id) REFERENCES data_set_field_separator(data_set_field_separator_id); -- -- TOC entry 182 (OID 464267954) -- Name: fky_data_set_metadata; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set ADD CONSTRAINT fky_data_set_metadata FOREIGN KEY (metadata_id) REFERENCES metadata(metadata_id); -- -- TOC entry 181 (OID 464267958) -- Name: fky_data_set_caveat; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set ADD CONSTRAINT fky_data_set_caveat FOREIGN KEY (caveat_id) REFERENCES caveat(caveat_id); -- -- TOC entry 203 (OID 464267962) -- Name: fky_data_set_upload_data_set; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_set_upload ADD CONSTRAINT fky_data_set_upload_data_set FOREIGN KEY (data_set_id) REFERENCES data_set(data_set_id); -- -- TOC entry 211 (OID 464267966) -- Name: fky_identification_currentness_ref; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY identification ADD CONSTRAINT fky_identification_currentness_ref FOREIGN KEY (currentness_ref_id) REFERENCES currentness_ref(currentness_ref_id); -- -- TOC entry 210 (OID 464267970) -- Name: fky_identification_digital_format; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY identification ADD CONSTRAINT fky_identification_digital_format FOREIGN KEY (digital_format_id) REFERENCES digital_format(digital_format_id); -- -- TOC entry 209 (OID 464267974) -- Name: fky_identification_file_size_metric; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY identification ADD CONSTRAINT fky_identification_file_size_metric FOREIGN KEY (file_size_metric_id) REFERENCES file_size_metric(file_size_metric_id); -- -- TOC entry 208 (OID 464267978) -- Name: fky_identification_metadata; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY identification ADD CONSTRAINT fky_identification_metadata FOREIGN KEY (metadata_id) REFERENCES metadata(metadata_id); -- -- TOC entry 207 (OID 464267982) -- Name: fky_identification_offline_media_type; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY identification ADD CONSTRAINT fky_identification_offline_media_type FOREIGN KEY (offline_media_type_id) REFERENCES offline_media_type(offline_media_type_id); -- -- TOC entry 206 (OID 464267986) -- Name: fky_identification_progress; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY identification ADD CONSTRAINT fky_identification_progress FOREIGN KEY (progress_id) REFERENCES progress(progress_id); -- -- TOC entry 205 (OID 464267990) -- Name: fky_identification_recording_format; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY identification ADD CONSTRAINT fky_identification_recording_format FOREIGN KEY (recording_format_id) REFERENCES recording_format(recording_format_id); -- -- TOC entry 204 (OID 464267994) -- Name: fky_identification_update_frequency; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY identification ADD CONSTRAINT fky_identification_update_frequency FOREIGN KEY (update_frequency_id) REFERENCES update_frequency(update_frequency_id); -- -- TOC entry 212 (OID 464267998) -- Name: fky_data_quality_metadata; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY data_quality ADD CONSTRAINT fky_data_quality_metadata FOREIGN KEY (metadata_id) REFERENCES metadata(metadata_id); -- -- TOC entry 216 (OID 464268002) -- Name: fky_spatial_data_pnt_vec_type; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY spatial_data ADD CONSTRAINT fky_spatial_data_pnt_vec_type FOREIGN KEY (pnt_vector_type_id) REFERENCES pnt_vector_type(pnt_vector_type_id); -- -- TOC entry 215 (OID 464268006) -- Name: fky_spatial_data_raster_obj_type; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY spatial_data ADD CONSTRAINT fky_spatial_data_raster_obj_type FOREIGN KEY (raster_object_type_id) REFERENCES raster_object_type(raster_object_type_id); -- -- TOC entry 214 (OID 464268010) -- Name: fky_spatial_data_ref_method; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY spatial_data ADD CONSTRAINT fky_spatial_data_ref_method FOREIGN KEY (spatial_ref_method_id) REFERENCES spatial_ref_method(spatial_ref_method_id); -- -- TOC entry 213 (OID 464268014) -- Name: fky_spatial_metadata; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY spatial_data ADD CONSTRAINT fky_spatial_metadata FOREIGN KEY (metadata_id) REFERENCES metadata(metadata_id); -- -- TOC entry 217 (OID 464268018) -- Name: fky_app_log_type; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY app_log ADD CONSTRAINT fky_app_log_type FOREIGN KEY (log_type_id) REFERENCES log_type(log_type_id); -- -- TOC entry 218 (OID 464268022) -- Name: fky_calibration_log_sensor; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY calibration_log ADD CONSTRAINT fky_calibration_log_sensor FOREIGN KEY (sensor_id) REFERENCES sensor(sensor_id); -- -- TOC entry 225 (OID 464268026) -- Name: fky_metadata_citation_dtl_citation; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY metadata_citation_dtl ADD CONSTRAINT fky_metadata_citation_dtl_citation FOREIGN KEY (citation_id) REFERENCES citation(citation_id); -- -- TOC entry 224 (OID 464268030) -- Name: fky_metadata_citation_dtl_metadata; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY metadata_citation_dtl ADD CONSTRAINT fky_metadata_citation_dtl_metadata FOREIGN KEY (metadata_id) REFERENCES metadata(metadata_id); -- -- TOC entry 223 (OID 464268034) -- Name: fky_citation_citation_type; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY metadata_citation_dtl ADD CONSTRAINT fky_citation_citation_type FOREIGN KEY (citation_type_id) REFERENCES citation_type(citation_type_id); -- -- TOC entry 227 (OID 464268038) -- Name: fky_metadata_process_dtl_metadata; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY metadata_process_dtl ADD CONSTRAINT fky_metadata_process_dtl_metadata FOREIGN KEY (metadata_id) REFERENCES metadata(metadata_id); -- -- TOC entry 226 (OID 464268042) -- Name: fky_metadata_process_dtl_process; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY metadata_process_dtl ADD CONSTRAINT fky_metadata_process_dtl_process FOREIGN KEY (process_id) REFERENCES process(process_id); -- -- TOC entry 229 (OID 464268046) -- Name: fky_class_method_citation_dtl_cit; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY classif_method_citation_dtl ADD CONSTRAINT fky_class_method_citation_dtl_cit FOREIGN KEY (citation_id) REFERENCES citation(citation_id); -- -- TOC entry 228 (OID 464268050) -- Name: fky_class_method_citation_dtl_meta; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY classif_method_citation_dtl ADD CONSTRAINT fky_class_method_citation_dtl_meta FOREIGN KEY (metadata_id) REFERENCES metadata(metadata_id); -- -- TOC entry 232 (OID 464268054) -- Name: fky_contact_metadata_dtl_metadata; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY contact_metadata_dtl ADD CONSTRAINT fky_contact_metadata_dtl_metadata FOREIGN KEY (metadata_id) REFERENCES metadata(metadata_id); -- -- TOC entry 231 (OID 464268058) -- Name: fky_contact_metadata_dtl_contact; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY contact_metadata_dtl ADD CONSTRAINT fky_contact_metadata_dtl_contact FOREIGN KEY (contact_id) REFERENCES contact(contact_id); -- -- TOC entry 230 (OID 464268062) -- Name: fky_contact_address_type; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY contact ADD CONSTRAINT fky_contact_address_type FOREIGN KEY (address_type_id) REFERENCES address_type(address_type_id); -- -- TOC entry 238 (OID 464268066) -- Name: fky_contact_sensor_dtl_contact; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY contact_sensor_dtl ADD CONSTRAINT fky_contact_sensor_dtl_contact FOREIGN KEY (contact_id) REFERENCES contact(contact_id); -- -- TOC entry 244 (OID 464268070) -- Name: fky_dd_variable_category; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY dd_variable ADD CONSTRAINT fky_dd_variable_category FOREIGN KEY (dd_category_id) REFERENCES dd_category(dd_category_id); -- -- TOC entry 243 (OID 464268074) -- Name: fky_dd_variable_dd_netcdf_data_type; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY dd_variable ADD CONSTRAINT fky_dd_variable_dd_netcdf_data_type FOREIGN KEY (dd_netcdf_data_type_id) REFERENCES dd_netcdf_data_type(dd_netcdf_data_type_id); -- -- TOC entry 242 (OID 464268078) -- Name: fky_dd_variable_dd_variable_stat; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY dd_variable ADD CONSTRAINT fky_dd_variable_dd_variable_stat FOREIGN KEY (dd_variable_stat_id) REFERENCES dd_variable_stat(dd_variable_stat_id); -- -- TOC entry 245 (OID 464268082) -- Name: fky_dd_user_approve_dd_variable; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY dd_user_approve ADD CONSTRAINT fky_dd_user_approve_dd_variable FOREIGN KEY (dd_variable_id) REFERENCES dd_variable(dd_variable_id); -- -- TOC entry 247 (OID 464268086) -- Name: fky_user_group_dtl_app_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY user_group_dtl ADD CONSTRAINT fky_user_group_dtl_app_user FOREIGN KEY (app_user_id) REFERENCES app_user(app_user_id); -- -- TOC entry 246 (OID 464268090) -- Name: fky_user_group_dtl_user_group; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY user_group_dtl ADD CONSTRAINT fky_user_group_dtl_user_group FOREIGN KEY (user_group_id) REFERENCES user_group(user_group_id); -- -- TOC entry 2 (OID 2200) -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres -- COMMENT ON SCHEMA public IS 'Standard public schema'; -- -- TOC entry 27 (OID 464267159) -- Name: COLUMN data_set_test.data_set_id; Type: COMMENT; Schema: public; Owner: postgres -- COMMENT ON COLUMN data_set_test.data_set_id IS 'Speeds up Query to have this field in this table';