ALTER TABLE "ES_SuveyConfig" add "Anonimo" BOOLEAN;
ALTER TABLE "ES_SuveyConfig" add "IdProyect" VARCHAR(5);
ALTER TABLE "ES_SuveyConfig" add "Token" VARCHAR(50);


CREATE TABLE IF NOT EXISTS public."ES_ProjectGroup"
(
    "Id" integer NOT NULL GENERATED BY DEFAULT AS IDENTITY ( INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    "IdEmpresa" integer NOT NULL,
    "IdProject" integer,
    "IdGroup" integer,
    "NumEval" integer,
    "TotEvalAsign" integer
    CONSTRAINT "PK_ES_ProjectGroup" PRIMARY KEY ("Id")
)

TABLESPACE pg_default;

ALTER TABLE public."ES_ProjectGroup"
    OWNER to azure_pg_admin;

