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 35 36 37 38 39 40 41 42 43 44
| CREATE TABLE public.ineo_suivi_chambres
(
id_siea character varying(254) NOT NULL,
id_suez character varying(254),
id_ft character varying(254),
os_conception character varying(254),
os_execution character varying(254),
os_travaux character varying(254),
rue character varying(254),
taille character varying(254),
proprietaire character varying(254),
a_traiter boolean,
t1 boolean,
t2 boolean,
t3 boolean,
total_t4 boolean,
t4a boolean,
t4bc boolean,
t4e boolean,
t4d boolean,
t5 boolean,
t6 boolean,
t7 boolean,
t8 boolean,
typ_princ character varying(254),
releve_t1 boolean,
releve_t2 boolean,
releve_t3 boolean,
releve_t4total boolean,
releve_t4a boolean,
releve_t4bc boolean,
releve_t4d boolean,
releve_t4e boolean,
releve_t5 boolean,
releve_t6 boolean,
releve_t7 boolean,
releve_t8 boolean,
CONSTRAINT ineo_suivi_chambres_pkey PRIMARY KEY (id_siea)
)
WITH (
OIDS=FALSE
);
ALTER TABLE public.ineo_suivi_chambres
OWNER TO postgres; |
Partager