--
-- Name: app_catalog; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE app_catalog (
    row_id serial NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),
    short_name character varying(50) NOT NULL,
    long_name character varying(200),
    description character varying(1000)
);


ALTER TABLE public.app_catalog OWNER TO postgres;

--
-- Name: m_type; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE m_scalar_type (
    row_id integer NOT NULL,    
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),
    obs_type_id integer,
    uom_type_id integer
);


ALTER TABLE public.m_scalar_type OWNER TO postgres;

--
-- Name: m_type; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE m_type (
    row_id integer NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),
    num_types integer NOT NULL default 1,
    description character varying(1000),
    m_scalar_type_id integer,
    m_scalar_type_id_2 integer,
    m_scalar_type_id_3 integer,
    m_scalar_type_id_4 integer,
    m_scalar_type_id_5 integer,
    m_scalar_type_id_6 integer,
    m_scalar_type_id_7 integer,
    m_scalar_type_id_8 integer    
);


ALTER TABLE public.m_type OWNER TO postgres;

-- -----------------------------------------------------------------------------------
--
-- Name: quality_control; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE quality_control (
    row_id serial NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),
    type_id integer,
    short_name character varying(50),    
    description character varying(2000),
    url character varying(200),
    begin_date timestamp without time zone,
    end_date timestamp without time zone,
    contact_name character varying(200),
    contact_email character varying(50),
    contact_phone character varying(50)	
);


ALTER TABLE public.quality_control OWNER TO postgres;

--
-- Name: quality_control_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY quality_control
    ADD CONSTRAINT quality_control_pkey PRIMARY KEY (row_id);


ALTER INDEX public.quality_control_pkey OWNER TO postgres;


--
-- Name: quality_control_type; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE quality_control_type (
    row_id serial NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),
    type_name character varying(50) NOT NULL,
    description character varying(1000)
);


ALTER TABLE public.quality_control_type OWNER TO postgres;

--
-- Name: quality_control_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY quality_control_type
    ADD CONSTRAINT quality_control_type_pkey PRIMARY KEY (row_id);


ALTER INDEX public.quality_control_type_pkey OWNER TO postgres;

--
-- Name: quality_control_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY quality_control
    ADD CONSTRAINT quality_control_type_id_fkey FOREIGN KEY (type_id) REFERENCES quality_control_type(row_id);


-- -----------------------------------------------------------------------------------
--
-- Name: collection; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE collection (
    row_id serial NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),
    type_id integer,
    short_name character varying(50),
    long_name character varying(200),
    description character varying(1000),
    fixed_date timestamp without time zone,
    min_date timestamp without time zone,
    max_date timestamp without time zone,
    fixed_lon double precision,
    min_lon double precision,
    max_lon double precision,
    fixed_lat double precision,
    min_lat double precision,
    max_lat double precision,
    fixed_z double precision,
    min_z double precision,
    max_z double precision    
);


ALTER TABLE public.collection OWNER TO postgres;

--
-- Name: collection_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY collection
    ADD CONSTRAINT collection_pkey PRIMARY KEY (row_id);


ALTER INDEX public.collection_pkey OWNER TO postgres;


--
-- Name: collection_type; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE collection_type (
    row_id serial NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),
    type_name character varying(50) NOT NULL,
    description character varying(1000)
);


ALTER TABLE public.collection_type OWNER TO postgres;

--
-- Name: collection_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY collection_type
    ADD CONSTRAINT collection_type_pkey PRIMARY KEY (row_id);


ALTER INDEX public.collection_type_pkey OWNER TO postgres;

--
-- Name: collection_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY collection
    ADD CONSTRAINT collection_type_id_fkey FOREIGN KEY (type_id) REFERENCES collection_type(row_id);

-- -----------------------------------------------------------------------------------
	
--
-- Name: timestamp_lkp; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE timestamp_lkp (
    row_id serial NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),
    product_id integer NOT NULL,
    pass_timestamp timestamp without time zone,
    filepath character varying(200)
);


ALTER TABLE public.timestamp_lkp OWNER TO postgres;

--
-- Name: timestamp_lkp_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY timestamp_lkp
    ADD CONSTRAINT timestamp_lkp_pkey PRIMARY KEY (row_id);


ALTER INDEX public.timestamp_lkp_pkey OWNER TO postgres;


--
-- Name: product_type; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE product_type (
    row_id serial NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),
    type_name character varying(50) NOT NULL,
    description character varying(1000)
);


ALTER TABLE public.product_type OWNER TO postgres;

--
-- Name: product_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY product_type
    ADD CONSTRAINT product_type_pkey PRIMARY KEY (row_id);


ALTER INDEX public.product_type_pkey OWNER TO postgres;

--
-- Name: timestamp_lkp_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY timestamp_lkp
    ADD CONSTRAINT timestamp_lkp_product_id_fkey FOREIGN KEY (product_id) REFERENCES product_type(row_id);
	
-- -----------------------------------------------------------------------------------

--
-- Name: multi_obs; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE multi_obs (
    row_id serial NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),
    platform_handle character varying(100) NOT NULL,
    sensor_id integer NOT NULL,
    m_type_id integer NOT NULL,
    m_date timestamp without time zone,
    m_lon double precision,
    m_lat double precision,
    m_z double precision,
    m_value double precision,
    m_value_2 double precision,
    m_value_3 double precision, 
    m_value_4 double precision, 
    m_value_5 double precision, 
    m_value_6 double precision, 
    m_value_7 double precision, 
    m_value_8 double precision,     
    m_desc character varying(50),
    qc_id integer,
    qc_level integer,
    qc_flag character varying(100),
    qc_id_2 integer,
    qc_level_2 integer,
    qc_flag_2 character varying(100),
    collection_id integer,
    collection_id_2 integer,
    d_label_theta integer,
    d_top_of_hour integer,
    d_report_hour timestamp without time zone
);


ALTER TABLE public.multi_obs OWNER TO postgres;

--
-- Name: obs_type; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE obs_type (
    row_id integer NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),    
    standard_name character varying(50),
    definition character varying(1000)
);


ALTER TABLE public.obs_type OWNER TO postgres;

--
-- Name: organization; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE organization (
    row_id serial NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),
    short_name character varying(50) NOT NULL,
    active boolean,
    long_name character varying(200),
    description character varying(1000),
    url character varying(200),
    opendap_url character varying(200)
);


ALTER TABLE public.organization OWNER TO postgres;

--
-- Name: platform; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE platform (
    row_id serial NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),
    organization_id integer NOT NULL,
    type_id integer,
    short_name character varying(50),
    platform_handle character varying(100) NOT NULL,
    fixed_longitude double precision,
    fixed_latitude double precision,
    active boolean,
    begin_date timestamp without time zone,
    end_date timestamp without time zone,
    project_id integer,
    app_catalog_id integer,
    long_name character varying(200),
    description character varying(1000),
    url character varying(200),
    collection_id integer,
    collection_id_2 integer    
);


ALTER TABLE public.platform OWNER TO postgres;

--
-- Name: platform_type; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE platform_type (
    row_id serial NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),
    type_name character varying(50) NOT NULL,
    description character varying(1000)
);


ALTER TABLE public.platform_type OWNER TO postgres;

--
-- Name: project; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE project (
    row_id serial NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),
    short_name character varying(50) NOT NULL,
    long_name character varying(200),
    description character varying(1000)
);


ALTER TABLE public.project OWNER TO postgres;

--
-- Name: sensor; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE sensor (
    row_id serial NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),
    platform_id integer NOT NULL,
    type_id integer,
    short_name character varying(50),
    m_type_id integer NOT NULL,
    fixed_z double precision,
    active boolean,
    begin_date timestamp without time zone,
    end_date timestamp without time zone,
    s_order integer NOT NULL default 1,
    url character varying(200),
    collection_id integer,
    collection_id_2 integer    
);

ALTER TABLE public.sensor OWNER TO postgres;

--
-- Name: sensor_attr; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE sensor_attr (
    row_id serial NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),
    sensor_id integer NOT NULL,
    attr_name character varying(50),
    attr_value character varying(50)
);


ALTER TABLE public.sensor_attr OWNER TO postgres;

--
-- Name: sensor_type; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE sensor_type (
    row_id serial NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),
    type_name character varying(50) NOT NULL,
    description character varying(1000)
);


ALTER TABLE public.sensor_type OWNER TO postgres;

--
-- Name: uom_type; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE uom_type (
    row_id integer NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),    
    standard_name character varying(50),
    definition character varying(1000),
    display character varying(50)
);


ALTER TABLE public.uom_type OWNER TO postgres;

-- table m_type_display_order is used to determine the order in which measurement types are listed for various displays

CREATE TABLE m_type_display_order (
    row_id serial NOT NULL,
    row_entry_date timestamp with time zone NOT NULL default now(),
    row_update_date timestamp with time zone NOT NULL default now(),
    m_type_id integer NOT NULL
);
ALTER TABLE public.m_type_display_order OWNER TO postgres;
ALTER TABLE ONLY m_type_display_order
    ADD CONSTRAINT m_type_display_order_pkey PRIMARY KEY (row_id);
ALTER INDEX public.m_type_display_order_pkey OWNER TO postgres;

--
-- Name: app_catalog_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY app_catalog
    ADD CONSTRAINT app_catalog_pkey PRIMARY KEY (row_id);


ALTER INDEX public.app_catalog_pkey OWNER TO postgres;

--
-- Name: m_scalar_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY m_scalar_type
    ADD CONSTRAINT m_scalar_type_pkey PRIMARY KEY (row_id);


ALTER INDEX public.m_scalar_type_pkey OWNER TO postgres;

--
-- Name: m_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY m_type
    ADD CONSTRAINT m_type_pkey PRIMARY KEY (row_id);


ALTER INDEX public.m_type_pkey OWNER TO postgres;

--
-- Name: multi_obs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY multi_obs
    ADD CONSTRAINT multi_obs_pkey PRIMARY KEY (row_id);


ALTER INDEX public.multi_obs_pkey OWNER TO postgres;

--
-- Name: obs_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY obs_type
    ADD CONSTRAINT obs_type_pkey PRIMARY KEY (row_id);


ALTER INDEX public.obs_type_pkey OWNER TO postgres;

--
-- Name: organization_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY organization
    ADD CONSTRAINT organization_pkey PRIMARY KEY (row_id);


ALTER INDEX public.organization_pkey OWNER TO postgres;

--
-- Name: platform_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY platform
    ADD CONSTRAINT platform_pkey PRIMARY KEY (row_id);


ALTER INDEX public.platform_pkey OWNER TO postgres;

CREATE UNIQUE INDEX i_platform ON platform (platform_handle);

--
-- Name: platform_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY platform_type
    ADD CONSTRAINT platform_type_pkey PRIMARY KEY (row_id);


ALTER INDEX public.platform_type_pkey OWNER TO postgres;

--
-- Name: project_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY project
    ADD CONSTRAINT project_pkey PRIMARY KEY (row_id);


ALTER INDEX public.project_pkey OWNER TO postgres;

--
-- Name: sensor_attr_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY sensor_attr
    ADD CONSTRAINT sensor_attr_pkey PRIMARY KEY (row_id);


ALTER INDEX public.sensor_attr_pkey OWNER TO postgres;

--
-- Name: sensor_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY sensor
    ADD CONSTRAINT sensor_pkey PRIMARY KEY (row_id);

CREATE UNIQUE INDEX i_sensor ON sensor (platform_id,m_type_id,s_order);

ALTER INDEX public.sensor_pkey OWNER TO postgres;

--
-- Name: sensor_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY sensor_type
    ADD CONSTRAINT sensor_type_pkey PRIMARY KEY (row_id);


ALTER INDEX public.sensor_type_pkey OWNER TO postgres;

--
-- Name: uom_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY uom_type
    ADD CONSTRAINT uom_type_pkey PRIMARY KEY (row_id);


ALTER INDEX public.uom_type_pkey OWNER TO postgres;

--
-- Name: i_multi_obs; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE UNIQUE INDEX i_multi_obs ON multi_obs USING btree (m_type_id, m_date, sensor_id);


ALTER INDEX public.i_multi_obs OWNER TO postgres;

--
-- Name: m_type_obs_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY m_scalar_type
    ADD CONSTRAINT m_type_obs_type_id_fkey FOREIGN KEY (obs_type_id) REFERENCES obs_type(row_id);


--
-- Name: m_type_uom_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY m_scalar_type
    ADD CONSTRAINT m_type_uom_type_id_fkey FOREIGN KEY (uom_type_id) REFERENCES uom_type(row_id);


-- foreign key constraints for m_type

ALTER TABLE ONLY m_type
    ADD CONSTRAINT m_scalar_type_id_fkey FOREIGN KEY (m_scalar_type_id) REFERENCES m_scalar_type(row_id);

ALTER TABLE ONLY m_type
    ADD CONSTRAINT m_scalar_type_id_2_fkey FOREIGN KEY (m_scalar_type_id_2) REFERENCES m_scalar_type(row_id);

ALTER TABLE ONLY m_type
    ADD CONSTRAINT m_scalar_type_id_3_fkey FOREIGN KEY (m_scalar_type_id_3) REFERENCES m_scalar_type(row_id);

ALTER TABLE ONLY m_type
    ADD CONSTRAINT m_scalar_type_id_4_fkey FOREIGN KEY (m_scalar_type_id_4) REFERENCES m_scalar_type(row_id);

ALTER TABLE ONLY m_type
    ADD CONSTRAINT m_scalar_type_id_5_fkey FOREIGN KEY (m_scalar_type_id_5) REFERENCES m_scalar_type(row_id);

ALTER TABLE ONLY m_type
    ADD CONSTRAINT m_scalar_type_id_6_fkey FOREIGN KEY (m_scalar_type_id_6) REFERENCES m_scalar_type(row_id);

ALTER TABLE ONLY m_type
    ADD CONSTRAINT m_scalar_type_id_7_fkey FOREIGN KEY (m_scalar_type_id_7) REFERENCES m_scalar_type(row_id);

ALTER TABLE ONLY m_type
    ADD CONSTRAINT m_scalar_type_id_8_fkey FOREIGN KEY (m_scalar_type_id_8) REFERENCES m_scalar_type(row_id);

-- ---------------------------------------------------------------------------------

--
-- Name: multi_obs_m_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY multi_obs
    ADD CONSTRAINT multi_obs_m_type_id_fkey FOREIGN KEY (m_type_id) REFERENCES m_type(row_id);

--
-- Name: multi_obs_sensor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY multi_obs
    ADD CONSTRAINT multi_obs_sensor_id_fkey FOREIGN KEY (sensor_id) REFERENCES sensor(row_id);

-- ---------------------------------------------------------------------------------

--
-- Name: multi_obs_qc_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY multi_obs
    ADD CONSTRAINT multi_obs_qc_id_fkey FOREIGN KEY (qc_id) REFERENCES quality_control(row_id);

--
-- Name: multi_obs_qc_id_2_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY multi_obs
    ADD CONSTRAINT multi_obs_qc_id_2_fkey FOREIGN KEY (qc_id_2) REFERENCES quality_control(row_id);

-- ---------------------------------------------------------------------------------

--
-- Name: multi_obs_collection_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY multi_obs
    ADD CONSTRAINT multi_obs_collection_id_fkey FOREIGN KEY (collection_id) REFERENCES collection(row_id);

--
-- Name: multi_obs_collection_id_2_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY multi_obs
    ADD CONSTRAINT multi_obs_collection_id_2_fkey FOREIGN KEY (collection_id_2) REFERENCES collection(row_id);

-- ---------------------------------------------------------------------------------

--
-- Name: platform_collection_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY platform
    ADD CONSTRAINT platform_collection_id_fkey FOREIGN KEY (collection_id) REFERENCES collection(row_id);

--
-- Name: platform_collection_id_2_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY platform
    ADD CONSTRAINT platform_collection_id_2_fkey FOREIGN KEY (collection_id_2) REFERENCES collection(row_id);

-- ---------------------------------------------------------------------------------

--
-- Name: sensor_collection_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY sensor
    ADD CONSTRAINT sensor_collection_id_fkey FOREIGN KEY (collection_id) REFERENCES collection(row_id);

--
-- Name: sensor_collection_id_2_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY sensor
    ADD CONSTRAINT sensor_collection_id_2_fkey FOREIGN KEY (collection_id_2) REFERENCES collection(row_id);

-- ---------------------------------------------------------------------------------

--
-- Name: platform_app_catalog_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY platform
    ADD CONSTRAINT platform_app_catalog_id_fkey FOREIGN KEY (app_catalog_id) REFERENCES app_catalog(row_id);


--
-- Name: platform_organization_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY platform
    ADD CONSTRAINT platform_organization_id_fkey FOREIGN KEY (organization_id) REFERENCES organization(row_id);


--
-- Name: platform_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY platform
    ADD CONSTRAINT platform_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(row_id);


--
-- Name: platform_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY platform
    ADD CONSTRAINT platform_type_id_fkey FOREIGN KEY (type_id) REFERENCES platform_type(row_id);


--
-- Name: sensor_attr_sensor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY sensor_attr
    ADD CONSTRAINT sensor_attr_sensor_id_fkey FOREIGN KEY (sensor_id) REFERENCES sensor(row_id);


--
-- Name: sensor_m_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY sensor
    ADD CONSTRAINT sensor_m_type_id_fkey FOREIGN KEY (m_type_id) REFERENCES m_type(row_id);


--
-- Name: sensor_platform_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY sensor
    ADD CONSTRAINT sensor_platform_id_fkey FOREIGN KEY (platform_id) REFERENCES platform(row_id);


--
-- Name: sensor_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY sensor
    ADD CONSTRAINT sensor_type_id_fkey FOREIGN KEY (type_id) REFERENCES sensor_type(row_id);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--