/**
 * @author sbarthon
 * @date 03/01/22
 * @version 1.0.0
 * @project SIEau
 * @table mat_codifications
 */

# --- !Ups

CREATE TABLE MAT_CODIFICATIONS (
typeSite integer,
id integer,
dateDebut timestamp without time zone,
dateFin timestamp without time zone,
referenceInterne character varying(255),
typeCodification integer);


CREATE INDEX idx_mat_codifications ON MAT_CODIFICATIONS (typeSite, id, typeCodification);

# --- !Downs
