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
| CREATE TABLE personne
(
id_personne bigint NOT NULL DEFAULT nextval('id_pers_seq'::regclass),
per_id_pers bigint,
titre_pers character varying(50),
matricule_pers character varying(50),
cin_pers character varying(50),
nom_pers character varying(50),
prenom_pers character varying(50),
date_naiss_pers date,
adresse_pers character varying(100),
code_postal_pers character varying(50),
ville_pers character varying(50),
email_pers character varying(50),
tel1_pers character varying(50),
tel2_pers character varying(50),
sexe_pers character varying(50),
desc_pers character varying(100),
mdp_compte character varying(50),
profil_compte character varying(50),
premiere_authen_compte boolean,
active_pers boolean,
CONSTRAINT pk_personne PRIMARY KEY (id_personne),
CONSTRAINT fk_personne_enregistr_personne FOREIGN KEY (per_id_pers)
REFERENCES personne (id_personne) MATCH SIMPLE
ON UPDATE RESTRICT ON DELETE RESTRICT
)
WITH (
OIDS=FALSE
);
ALTER TABLE personne OWNER TO postgres;
-- Index: enregistre_2_fk
-- DROP INDEX enregistre_2_fk;
CREATE INDEX enregistre_2_fk
ON personne
USING btree
(per_id_pers);
-- Index: personne_pk
-- DROP INDEX personne_pk;
CREATE UNIQUE INDEX personne_pk
ON personne
USING btree
(id_personne); |
Partager