-- futures 0001_initial -- -- Create model FuturesDriversSets -- CREATE TABLE "futures_drivers_sets" ("driver_set_id" uuid NOT NULL PRIMARY KEY, "driver_set_status" varchar(50) NOT NULL, "created_on" timestamp with time zone NOT NULL); -- -- Create model FuturesProjects -- CREATE TABLE "futures_projects" ("project_id" uuid NOT NULL PRIMARY KEY, "domain" varchar(255) NULL, "client" varchar(255) NULL, "geography" varchar(255) NULL, "horizon" varchar(255) NULL, "questions" varchar(1024) NULL, "created_on" timestamp with time zone NOT NULL, "is_public" boolean NOT NULL); -- -- Create model FuturesDrivers -- CREATE TABLE "futures_drivers" ("driver_id" uuid NOT NULL PRIMARY KEY, "driver_number" integer NOT NULL, "driver_name" varchar(255) NOT NULL, "driver_description" varchar(1024) NULL, "weight_past" double precision NULL, "push_present" double precision NULL, "pull_future" double precision NULL, "last_modified" timestamp with time zone NOT NULL, "driver_set_id" uuid NOT NULL, "project_id" uuid NOT NULL); -- -- Add field project to futuresdriverssets -- ALTER TABLE "futures_drivers_sets" ADD COLUMN "project_id" uuid NOT NULL CONSTRAINT "futures_drivers_sets_project_id_6a81e448_fk_futures_p" REFERENCES "futures_projects"("project_id") DEFERRABLE INITIALLY DEFERRED; -- -- Create model FuturesDomainCategories -- CREATE TABLE "futures_domain_categories" ("category_id" uuid NOT NULL PRIMARY KEY, "category_name" varchar(100) NOT NULL, "category_path" varchar(255) NOT NULL, "parent_id" uuid NULL, "project_id" uuid NOT NULL); -- -- Create model FuturesScenarioSets -- CREATE TABLE "futures_scenario_sets" ("scenario_set_id" uuid NOT NULL PRIMARY KEY, "scenario_set_status" varchar(50) NOT NULL, "created_on" timestamp with time zone NOT NULL, "scenario_methodology" varchar(255) NULL, "driver_set_id" uuid NOT NULL, "project_id" uuid NOT NULL); -- -- Create model FuturesScenarios -- CREATE TABLE "futures_scenarios" ("scenario_id" uuid NOT NULL PRIMARY KEY, "scenario_logics" varchar(1024) NULL, "scenario_text" text NULL, "last_modified" timestamp with time zone NOT NULL, "scenario_title" varchar(255) NULL, "project_id" uuid NOT NULL, "scenario_set_id" uuid NOT NULL); -- -- Create model FuturesSignals -- CREATE TABLE "futures_signals" ("signal_id" uuid NOT NULL PRIMARY KEY, "title" varchar(255) NULL, "author" varchar(255) NULL, "source_name" varchar(255) NULL, "url" varchar(500) NULL, "signal_date" date NULL, "steep" varchar(50) NULL, "horizon" varchar(50) NULL, "keywords" jsonb NULL, "signal_type" varchar(50) NULL, "description" varchar(1024) NULL, "change_desc" varchar(1024) NULL, "impact" integer NULL, "likelihood" integer NULL, "credibility" integer NULL, "novelty" integer NULL, "created_on" timestamp with time zone NOT NULL, "project_id" uuid NULL); -- -- Create model FuturesStakeholders -- CREATE TABLE "futures_stakeholders" ("stakeholder_id" uuid NOT NULL PRIMARY KEY, "stakeholder_name" varchar(255) NOT NULL, "project_id" uuid NOT NULL); -- -- Create model FuturesScenarioDrivers -- CREATE TABLE "futures_scenario_drivers" ("id" bigint NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, "driver_value" varchar(1024) NULL, "last_modified" timestamp with time zone NOT NULL, "driver_id" uuid NOT NULL, "project_id" uuid NOT NULL, "scenario_id" uuid NOT NULL, CONSTRAINT "unique_scenario_driver" UNIQUE ("scenario_id", "driver_id")); -- -- Create model FuturesDriverSignals -- CREATE TABLE "futures_driver_signals" ("id" bigint NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, "short_description" varchar(1024) NULL, "created_on" timestamp with time zone NOT NULL, "driver_id" uuid NOT NULL, "project_id" uuid NOT NULL, "signal_id" uuid NOT NULL, CONSTRAINT "unique_driver_signal" UNIQUE ("driver_id", "signal_id")); ALTER TABLE "futures_drivers" ADD CONSTRAINT "futures_drivers_driver_set_id_3c27ebca_fk_futures_d" FOREIGN KEY ("driver_set_id") REFERENCES "futures_drivers_sets" ("driver_set_id") DEFERRABLE INITIALLY DEFERRED; ALTER TABLE "futures_drivers" ADD CONSTRAINT "futures_drivers_project_id_024f1f05_fk_futures_p" FOREIGN KEY ("project_id") REFERENCES "futures_projects" ("project_id") DEFERRABLE INITIALLY DEFERRED; CREATE INDEX "futures_drivers_driver_set_id_3c27ebca" ON "futures_drivers" ("driver_set_id"); CREATE INDEX "futures_drivers_project_id_024f1f05" ON "futures_drivers" ("project_id"); CREATE INDEX "futures_drivers_sets_project_id_6a81e448" ON "futures_drivers_sets" ("project_id"); ALTER TABLE "futures_domain_categories" ADD CONSTRAINT "futures_domain_categ_parent_id_b8f8187a_fk_futures_d" FOREIGN KEY ("parent_id") REFERENCES "futures_domain_categories" ("category_id") DEFERRABLE INITIALLY DEFERRED; ALTER TABLE "futures_domain_categories" ADD CONSTRAINT "futures_domain_categ_project_id_1295f32b_fk_futures_p" FOREIGN KEY ("project_id") REFERENCES "futures_projects" ("project_id") DEFERRABLE INITIALLY DEFERRED; CREATE INDEX "futures_domain_categories_parent_id_b8f8187a" ON "futures_domain_categories" ("parent_id"); CREATE INDEX "futures_domain_categories_project_id_1295f32b" ON "futures_domain_categories" ("project_id"); ALTER TABLE "futures_scenario_sets" ADD CONSTRAINT "futures_scenario_set_driver_set_id_be5ebe3a_fk_futures_d" FOREIGN KEY ("driver_set_id") REFERENCES "futures_drivers_sets" ("driver_set_id") DEFERRABLE INITIALLY DEFERRED; ALTER TABLE "futures_scenario_sets" ADD CONSTRAINT "futures_scenario_set_project_id_652db9c0_fk_futures_p" FOREIGN KEY ("project_id") REFERENCES "futures_projects" ("project_id") DEFERRABLE INITIALLY DEFERRED; CREATE INDEX "futures_scenario_sets_driver_set_id_be5ebe3a" ON "futures_scenario_sets" ("driver_set_id"); CREATE INDEX "futures_scenario_sets_project_id_652db9c0" ON "futures_scenario_sets" ("project_id"); ALTER TABLE "futures_scenarios" ADD CONSTRAINT "futures_scenarios_project_id_75bbc6ab_fk_futures_p" FOREIGN KEY ("project_id") REFERENCES "futures_projects" ("project_id") DEFERRABLE INITIALLY DEFERRED; ALTER TABLE "futures_scenarios" ADD CONSTRAINT "futures_scenarios_scenario_set_id_4022984b_fk_futures_s" FOREIGN KEY ("scenario_set_id") REFERENCES "futures_scenario_sets" ("scenario_set_id") DEFERRABLE INITIALLY DEFERRED; CREATE INDEX "futures_scenarios_project_id_75bbc6ab" ON "futures_scenarios" ("project_id"); CREATE INDEX "futures_scenarios_scenario_set_id_4022984b" ON "futures_scenarios" ("scenario_set_id"); ALTER TABLE "futures_signals" ADD CONSTRAINT "futures_signals_project_id_3188838c_fk_futures_p" FOREIGN KEY ("project_id") REFERENCES "futures_projects" ("project_id") DEFERRABLE INITIALLY DEFERRED; CREATE INDEX "futures_signals_project_id_3188838c" ON "futures_signals" ("project_id"); ALTER TABLE "futures_stakeholders" ADD CONSTRAINT "futures_stakeholders_project_id_f12d5142_fk_futures_p" FOREIGN KEY ("project_id") REFERENCES "futures_projects" ("project_id") DEFERRABLE INITIALLY DEFERRED; CREATE INDEX "futures_stakeholders_project_id_f12d5142" ON "futures_stakeholders" ("project_id"); ALTER TABLE "futures_scenario_drivers" ADD CONSTRAINT "futures_scenario_dri_driver_id_2afb1fbb_fk_futures_d" FOREIGN KEY ("driver_id") REFERENCES "futures_drivers" ("driver_id") DEFERRABLE INITIALLY DEFERRED; ALTER TABLE "futures_scenario_drivers" ADD CONSTRAINT "futures_scenario_dri_project_id_ab228456_fk_futures_p" FOREIGN KEY ("project_id") REFERENCES "futures_projects" ("project_id") DEFERRABLE INITIALLY DEFERRED; ALTER TABLE "futures_scenario_drivers" ADD CONSTRAINT "futures_scenario_dri_scenario_id_bd3e3e72_fk_futures_s" FOREIGN KEY ("scenario_id") REFERENCES "futures_scenarios" ("scenario_id") DEFERRABLE INITIALLY DEFERRED; CREATE INDEX "futures_scenario_drivers_driver_id_2afb1fbb" ON "futures_scenario_drivers" ("driver_id"); CREATE INDEX "futures_scenario_drivers_project_id_ab228456" ON "futures_scenario_drivers" ("project_id"); CREATE INDEX "futures_scenario_drivers_scenario_id_bd3e3e72" ON "futures_scenario_drivers" ("scenario_id"); ALTER TABLE "futures_driver_signals" ADD CONSTRAINT "futures_driver_signa_driver_id_32a4d5f8_fk_futures_d" FOREIGN KEY ("driver_id") REFERENCES "futures_drivers" ("driver_id") DEFERRABLE INITIALLY DEFERRED; ALTER TABLE "futures_driver_signals" ADD CONSTRAINT "futures_driver_signa_project_id_9865e82b_fk_futures_p" FOREIGN KEY ("project_id") REFERENCES "futures_projects" ("project_id") DEFERRABLE INITIALLY DEFERRED; ALTER TABLE "futures_driver_signals" ADD CONSTRAINT "futures_driver_signa_signal_id_8eae928b_fk_futures_s" FOREIGN KEY ("signal_id") REFERENCES "futures_signals" ("signal_id") DEFERRABLE INITIALLY DEFERRED; CREATE INDEX "futures_driver_signals_driver_id_32a4d5f8" ON "futures_driver_signals" ("driver_id"); CREATE INDEX "futures_driver_signals_project_id_9865e82b" ON "futures_driver_signals" ("project_id"); CREATE INDEX "futures_driver_signals_signal_id_8eae928b" ON "futures_driver_signals" ("signal_id"); -- futures 0003_alter_futuresdomaincategories_category_name_and_more -- -- Alter field category_name on futuresdomaincategories -- ALTER TABLE "futures_domain_categories" ALTER COLUMN "category_name" TYPE varchar(255); -- -- Alter field category_path on futuresdomaincategories -- ALTER TABLE "futures_domain_categories" ALTER COLUMN "category_path" TYPE varchar(512); -- futures 0004_remove_futuressignals_project_and_more -- -- Add field url_normalized to futuressignals -- ALTER TABLE "futures_signals" ADD COLUMN "url_normalized" varchar(1000) DEFAULT '' NOT NULL; ALTER TABLE "futures_signals" ALTER COLUMN "url_normalized" DROP DEFAULT; -- -- Raw Python operation -- -- THIS OPERATION CANNOT BE WRITTEN AS SQL CREATE INDEX "futures_signals_url_normalized_46906516" ON "futures_signals" ("url_normalized"); CREATE INDEX "futures_signals_url_normalized_46906516_like" ON "futures_signals" ("url_normalized" varchar_pattern_ops); -- futures 0005_remove_futuresscenarios_scenario_title_and_more -- -- Add field scenario_sections to futuresscenarios -- ALTER TABLE "futures_scenarios" ADD COLUMN "scenario_sections" jsonb DEFAULT '{}'::jsonb NOT NULL; ALTER TABLE "futures_scenarios" ALTER COLUMN "scenario_sections" DROP DEFAULT; -- futures 0006_futuresdrivers_created_on_and_more -- -- Add field created_on to futuresdrivers -- ALTER TABLE "futures_drivers" ADD COLUMN "created_on" timestamp with time zone DEFAULT '2025-11-08 01:22:13.254919+00:00'::timestamptz NOT NULL; ALTER TABLE "futures_drivers" ALTER COLUMN "created_on" DROP DEFAULT; -- -- Add field created_on to futuresscenariodrivers -- ALTER TABLE "futures_scenario_drivers" ADD COLUMN "created_on" timestamp with time zone DEFAULT '2025-11-08 01:22:13.264634+00:00'::timestamptz NOT NULL; ALTER TABLE "futures_scenario_drivers" ALTER COLUMN "created_on" DROP DEFAULT; -- -- Add field created_on to futuresscenarios -- ALTER TABLE "futures_scenarios" ADD COLUMN "created_on" timestamp with time zone DEFAULT '2025-11-08 01:22:13.276060+00:00'::timestamptz NOT NULL; ALTER TABLE "futures_scenarios" ALTER COLUMN "created_on" DROP DEFAULT; -- futures 0009_vision -- -- Create model Vision -- CREATE TABLE "futures_vision" ("id" uuid NOT NULL PRIMARY KEY, "statement" text NOT NULL, "prompts" jsonb NOT NULL, "status" varchar(10) NOT NULL, "updated_at" timestamp with time zone NOT NULL, "created_at" timestamp with time zone NOT NULL, "project_id" uuid NOT NULL UNIQUE, CONSTRAINT "unique_project_vision" UNIQUE ("project_id")); ALTER TABLE "futures_vision" ADD CONSTRAINT "futures_vision_project_id_838d3926_fk_futures_p" FOREIGN KEY ("project_id") REFERENCES "futures_projects" ("project_id") DEFERRABLE INITIALLY DEFERRED;