1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| CREATE TABLE donnees_heure (
id_st integer NOT NULL,
id_pr integer NOT NULL,
id_stat integer NOT NULL,
date timestamp without time zone NOT NULL,
code integer NOT NULL,
valeur double precision
) WITHOUT OIDS;
--
-- TOC entry 4 (OID 21349687)
-- Name: donnees_heure_pkey; Type: CONSTRAINT; Schema: public; Owner: transalpair
--
ALTER TABLE ONLY donnees_heure
ADD CONSTRAINT donnees_heure_pkey PRIMARY KEY (date, id_st, id_pr, id_stat);
--
-- TOC entry 5 (OID 21349693)
-- Name: Ref_32; Type: FK CONSTRAINT; Schema: public; Owner: transalpair
--
ALTER TABLE ONLY donnees_heure
ADD CONSTRAINT "Ref_32" FOREIGN KEY (id_st, id_pr) REFERENCES stations_parametres(id_st, id_pr) MATCH FULL;
--
-- TOC entry 6 (OID 21349697)
-- Name: ref_1015; Type: FK CONSTRAINT; Schema: public; Owner: transalpair
--
ALTER TABLE ONLY donnees_heure
ADD CONSTRAINT ref_1015 FOREIGN KEY (id_stat, id_pr) REFERENCES statistiques_parametres(id_stat, id_pr); |
Partager