   id_etablissemet character varying(36),
   libelle character varying,
   CONSTRAINT type_evt_pk PRIMARY KEY (id)
+);
+
+CREATE TABLE presences.categorie_motif_absence
+(
+  libelle          CHARACTER VARYING(36),
+  id               BIGSERIAL NOT NULL,
+  id_etablissement CHARACTER VARYING(36),
+  CONSTRAINT categorie_motif_abs_pkey 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
)

      ON UPDATE NO ACTION ON DELETE CASCADE
);

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
(
