/**
 * @author Titouan Pasquet
 * @date 10/02/21
 * @version 1.0.0
 * @project RSEau
 */

# --- !Ups

drop table if exists rseau_results;
create table rseau_results
(
    date              timestamp with time zone,
    landid            integer,
    sparedwateramount double precision,
    parsimonyscore    double precision,
    counterpartscore  integer,
    waterstressscore  integer,
    waterstressday    timestamp with time zone
);

# --- !Downs

drop table rseau_results;

