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
|
CREATE TABLE matable
(
folio character varying(6),
nom character varying(50),
dossier character varying(12),
date_dos character varying(6),
cb2 character varying(25),
cb3 character varying(25),
maq character varying(4),
flag character varying(1),
multi character varying(12),
com1 character varying(100),
com2 character varying(100),
com3 character varying(100),
com4 character varying(100),
com5 character varying(100),
com6 character varying(100),
com7 character varying(100),
com8 character varying(100),
entete character varying(140),
patient text,
obr text,
dynamique text,
termine character varying(1),
statut double precision,
priorite character varying(30),
sauvegarde double precision,
folioparent character varying(12),
datecreation timestamp without time zone,
archive character varying(1),
complement text
)
WITH (
OIDS=FALSE
); |
Partager