/**
 * @author tpasquet via pminot
 * @date 22/10/21
 * @version 1.0.0
 * @project SIEau
 * @table pgsse_dangers
 */

# --- !Ups
DROP TABLE IF EXISTS pgsse_dangers_doc;
CREATE TABLE pgsse_dangers_doc (
                                   idEnquete BIGINT,
                                   typeSite BIGINT,
                                   codeSite BIGINT,
                                   idDanger BIGINT,
                                   nomDocument VARCHAR ( 255 ),
                                   description VARCHAR ( 255 )
);

DROP TABLE IF EXISTS pgsse_dangers;
CREATE TABLE pgsse_dangers (
                                       idDanger BIGINT,
                                       idEnquete BIGINT,
                                       typeSite BIGINT,
                                       codeSite BIGINT,
                                       typeLexique VARCHAR ( 50 ),
                                       situationDangereuse BIGINT,
                                       commentaire VARCHAR ( 255 )
);

# --- !Downs
