CREATE SEQUENCE "public"."alert_agreement_id_alert_agreement_seq"
 INCREMENT 1
 MINVALUE 1
 MAXVALUE 9223372036854775807
 START 1
 CACHE 1;

ALTER TABLE "public"."alert_agreement_id_alert_agreement_seq" OWNER TO "postgres";


CREATE TABLE "public"."alert_agreement" (
"id_alert_agreement" int2 DEFAULT nextval('alert_agreement_id_alert_agreement_seq'::regclass) NOT NULL,
"amount_agreement" varchar(255) COLLATE "default",
"rank_1" int2,
"rank_2" int2,
"rank_3" int2,
"id_agreement" int2,
CONSTRAINT "alert_agreement_pkey" PRIMARY KEY ("id_alert_agreement"),
CONSTRAINT "fk_agreement_id_agreement" FOREIGN KEY ("id_agreement") REFERENCES "public"."contratos" ("id_contratos") ON DELETE NO ACTION ON UPDATE NO ACTION
)
WITH (OIDS=FALSE)
;

ALTER TABLE "public"."alert_agreement" OWNER TO "postgres";