/**
 * @author jro
 * @date 30/03/2022
 * @version 1.0.0
 * @project SIEau
 * @table evenements_agri_enquetes
 */
# --- !Ups
create table evenements_agri_enquetes
(
    idenquete        bigint not null,
    numero           integer not null,
    dateevenement    timestamp with time zone not null,
    commentaires     text,
    type             varchar(12),
    typeassocie      varchar(25),
    idassocie        integer,
    datecloture      timestamp with time zone,
    datemaj          timestamp with time zone,
    loginmaj         varchar(50),
    jobexecutionid   bigint
);
# --- !Downs