Skip to content

Instantly share code, notes, and snippets.

@jonathanperret

jonathanperret/carnet_de_bord.azimutt.json

Last active September 13, 2023 08:40
Show Gist options
  • Save jonathanperret/a9a596f8901c7ec6e56a26fdb5c6110e to your computer and use it in GitHub Desktop.
Save jonathanperret/a9a596f8901c7ec6e56a26fdb5c6110e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
carnet_de_bord.azimutt.json
{
"id": "00000000-0000-0000-0000-000000000000",
"name": "carnet_de_bord-2023-09-13T07:45:58.json",
"sources": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"name": "carnet_de_bord-2023-09-13T07:45:58.json",
"kind": {
"kind": "JsonLocalFile",
"name": "carnet_de_bord-2023-09-13T07:45:58.json",
"size": 116750,
"modified": 1694591158000
},
"content": [],
"tables": [
{
"schema": "hdb_catalog",
"table": "hdb_action_log",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "hdb_catalog.gen_hasura_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "action_name",
"type": "text",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "input_payload",
"type": "jsonb",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "request_headers",
"type": "jsonb",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "session_variables",
"type": "jsonb",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "response_payload",
"type": "jsonb",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "errors",
"type": "jsonb",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "response_received_at",
"type": "timestamp with time zone",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "status",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "hdb_action_log_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"checks": [
{
"name": "hdb_action_log_status_check",
"columns": [
"status"
],
"predicate": "(status = ANY (ARRAY['created'::text, 'processing'::text, 'completed'::text, 'error'::text]))",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "hdb_catalog",
"table": "hdb_cron_event_invocation_logs",
"columns": [
{
"name": "id",
"type": "text",
"default": "hdb_catalog.gen_hasura_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "event_id",
"type": "text",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "status",
"type": "integer",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "request",
"type": "json",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "response",
"type": "json",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"nullable": true,
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "hdb_cron_event_invocation_logs_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"indexes": [
{
"name": "hdb_cron_event_invocation_event_id",
"columns": [
"event_id"
],
"definition": "btree (event_id)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "hdb_catalog",
"table": "hdb_cron_events",
"columns": [
{
"name": "id",
"type": "text",
"default": "hdb_catalog.gen_hasura_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "trigger_name",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "scheduled_time",
"type": "timestamp with time zone",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "status",
"type": "text",
"default": "'scheduled'::text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "tries",
"type": "integer",
"default": "0",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"nullable": true,
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "next_retry_at",
"type": "timestamp with time zone",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "hdb_cron_events_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "hdb_cron_events_unique_scheduled",
"columns": [
"trigger_name",
"scheduled_time"
],
"definition": "btree (trigger_name, scheduled_time) WHERE status = 'scheduled'::text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"indexes": [
{
"name": "hdb_cron_event_status",
"columns": [
"status"
],
"definition": "btree (status)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"checks": [
{
"name": "valid_status",
"columns": [
"status"
],
"predicate": "(status = ANY (ARRAY['scheduled'::text, 'locked'::text, 'delivered'::text, 'error'::text, 'dead'::text]))",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "hdb_catalog",
"table": "hdb_metadata",
"columns": [
{
"name": "id",
"type": "integer",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "metadata",
"type": "json",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "resource_version",
"type": "integer",
"default": "1",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "hdb_metadata_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "hdb_metadata_resource_version_key",
"columns": [
"resource_version"
],
"definition": "btree (resource_version)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "hdb_catalog",
"table": "hdb_scheduled_event_invocation_logs",
"columns": [
{
"name": "id",
"type": "text",
"default": "hdb_catalog.gen_hasura_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "event_id",
"type": "text",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "status",
"type": "integer",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "request",
"type": "json",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "response",
"type": "json",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"nullable": true,
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "hdb_scheduled_event_invocation_logs_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "hdb_catalog",
"table": "hdb_scheduled_events",
"columns": [
{
"name": "id",
"type": "text",
"default": "hdb_catalog.gen_hasura_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "webhook_conf",
"type": "json",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "scheduled_time",
"type": "timestamp with time zone",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "retry_conf",
"type": "json",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "payload",
"type": "json",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "header_conf",
"type": "json",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "status",
"type": "text",
"default": "'scheduled'::text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "tries",
"type": "integer",
"default": "0",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"nullable": true,
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "next_retry_at",
"type": "timestamp with time zone",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "comment",
"type": "text",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "hdb_scheduled_events_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"indexes": [
{
"name": "hdb_scheduled_event_status",
"columns": [
"status"
],
"definition": "btree (status)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"checks": [
{
"name": "valid_status",
"columns": [
"status"
],
"predicate": "(status = ANY (ARRAY['scheduled'::text, 'locked'::text, 'delivered'::text, 'error'::text, 'dead'::text]))",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "hdb_catalog",
"table": "hdb_schema_notifications",
"columns": [
{
"name": "id",
"type": "integer",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notification",
"type": "json",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "resource_version",
"type": "integer",
"default": "1",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "instance_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"nullable": true,
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "hdb_schema_notifications_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"checks": [
{
"name": "hdb_schema_notifications_id_check",
"columns": [
"id"
],
"predicate": "(id = 1)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "hdb_catalog",
"table": "hdb_version",
"columns": [
{
"name": "hasura_uuid",
"type": "uuid",
"default": "hdb_catalog.gen_hasura_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "version",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "upgraded_on",
"type": "timestamp with time zone",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "cli_state",
"type": "jsonb",
"default": "'{}'::jsonb",
"columns": [
{
"name": "settings",
"type": "Object",
"columns": [
{
"name": "migration_mode",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "migrations",
"type": "Object",
"columns": [
{
"name": "carnet_de_bord",
"type": "Object",
"columns": [
{
"name": "1627477968727",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1629385138451",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1630489662804",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1630657910465",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1631030441995",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1631103338959",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1631522881439",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1631523269288",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1631609342756",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1631628415953",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1631628461201",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1631791942658",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1632141402215",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1632250782346",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1632475175410",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1632475184221",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1632909951670",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1635157124822",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1635180194757",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1635250408042",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1636014187087",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1636061553772",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1636473368023",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1636972069991",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1637072464419",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1637228317847",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1638198107961",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1638200411278",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1638284490463",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1639487749105",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1641897839853",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1642686957723",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1642687324219",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1643276813108",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1643639454989",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1643721328820",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1643879407459",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1644337776226",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1645032690130",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1645388112574",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1645522376586",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1645632361083",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1645784287613",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1645787372124",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1646041002160",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1646132441749",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1646932547523",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1646947685577",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1647357936182",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1647540707476",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1648464159795",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1648464159796",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1649937760372",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1650979648159",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1652363016560",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1652719748589",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1653319594182",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1653398280578",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1653399022983",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1653842432201",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1655396477440",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1655740534831",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1655901967843",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1656341597628",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1656508674703",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1656508700081",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1656924228182",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1656938801649",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1657183288078",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1661774060280",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1661932837319",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1662401213060",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1662997881814",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1662997905742",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1662998098847",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1663750758041",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1664461915466",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1664790703990",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1664917252319",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1665481676818",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1666421645398",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1666803142735",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1666902217239",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1668634031211",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1669048458209",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1669222003536",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1669322112555",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1669650568906",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1670403426683",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1670839941366",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1670841382499",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1670942301458",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1671012020468",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1671553444065",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1672741051729",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1672749193531",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1672828442980",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1672870195818",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1672908864766",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1673345447763",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1673430035903",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1674050275074",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1674589230652",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1674770534898",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1675255129484",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1675784882824",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1675941150892",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1676995035581",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1677098994655",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1677140195658",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1677152492575",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1677530150445",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1677550512224",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1677766016033",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1678120606346",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1678134062555",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1678283834781",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1678785541856",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1678982297641",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1678982351351",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1678985287261",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1678998383915",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1679604766429",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1680096458370",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1680096458377",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1680782163315",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1681305548513",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1682543337664",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1683096909827",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1683211299655",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1683801154520",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1684311013795",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1684333811675",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1684334642154",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1684334846968",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1684934249002",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1685617220624",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1685647584426",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1685994546326",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1686148392370",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1686565344352",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1686581427531",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1686819160057",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1687180495589",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1688421552435",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1688569331521",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1688570757839",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1688627437320",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1690201898828",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1690290906168",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1690291318350",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1690291389487",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1690467448554",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1691064712005",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1691584295337",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1691672216031",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1693386612650",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1693388929776",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1693401046986",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "1693895458197",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "isStateCopyCompleted",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "console_state",
"type": "jsonb",
"default": "'{}'::jsonb",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "ee_client_id",
"type": "text",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "ee_client_secret",
"type": "text",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "hdb_version_pkey",
"columns": [
"hasura_uuid"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "hdb_version_one_row",
"columns": [
"unknown"
],
"definition": "btree ((version IS NOT NULL))",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "account",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "public.gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "username",
"type": "character varying(255)",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "type",
"type": "character varying(255)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "access_key",
"type": "character varying(255)",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "access_key_date",
"type": "timestamp with time zone",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "last_login",
"type": "timestamp with time zone",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "beneficiary_id",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "professional_id",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "admin_id",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "confirmed",
"type": "boolean",
"default": "false",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "onboarding_done",
"type": "boolean",
"nullable": true,
"default": "false",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "manager_id",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "admin_structure_id",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "orientation_manager_id",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "deleted_at",
"type": "timestamp with time zone",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "account_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "account_admin_id_key",
"columns": [
"admin_id"
],
"definition": "btree (admin_id)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "account_admin_structure_id_key",
"columns": [
"admin_structure_id"
],
"definition": "btree (admin_structure_id)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "account_beneficiary_id_key",
"columns": [
"beneficiary_id"
],
"definition": "btree (beneficiary_id)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "account_manager_id_key",
"columns": [
"manager_id"
],
"definition": "btree (manager_id)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "account_professional_id_key",
"columns": [
"professional_id"
],
"definition": "btree (professional_id)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "account_username_unique",
"columns": [
"username"
],
"definition": "btree (username)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"checks": [
{
"name": "Account must be linked to a profile of the right type",
"columns": [
"type",
"manager_id",
"beneficiary_id",
"professional_id",
"admin_id",
"admin_structure_id",
"orientation_manager_id"
],
"predicate": "(type::text = 'manager'::text AND manager_id IS NOT NULL OR type::text = 'beneficiary'::text AND beneficiary_id IS NOT NULL OR type::text = 'professional'::text AND professional_id IS NOT NULL OR type::text = 'admin_cdb'::text AND admin_id IS NOT NULL OR type::text = 'admin_structure'::text AND admin_structure_id IS NOT NULL OR type::text = 'orientation_manager'::text AND orientation_manager_id IS NOT NULL OR type::text = 'service'::text)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "account_info",
"view": true,
"columns": [
{
"name": "account_id",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "firstname",
"type": "character varying",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "lastname",
"type": "character varying",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "email",
"type": "citext",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "action_status",
"columns": [
{
"name": "status",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "action_status_pkey",
"columns": [
"status"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"comment": {
"text": "available actions status",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "admin_cdb",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "public.gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "email",
"type": "citext",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "firstname",
"type": "character varying",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "lastname",
"type": "character varying",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "admin_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "admin_email_unique",
"columns": [
"email"
],
"definition": "btree (email)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "admin_structure",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "firstname",
"type": "character varying",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "lastname",
"type": "character varying",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "email",
"type": "citext",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "phone_numbers",
"type": "character varying",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "position",
"type": "character varying",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "deployment_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "admin_structure_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "admin_structure_email_key",
"columns": [
"email"
],
"definition": "btree (email)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"comment": {
"text": "Table of structure manager, handle pro and brsa attachment",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "admin_structure_structure",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "admin_structure_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "structure_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "deleted_at",
"type": "timestamp with time zone",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "admin_structure_structure_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "admin_structure_structure_admin_structure_id_structure_id_key",
"columns": [
"admin_structure_id",
"structure_id"
],
"definition": "btree (admin_structure_id, structure_id)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"comment": {
"text": "associative table between admin_structure and structure (many ot many)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "beneficiary",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "public.gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "email",
"type": "citext",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "lastname",
"type": "character varying(255)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "firstname",
"type": "character varying(255)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "caf_number",
"type": "character varying(255)",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "pe_number",
"type": "character varying(255)",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "postal_code",
"type": "character varying(255)",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "city",
"type": "character varying(255)",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "address1",
"type": "character varying(255)",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "address2",
"type": "character varying(255)",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "mobile_number",
"type": "character varying(255)",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "date_of_birth",
"type": "date",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "deployment_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "external_id",
"type": "text",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "place_of_birth",
"type": "character varying",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "nir",
"type": "character varying(13)",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "pe_unique_import_id",
"type": "text",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "right_rsa",
"type": "character varying",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "right_are",
"type": "boolean",
"default": "false",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "right_ass",
"type": "boolean",
"default": "false",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "right_bonus",
"type": "boolean",
"default": "false",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "is_homeless",
"type": "boolean",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "subject_to_right_and_duty",
"type": "boolean",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "rsa_suspension_reason",
"type": "text",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "rsa_closure_reason",
"type": "text",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "rsa_closure_date",
"type": "date",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "beneficiary_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "beneficiary_deployment_id_external_id_key",
"columns": [
"deployment_id",
"external_id"
],
"definition": "btree (deployment_id, external_id)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "beneficiary_nir_key",
"columns": [
"nir"
],
"definition": "btree (nir)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "firstname_lastname_date_of_birth_unique_idx",
"columns": [
"unknown",
"unknown",
"date_of_birth",
"deployment_id"
],
"definition": "btree (lower(btrim(firstname::text)), lower(btrim(lastname::text)), date_of_birth, deployment_id)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "beneficiary_structure",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "beneficiary_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "structure_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "status",
"type": "character varying",
"default": "'current'::character varying",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "data",
"type": "jsonb",
"default": "jsonb_build_object()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "beneficiary_structure_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"comment": {
"text": "associative table between beneficiary and structure (many ot many)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "contract_type",
"columns": [
{
"name": "id",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "label",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "contract_type_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "deployment",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "public.gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "label",
"type": "character varying",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "config",
"type": "jsonb",
"nullable": true,
"columns": [
{
"name": "enable_pe_diagnostic_api",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "url",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "headers",
"type": "Object",
"columns": [
{
"name": "token",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "callback",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "department_code",
"type": "character varying",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "deployment_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"comment": {
"text": "list of carnet-de-bord deployments",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "employment_type",
"columns": [
{
"name": "id",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "label",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "employment_type_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "external_data",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "source",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "data",
"type": "jsonb",
"columns": [
{
"name": "contraintesIndividusDto",
"type": "Object",
"columns": [
{
"name": "code",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "libelle",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "conseiller",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "contraintes",
"type": "Object[]",
"columns": [
{
"name": "code",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "date",
"type": "string",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "valeur",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "libelle",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "objectifs",
"type": "Object[]",
"columns": [
{
"name": "code",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "valeur",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "libelle",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "situations",
"type": "Object[]",
"columns": [
{
"name": "code",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "valeur",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "libelle",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "dateDeModification",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "besoinsParDiagnosticIndividuDtos",
"type": "Object[]",
"columns": [
{
"name": "statut",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "besoins",
"type": "Object[]",
"columns": [
{
"name": "code",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "valeur",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "libelle",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "nomMetier",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "typologie",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "estPrioritaire",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "idMetierChiffre",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "dateMiseAJour",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "parsed",
"type": "Object",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "source",
"type": "Object",
"columns": [
{
"name": "dr",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "nom",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "brsa",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "prenom",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "rome_1",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "rome_2",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "civilite",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "dif_sante",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "departement",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "inscription",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "suivi_debut",
"type": "null",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "dif_logement",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "referent_nom",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "struct_suivi",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "der_entretien",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "dif_admin_jur",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "dif_familiale",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "dif_inser_com",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "dif_transport",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "referent_mail",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "adresse_ligne2",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "adresse_ligne3",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "adresse_ligne4",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "adresse_ligne5",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "adresse_ligne6",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "date_naissance",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "dif_financiere",
"type": "boolean",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "lieu_naissance",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "suivi_fin_prev",
"type": "null",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "referent_prenom",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "appelation_rome_1",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "appelation_rome_2",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "motif_inscription",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "referent_civilite",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "struct_principale",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "der_entretien_ppae",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "code_lieu_naissance",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "categorie_inscription",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "identifiant_unique_de",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "code_motif_inscription",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "modalite_accompagnement",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "mrech_axetravailprincipal",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "mrech_axetravailsecondaire",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "hash",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"nullable": true,
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"nullable": true,
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "external_data_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "external_data_info",
"columns": [
{
"name": "external_data_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "beneficiary_id",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "professional_id",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "external_data_info_pkey",
"columns": [
"external_data_id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "external_source",
"columns": [
{
"name": "value",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "comment",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "external_source_pkey",
"columns": [
"value"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "manager",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "email",
"type": "email",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "firstname",
"type": "character varying",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "lastname",
"type": "character varying",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "deployment_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "manager_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "manager_email_deployment_id_key",
"columns": [
"email",
"deployment_id"
],
"definition": "btree (email, deployment_id)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"comment": {
"text": "A manager handle structure and professional for a given deployment",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "notebook",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "public.gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "beneficiary_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "right_rqth",
"type": "boolean",
"default": "false",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "education_level",
"type": "character varying",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "work_situation_date",
"type": "date",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "contract_type",
"type": "character varying",
"nullable": true,
"values": [
"cer"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "contract_sign_date",
"type": "date",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "work_situation",
"type": "character varying",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "work_situation_end_date",
"type": "date",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "contract_start_date",
"type": "date",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "contract_end_date",
"type": "date",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "last_job_ended_at",
"type": "date",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "diagnostic_fetched_at",
"type": "timestamp with time zone",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "notebook_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "notebook_beneficiary_id_key",
"columns": [
"beneficiary_id"
],
"definition": "btree (beneficiary_id)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "notebook_action",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "action",
"type": "character varying",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "target_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "status",
"type": "character varying",
"default": "'in_progress'::character varying",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "creator_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "starting_at",
"type": "timestamp with time zone",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "notebook_action_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "notebook_appointment",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "account_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "date",
"type": "timestamp with time zone",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "status",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"nullable": true,
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"nullable": true,
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "deleted_by",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "deleted_at",
"type": "timestamp with time zone",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "notebook_appointment_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "notebook_creation",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "creator_account_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "source",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "notebook_creation_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"comment": {
"text": "tracks notebook creations",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "notebook_creation_source_type",
"columns": [
{
"name": "id",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "comment",
"type": "text",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "notebook_creation_source_type_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"comment": {
"text": "Enum table which contains available sources that create notebooks",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "notebook_event",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "public.gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "creation_date",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "event_date",
"type": "timestamp with time zone",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "creator_id",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "event",
"type": "jsonb",
"columns": [
{
"name": "status",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "category",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "event_label",
"type": "string",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "event_type",
"type": "text",
"values": [
"action",
"target"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "notebook_event_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "notebook_event_type",
"columns": [
{
"name": "value",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "comment",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "notebook_event_type_pkey",
"columns": [
"value"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "notebook_focus",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "theme",
"type": "character varying",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "creator_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "notebook_focus_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "notebook_info",
"columns": [
{
"name": "notebook_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "orientation_system_id",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "orientation_reason",
"type": "text",
"nullable": true,
"comment": {
"text": "motif de l'orientation, saisi par le chargé d'orientation",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "notebook_info_pkey",
"columns": [
"notebook_id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"comment": {
"text": "notebook orientation infos",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "notebook_member",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "public.gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "account_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "last_visited_at",
"type": "timestamp with time zone",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "member_type",
"type": "character varying",
"values": [
"no_referent",
"orientation_manager",
"referent"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "last_modified_at",
"type": "timestamp with time zone",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "creator_id",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "invitation_sent_at",
"type": "timestamp with time zone",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "active",
"type": "boolean",
"default": "true",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "membership_ended_at",
"type": "timestamp with time zone",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "notebook_member_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "notebook_member_notebook_id_account_id_if_active",
"columns": [
"notebook_id",
"account_id"
],
"definition": "btree (notebook_id, account_id) WHERE active",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_member_unique_referent",
"columns": [
"notebook_id"
],
"definition": "btree (notebook_id) WHERE active AND member_type::text = 'referent'::text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"indexes": [
{
"name": "notebook_member_notebook_id",
"columns": [
"notebook_id"
],
"definition": "btree (notebook_id)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "notebook_public_view",
"view": true,
"columns": [
{
"name": "id",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "beneficiary_id",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "notebook_situation",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "situation_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_by",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "deleted_at",
"type": "timestamp with time zone",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "deleted_by",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "notebook_situation_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "notebook_situation_notebook_id_situation_id_deleted_at_key",
"columns": [
"notebook_id",
"situation_id",
"deleted_at"
],
"definition": "btree (notebook_id, situation_id, deleted_at)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "notebook_target",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "focus_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "target",
"type": "character varying",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "creator_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "status",
"type": "character varying",
"default": "'in_progress'::character varying",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "linked_to",
"type": "character varying",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "notebook_target_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "notebook_target_focus_id_target_key",
"columns": [
"focus_id",
"target"
],
"definition": "btree (focus_id, target)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "notebook_update",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "account_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "type",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "notebook_update_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "notebook_visit",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "account_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "visited_at",
"type": "timestamp with time zone",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "notebook_visit_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"indexes": [
{
"name": "notebook_visit_visited_at_account_key",
"columns": [
"visited_at",
"account_id"
],
"definition": "btree (visited_at, account_id)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"comment": {
"text": "store notebook visit on a given notebook",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "nps_rating",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "account_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "score",
"type": "integer",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "nps_rating_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"checks": [
{
"name": "score_between_0_and_10",
"columns": [
"score"
],
"predicate": "(score >= 0 AND score <= 10)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"comment": {
"text": "NPS ratings from users",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "nps_rating_dismissal",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "account_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "dismissed_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "nps_rating_dismissal_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"comment": {
"text": "Store when a user dismisses an NPS rating",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "orientation_manager",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "firstname",
"type": "character varying",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "lastname",
"type": "character varying",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "email",
"type": "citext",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "phone_numbers",
"type": "character varying",
"nullable": true,
"comment": {
"text": "liste des numéros de téléphones séparés par des virgules",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "deployment_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "orientation_manager_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "orientation_manager_email_key",
"columns": [
"email"
],
"definition": "btree (email)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"comment": {
"text": "Table des chargés d’orientation",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "orientation_request",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "beneficiary_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "requestor_account_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "status",
"type": "text",
"nullable": true,
"default": "'pending'::text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "decided_at",
"type": "timestamp with time zone",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "reason",
"type": "text",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "requested_orientation_system_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "decided_orientation_system_id",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "decision_reason",
"type": "text",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "orientation_request_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "orientation_system",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "name",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "orientation_type",
"type": "text",
"values": [
"autre",
"pro",
"social",
"sociopro"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "deployment_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "orientation_system_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "name_deployment_id_unique_idx",
"columns": [
"unknown",
"deployment_id"
],
"definition": "btree (lower(btrim(name)), deployment_id)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "orientation_type",
"columns": [
{
"name": "id",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "label",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "orientation_type_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"comment": {
"text": "table contenant les différents types d’orientation",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "professional",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "public.gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "structure_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "email",
"type": "citext",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "lastname",
"type": "character varying(255)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "firstname",
"type": "character varying(255)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "position",
"type": "text",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "mobile_number",
"type": "character varying",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "professional_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "professional_email_unique",
"columns": [
"email"
],
"definition": "btree (email)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "professional_orientation_system",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "professional_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "orientation_system_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "professional_orientation_system_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "professional_orientation_system_professional_id_orientation_sys",
"columns": [
"professional_id",
"orientation_system_id"
],
"definition": "btree (professional_id, orientation_system_id)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "professional_project",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "rome_code_id",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"nullable": true,
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"nullable": true,
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "mobility_radius",
"type": "integer",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "hourly_rate",
"type": "integer",
"nullable": true,
"comment": {
"text": "in cents (divide by 100 for the EUR value)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "contract_type_id",
"type": "text",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "employment_type_id",
"type": "text",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_by",
"type": "uuid",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "professional_project_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "notebook_id_rome_code_id_null_idx",
"columns": [
"notebook_id",
"unknown"
],
"definition": "btree (notebook_id, COALESCE(rome_code_id, '00000000-0000-0000-0000-000000000000'::uuid))",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"checks": [
{
"name": "hourly-rate-gt-zero",
"columns": [
"hourly_rate"
],
"predicate": "(hourly_rate > 0)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "mobility-radius-ge-zero",
"columns": [
"mobility_radius"
],
"predicate": "(mobility_radius >= 0)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"comment": {
"text": "Stores the jobs wanted for a notebook beneficiary",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "ref_action",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "description",
"type": "character varying",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "theme",
"type": "text",
"default": "'none'::character varying",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "ref_action_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "ref_situation",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "description",
"type": "character varying",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "theme",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "ref_situation_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "ref_target",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "description",
"type": "character varying",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "theme",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "ref_target_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "ref_theme",
"columns": [
{
"name": "name",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "label",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "ref_theme_pkey",
"columns": [
"name"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"comment": {
"text": "contains the availables themes for focus, sitations, targets, actions",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "role",
"columns": [
{
"name": "label",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "role_pkey",
"columns": [
"label"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"comment": {
"text": "liste des roles",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "rome_code",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "code",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "description",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "label",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "rome_codes_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "rome_codes_label_key",
"columns": [
"label"
],
"definition": "btree (label)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "rsa_closure_reason",
"columns": [
{
"name": "code",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "label",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "rsa_closure_reason_pkey",
"columns": [
"code"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"comment": {
"text": "code and reason for rsa closure reason",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "rsa_suspension_reason",
"columns": [
{
"name": "code",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "label",
"type": "text",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "rsa_suspension_reason_pkey",
"columns": [
"code"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"comment": {
"text": "rsa suspension code and reason for enum",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "structure",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "public.gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "siret",
"type": "character varying(255)",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "name",
"type": "citext",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "short_desc",
"type": "text",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "phone",
"type": "character varying(255)",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "email",
"type": "character varying(255)",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "postal_code",
"type": "character varying(255)",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "city",
"type": "character varying(255)",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "address1",
"type": "character varying(255)",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "address2",
"type": "character varying(255)",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"nullable": true,
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "updated_at",
"type": "timestamp with time zone",
"nullable": true,
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "website",
"type": "character varying",
"nullable": true,
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "deployment_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "sensitive",
"type": "boolean",
"default": "false",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "structure_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "structure_name_deployment_id_key",
"columns": [
"name",
"deployment_id"
],
"definition": "btree (name, deployment_id)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"table": "structure_orientation_system",
"columns": [
{
"name": "id",
"type": "uuid",
"default": "gen_random_uuid()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "created_at",
"type": "timestamp with time zone",
"default": "now()",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "structure_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "orientation_system_id",
"type": "uuid",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"primaryKey": {
"name": "structure_orientation_system_pkey",
"columns": [
"id"
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
"uniques": [
{
"name": "structure_orientation_system_structure_id_orientation_system_id",
"columns": [
"structure_id",
"orientation_system_id"
],
"definition": "btree (structure_id, orientation_system_id)",
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"relations": [
{
"name": "hdb_cron_event_invocation_logs_event_id_fkey",
"src": {
"table": "hdb_catalog.hdb_cron_event_invocation_logs",
"column": "event_id"
},
"ref": {
"table": "hdb_catalog.hdb_cron_events",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "hdb_scheduled_event_invocation_logs_event_id_fkey",
"src": {
"table": "hdb_catalog.hdb_scheduled_event_invocation_logs",
"column": "event_id"
},
"ref": {
"table": "hdb_catalog.hdb_scheduled_events",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "account_admin_id_foreign",
"src": {
"table": "public.account",
"column": "admin_id"
},
"ref": {
"table": "public.admin_cdb",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "account_admin_structure_id_fkey",
"src": {
"table": "public.account",
"column": "admin_structure_id"
},
"ref": {
"table": "public.admin_structure",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "account_beneficiary_id_foreign",
"src": {
"table": "public.account",
"column": "beneficiary_id"
},
"ref": {
"table": "public.beneficiary",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "account_manager_id_fkey",
"src": {
"table": "public.account",
"column": "manager_id"
},
"ref": {
"table": "public.manager",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "account_orientation_manager_id_fkey",
"src": {
"table": "public.account",
"column": "orientation_manager_id"
},
"ref": {
"table": "public.orientation_manager",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "account_professional_id_foreign",
"src": {
"table": "public.account",
"column": "professional_id"
},
"ref": {
"table": "public.professional",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "account_type_fkey",
"src": {
"table": "public.account",
"column": "type"
},
"ref": {
"table": "public.role",
"column": "label"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "admin_structure_deployment_id_fkey",
"src": {
"table": "public.admin_structure",
"column": "deployment_id"
},
"ref": {
"table": "public.deployment",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "admin_structure_structure_admin_structure_id_fkey",
"src": {
"table": "public.admin_structure_structure",
"column": "admin_structure_id"
},
"ref": {
"table": "public.admin_structure",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "admin_structure_structure_structure_id_fkey",
"src": {
"table": "public.admin_structure_structure",
"column": "structure_id"
},
"ref": {
"table": "public.structure",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "beneficiary_deployment_id_fkey",
"src": {
"table": "public.beneficiary",
"column": "deployment_id"
},
"ref": {
"table": "public.deployment",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "beneficiary_rsa_closure_reason_fkey",
"src": {
"table": "public.beneficiary",
"column": "rsa_closure_reason"
},
"ref": {
"table": "public.rsa_closure_reason",
"column": "code"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "beneficiary_rsa_suspension_reason_fkey",
"src": {
"table": "public.beneficiary",
"column": "rsa_suspension_reason"
},
"ref": {
"table": "public.rsa_suspension_reason",
"column": "code"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "beneficiary_structure_beneficiary_id_fkey",
"src": {
"table": "public.beneficiary_structure",
"column": "beneficiary_id"
},
"ref": {
"table": "public.beneficiary",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "beneficiary_structure_structure_id_fkey",
"src": {
"table": "public.beneficiary_structure",
"column": "structure_id"
},
"ref": {
"table": "public.structure",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "external_data_source_fkey",
"src": {
"table": "public.external_data",
"column": "source"
},
"ref": {
"table": "public.external_source",
"column": "value"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "external_data_info_beneficiary_id_fkey",
"src": {
"table": "public.external_data_info",
"column": "beneficiary_id"
},
"ref": {
"table": "public.beneficiary",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "external_data_info_external_data_id_fkey",
"src": {
"table": "public.external_data_info",
"column": "external_data_id"
},
"ref": {
"table": "public.external_data",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "external_data_info_professional_id_fkey",
"src": {
"table": "public.external_data_info",
"column": "professional_id"
},
"ref": {
"table": "public.professional",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "manager_deployment_id_fkey",
"src": {
"table": "public.manager",
"column": "deployment_id"
},
"ref": {
"table": "public.deployment",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_beneficiary_id_fkey",
"src": {
"table": "public.notebook",
"column": "beneficiary_id"
},
"ref": {
"table": "public.beneficiary",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_action_creator_id_fkey",
"src": {
"table": "public.notebook_action",
"column": "creator_id"
},
"ref": {
"table": "public.account",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_action_status_fkey",
"src": {
"table": "public.notebook_action",
"column": "status"
},
"ref": {
"table": "public.action_status",
"column": "status"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_action_target_id_fkey",
"src": {
"table": "public.notebook_action",
"column": "target_id"
},
"ref": {
"table": "public.notebook_target",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_appointment_account_id_fkey",
"src": {
"table": "public.notebook_appointment",
"column": "account_id"
},
"ref": {
"table": "public.account",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_appointment_deleted_by_fkey",
"src": {
"table": "public.notebook_appointment",
"column": "deleted_by"
},
"ref": {
"table": "public.account",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_appointment_notebook_id_fkey",
"src": {
"table": "public.notebook_appointment",
"column": "notebook_id"
},
"ref": {
"table": "public.notebook",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_creation_creator_account_id_fkey",
"src": {
"table": "public.notebook_creation",
"column": "creator_account_id"
},
"ref": {
"table": "public.account",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_creation_notebook_id_fkey",
"src": {
"table": "public.notebook_creation",
"column": "notebook_id"
},
"ref": {
"table": "public.notebook",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_creation_source_fkey",
"src": {
"table": "public.notebook_creation",
"column": "source"
},
"ref": {
"table": "public.notebook_creation_source_type",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_event_creator_id_fkey",
"src": {
"table": "public.notebook_event",
"column": "creator_id"
},
"ref": {
"table": "public.account",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_event_event_type_fkey",
"src": {
"table": "public.notebook_event",
"column": "event_type"
},
"ref": {
"table": "public.notebook_event_type",
"column": "value"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_event_notebook_id_fkey",
"src": {
"table": "public.notebook_event",
"column": "notebook_id"
},
"ref": {
"table": "public.notebook",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_focus_creator_id_fkey",
"src": {
"table": "public.notebook_focus",
"column": "creator_id"
},
"ref": {
"table": "public.account",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_focus_notebook_id_fkey",
"src": {
"table": "public.notebook_focus",
"column": "notebook_id"
},
"ref": {
"table": "public.notebook",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_info_notebook_id_fkey",
"src": {
"table": "public.notebook_info",
"column": "notebook_id"
},
"ref": {
"table": "public.notebook",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_info_orientation_system_id_fkey",
"src": {
"table": "public.notebook_info",
"column": "orientation_system_id"
},
"ref": {
"table": "public.orientation_system",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_member_account_id_fkey",
"src": {
"table": "public.notebook_member",
"column": "account_id"
},
"ref": {
"table": "public.account",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_member_creator_id_fkey",
"src": {
"table": "public.notebook_member",
"column": "creator_id"
},
"ref": {
"table": "public.account",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_member_notebook_id_fkey",
"src": {
"table": "public.notebook_member",
"column": "notebook_id"
},
"ref": {
"table": "public.notebook",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_situation_created_by_fkey",
"src": {
"table": "public.notebook_situation",
"column": "created_by"
},
"ref": {
"table": "public.account",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_situation_deleted_by_fkey",
"src": {
"table": "public.notebook_situation",
"column": "deleted_by"
},
"ref": {
"table": "public.account",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_situation_notebook_id_fkey",
"src": {
"table": "public.notebook_situation",
"column": "notebook_id"
},
"ref": {
"table": "public.notebook",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_situation_situation_id_fkey",
"src": {
"table": "public.notebook_situation",
"column": "situation_id"
},
"ref": {
"table": "public.ref_situation",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_target_creator_id_fkey",
"src": {
"table": "public.notebook_target",
"column": "creator_id"
},
"ref": {
"table": "public.account",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_target_focus_id_fkey",
"src": {
"table": "public.notebook_target",
"column": "focus_id"
},
"ref": {
"table": "public.notebook_focus",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_update_account_id_fkey",
"src": {
"table": "public.notebook_update",
"column": "account_id"
},
"ref": {
"table": "public.account",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_update_notebook_id_fkey",
"src": {
"table": "public.notebook_update",
"column": "notebook_id"
},
"ref": {
"table": "public.notebook",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_visit_account_id_fkey",
"src": {
"table": "public.notebook_visit",
"column": "account_id"
},
"ref": {
"table": "public.account",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "notebook_visit_notebook_id_fkey",
"src": {
"table": "public.notebook_visit",
"column": "notebook_id"
},
"ref": {
"table": "public.notebook",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "nps_rating_account_id_fkey",
"src": {
"table": "public.nps_rating",
"column": "account_id"
},
"ref": {
"table": "public.account",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "nps_rating_dismissal_account_id_fkey",
"src": {
"table": "public.nps_rating_dismissal",
"column": "account_id"
},
"ref": {
"table": "public.account",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "orientation_manager_deployment_id_fkey",
"src": {
"table": "public.orientation_manager",
"column": "deployment_id"
},
"ref": {
"table": "public.deployment",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "orientation_request_beneficiary_id_fkey",
"src": {
"table": "public.orientation_request",
"column": "beneficiary_id"
},
"ref": {
"table": "public.beneficiary",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "orientation_request_decided_orientation_system_id_fkey",
"src": {
"table": "public.orientation_request",
"column": "decided_orientation_system_id"
},
"ref": {
"table": "public.orientation_system",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "orientation_request_requested_orientation_system_id_fkey",
"src": {
"table": "public.orientation_request",
"column": "requested_orientation_system_id"
},
"ref": {
"table": "public.orientation_system",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "orientation_request_requestor_account_id_fkey",
"src": {
"table": "public.orientation_request",
"column": "requestor_account_id"
},
"ref": {
"table": "public.account",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "orientation_system_deployment_id_fkey",
"src": {
"table": "public.orientation_system",
"column": "deployment_id"
},
"ref": {
"table": "public.deployment",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "orientation_system_orientation_type_fkey",
"src": {
"table": "public.orientation_system",
"column": "orientation_type"
},
"ref": {
"table": "public.orientation_type",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "professional_structure_id_foreign",
"src": {
"table": "public.professional",
"column": "structure_id"
},
"ref": {
"table": "public.structure",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "professional_orientation_system_orientation_system_id_fkey",
"src": {
"table": "public.professional_orientation_system",
"column": "orientation_system_id"
},
"ref": {
"table": "public.orientation_system",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "professional_orientation_system_professional_id_fkey",
"src": {
"table": "public.professional_orientation_system",
"column": "professional_id"
},
"ref": {
"table": "public.professional",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "professional_project_contract_type_id_fkey",
"src": {
"table": "public.professional_project",
"column": "contract_type_id"
},
"ref": {
"table": "public.contract_type",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "professional_project_employment_type_id_fkey",
"src": {
"table": "public.professional_project",
"column": "employment_type_id"
},
"ref": {
"table": "public.employment_type",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "professional_project_notebook_id_fkey",
"src": {
"table": "public.professional_project",
"column": "notebook_id"
},
"ref": {
"table": "public.notebook",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "professional_project_rome_code_id_fkey",
"src": {
"table": "public.professional_project",
"column": "rome_code_id"
},
"ref": {
"table": "public.rome_code",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "ref_action_theme_fkey",
"src": {
"table": "public.ref_action",
"column": "theme"
},
"ref": {
"table": "public.ref_theme",
"column": "name"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "ref_situation_theme_fkey",
"src": {
"table": "public.ref_situation",
"column": "theme"
},
"ref": {
"table": "public.ref_theme",
"column": "name"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "ref_target_theme_fkey",
"src": {
"table": "public.ref_target",
"column": "theme"
},
"ref": {
"table": "public.ref_theme",
"column": "name"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "structure_deployment_id_fkey",
"src": {
"table": "public.structure",
"column": "deployment_id"
},
"ref": {
"table": "public.deployment",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "structure_orientation_system_orientation_system_id_fkey",
"src": {
"table": "public.structure_orientation_system",
"column": "orientation_system_id"
},
"ref": {
"table": "public.orientation_system",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"name": "structure_orientation_system_structure_id_fkey",
"src": {
"table": "public.structure_orientation_system",
"column": "structure_id"
},
"ref": {
"table": "public.structure",
"column": "id"
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"types": [
{
"schema": "public",
"name": "citext",
"value": {
"definition": ""
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"name": "email",
"value": {
"definition": ""
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
},
{
"schema": "public",
"name": "gtrgm",
"value": {
"definition": ""
},
"origins": [
{
"id": "ac417969-91a8-4806-bc03-3d70d065e5d1",
"lines": []
}
]
}
],
"createdAt": 1694591190924,
"updatedAt": 1694591190924
}
],
"layouts": {
"initial layout": {
"tables": [
{
"id": "public.account",
"position": {
"left": 4840,
"top": 510
},
"size": {
"width": 114.79718016792492,
"height": 45.00013443941241
},
"color": "pink",
"columns": [
"id",
"type",
"beneficiary_id",
"professional_id",
"admin_id",
"manager_id",
"admin_structure_id",
"orientation_manager_id"
],
"collapsed": true
},
{
"id": "public.action_status",
"position": {
"left": 7320,
"top": 1690
},
"size": {
"width": 182.31289956697378,
"height": 45.00013443941241
},
"color": "green",
"columns": [
"status"
],
"collapsed": true
},
{
"id": "public.admin_cdb",
"position": {
"left": 4360,
"top": 580
},
"size": {
"width": 141.73422820909514,
"height": 45.00013443941241
},
"color": "yellow",
"columns": [
"id"
],
"collapsed": true
},
{
"id": "public.admin_structure",
"position": {
"left": 4320,
"top": 640
},
"size": {
"width": 207.7969626073513,
"height": 45.00013443941241
},
"color": "yellow",
"columns": [
"id",
"deployment_id"
],
"collapsed": true
},
{
"id": "public.admin_structure_structure",
"position": {
"left": 3870,
"top": 630
},
"size": {
"width": 297.4064467115947,
"height": 45.00013443941241
},
"color": "yellow",
"columns": [
"admin_structure_id",
"structure_id"
],
"collapsed": true
},
{
"id": "public.beneficiary",
"position": {
"left": 4370,
"top": 720
},
"size": {
"width": 140.937796599154,
"height": 45.00013443941241
},
"color": "amber",
"columns": [
"id",
"deployment_id",
"rsa_suspension_reason",
"rsa_closure_reason"
],
"collapsed": true
},
{
"id": "public.beneficiary_structure",
"position": {
"left": 3870,
"top": 520
},
"size": {
"width": 249.46843255186707,
"height": 45.00013443941241
},
"color": "amber",
"columns": [
"beneficiary_id",
"structure_id"
],
"collapsed": true
},
{
"id": "public.contract_type",
"position": {
"left": 6730,
"top": 2050
},
"size": {
"width": 167.0784130303831,
"height": 45.00013443941241
},
"color": "green",
"columns": [
"id"
],
"collapsed": true
},
{
"id": "public.deployment",
"position": {
"left": 4020,
"top": -60
},
"size": {
"width": 167.74982848201293,
"height": 45.00013443941241
},
"color": "pink",
"columns": [
"id"
],
"collapsed": true
},
{
"id": "public.employment_type",
"position": {
"left": 6730,
"top": 1920
},
"size": {
"width": 202.62496545651516,
"height": 45.00013443941241
},
"color": "fuchsia",
"columns": [
"id"
],
"collapsed": true
},
{
"id": "public.external_data",
"position": {
"left": 6120,
"top": 610
},
"size": {
"width": 162.92228144568483,
"height": 45.00013443941241
},
"color": "sky",
"columns": [
"id",
"source"
],
"collapsed": true
},
{
"id": "public.external_data_info",
"position": {
"left": 6340,
"top": 680
},
"size": {
"width": 206.156016249657,
"height": 45.00013443941241
},
"color": "sky",
"columns": [
"external_data_id",
"beneficiary_id",
"professional_id"
],
"collapsed": true
},
{
"id": "public.external_source",
"position": {
"left": 6340,
"top": 610
},
"size": {
"width": 184.01591688438907,
"height": 45.00013443941241
},
"color": "sky",
"columns": [
"value"
],
"collapsed": true
},
{
"id": "public.manager",
"position": {
"left": 4370,
"top": 800
},
"size": {
"width": 141.26563617514515,
"height": 45.00013443941241
},
"color": "lime",
"columns": [
"id",
"deployment_id"
],
"collapsed": true
},
{
"id": "public.notebook",
"position": {
"left": 5890,
"top": 830
},
"size": {
"width": 126.9377353460286,
"height": 45.00013443941241
},
"color": "rose",
"columns": [
"id",
"beneficiary_id"
],
"collapsed": true
},
{
"id": "public.notebook_action",
"position": {
"left": 7050,
"top": 1680
},
"size": {
"width": 191.5160121441969,
"height": 45.00013443941241
},
"color": "rose",
"columns": [
"target_id",
"status",
"creator_id"
],
"collapsed": true
},
{
"id": "public.notebook_appointment",
"position": {
"left": 6400,
"top": 1360
},
"size": {
"width": 248.65626464227836,
"height": 45.00013443941241
},
"color": "rose",
"columns": [
"notebook_id",
"account_id",
"deleted_by"
],
"collapsed": true
},
{
"id": "public.notebook_creation",
"position": {
"left": 6380,
"top": 830
},
"size": {
"width": 228.1562373958354,
"height": 45.00013443941241
},
"color": "rose",
"columns": [
"notebook_id",
"creator_account_id",
"source"
],
"collapsed": true
},
{
"id": "public.notebook_creation_source_type",
"position": {
"left": 6700,
"top": 830
},
"size": {
"width": 347.734629940015,
"height": 45.00013443941241
},
"color": "rose",
"columns": [
"id"
],
"collapsed": true
},
{
"id": "public.notebook_event",
"position": {
"left": 6400,
"top": 1490
},
"size": {
"width": 185.65598900321405,
"height": 45.00013443941241
},
"color": "rose",
"columns": [
"notebook_id",
"event_type",
"creator_id"
],
"collapsed": true
},
{
"id": "public.notebook_event_type",
"position": {
"left": 6730,
"top": 1490
},
"size": {
"width": 235.43777293831582,
"height": 45.00013443941241
},
"color": "rose",
"columns": [
"value"
],
"collapsed": true
},
{
"id": "public.notebook_focus",
"position": {
"left": 6400,
"top": 1680
},
"size": {
"width": 186.07824637709064,
"height": 45.00013443941241
},
"color": "rose",
"columns": [
"id",
"creator_id",
"notebook_id"
],
"collapsed": true
},
{
"id": "public.notebook_info",
"position": {
"left": 6400,
"top": 1260
},
"size": {
"width": 190.1723070020679,
"height": 45.00013443941241
},
"color": "rose",
"columns": [
"notebook_id",
"orientation_system_id"
],
"collapsed": true
},
{
"id": "public.notebook_member",
"position": {
"left": 5590,
"top": 510
},
"size": {
"width": 210.9372286259117,
"height": 45.00013443941241
},
"color": "rose",
"columns": [
"notebook_id",
"account_id",
"creator_id"
],
"collapsed": true
},
{
"id": "public.notebook_situation",
"position": {
"left": 6400,
"top": 1810
},
"size": {
"width": 212.42168622599957,
"height": 45.00013443941241
},
"color": "rose",
"columns": [
"notebook_id",
"situation_id",
"created_by",
"deleted_by"
],
"collapsed": true
},
{
"id": "public.notebook_target",
"position": {
"left": 6740,
"top": 1680
},
"size": {
"width": 189.8750657865026,
"height": 45.00013443941241
},
"color": "rose",
"columns": [
"id",
"focus_id",
"creator_id"
],
"collapsed": true
},
{
"id": "public.notebook_update",
"position": {
"left": 6380,
"top": 890
},
"size": {
"width": 198.95316220541446,
"height": 45.00013443941241
},
"color": "rose",
"columns": [
"notebook_id",
"account_id"
],
"collapsed": true
},
{
"id": "public.notebook_visit",
"position": {
"left": 6380,
"top": 960
},
"size": {
"width": 193.0310681047106,
"height": 45.00013443941241
},
"color": "rose",
"columns": [
"notebook_id",
"account_id"
],
"collapsed": true
},
{
"id": "public.nps_rating",
"position": {
"left": 5090,
"top": 380
},
"size": {
"width": 157.2808180220294,
"height": 45.00013443941241
},
"color": "pink",
"columns": [
"account_id"
],
"collapsed": true
},
{
"id": "public.nps_rating_dismissal",
"position": {
"left": 5090,
"top": 440
},
"size": {
"width": 248.74980820129448,
"height": 45.00013443941241
},
"color": "pink",
"columns": [
"account_id"
],
"collapsed": true
},
{
"id": "public.orientation_manager",
"position": {
"left": 4320,
"top": 870
},
"size": {
"width": 245.7660309403405,
"height": 45.00013443941241
},
"color": "lime",
"columns": [
"id",
"deployment_id"
],
"collapsed": true
},
{
"id": "public.orientation_request",
"position": {
"left": 4820,
"top": 720
},
"size": {
"width": 214.98408035194626,
"height": 45.00013443941241
},
"color": "lime",
"columns": [
"beneficiary_id",
"requestor_account_id",
"requested_orientation_system_id",
"decided_orientation_system_id"
],
"collapsed": true
},
{
"id": "public.orientation_system",
"position": {
"left": 4330,
"top": 1270
},
"size": {
"width": 211.09371738351814,
"height": 45.00013443941241
},
"color": "lime",
"columns": [
"id",
"orientation_type",
"deployment_id"
],
"collapsed": true
},
{
"id": "public.orientation_type",
"position": {
"left": 3980,
"top": 1370
},
"size": {
"width": 207.3283705734013,
"height": 45.00013443941241
},
"color": "lime",
"columns": [
"id"
],
"collapsed": true
},
{
"id": "public.professional",
"position": {
"left": 4370,
"top": 960
},
"size": {
"width": 150.0937002774344,
"height": 45.00013443941241
},
"color": "blue",
"columns": [
"id",
"structure_id"
],
"collapsed": true
},
{
"id": "public.professional_orientation_system",
"position": {
"left": 3880,
"top": 1180
},
"size": {
"width": 327.5467059699156,
"height": 45.00013443941241
},
"color": "blue",
"columns": [
"professional_id",
"orientation_system_id"
],
"collapsed": true
},
{
"id": "public.professional_project",
"position": {
"left": 6400,
"top": 1900
},
"size": {
"width": 242.35912206664065,
"height": 45.00013443941241
},
"color": "blue",
"columns": [
"notebook_id",
"rome_code_id",
"contract_type_id",
"employment_type_id"
],
"collapsed": true
},
{
"id": "public.ref_action",
"position": {
"left": 7370,
"top": 1810
},
"size": {
"width": 131.98471633855345,
"height": 45.00013443941241
},
"color": "sky",
"columns": [
"theme"
],
"collapsed": true
},
{
"id": "public.ref_situation",
"position": {
"left": 6740,
"top": 1810
},
"size": {
"width": 152.8903904203561,
"height": 45.00013443941241
},
"color": "sky",
"columns": [
"id",
"theme"
],
"collapsed": true
},
{
"id": "public.ref_target",
"position": {
"left": 7370,
"top": 1910
},
"size": {
"width": 130.34376998085915,
"height": 45.00013443941241
},
"color": "sky",
"columns": [
"theme"
],
"collapsed": true
},
{
"id": "public.ref_theme",
"position": {
"left": 7030,
"top": 1810
},
"size": {
"width": 153.99979954551011,
"height": 45.00013443941241
},
"color": "sky",
"columns": [
"name"
],
"collapsed": true
},
{
"id": "public.role",
"position": {
"left": 4840,
"top": 580
},
"size": {
"width": 96.65584939087951,
"height": 45.00013443941241
},
"color": "fuchsia",
"columns": [
"label"
],
"collapsed": true
},
{
"id": "public.rome_code",
"position": {
"left": 6730,
"top": 1990
},
"size": {
"width": 142.6871485766427,
"height": 45.00013443941241
},
"color": "blue",
"columns": [
"id"
],
"collapsed": true
},
{
"id": "public.rsa_closure_reason",
"position": {
"left": 4820,
"top": 800
},
"size": {
"width": 234.82842844640695,
"height": 45.00013443941241
},
"color": "teal",
"columns": [
"code"
],
"collapsed": true
},
{
"id": "public.rsa_suspension_reason",
"position": {
"left": 4820,
"top": 860
},
"size": {
"width": 271.4371810987503,
"height": 45.00013443941241
},
"color": "teal",
"columns": [
"code"
],
"collapsed": true
},
{
"id": "public.structure",
"position": {
"left": 3790,
"top": 390
},
"size": {
"width": 123.25019579528032,
"height": 45.00013443941241
},
"color": "indigo",
"columns": [
"id",
"deployment_id"
],
"collapsed": true
},
{
"id": "public.structure_orientation_system",
"position": {
"left": 3880,
"top": 1270
},
"size": {
"width": 300.3124167131801,
"height": 45.00013443941241
},
"color": "indigo",
"columns": [
"structure_id",
"orientation_system_id"
],
"collapsed": true
}
],
"createdAt": 1694591190924,
"updatedAt": 1694594176983
}
},
"settings": {
"defaultSchema": "public",
"removedSchemas": [
"hdb_catalog"
],
"removeViews": true,
"hiddenColumns": {
"list": "",
"relations": true
},
"collapseTableColumns": true
},
"createdAt": 1694591196020,
"updatedAt": 1694591196020,
"version": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment