/**
 * @author ebonneau
 * @date 16/02/22
 * @version 1.0.0
 * @project MEDEAU
 * @table : evenements_agri_exploitations
 */

# --- !Ups
drop table if exists evenements_agri_exploitations;
create table evenements_agri_exploitations
(
  codeexploitation bigint,
  numero      integer,
  dateevenement   timestamp with time zone,
  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
