{ "generated_at": "2026-04-10T01:38:26.112134Z", "apps": [ "futures" ], "models": [ { "app": "futures", "model": "FuturesDomainCategories", "table": "futures_domain_categories", "fields": [ { "name": "category_id", "type": "uuid", "null": false, "default": "uuid.uuid4", "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "project_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_projects", "on_delete": "CASCADE" }, { "name": "category_name", "type": "varchar", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "parent_id", "type": "fk", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_domain_categories", "on_delete": "CASCADE" }, { "name": "category_path", "type": "varchar", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null } ], "relationships": [ { "type": "fk", "from": "futures_domain_categories", "field": "project_id", "to": "futures_projects" }, { "type": "fk", "from": "futures_domain_categories", "field": "parent_id", "to": "futures_domain_categories" } ], "unique_constraints": [] }, { "app": "futures", "model": "FuturesDriverSignals", "table": "futures_driver_signals", "fields": [ { "name": "id", "type": "integer", "null": false, "default": null, "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "driver_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_drivers", "on_delete": "CASCADE" }, { "name": "signal_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_signals", "on_delete": "CASCADE" }, { "name": "short_description", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "created_on", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "project_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_projects", "on_delete": "CASCADE" } ], "relationships": [ { "type": "fk", "from": "futures_driver_signals", "field": "driver_id", "to": "futures_drivers" }, { "type": "fk", "from": "futures_driver_signals", "field": "signal_id", "to": "futures_signals" }, { "type": "fk", "from": "futures_driver_signals", "field": "project_id", "to": "futures_projects" } ], "unique_constraints": [ [ "driver", "signal" ] ] }, { "app": "futures", "model": "FuturesDriverTrends", "table": "futures_driver_trends", "fields": [ { "name": "id", "type": "integer", "null": false, "default": null, "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "driver_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_drivers", "on_delete": "CASCADE" }, { "name": "trend_id", "type": "fk", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_steep_trend", "on_delete": "SET_NULL" }, { "name": "short_description", "type": "varchar", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "created_on", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "project_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_projects", "on_delete": "CASCADE" } ], "relationships": [ { "type": "fk", "from": "futures_driver_trends", "field": "driver_id", "to": "futures_drivers" }, { "type": "fk", "from": "futures_driver_trends", "field": "trend_id", "to": "futures_steep_trend" }, { "type": "fk", "from": "futures_driver_trends", "field": "project_id", "to": "futures_projects" } ], "unique_constraints": [] }, { "app": "futures", "model": "FuturesDrivers", "table": "futures_drivers", "fields": [ { "name": "driver_id", "type": "uuid", "null": false, "default": "uuid.uuid4", "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "driver_set_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_drivers_sets", "on_delete": "CASCADE" }, { "name": "driver_number", "type": "integer", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "driver_name", "type": "varchar", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "driver_description", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "weight_past", "type": "float", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "push_present", "type": "float", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "pull_future", "type": "float", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "created_on", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "last_modified", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "project_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_projects", "on_delete": "CASCADE" } ], "relationships": [ { "type": "fk", "from": "futures_drivers", "field": "driver_set_id", "to": "futures_drivers_sets" }, { "type": "fk", "from": "futures_drivers", "field": "project_id", "to": "futures_projects" } ], "unique_constraints": [] }, { "app": "futures", "model": "FuturesDriversSets", "table": "futures_drivers_sets", "fields": [ { "name": "driver_set_id", "type": "uuid", "null": false, "default": "uuid.uuid4", "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "driver_set_status", "type": "varchar", "null": false, "default": "status.DRAFT", "pk": false, "unique": false, "choices": [ "Draft", "Deprecated", "Final" ], "hint": null, "fk_to": null, "on_delete": null }, { "name": "created_on", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "project_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_projects", "on_delete": "CASCADE" } ], "relationships": [ { "type": "fk", "from": "futures_drivers_sets", "field": "project_id", "to": "futures_projects" } ], "unique_constraints": [] }, { "app": "futures", "model": "FuturesProjects", "table": "futures_projects", "fields": [ { "name": "project_id", "type": "uuid", "null": false, "default": "uuid.uuid4", "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "domain", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "client", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "geography", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "horizon", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "questions", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "created_on", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "is_public", "type": "boolean", "null": false, "default": "False", "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null } ], "relationships": [], "unique_constraints": [] }, { "app": "futures", "model": "FuturesScenarioDrivers", "table": "futures_scenario_drivers", "fields": [ { "name": "id", "type": "integer", "null": false, "default": null, "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "scenario_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_scenarios", "on_delete": "CASCADE" }, { "name": "driver_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_drivers", "on_delete": "CASCADE" }, { "name": "driver_value", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "created_on", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "last_modified", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "project_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_projects", "on_delete": "CASCADE" } ], "relationships": [ { "type": "fk", "from": "futures_scenario_drivers", "field": "scenario_id", "to": "futures_scenarios" }, { "type": "fk", "from": "futures_scenario_drivers", "field": "driver_id", "to": "futures_drivers" }, { "type": "fk", "from": "futures_scenario_drivers", "field": "project_id", "to": "futures_projects" } ], "unique_constraints": [ [ "scenario", "driver" ] ] }, { "app": "futures", "model": "FuturesScenarioSets", "table": "futures_scenario_sets", "fields": [ { "name": "scenario_set_id", "type": "uuid", "null": false, "default": "uuid.uuid4", "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "scenario_set_status", "type": "varchar", "null": false, "default": "status.DRAFT", "pk": false, "unique": false, "choices": [ "Draft", "Deprecated", "Final" ], "hint": null, "fk_to": null, "on_delete": null }, { "name": "created_on", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "project_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_projects", "on_delete": "CASCADE" }, { "name": "scenario_methodology", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "driver_set_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_drivers_sets", "on_delete": "CASCADE" } ], "relationships": [ { "type": "fk", "from": "futures_scenario_sets", "field": "project_id", "to": "futures_projects" }, { "type": "fk", "from": "futures_scenario_sets", "field": "driver_set_id", "to": "futures_drivers_sets" } ], "unique_constraints": [] }, { "app": "futures", "model": "FuturesScenarios", "table": "futures_scenarios", "fields": [ { "name": "scenario_id", "type": "uuid", "null": false, "default": "uuid.uuid4", "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "scenario_set_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_scenario_sets", "on_delete": "CASCADE" }, { "name": "scenario_logics", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "scenario_title", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "scenario_text", "type": "text", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "project_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_projects", "on_delete": "CASCADE" }, { "name": "created_on", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "last_modified", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "scenario_sections", "type": "json", "null": false, "default": "builtins.dict", "pk": false, "unique": false, "choices": null, "hint": { "type": "object", "properties": { "overview": { "type": "string" }, "narrative": { "type": "string" }, "timeline": { "type": "array", "items": { "type": "string" } }, "wildcards": { "type": "array", "items": { "type": "string" } } }, "required": [ "overview", "narrative" ] }, "fk_to": null, "on_delete": null } ], "relationships": [ { "type": "fk", "from": "futures_scenarios", "field": "scenario_set_id", "to": "futures_scenario_sets" }, { "type": "fk", "from": "futures_scenarios", "field": "project_id", "to": "futures_projects" } ], "unique_constraints": [] }, { "app": "futures", "model": "FuturesSignals", "table": "futures_signals", "fields": [ { "name": "signal_id", "type": "uuid", "null": false, "default": "uuid.uuid4", "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "title", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "author", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "source_name", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "url", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "signal_date", "type": "date", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "steep", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": [ "Social", "Technological", "Economic", "Environmental", "Political" ], "hint": null, "fk_to": null, "on_delete": null }, { "name": "horizon", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": [ "H1", "H2", "H3" ], "hint": null, "fk_to": null, "on_delete": null }, { "name": "keywords", "type": "json", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": { "type": "array", "items": { "type": "string" }, "example": [ "AI", "telehealth", "policy" ] }, "fk_to": null, "on_delete": null }, { "name": "signal_type", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": [ "Event", "Trend", "Plan", "Projection", "Issue", "Obstacle" ], "hint": null, "fk_to": null, "on_delete": null }, { "name": "description", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "change_desc", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "impact", "type": "integer", "null": true, "default": null, "pk": false, "unique": false, "choices": [ 0, 1, 2, 3, 4, 5 ], "hint": null, "fk_to": null, "on_delete": null }, { "name": "likelihood", "type": "integer", "null": true, "default": null, "pk": false, "unique": false, "choices": [ 0, 1, 2, 3, 4, 5 ], "hint": null, "fk_to": null, "on_delete": null }, { "name": "credibility", "type": "integer", "null": true, "default": null, "pk": false, "unique": false, "choices": [ 0, 1, 2, 3, 4, 5 ], "hint": null, "fk_to": null, "on_delete": null }, { "name": "novelty", "type": "integer", "null": true, "default": null, "pk": false, "unique": false, "choices": [ 0, 1, 2, 3, 4, 5 ], "hint": null, "fk_to": null, "on_delete": null }, { "name": "created_on", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "project_id", "type": "fk", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_projects", "on_delete": "CASCADE" }, { "name": "url_normalized", "type": "varchar", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "source_type", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": [ "manual", "link", "gdelt", "rss", "import" ], "hint": null, "fk_to": null, "on_delete": null }, { "name": "embedding", "type": "VectorField", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null } ], "relationships": [ { "type": "fk", "from": "futures_signals", "field": "project_id", "to": "futures_projects" } ], "unique_constraints": [] }, { "app": "futures", "model": "FuturesStakeholders", "table": "futures_stakeholders", "fields": [ { "name": "stakeholder_id", "type": "uuid", "null": false, "default": "uuid.uuid4", "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "project_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_projects", "on_delete": "CASCADE" }, { "name": "stakeholder_name", "type": "varchar", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null } ], "relationships": [ { "type": "fk", "from": "futures_stakeholders", "field": "project_id", "to": "futures_projects" } ], "unique_constraints": [] }, { "app": "futures", "model": "DigestUploadChunk", "table": "futures_digestuploadchunk", "fields": [ { "name": "id", "type": "integer", "null": false, "default": null, "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "task_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_apptask", "on_delete": "CASCADE" }, { "name": "chunk_index", "type": "integer", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "data", "type": "BinaryField", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null } ], "relationships": [ { "type": "fk", "from": "futures_digestuploadchunk", "field": "task_id", "to": "futures_apptask" } ], "unique_constraints": [] }, { "app": "futures", "model": "Vision", "table": "futures_vision", "fields": [ { "name": "id", "type": "uuid", "null": false, "default": "uuid.uuid4", "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "project_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": true, "choices": null, "hint": null, "fk_to": "futures_projects", "on_delete": "CASCADE" }, { "name": "statement", "type": "text", "null": false, "default": "''", "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "prompts", "type": "json", "null": false, "default": "builtins.list", "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "status", "type": "varchar", "null": false, "default": "Vision.Status.DRAFT", "pk": false, "unique": false, "choices": [ "Draft", "Final" ], "hint": null, "fk_to": null, "on_delete": null }, { "name": "updated_at", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "created_at", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null } ], "relationships": [ { "type": "one_to_one", "from": "futures_vision", "field": "project_id", "to": "futures_projects" } ], "unique_constraints": [ [ "project" ] ] }, { "app": "futures", "model": "FuturesArtifactSet", "table": "futures_artifact_sets", "fields": [ { "name": "artifact_set_id", "type": "uuid", "null": false, "default": "uuid.uuid4", "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "artifact_set_status", "type": "varchar", "null": false, "default": "status.DRAFT", "pk": false, "unique": false, "choices": [ "Draft", "Deprecated", "Final" ], "hint": null, "fk_to": null, "on_delete": null }, { "name": "created_on", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "project_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_projects", "on_delete": "CASCADE" }, { "name": "scenario_set_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_scenario_sets", "on_delete": "CASCADE" } ], "relationships": [ { "type": "fk", "from": "futures_artifact_sets", "field": "project_id", "to": "futures_projects" }, { "type": "fk", "from": "futures_artifact_sets", "field": "scenario_set_id", "to": "futures_scenario_sets" } ], "unique_constraints": [] }, { "app": "futures", "model": "SteepTrend", "table": "futures_steep_trend", "fields": [ { "name": "trend_id", "type": "uuid", "null": false, "default": "uuid.uuid4", "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "steep", "type": "varchar", "null": false, "default": null, "pk": false, "unique": false, "choices": [ "Social", "Technological", "Economic", "Environmental", "Political" ], "hint": null, "fk_to": null, "on_delete": null }, { "name": "topic", "type": "varchar", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "name", "type": "varchar", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "summary", "type": "text", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "detail", "type": "text", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "source_label", "type": "varchar", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "source_url", "type": "varchar", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "status", "type": "varchar", "null": false, "default": "SteepTrend.Status.WATCHING", "pk": false, "unique": false, "choices": [ "active", "watching", "archived" ], "hint": null, "fk_to": null, "on_delete": null }, { "name": "last_synthesized_at", "type": "date", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "embedding", "type": "VectorField", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "created_on", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "updated_on", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null } ], "relationships": [], "unique_constraints": [] }, { "app": "futures", "model": "SteepTrendEvidence", "table": "futures_steep_trend_evidence", "fields": [ { "name": "evidence_id", "type": "uuid", "null": false, "default": "uuid.uuid4", "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "trend_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_steep_trend", "on_delete": "CASCADE" }, { "name": "signal_id", "type": "fk", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_signals", "on_delete": "SET_NULL" }, { "name": "news_item_id", "type": "fk", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_newsitem", "on_delete": "SET_NULL" }, { "name": "source_label", "type": "varchar", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "source_url", "type": "varchar", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "is_contrary", "type": "boolean", "null": false, "default": "False", "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "relevance_note", "type": "text", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "added_at", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "expires_at", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null } ], "relationships": [ { "type": "fk", "from": "futures_steep_trend_evidence", "field": "trend_id", "to": "futures_steep_trend" }, { "type": "fk", "from": "futures_steep_trend_evidence", "field": "signal_id", "to": "futures_signals" }, { "type": "fk", "from": "futures_steep_trend_evidence", "field": "news_item_id", "to": "futures_newsitem" } ], "unique_constraints": [] }, { "app": "futures", "model": "TrendRecommendation", "table": "futures_trend_recommendation", "fields": [ { "name": "rec_id", "type": "uuid", "null": false, "default": "uuid.uuid4", "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "task_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_apptask", "on_delete": "CASCADE" }, { "name": "kind", "type": "varchar", "null": false, "default": null, "pk": false, "unique": false, "choices": [ "add", "update", "archive", "change_status", "merge", "split", "attach_evidence", "flag_contrary", "consolidate_topics", "flag_weak_evidence" ], "hint": null, "fk_to": null, "on_delete": null }, { "name": "status", "type": "varchar", "null": false, "default": "TrendRecommendation.Status.PENDING", "pk": false, "unique": false, "choices": [ "pending", "approved", "denied" ], "hint": null, "fk_to": null, "on_delete": null }, { "name": "justification", "type": "text", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "target_trend_id", "type": "fk", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_steep_trend", "on_delete": "SET_NULL" }, { "name": "proposed_data", "type": "json", "null": false, "default": "builtins.dict", "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "created_at", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "reviewed_at", "type": "date", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "reviewed_by_id", "type": "fk", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "users_user", "on_delete": "SET_NULL" }, { "name": "reviewer_note", "type": "varchar", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null } ], "relationships": [ { "type": "fk", "from": "futures_trend_recommendation", "field": "task_id", "to": "futures_apptask" }, { "type": "fk", "from": "futures_trend_recommendation", "field": "target_trend_id", "to": "futures_steep_trend" }, { "type": "fk", "from": "futures_trend_recommendation", "field": "reviewed_by_id", "to": "users_user" } ], "unique_constraints": [] }, { "app": "futures", "model": "TrendsConfig", "table": "futures_trends_config", "fields": [ { "name": "id", "type": "integer", "null": false, "default": null, "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "access_level", "type": "varchar", "null": false, "default": "TrendsConfig.Access.STAFF", "pk": false, "unique": false, "choices": [ "staff", "paying", "members" ], "hint": null, "fk_to": null, "on_delete": null }, { "name": "discovery_processed_through", "type": "date", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "signals_curated_through_date", "type": "date", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null } ], "relationships": [], "unique_constraints": [] }, { "app": "futures", "model": "FuturesArtifacts", "table": "futures_artifacts", "fields": [ { "name": "artifact_id", "type": "uuid", "null": false, "default": "uuid.uuid4", "pk": true, "unique": true, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "artifact_set_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_artifact_sets", "on_delete": "CASCADE" }, { "name": "scenario_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_scenarios", "on_delete": "CASCADE" }, { "name": "project_id", "type": "fk", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": "futures_projects", "on_delete": "CASCADE" }, { "name": "title", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "artifact_type", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "who_uses_it", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "significance", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "relationship_to_scenario", "type": "varchar", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "image", "type": "ImageField", "null": true, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "created_on", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null }, { "name": "last_modified", "type": "date", "null": false, "default": null, "pk": false, "unique": false, "choices": null, "hint": null, "fk_to": null, "on_delete": null } ], "relationships": [ { "type": "fk", "from": "futures_artifacts", "field": "artifact_set_id", "to": "futures_artifact_sets" }, { "type": "fk", "from": "futures_artifacts", "field": "scenario_id", "to": "futures_scenarios" }, { "type": "fk", "from": "futures_artifacts", "field": "project_id", "to": "futures_projects" } ], "unique_constraints": [] } ] }