Skip to content
Snippets Groups Projects
Select Git revision
  • aa1b48f85848a0778a3d8226706e40af959e4127
  • master default protected
2 results

App.vue

Blame
  • Code owners
    Assign users and groups as approvers for specific file changes. Learn more.
    schema.pgsql.sql 3.41 KiB
    
    -----------------------------------------------------------------------------------------------------------------
    --                                             UnicaenAlerte
    -----------------------------------------------------------------------------------------------------------------
    
    create sequence unicaen_alerte_alerte_id_seq;
    
    create table unicaen_alerte_alerte
    (
        id bigint default nextval('unicaen_alerte_alerte_id_seq') not null constraint unicaen_alerte_alerte__pk primary key,
        code varchar(64) not null,
        title text not null,
        text text not null,
        severity varchar(64),
        duration smallint not null default 0,
        dismissible boolean default true
    );
    
    comment on table unicaen_alerte_alerte is 'Messages d''alerte';
    comment on column unicaen_alerte_alerte.code is 'Code littéral unique de cette alerte';
    comment on column unicaen_alerte_alerte.title is 'Titre/intitulé de cette alerte';
    comment on column unicaen_alerte_alerte.text is 'Texte de cette alerte';
    comment on column unicaen_alerte_alerte.dismissible is 'Indique si cette alerte peut être fermée par l''utilisateur';
    comment on column unicaen_alerte_alerte.severity is 'Sévérité (classe CSS) associée à cette alerte : success, info, warning, danger';
    comment on column unicaen_alerte_alerte.duration is 'Durée d''affichage de cette alerte en millisecondes (0 = infini)';
    
    create index unicaen_alerte_alerte__idx on unicaen_alerte_alerte (id);
    create unique index unicaen_alerte_alerte__un on unicaen_alerte_alerte (code);
    
    
    
    create sequence unicaen_alerte_alerte_planning_id_seq;
    
    create table unicaen_alerte_alerte_planning
    (
        id bigint default nextval('unicaen_alerte_alerte_planning_id_seq') not null constraint unicaen_alerte_alerte_planning__pk primary key,
        alerte_id bigint not null constraint unicaen_alerte_alerte_planning__unicaen_alerte__fk references unicaen_alerte_alerte,
        start_date timestamp not null default current_timestamp,
        end_date timestamp not null,
        severity varchar(64)
    );
    
    
    comment on table unicaen_alerte_alerte_planning is 'Plannings d''affichage des alertes';
    comment on column unicaen_alerte_alerte_planning.alerte_id is 'Identifiant de l''alerte concernée';
    comment on column unicaen_alerte_alerte_planning.start_date is 'Date et heure de début de la période d''affichage de l''alerte';
    comment on column unicaen_alerte_alerte_planning.end_date is 'Date et heure de fin de la période d''affichage de l''alerte';
    comment on column unicaen_alerte_alerte_planning.severity is 'Sévérité remplaçant celle de l''alerte sur cette période';
    
    create index unicaen_alerte_alerte_planning__idx on unicaen_alerte_alerte_planning (id);
    create index unicaen_alerte_alerte_planning__alerte__idx on unicaen_alerte_alerte_planning (alerte_id);
    
    
    
    
    
    insert into unicaen_alerte_alerte(id, code, title, text, severity, duration, dismissible)
    select nextval('unicaen_alerte_alerte_id_seq'),
           'ALERTE_SOUTENANCE',
           'DEMANDE DE SOUTENANCE',
           '<p>En raison de la période estivale le délai de traitement de 2 mois est repoussé pendant la période de fermeture des services de l’établissement soit du 13/07 au 29/08/2022.</p>',
           'danger',
           0,
           false;
    
    insert into unicaen_alerte_alerte_planning(id, alerte_id, start_date, end_date)
    select nextval('unicaen_alerte_alerte_planning_id_seq'),
           currval('unicaen_alerte_alerte_id_seq'),
           to_date('20220701','YYYYMMDD'),
           to_date('20220831','YYYYMMDD');