       ON UPDATE NO ACTION ON DELETE CASCADE
 );
 
-CREATE TABLE presences.categorie_motif_absence
+CREATE TABLE presences.categorie_motif_appel
 (
   libelle character varying(36),
-  id bigserial NOT NULL,
-  id_etablissement character varying(36),
-  CONSTRAINT categorie_motif_abs_pkey PRIMARY KEY (id)
-)
-
-CREATE TABLE presences.categorie_motif_appel
-(
-  libelle character varying(36),
   id_etablissement character varying(36),
   id bigserial NOT NULL,
   CONSTRAINT categorie_motif_appel_pkey PRIMARY KEY (id)
-)
+);
 
 CREATE TABLE presences.motif_appel
 (

  id_etablissemet character varying(36),
  libelle character varying,
  CONSTRAINT type_evt_pk PRIMARY KEY (id)
);

CREATE TABLE presences.motif

  CONSTRAINT fk_categorie_motif_appel_id FOREIGN KEY (id_categorie)
      REFERENCES presences.categorie_motif_appel (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE CASCADE
);
