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 45 46 47 48 49
|
------------------------------------------------------------
-- Table: bien
------------------------------------------------------------
CREATE TABLE public.bien(
num_bien SERIAL NOT NULL ,
vendeur VARCHAR (50) ,
date_recep_mairie DATE ,
date_recep_pref DATE ,
CONSTRAINT PK_bien PRIMARY KEY (num_bien)
)WITHOUT OIDS;
------------------------------------------------------------
-- Table: dia
------------------------------------------------------------
CREATE TABLE public.dia(
num SERIAL NOT NULL ,
num_dia INT NOT NULL ,
adresse_du_bien VARCHAR (150) ,
acquereur VARCHAR (50) ,
montant_euros NUMERIC (10,2) ,
copropriete BOOL ,
superficie_bien_m2 NUMERIC (10,2) ,
superficie_terrain_m2 NUMERIC (15,2) ,
ref_cadas_longue VARCHAR (100) ,
num_bien INTEGER NOT NULL ,
CONSTRAINT PK_dia PRIMARY KEY (num)
,CONSTRAINT FK_dia_bien FOREIGN KEY (num_bien) REFERENCES public.bien(num_bien)
)WITHOUT OIDS;
------------------------------------------------------------
-- Table: _ref_cadas
------------------------------------------------------------
CREATE TABLE public._ref_cadas(
pk_ref SERIAL NOT NULL ,
section VARCHAR (2) ,
parcelle VARCHAR (4) ,
ind_partie BOOL ,
superf_ha INT ,
superf_a INT ,
superf_ca INT ,
num INT NOT NULL ,
CONSTRAINT PK__ref_cadas PRIMARY KEY (pk_ref)
,CONSTRAINT FK__ref_cadas_dia FOREIGN KEY (num) REFERENCES public.dia(num)
)WITHOUT OIDS; |
Partager