דילוג לתוכן
מרכז התיעוד
לאתר LinkNodes Energy
LinkNodesENERGYתיעוד

טוענים את החיפוש…

    חיפוש גם בתוך המאמרים ↑ ↓ לניווט Esc לסגירה

    לאתר החברה

    נתונים ודיווח

    מילון הסכימה המובנה

    מילון שמופק מהגדרות המיגרציות; אינו מכיל נתוני לקוחות.

    מילון שמופק מהגדרות המיגרציות; אינו מכיל נתוני לקוחות.

    {
      "version": "1.0.0",
      "source": "Committed migration definitions, not live customer data",
      "migrations": [
        {
          "path": "supabase/migrations/0001_ev1.sql",
          "sha256": "5a264b0ba21fd034f4e62f1f28cea965599a5181173f13885a118799200ad321"
        },
        {
          "path": "supabase/migrations/20261107211048_platform_foundation.sql",
          "sha256": "493ec2c562b8e389c2111ab0622b00db3e489cc60818354a5dc36d18ee12e788"
        },
        {
          "path": "supabase/migrations/20261107232238_israel_reference_data.sql",
          "sha256": "435239818452bf3ba09ca66f4733a0ae1082ea9484bdd3c070a9c71c85904da5"
        },
        {
          "path": "supabase/migrations/20261107233211_harden_vehicle_lookup_quota.sql",
          "sha256": "0ee5c57d8912c720a0897a9754afbbdcd8a26aa5f51a6a8e53b16d8d8328f7ff"
        },
        {
          "path": "supabase/migrations/20261107234917_catalog_vehicle_selection.sql",
          "sha256": "b19e30e0b41aec453d61de4fc9288b982427c8ae480d5030dea1d022111d5b76"
        },
        {
          "path": "supabase/migrations/20261108003309_customer_provider_preferences.sql",
          "sha256": "b4b1efefacc20866f85d44c6f6e610084eb9ceaea9893eb14d288f8f451d7a33"
        },
        {
          "path": "supabase/migrations/20261108005217_provider_conflict_response.sql",
          "sha256": "4dd86b5eaf9883b0e56090e89ff51ecfee78d3bfc28cb7300dbe7956e4848b3d"
        },
        {
          "path": "supabase/migrations/20261108013050_workspace_profiles.sql",
          "sha256": "5d8a48d22ab91c074dac2c53f7c1a3d5558c6716637cbb507bec251ba21c67eb"
        },
        {
          "path": "supabase/migrations/20261108194554_account_plans_and_vehicle_limits.sql",
          "sha256": "a226b934c909625a66babf0f70c4944fbf7e8765be13bab758e69e704d6be1c7"
        },
        {
          "path": "supabase/migrations/20261109181613_verified_provider_directory.sql",
          "sha256": "bffe748d61aa7ddbae16bbfd191f7fe2d401a4711bae63656cf43a98b8ddc4bb"
        },
        {
          "path": "supabase/migrations/20261109190535_verified_vehicle_writes.sql",
          "sha256": "993af68d56aa4b9331b46b4bd509c90fde69f7523e4441c2880e733d4c25c0c3"
        },
        {
          "path": "supabase/migrations/20261109190551_invitation_driver_lifecycle.sql",
          "sha256": "7097dd611d09280d8a43b6be122ed08e9f6cb915a98d6d42542b5f4ca1714aef"
        },
        {
          "path": "supabase/migrations/20261109191257_enforce_verified_vehicle_writes.sql",
          "sha256": "32ff07f70c9c4816a7d043d2affdc34dfd4f08bb48f6dfaaef5af95f5c0d3fbd"
        },
        {
          "path": "supabase/migrations/20261110132059_fuel_provider_directory.sql",
          "sha256": "f831c8f0340148e41be72fff36c0ab1aaecf91d0bd40aceefe85fc0463e89407"
        },
        {
          "path": "supabase/migrations/20261110203000_hyp_billing_foundation.sql",
          "sha256": "aa72978220a90347865ac5133ee1d07daf103b6d225c7cd110d35665b9359a6b"
        },
        {
          "path": "supabase/migrations/20261111155528_mobile_onboarding_and_deletion_requests.sql",
          "sha256": "1b269ef37ba615401663f3b226f894c92165d3e65e1ba8db15650bbb855576de"
        },
        {
          "path": "supabase/migrations/20261111161830_clerk_org_provision_claims.sql",
          "sha256": "50dcb5a212b1358aa9f2c819ebd0806c38f81e97147699fb3ea7bb11eea09f7c"
        },
        {
          "path": "supabase/migrations/20261120160000_billing_safety.sql",
          "sha256": "1eeb8b8f04342b35b047b295e3b8e428bddc58ad21ae0a78fc3ff498bbede84a"
        },
        {
          "path": "supabase/migrations/20261121230000_uniform_charging_commission.sql",
          "sha256": "e999047df9ead8c9678eded34dbf1dd9b2f86721d14f4c344f32aa03494b964f"
        }
      ],
      "tables": [
        {
          "id": "public.stations",
          "schema": "public",
          "name": "stations",
          "source": "supabase/migrations/0001_ev1.sql",
          "scope": "catalog",
          "legacy": true,
          "columns": [
            {
              "name": "id",
              "definition": "text primary key"
            },
            {
              "name": "name",
              "definition": "text not null check (length(trim(name)) > 0)"
            },
            {
              "name": "address",
              "definition": "text not null"
            },
            {
              "name": "city",
              "definition": "text not null"
            },
            {
              "name": "lat",
              "definition": "double precision not null check (lat between -90 and 90)"
            },
            {
              "name": "lng",
              "definition": "double precision not null check (lng between -180 and 180)"
            },
            {
              "name": "available",
              "definition": "integer not null default 0 check (available >= 0)"
            },
            {
              "name": "total",
              "definition": "integer not null check (total > 0)"
            },
            {
              "name": "power",
              "definition": "integer not null check (power > 0)"
            },
            {
              "name": "price",
              "definition": "numeric(8, 3) not null check (price >= 0)"
            },
            {
              "name": "connector",
              "definition": "text not null check (connector in ('CCS2', 'Type 2', 'CHAdeMO'))"
            },
            {
              "name": "rating",
              "definition": "numeric(2, 1) check (rating between 0 and 5)"
            },
            {
              "name": "amenities",
              "definition": "text[] not null default '{}'"
            },
            {
              "name": "tag",
              "definition": "text"
            },
            {
              "name": "updated_at",
              "definition": "timestamptz not null default now()"
            }
          ],
          "constraints": [
            "constraint available_connectors_within_total check (available <= total)"
          ],
          "relations": []
        },
        {
          "id": "public.favorites",
          "schema": "public",
          "name": "favorites",
          "source": "supabase/migrations/0001_ev1.sql",
          "scope": "user",
          "legacy": true,
          "columns": [
            {
              "name": "user_id",
              "definition": "text not null default (auth.jwt() ->> 'sub') check (length(trim(user_id)) > 0)"
            },
            {
              "name": "station_id",
              "definition": "text not null references public.stations(id) on delete cascade"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            }
          ],
          "constraints": ["primary key (user_id, station_id)"],
          "relations": [
            {
              "columns": "station_id",
              "target": "public.stations",
              "targetColumns": "id"
            }
          ]
        },
        {
          "id": "public.vehicles",
          "schema": "public",
          "name": "vehicles",
          "source": "supabase/migrations/0001_ev1.sql",
          "scope": "user",
          "legacy": true,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "user_id",
              "definition": "text not null default (auth.jwt() ->> 'sub') check (length(trim(user_id)) > 0)"
            },
            {
              "name": "name",
              "definition": "text not null check (length(trim(name)) between 1 and 100)"
            },
            {
              "name": "battery_capacity_kwh",
              "definition": "numeric(7, 2) not null check (battery_capacity_kwh > 0 and battery_capacity_kwh <= 1000)"
            },
            {
              "name": "connector",
              "definition": "text not null check (connector in ('CCS2', 'Type 2', 'CHAdeMO'))"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            }
          ],
          "constraints": [],
          "relations": []
        },
        {
          "id": "public.charging_sessions",
          "schema": "public",
          "name": "charging_sessions",
          "source": "supabase/migrations/0001_ev1.sql",
          "scope": "user",
          "legacy": true,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "user_id",
              "definition": "text not null check (length(trim(user_id)) > 0)"
            },
            {
              "name": "station_id",
              "definition": "text not null references public.stations(id)"
            },
            {
              "name": "connector_identifier",
              "definition": "text not null"
            },
            {
              "name": "status",
              "definition": "text not null check (status in ('requested', 'authorized', 'charging', 'stopping', 'completed', 'failed'))"
            },
            {
              "name": "energy_kwh",
              "definition": "numeric(12, 3) not null default 0 check (energy_kwh >= 0)"
            },
            {
              "name": "amount_minor",
              "definition": "bigint not null default 0 check (amount_minor >= 0)"
            },
            {
              "name": "currency",
              "definition": "text not null default 'ILS' check (currency = 'ILS')"
            },
            {
              "name": "tariff_per_kwh",
              "definition": "numeric(8, 3) not null check (tariff_per_kwh >= 0)"
            },
            {
              "name": "idempotency_key",
              "definition": "uuid not null unique"
            },
            {
              "name": "requested_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "started_at",
              "definition": "timestamptz"
            },
            {
              "name": "ended_at",
              "definition": "timestamptz"
            },
            {
              "name": "updated_at",
              "definition": "timestamptz not null default now()"
            }
          ],
          "constraints": [
            "constraint valid_session_times check (ended_at is null or (started_at is not null and ended_at >= started_at))"
          ],
          "relations": [
            {
              "columns": "station_id",
              "target": "public.stations",
              "targetColumns": "id"
            }
          ]
        },
        {
          "id": "public.ev1_tenants",
          "schema": "public",
          "name": "ev1_tenants",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "kind",
              "definition": "text not null check(kind in ('personal','business'))"
            },
            {
              "name": "name",
              "definition": "text not null check(length(trim(name)) between 2 and 100)"
            },
            {
              "name": "legal_name",
              "definition": "text check(length(legal_name)<=160)"
            },
            {
              "name": "tax_id",
              "definition": "text check(tax_id ~ '^[0-9]{5,20}$')"
            },
            {
              "name": "owner_user_id",
              "definition": "text not null check(length(owner_user_id)>0)"
            },
            {
              "name": "provision_key",
              "definition": "uuid not null"
            },
            {
              "name": "clerk_org_id",
              "definition": "text unique"
            },
            {
              "name": "currency",
              "definition": "text not null default 'ILS' check(currency='ILS')"
            },
            {
              "name": "timezone",
              "definition": "text not null default 'Asia/Jerusalem' check(timezone='Asia/Jerusalem')"
            },
            {
              "name": "status",
              "definition": "text not null default 'active' check(status in ('active','suspended'))"
            },
            {
              "name": "fuel_price_minor_per_litre",
              "definition": "integer not null default 750 check(fuel_price_minor_per_litre between 0 and 10000)"
            },
            {
              "name": "fuel_kg_co2_per_litre",
              "definition": "numeric(8,4) not null default 2.31 check(fuel_kg_co2_per_litre between 0 and 10)"
            },
            {
              "name": "grid_kg_co2_per_kwh",
              "definition": "numeric(8,4) not null default 0.45 check(grid_kg_co2_per_kwh between 0 and 5)"
            },
            {
              "name": "accepted_terms_version",
              "definition": "text not null default 'platform-preview-1'"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "plan_code",
              "definition": "text"
            }
          ],
          "constraints": [
            "unique(owner_user_id,provision_key)",
            "constraint lne_account_plan_kind check (\n (kind='personal' and plan_code in ('personal','family')) or\n (kind='business' and plan_code in ('business','enterprise'))\n)"
          ],
          "relations": []
        },
        {
          "id": "public.ev1_memberships",
          "schema": "public",
          "name": "ev1_memberships",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "tenant_id",
              "definition": "uuid not null references public.ev1_tenants(id)"
            },
            {
              "name": "user_id",
              "definition": "text not null check(length(user_id)>0)"
            },
            {
              "name": "role",
              "definition": "text not null check(role in ('owner','admin','fleet_manager','finance','driver'))"
            },
            {
              "name": "status",
              "definition": "text not null default 'active' check(status in ('active','suspended'))"
            },
            {
              "name": "display_name",
              "definition": "text not null default '' check(length(display_name)<=100)"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            }
          ],
          "constraints": ["primary key(tenant_id,user_id)"],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            }
          ]
        },
        {
          "id": "public.ev1_vehicle_models",
          "schema": "public",
          "name": "ev1_vehicle_models",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "catalog",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "text primary key"
            },
            {
              "name": "make",
              "definition": "text not null"
            },
            {
              "name": "model",
              "definition": "text not null"
            },
            {
              "name": "category",
              "definition": "text not null check(category in ('car','suv','van','truck','bus'))"
            },
            {
              "name": "powertrain",
              "definition": "text not null check(powertrain in ('BEV','PHEV'))"
            },
            {
              "name": "battery_kwh",
              "definition": "numeric(8,2) not null check(battery_kwh>0)"
            },
            {
              "name": "connector",
              "definition": "text not null check(connector in ('CCS2','Type 2','CHAdeMO'))"
            },
            {
              "name": "consumption_wh_per_km",
              "definition": "integer not null check(consumption_wh_per_km between 50 and 3000)"
            },
            {
              "name": "reference_fuel_l_per_100km",
              "definition": "numeric(8,3) not null check(reference_fuel_l_per_100km between 0 and 100)"
            }
          ],
          "constraints": [],
          "relations": []
        },
        {
          "id": "public.ev1_cost_centers",
          "schema": "public",
          "name": "ev1_cost_centers",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "tenant_id",
              "definition": "uuid not null references public.ev1_tenants(id)"
            },
            {
              "name": "name",
              "definition": "text not null check(length(trim(name)) between 2 and 100)"
            },
            {
              "name": "code",
              "definition": "text not null check(code ~ '^[A-Za-z0-9_-]{1,24}$')"
            },
            {
              "name": "monthly_budget_minor",
              "definition": "integer check(monthly_budget_minor between 0 and 100000000)"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            }
          ],
          "constraints": ["unique(tenant_id,id)", "unique(tenant_id,code)"],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            }
          ]
        },
        {
          "id": "public.ev1_drivers",
          "schema": "public",
          "name": "ev1_drivers",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "tenant_id",
              "definition": "uuid not null references public.ev1_tenants(id)"
            },
            {
              "name": "name",
              "definition": "text not null check(length(trim(name)) between 2 and 100)"
            },
            {
              "name": "email",
              "definition": "text not null check(length(email)<=254 and email ~ '^[^[:space:]@]+@[^[:space:]@]+\\.[^[:space:]@]+$')"
            },
            {
              "name": "user_id",
              "definition": "text"
            },
            {
              "name": "cost_center_id",
              "definition": "uuid"
            },
            {
              "name": "status",
              "definition": "text not null default 'active' check(status in ('active','suspended'))"
            },
            {
              "name": "monthly_budget_minor",
              "definition": "integer check(monthly_budget_minor between 0 and 100000000)"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            }
          ],
          "constraints": [
            "unique(tenant_id,id)",
            "foreign key(tenant_id,cost_center_id) references public.ev1_cost_centers(tenant_id,id)",
            "foreign key(tenant_id,user_id) references public.ev1_memberships(tenant_id,user_id)"
          ],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            },
            {
              "columns": "tenant_id,cost_center_id",
              "target": "public.ev1_cost_centers",
              "targetColumns": "tenant_id,id"
            },
            {
              "columns": "tenant_id,user_id",
              "target": "public.ev1_memberships",
              "targetColumns": "tenant_id,user_id"
            }
          ]
        },
        {
          "id": "public.ev1_fleet_vehicles",
          "schema": "public",
          "name": "ev1_fleet_vehicles",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "tenant_id",
              "definition": "uuid not null references public.ev1_tenants(id)"
            },
            {
              "name": "model_id",
              "definition": "text references public.ev1_vehicle_models(id)"
            },
            {
              "name": "plate",
              "definition": "text not null check(plate ~ '^[0-9A-Za-z -]{4,16}$')"
            },
            {
              "name": "label",
              "definition": "text not null default '' check(length(label)<=100)"
            },
            {
              "name": "driver_id",
              "definition": "uuid"
            },
            {
              "name": "cost_center_id",
              "definition": "uuid"
            },
            {
              "name": "status",
              "definition": "text not null default 'active' check(status in ('active','suspended','retired'))"
            },
            {
              "name": "monthly_budget_minor",
              "definition": "integer check(monthly_budget_minor between 0 and 100000000)"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "catalog_vehicle",
              "definition": "jsonb"
            },
            {
              "name": "revision",
              "definition": "bigint not null default 0 check (revision >= 0)"
            }
          ],
          "constraints": [
            "unique(tenant_id,id)",
            "unique(tenant_id,plate)",
            "foreign key(tenant_id,driver_id) references public.ev1_drivers(tenant_id,id)",
            "foreign key(tenant_id,cost_center_id) references public.ev1_cost_centers(tenant_id,id)",
            "constraint vehicle_model_selection check ((\n (model_id is not null and catalog_vehicle is null) or\n (model_id is null and catalog_vehicle is not null and\n  jsonb_typeof(catalog_vehicle)='object' and\n  catalog_vehicle ?& array['id','make','model','year','fuel','trim','source'] and\n  catalog_vehicle->>'id' ~ '^[1-9][0-9]{0,11}$' and\n  jsonb_typeof(catalog_vehicle->'id')='number' and\n  length(catalog_vehicle->>'make') between 1 and 160 and\n  length(catalog_vehicle->>'model') between 1 and 160 and\n  catalog_vehicle->>'year' ~ '^[12][0-9]{3}$' and\n  catalog_vehicle->>'source'='142afde2-6228-49f9-8a29-9b6c3a0cbe40' and\n  length(catalog_vehicle::text)<2500)\n) is true)"
          ],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            },
            {
              "columns": "model_id",
              "target": "public.ev1_vehicle_models",
              "targetColumns": "id"
            },
            {
              "columns": "tenant_id,driver_id",
              "target": "public.ev1_drivers",
              "targetColumns": "tenant_id,id"
            },
            {
              "columns": "tenant_id,cost_center_id",
              "target": "public.ev1_cost_centers",
              "targetColumns": "tenant_id,id"
            }
          ]
        },
        {
          "id": "public.ev1_charging_policies",
          "schema": "public",
          "name": "ev1_charging_policies",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "tenant_id",
              "definition": "uuid primary key references public.ev1_tenants(id)"
            },
            {
              "name": "monthly_budget_minor",
              "definition": "integer check(monthly_budget_minor between 0 and 100000000)"
            },
            {
              "name": "max_session_minor",
              "definition": "integer not null default 20000 check(max_session_minor between 100 and 100000000)"
            },
            {
              "name": "max_power_kw",
              "definition": "integer not null default 350 check(max_power_kw between 1 and 2000)"
            },
            {
              "name": "allow_public",
              "definition": "boolean not null default true"
            },
            {
              "name": "allow_home",
              "definition": "boolean not null default true"
            },
            {
              "name": "allowed_days",
              "definition": "integer[] not null default '{0,1,2,3,4,5,6}' check(cardinality(allowed_days) between 1 and 7 and allowed_days <@ array[0,1,2,3,4,5,6])"
            },
            {
              "name": "start_hour",
              "definition": "integer not null default 0 check(start_hour between 0 and 23)"
            },
            {
              "name": "end_hour",
              "definition": "integer not null default 0 check(end_hour between 0 and 23)"
            }
          ],
          "constraints": [],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            }
          ]
        },
        {
          "id": "public.ev1_charge_credentials",
          "schema": "public",
          "name": "ev1_charge_credentials",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "tenant_id",
              "definition": "uuid not null references public.ev1_tenants(id)"
            },
            {
              "name": "driver_id",
              "definition": "uuid not null"
            },
            {
              "name": "vehicle_id",
              "definition": "uuid"
            },
            {
              "name": "label",
              "definition": "text not null check(length(trim(label)) between 2 and 100)"
            },
            {
              "name": "last_four",
              "definition": "text not null check(length(last_four)=4)"
            },
            {
              "name": "kind",
              "definition": "text not null check(kind in ('virtual','rfid'))"
            },
            {
              "name": "status",
              "definition": "text not null default 'pending' check(status in ('pending','active','suspended','revoked'))"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            }
          ],
          "constraints": [
            "unique(tenant_id,id)",
            "foreign key(tenant_id,driver_id) references public.ev1_drivers(tenant_id,id)",
            "foreign key(tenant_id,vehicle_id) references public.ev1_fleet_vehicles(tenant_id,id)"
          ],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            },
            {
              "columns": "tenant_id,driver_id",
              "target": "public.ev1_drivers",
              "targetColumns": "tenant_id,id"
            },
            {
              "columns": "tenant_id,vehicle_id",
              "target": "public.ev1_fleet_vehicles",
              "targetColumns": "tenant_id,id"
            }
          ]
        },
        {
          "id": "ev1_private.credential_secrets",
          "schema": "ev1_private",
          "name": "credential_secrets",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "private",
          "legacy": false,
          "columns": [
            {
              "name": "credential_id",
              "definition": "uuid primary key references public.ev1_charge_credentials(id)"
            },
            {
              "name": "token_hash",
              "definition": "text not null unique check(token_hash ~ '^[0-9a-f]{64}$')"
            }
          ],
          "constraints": [],
          "relations": [
            {
              "columns": "credential_id",
              "target": "public.ev1_charge_credentials",
              "targetColumns": "id"
            }
          ]
        },
        {
          "id": "public.ev1_fleet_sessions",
          "schema": "public",
          "name": "ev1_fleet_sessions",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "tenant_id",
              "definition": "uuid not null references public.ev1_tenants(id)"
            },
            {
              "name": "driver_id",
              "definition": "uuid"
            },
            {
              "name": "vehicle_id",
              "definition": "uuid not null"
            },
            {
              "name": "station_name",
              "definition": "text not null"
            },
            {
              "name": "provider",
              "definition": "text"
            },
            {
              "name": "provider_session_id",
              "definition": "text"
            },
            {
              "name": "connector_key",
              "definition": "text"
            },
            {
              "name": "status",
              "definition": "text not null check(status in ('requested','authorized','charging','stopping','completed','failed','cancelled','reconciliation_required'))"
            },
            {
              "name": "energy_wh",
              "definition": "bigint not null default 0 check(energy_wh between 0 and 100000000)"
            },
            {
              "name": "amount_minor",
              "definition": "bigint not null default 0 check(amount_minor between 0 and 100000000)"
            },
            {
              "name": "currency",
              "definition": "text not null default 'ILS' check(currency='ILS')"
            },
            {
              "name": "consumption_wh_per_km",
              "definition": "integer not null check(consumption_wh_per_km between 50 and 3000)"
            },
            {
              "name": "reference_fuel_l_per_100km",
              "definition": "numeric(8,3) not null check(reference_fuel_l_per_100km between 0 and 100)"
            },
            {
              "name": "reserved_minor",
              "definition": "integer not null default 0 check(reserved_minor between 0 and 100000000)"
            },
            {
              "name": "idempotency_key",
              "definition": "uuid not null"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "started_at",
              "definition": "timestamptz"
            },
            {
              "name": "ended_at",
              "definition": "timestamptz"
            },
            {
              "name": "provider_amount_finalized_at",
              "definition": "timestamptz"
            }
          ],
          "constraints": [
            "unique(tenant_id,id)",
            "unique(tenant_id,idempotency_key)",
            "unique(provider,provider_session_id)",
            "foreign key(tenant_id,driver_id) references public.ev1_drivers(tenant_id,id)",
            "foreign key(tenant_id,vehicle_id) references public.ev1_fleet_vehicles(tenant_id,id)",
            "check(ended_at is null or (started_at is not null and ended_at>=started_at))",
            "check(status<>'completed' or ended_at is not null)"
          ],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            },
            {
              "columns": "tenant_id,driver_id",
              "target": "public.ev1_drivers",
              "targetColumns": "tenant_id,id"
            },
            {
              "columns": "tenant_id,vehicle_id",
              "target": "public.ev1_fleet_vehicles",
              "targetColumns": "tenant_id,id"
            }
          ]
        },
        {
          "id": "public.ev1_payment_methods",
          "schema": "public",
          "name": "ev1_payment_methods",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "tenant_id",
              "definition": "uuid not null references public.ev1_tenants(id)"
            },
            {
              "name": "brand",
              "definition": "text not null"
            },
            {
              "name": "last_four",
              "definition": "text not null check(last_four ~ '^[0-9]{4}$')"
            },
            {
              "name": "expiry_month",
              "definition": "integer not null check(expiry_month between 1 and 12)"
            },
            {
              "name": "expiry_year",
              "definition": "integer not null check(expiry_year between 2020 and 2100)"
            },
            {
              "name": "status",
              "definition": "text not null check(status in ('active','expired','removed'))"
            },
            {
              "name": "is_default",
              "definition": "boolean not null default false"
            }
          ],
          "constraints": ["unique(tenant_id,id)"],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            }
          ]
        },
        {
          "id": "ev1_private.payment_tokens",
          "schema": "ev1_private",
          "name": "payment_tokens",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "private",
          "legacy": false,
          "columns": [
            {
              "name": "payment_method_id",
              "definition": "uuid primary key references public.ev1_payment_methods(id)"
            },
            {
              "name": "provider",
              "definition": "text not null"
            },
            {
              "name": "provider_customer_ref",
              "definition": "text not null"
            },
            {
              "name": "provider_method_ref",
              "definition": "text not null"
            }
          ],
          "constraints": ["unique(provider,provider_method_ref)"],
          "relations": [
            {
              "columns": "payment_method_id",
              "target": "public.ev1_payment_methods",
              "targetColumns": "id"
            }
          ]
        },
        {
          "id": "public.ev1_invoices",
          "schema": "public",
          "name": "ev1_invoices",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "tenant_id",
              "definition": "uuid not null references public.ev1_tenants(id)"
            },
            {
              "name": "number",
              "definition": "text not null"
            },
            {
              "name": "period_start",
              "definition": "date not null"
            },
            {
              "name": "period_end",
              "definition": "date not null"
            },
            {
              "name": "amount_minor",
              "definition": "bigint not null check(amount_minor between 0 and 100000000)"
            },
            {
              "name": "currency",
              "definition": "text not null default 'ILS' check(currency='ILS')"
            },
            {
              "name": "status",
              "definition": "text not null check(status in ('draft','open','paid','void'))"
            }
          ],
          "constraints": [
            "unique(tenant_id,id)",
            "unique(tenant_id,number)",
            "check(period_end>=period_start)"
          ],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            }
          ]
        },
        {
          "id": "public.ev1_payments",
          "schema": "public",
          "name": "ev1_payments",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "tenant_id",
              "definition": "uuid not null references public.ev1_tenants(id)"
            },
            {
              "name": "session_id",
              "definition": "uuid not null"
            },
            {
              "name": "provider",
              "definition": "text not null"
            },
            {
              "name": "provider_payment_ref",
              "definition": "text"
            },
            {
              "name": "idempotency_key",
              "definition": "uuid not null"
            },
            {
              "name": "amount_minor",
              "definition": "bigint not null check(amount_minor between 0 and 100000000)"
            },
            {
              "name": "refunded_minor",
              "definition": "bigint not null default 0 check(refunded_minor>=0 and refunded_minor<=amount_minor)"
            },
            {
              "name": "currency",
              "definition": "text not null default 'ILS' check(currency='ILS')"
            },
            {
              "name": "status",
              "definition": "text not null check(status in ('requires_method','authorized','captured','failed','partially_refunded','refunded'))"
            }
          ],
          "constraints": [
            "unique(tenant_id,idempotency_key)",
            "unique(provider,provider_payment_ref)",
            "foreign key(tenant_id,session_id) references public.ev1_fleet_sessions(tenant_id,id)"
          ],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            },
            {
              "columns": "tenant_id,session_id",
              "target": "public.ev1_fleet_sessions",
              "targetColumns": "tenant_id,id"
            }
          ]
        },
        {
          "id": "public.ev1_invitations",
          "schema": "public",
          "name": "ev1_invitations",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "tenant_id",
              "definition": "uuid not null references public.ev1_tenants(id)"
            },
            {
              "name": "email",
              "definition": "text not null check(length(email)<=254)"
            },
            {
              "name": "role",
              "definition": "text not null check(role in ('admin','fleet_manager','finance','driver'))"
            },
            {
              "name": "status",
              "definition": "text not null default 'pending' check(status in ('pending','accepted','revoked'))"
            },
            {
              "name": "invited_by",
              "definition": "text not null"
            },
            {
              "name": "expires_at",
              "definition": "timestamptz not null default now()+interval '7 days'"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "accepted_by_user_id",
              "definition": "text"
            },
            {
              "name": "accepted_at",
              "definition": "timestamptz"
            }
          ],
          "constraints": ["unique(tenant_id,id)"],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            }
          ]
        },
        {
          "id": "ev1_private.invitation_secrets",
          "schema": "ev1_private",
          "name": "invitation_secrets",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "private",
          "legacy": false,
          "columns": [
            {
              "name": "invitation_id",
              "definition": "uuid primary key references public.ev1_invitations(id)"
            },
            {
              "name": "token_hash",
              "definition": "text not null unique check(token_hash ~ '^[0-9a-f]{64}$')"
            }
          ],
          "constraints": [],
          "relations": [
            {
              "columns": "invitation_id",
              "target": "public.ev1_invitations",
              "targetColumns": "id"
            }
          ]
        },
        {
          "id": "public.ev1_audit_events",
          "schema": "public",
          "name": "ev1_audit_events",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "tenant_id",
              "definition": "uuid not null references public.ev1_tenants(id)"
            },
            {
              "name": "actor_user_id",
              "definition": "text"
            },
            {
              "name": "action",
              "definition": "text not null"
            },
            {
              "name": "resource_type",
              "definition": "text not null"
            },
            {
              "name": "resource_id",
              "definition": "text not null"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            }
          ],
          "constraints": [],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            }
          ]
        },
        {
          "id": "ev1_private.outbox",
          "schema": "ev1_private",
          "name": "outbox",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "private",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "tenant_id",
              "definition": "uuid not null references public.ev1_tenants(id)"
            },
            {
              "name": "session_id",
              "definition": "uuid not null"
            },
            {
              "name": "event_type",
              "definition": "text not null"
            },
            {
              "name": "payload",
              "definition": "jsonb not null default '{}'"
            },
            {
              "name": "deduplication_key",
              "definition": "text not null unique"
            },
            {
              "name": "attempts",
              "definition": "integer not null default 0 check(attempts>=0)"
            },
            {
              "name": "available_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "published_at",
              "definition": "timestamptz"
            }
          ],
          "constraints": [
            "foreign key(tenant_id,session_id) references public.ev1_fleet_sessions(tenant_id,id)"
          ],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            },
            {
              "columns": "tenant_id,session_id",
              "target": "public.ev1_fleet_sessions",
              "targetColumns": "tenant_id,id"
            }
          ]
        },
        {
          "id": "ev1_private.provider_events",
          "schema": "ev1_private",
          "name": "provider_events",
          "source": "supabase/migrations/20261107211048_platform_foundation.sql",
          "scope": "private",
          "legacy": false,
          "columns": [
            {
              "name": "provider",
              "definition": "text not null"
            },
            {
              "name": "event_id",
              "definition": "text not null"
            },
            {
              "name": "received_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "payload_hash",
              "definition": "text not null"
            }
          ],
          "constraints": ["primary key(provider,event_id)"],
          "relations": []
        },
        {
          "id": "public.lne_data_sources",
          "schema": "public",
          "name": "lne_data_sources",
          "source": "supabase/migrations/20261107232238_israel_reference_data.sql",
          "scope": "catalog",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "text primary key"
            },
            {
              "name": "title",
              "definition": "text not null"
            },
            {
              "name": "publisher",
              "definition": "text not null"
            },
            {
              "name": "url",
              "definition": "text not null"
            },
            {
              "name": "license",
              "definition": "text not null"
            },
            {
              "name": "source_modified_at",
              "definition": "timestamptz"
            },
            {
              "name": "fetched_at",
              "definition": "timestamptz not null"
            },
            {
              "name": "coverage",
              "definition": "text not null"
            },
            {
              "name": "row_count",
              "definition": "integer not null check(row_count>=0)"
            },
            {
              "name": "content_sha256",
              "definition": "text not null"
            }
          ],
          "constraints": [],
          "relations": []
        },
        {
          "id": "public.lne_localities",
          "schema": "public",
          "name": "lne_localities",
          "source": "supabase/migrations/20261107232238_israel_reference_data.sql",
          "scope": "catalog",
          "legacy": false,
          "columns": [
            {
              "name": "code",
              "definition": "text primary key"
            },
            {
              "name": "name_he",
              "definition": "text not null"
            },
            {
              "name": "name_en",
              "definition": "text"
            },
            {
              "name": "region",
              "definition": "text"
            },
            {
              "name": "source_id",
              "definition": "text not null references public.lne_data_sources(id)"
            }
          ],
          "constraints": [],
          "relations": [
            {
              "columns": "source_id",
              "target": "public.lne_data_sources",
              "targetColumns": "id"
            }
          ]
        },
        {
          "id": "public.lne_operators",
          "schema": "public",
          "name": "lne_operators",
          "source": "supabase/migrations/20261107232238_israel_reference_data.sql",
          "scope": "catalog",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "text primary key"
            },
            {
              "name": "name",
              "definition": "text not null"
            },
            {
              "name": "aliases",
              "definition": "text[] not null default '{}'"
            },
            {
              "name": "website",
              "definition": "text"
            },
            {
              "name": "identity_status",
              "definition": "text not null check(identity_status in ('verified','source_only','review'))"
            },
            {
              "name": "integration_status",
              "definition": "text not null default 'not_connected' check(integration_status in ('not_connected','sandbox','live'))"
            },
            {
              "name": "note",
              "definition": "text not null"
            },
            {
              "name": "source_url",
              "definition": "text not null"
            },
            {
              "name": "capabilities",
              "definition": "jsonb not null default '{\"availability\":false,\"tariffs\":false,\"remote_start\":false,\"remote_stop\":false,\"cdr\":false,\"settlement\":false}'"
            },
            {
              "name": "energy_sources",
              "definition": "text[] not null default array['electricity']::text[]"
            }
          ],
          "constraints": [
            "constraint lne_operator_energy_sources check (\n  array_ndims(energy_sources)=1\n  and cardinality(energy_sources) between 1 and 4\n  and array_position(energy_sources,null) is null\n  and energy_sources <@ array['electricity','petrol','diesel','lpg']::text[]\n)"
          ],
          "relations": []
        },
        {
          "id": "public.lne_charging_locations",
          "schema": "public",
          "name": "lne_charging_locations",
          "source": "supabase/migrations/20261107232238_israel_reference_data.sql",
          "scope": "catalog",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "text primary key"
            },
            {
              "name": "source_id",
              "definition": "text not null references public.lne_data_sources(id)"
            },
            {
              "name": "source_record_id",
              "definition": "text not null"
            },
            {
              "name": "operator_id",
              "definition": "text not null references public.lne_operators(id)"
            },
            {
              "name": "source_operator",
              "definition": "text not null"
            },
            {
              "name": "name",
              "definition": "text not null"
            },
            {
              "name": "address",
              "definition": "text"
            },
            {
              "name": "latitude",
              "definition": "double precision"
            },
            {
              "name": "longitude",
              "definition": "double precision"
            },
            {
              "name": "reported_points",
              "definition": "integer check(reported_points>=0)"
            },
            {
              "name": "reported_fast",
              "definition": "integer check(reported_fast>=0)"
            },
            {
              "name": "reported_slow",
              "definition": "integer check(reported_slow>=0)"
            },
            {
              "name": "availability",
              "definition": "text not null default 'unknown' check(availability='unknown')"
            }
          ],
          "constraints": [
            "unique(source_id,source_record_id)",
            "check((latitude is null and longitude is null) or (latitude between -90 and 90 and longitude between -180 and 180))"
          ],
          "relations": [
            {
              "columns": "source_id",
              "target": "public.lne_data_sources",
              "targetColumns": "id"
            },
            {
              "columns": "operator_id",
              "target": "public.lne_operators",
              "targetColumns": "id"
            }
          ]
        },
        {
          "id": "ev1_private.vehicle_lookup_limits",
          "schema": "ev1_private",
          "name": "vehicle_lookup_limits",
          "source": "supabase/migrations/20261107232238_israel_reference_data.sql",
          "scope": "private",
          "legacy": false,
          "columns": [
            {
              "name": "user_id",
              "definition": "text not null"
            },
            {
              "name": "day",
              "definition": "date not null"
            },
            {
              "name": "attempts",
              "definition": "integer not null check(attempts between 1 and 30)"
            }
          ],
          "constraints": ["primary key(user_id,day)"],
          "relations": []
        },
        {
          "id": "public.ev1_provider_preferences",
          "schema": "public",
          "name": "ev1_provider_preferences",
          "source": "supabase/migrations/20261108003309_customer_provider_preferences.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "tenant_id",
              "definition": "uuid primary key references public.ev1_tenants(id)"
            },
            {
              "name": "revision",
              "definition": "integer not null check (revision > 0)"
            },
            {
              "name": "updated_by",
              "definition": "text not null"
            },
            {
              "name": "updated_at",
              "definition": "timestamptz not null default now()"
            }
          ],
          "constraints": [],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            }
          ]
        },
        {
          "id": "public.ev1_tenant_providers",
          "schema": "public",
          "name": "ev1_tenant_providers",
          "source": "supabase/migrations/20261108003309_customer_provider_preferences.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "tenant_id",
              "definition": "uuid not null references public.ev1_provider_preferences(tenant_id)"
            },
            {
              "name": "operator_id",
              "definition": "text not null references public.lne_operators(id)"
            },
            {
              "name": "approved_by",
              "definition": "text not null"
            },
            {
              "name": "approved_at",
              "definition": "timestamptz not null default now()"
            }
          ],
          "constraints": ["primary key (tenant_id, operator_id)"],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_provider_preferences",
              "targetColumns": "tenant_id"
            },
            {
              "columns": "operator_id",
              "target": "public.lne_operators",
              "targetColumns": "id"
            }
          ]
        },
        {
          "id": "public.ev1_workspace_profiles",
          "schema": "public",
          "name": "ev1_workspace_profiles",
          "source": "supabase/migrations/20261108013050_workspace_profiles.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "tenant_id",
              "definition": "uuid primary key references public.ev1_tenants(id)"
            },
            {
              "name": "contact_name",
              "definition": "text not null default '' check(length(contact_name)<=100)"
            },
            {
              "name": "contact_email",
              "definition": "text not null default '' check(length(contact_email)<=254 and (contact_email='' or contact_email ~ '^[^[:space:]@]+@[^[:space:]@]+\\.[^[:space:]@]+$'))"
            },
            {
              "name": "phone",
              "definition": "text not null default '' check(phone='' or phone ~ '^\\+?[0-9 ()-]{7,25}$')"
            },
            {
              "name": "website",
              "definition": "text not null default '' check(length(website)<=300 and (website='' or website ~ '^https://[^[:space:]@]+$'))"
            },
            {
              "name": "industry",
              "definition": "text not null default '' check(industry in ('','transport','logistics','leasing','services','retail','public','technology','other'))"
            },
            {
              "name": "address_line",
              "definition": "text not null default '' check(length(address_line)<=180)"
            },
            {
              "name": "city",
              "definition": "text not null default '' check(length(city)<=100)"
            },
            {
              "name": "postal_code",
              "definition": "text not null default '' check(postal_code='' or postal_code ~ '^[0-9]{5,7}$')"
            },
            {
              "name": "country_code",
              "definition": "text not null default 'IL' check(country_code='IL')"
            },
            {
              "name": "logo_path",
              "definition": "text check(logo_path is null or (split_part(logo_path,'/',1)=tenant_id::text and logo_path ~ '^[0-9a-f-]{36}/[0-9a-f-]{36}\\.webp$'))"
            },
            {
              "name": "revision",
              "definition": "integer not null default 1 check(revision>0)"
            },
            {
              "name": "updated_by",
              "definition": "text not null"
            },
            {
              "name": "updated_at",
              "definition": "timestamptz not null default now()"
            }
          ],
          "constraints": [],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            }
          ]
        },
        {
          "id": "ev1_private.verified_member_emails",
          "schema": "ev1_private",
          "name": "verified_member_emails",
          "source": "supabase/migrations/20261109190551_invitation_driver_lifecycle.sql",
          "scope": "private",
          "legacy": false,
          "columns": [
            {
              "name": "tenant_id",
              "definition": "uuid not null"
            },
            {
              "name": "user_id",
              "definition": "text not null"
            },
            {
              "name": "email",
              "definition": "text not null check (\n   email=lower(btrim(email)) and length(email)<=254\n   and email ~ '^[^[:space:]@]+@[^[:space:]@]+\\.[^[:space:]@]+$'\n )"
            },
            {
              "name": "verified_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "is_current",
              "definition": "boolean not null default true"
            }
          ],
          "constraints": [
            "primary key(tenant_id,email)",
            "foreign key(tenant_id,user_id) references public.ev1_memberships(tenant_id,user_id)"
          ],
          "relations": [
            {
              "columns": "tenant_id,user_id",
              "target": "public.ev1_memberships",
              "targetColumns": "tenant_id,user_id"
            }
          ]
        },
        {
          "id": "ev1_private.billing_catalog",
          "schema": "ev1_private",
          "name": "billing_catalog",
          "source": "supabase/migrations/20261110203000_hyp_billing_foundation.sql",
          "scope": "private",
          "legacy": false,
          "columns": [
            {
              "name": "version",
              "definition": "text not null"
            },
            {
              "name": "plan_code",
              "definition": "text not null check (plan_code in ('personal','family','business','enterprise'))"
            },
            {
              "name": "monthly_price_minor",
              "definition": "bigint"
            },
            {
              "name": "annual_price_minor",
              "definition": "bigint"
            },
            {
              "name": "price_includes_vat",
              "definition": "boolean not null"
            },
            {
              "name": "trial_days",
              "definition": "integer not null default 0 check (trial_days between 0 and 365)"
            },
            {
              "name": "commission_rate_bps",
              "definition": "integer check (commission_rate_bps between 0 and 10000)"
            },
            {
              "name": "commission_basis",
              "definition": "text not null default 'charging_gross' check (commission_basis = 'charging_gross')"
            },
            {
              "name": "vat_rate_bps",
              "definition": "integer not null check (vat_rate_bps between 0 and 10000)"
            },
            {
              "name": "active",
              "definition": "boolean not null default false"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            }
          ],
          "constraints": [
            "primary key (version, plan_code)",
            "check (monthly_price_minor is null or monthly_price_minor > 0)",
            "check (annual_price_minor is null or annual_price_minor > 0)"
          ],
          "relations": []
        },
        {
          "id": "public.ev1_subscriptions",
          "schema": "public",
          "name": "ev1_subscriptions",
          "source": "supabase/migrations/20261110203000_hyp_billing_foundation.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "tenant_id",
              "definition": "uuid not null references public.ev1_tenants(id)"
            },
            {
              "name": "plan_code",
              "definition": "text not null check (plan_code in ('personal','family','business','enterprise'))"
            },
            {
              "name": "billing_interval",
              "definition": "text not null check (billing_interval in ('monthly','annual'))"
            },
            {
              "name": "status",
              "definition": "text not null default 'pending_payment'\n    check (status in ('pending_payment','trialing','active','past_due','canceled','expired'))"
            },
            {
              "name": "catalog_version",
              "definition": "text not null"
            },
            {
              "name": "terms_version",
              "definition": "text not null"
            },
            {
              "name": "billing_name",
              "definition": "text not null check (length(trim(billing_name)) between 2 and 160)"
            },
            {
              "name": "billing_email",
              "definition": "text not null check (\n    length(billing_email)<=254 and billing_email=lower(trim(billing_email))\n    and billing_email ~ '^[^[:space:]@]+@[^[:space:]@]+\\.[^[:space:]@]+$'\n  )"
            },
            {
              "name": "billing_tax_id",
              "definition": "text check (billing_tax_id is null or billing_tax_id ~ '^[0-9]{5,20}$')"
            },
            {
              "name": "price_minor",
              "definition": "bigint not null check (price_minor > 0 and price_minor <= 100000000)"
            },
            {
              "name": "price_includes_vat",
              "definition": "boolean not null"
            },
            {
              "name": "vat_rate_bps",
              "definition": "integer not null check (vat_rate_bps between 0 and 10000)"
            },
            {
              "name": "commission_rate_bps",
              "definition": "integer check (commission_rate_bps between 0 and 10000)"
            },
            {
              "name": "commission_basis",
              "definition": "text not null check (commission_basis = 'charging_gross')"
            },
            {
              "name": "payment_method_id",
              "definition": "uuid"
            },
            {
              "name": "accepted_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "current_period_start",
              "definition": "timestamptz"
            },
            {
              "name": "current_period_end",
              "definition": "timestamptz"
            },
            {
              "name": "next_charge_at",
              "definition": "timestamptz"
            },
            {
              "name": "cancel_at_period_end",
              "definition": "boolean not null default false"
            },
            {
              "name": "failed_attempts",
              "definition": "integer not null default 0 check (failed_attempts >= 0)"
            },
            {
              "name": "retry_after",
              "definition": "timestamptz"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "updated_at",
              "definition": "timestamptz not null default now()"
            }
          ],
          "constraints": [
            "unique (tenant_id,id)",
            "foreign key (tenant_id,payment_method_id)\n    references public.ev1_payment_methods(tenant_id,id)",
            "check (current_period_end is null or current_period_start is not null)",
            "check (current_period_end is null or current_period_end >= current_period_start)"
          ],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            },
            {
              "columns": "tenant_id,payment_method_id",
              "target": "public.ev1_payment_methods",
              "targetColumns": "tenant_id,id"
            }
          ]
        },
        {
          "id": "public.ev1_billing_obligations",
          "schema": "public",
          "name": "ev1_billing_obligations",
          "source": "supabase/migrations/20261110203000_hyp_billing_foundation.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "tenant_id",
              "definition": "uuid not null references public.ev1_tenants(id)"
            },
            {
              "name": "subscription_id",
              "definition": "uuid not null"
            },
            {
              "name": "session_id",
              "definition": "uuid"
            },
            {
              "name": "payment_method_id",
              "definition": "uuid"
            },
            {
              "name": "kind",
              "definition": "text not null check (kind in ('subscription','charging_commission'))"
            },
            {
              "name": "logical_key",
              "definition": "text not null check (length(logical_key) between 1 and 180)"
            },
            {
              "name": "description",
              "definition": "text not null check (length(description) between 1 and 300)"
            },
            {
              "name": "net_minor",
              "definition": "bigint not null check (net_minor >= 0 and net_minor <= 100000000)"
            },
            {
              "name": "tax_minor",
              "definition": "bigint not null check (tax_minor >= 0 and tax_minor <= 100000000)"
            },
            {
              "name": "amount_minor",
              "definition": "bigint not null check (amount_minor > 0 and amount_minor <= 100000000)"
            },
            {
              "name": "currency",
              "definition": "text not null default 'ILS' check (currency='ILS')"
            },
            {
              "name": "status",
              "definition": "text not null default 'open'\n    check (status in ('open','processing','paid','void','partially_refunded','refunded'))"
            },
            {
              "name": "commission_base_minor",
              "definition": "bigint"
            },
            {
              "name": "commission_rate_bps",
              "definition": "integer"
            },
            {
              "name": "commission_tax_rate_bps",
              "definition": "integer"
            },
            {
              "name": "due_at",
              "definition": "timestamptz not null"
            },
            {
              "name": "paid_at",
              "definition": "timestamptz"
            },
            {
              "name": "lease_owner",
              "definition": "uuid"
            },
            {
              "name": "lease_until",
              "definition": "timestamptz"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "updated_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "commission_policy_version",
              "definition": "text"
            }
          ],
          "constraints": [
            "unique (tenant_id,id)",
            "unique (tenant_id,logical_key)",
            "foreign key (tenant_id,subscription_id)\n    references public.ev1_subscriptions(tenant_id,id)",
            "foreign key (tenant_id,session_id)\n    references public.ev1_fleet_sessions(tenant_id,id)",
            "foreign key (tenant_id,payment_method_id)\n    references public.ev1_payment_methods(tenant_id,id)",
            "check (amount_minor = net_minor + tax_minor)",
            "check (\n    (kind='subscription' and session_id is null and commission_base_minor is null)\n    or\n    (kind='charging_commission' and session_id is not null and commission_base_minor is not null\n      and commission_rate_bps between 0 and 10000\n      and commission_tax_rate_bps between 0 and 10000)\n  )"
          ],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            },
            {
              "columns": "tenant_id,subscription_id",
              "target": "public.ev1_subscriptions",
              "targetColumns": "tenant_id,id"
            },
            {
              "columns": "tenant_id,session_id",
              "target": "public.ev1_fleet_sessions",
              "targetColumns": "tenant_id,id"
            },
            {
              "columns": "tenant_id,payment_method_id",
              "target": "public.ev1_payment_methods",
              "targetColumns": "tenant_id,id"
            }
          ]
        },
        {
          "id": "public.ev1_payment_attempts",
          "schema": "public",
          "name": "ev1_payment_attempts",
          "source": "supabase/migrations/20261110203000_hyp_billing_foundation.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "tenant_id",
              "definition": "uuid not null references public.ev1_tenants(id)"
            },
            {
              "name": "obligation_id",
              "definition": "uuid not null"
            },
            {
              "name": "provider",
              "definition": "text not null default 'hyp' check (provider='hyp')"
            },
            {
              "name": "action",
              "definition": "text not null check (action in ('checkout','card_verification','token_charge'))"
            },
            {
              "name": "status",
              "definition": "text not null default 'created'\n    check (status in ('created','pending_customer','processing','succeeded','failed','unknown'))"
            },
            {
              "name": "idempotency_key",
              "definition": "uuid not null"
            },
            {
              "name": "attempt_no",
              "definition": "integer not null default 1 check (attempt_no > 0)"
            },
            {
              "name": "amount_minor",
              "definition": "bigint not null check (amount_minor > 0 and amount_minor <= 100000000)"
            },
            {
              "name": "provider_payment_ref",
              "definition": "text"
            },
            {
              "name": "provider_authorization_code",
              "definition": "text"
            },
            {
              "name": "provider_code",
              "definition": "text"
            },
            {
              "name": "provider_message",
              "definition": "text"
            },
            {
              "name": "provider_brand",
              "definition": "text"
            },
            {
              "name": "provider_last_four",
              "definition": "text check (provider_last_four is null or provider_last_four ~ '^[0-9]{4}$')"
            },
            {
              "name": "provider_expiry_month",
              "definition": "integer check (provider_expiry_month is null or provider_expiry_month between 1 and 12)"
            },
            {
              "name": "provider_expiry_year",
              "definition": "integer check (provider_expiry_year is null or provider_expiry_year between 2020 and 2100)"
            },
            {
              "name": "provider_document_ref",
              "definition": "text"
            },
            {
              "name": "redirect_verified",
              "definition": "boolean not null default false"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "verified_at",
              "definition": "timestamptz"
            },
            {
              "name": "completed_at",
              "definition": "timestamptz"
            }
          ],
          "constraints": [
            "unique (tenant_id,id)",
            "unique (tenant_id,idempotency_key)",
            "foreign key (tenant_id,obligation_id)\n    references public.ev1_billing_obligations(tenant_id,id)"
          ],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            },
            {
              "columns": "tenant_id,obligation_id",
              "target": "public.ev1_billing_obligations",
              "targetColumns": "tenant_id,id"
            }
          ]
        },
        {
          "id": "public.ev1_financial_documents",
          "schema": "public",
          "name": "ev1_financial_documents",
          "source": "supabase/migrations/20261110203000_hyp_billing_foundation.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "tenant_id",
              "definition": "uuid not null references public.ev1_tenants(id)"
            },
            {
              "name": "obligation_id",
              "definition": "uuid not null"
            },
            {
              "name": "payment_attempt_id",
              "definition": "uuid not null"
            },
            {
              "name": "provider",
              "definition": "text not null default 'hyp' check (provider='hyp')"
            },
            {
              "name": "document_type",
              "definition": "text not null\n    check (document_type in ('invoice_receipt','receipt','credit_note','unknown'))"
            },
            {
              "name": "provider_document_ref",
              "definition": "text not null check (length(provider_document_ref) between 1 and 120)"
            },
            {
              "name": "amount_minor",
              "definition": "bigint not null check (amount_minor >= 0 and amount_minor <= 100000000)"
            },
            {
              "name": "currency",
              "definition": "text not null default 'ILS' check (currency='ILS')"
            },
            {
              "name": "status",
              "definition": "text not null default 'issued' check (status in ('issued','pending','failed','void'))"
            },
            {
              "name": "issued_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            }
          ],
          "constraints": [
            "unique (tenant_id,id)",
            "unique (provider,provider_document_ref)",
            "foreign key (tenant_id,obligation_id)\n    references public.ev1_billing_obligations(tenant_id,id)",
            "foreign key (tenant_id,payment_attempt_id)\n    references public.ev1_payment_attempts(tenant_id,id)"
          ],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            },
            {
              "columns": "tenant_id,obligation_id",
              "target": "public.ev1_billing_obligations",
              "targetColumns": "tenant_id,id"
            },
            {
              "columns": "tenant_id,payment_attempt_id",
              "target": "public.ev1_payment_attempts",
              "targetColumns": "tenant_id,id"
            }
          ]
        },
        {
          "id": "public.ev1_refunds",
          "schema": "public",
          "name": "ev1_refunds",
          "source": "supabase/migrations/20261110203000_hyp_billing_foundation.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "tenant_id",
              "definition": "uuid not null references public.ev1_tenants(id)"
            },
            {
              "name": "payment_attempt_id",
              "definition": "uuid not null"
            },
            {
              "name": "idempotency_key",
              "definition": "uuid not null"
            },
            {
              "name": "provider",
              "definition": "text not null default 'hyp' check (provider='hyp')"
            },
            {
              "name": "provider_ref",
              "definition": "text"
            },
            {
              "name": "amount_minor",
              "definition": "bigint not null check (amount_minor > 0 and amount_minor <= 100000000)"
            },
            {
              "name": "status",
              "definition": "text not null default 'pending'\n    check (status in ('pending','succeeded','failed','unknown'))"
            },
            {
              "name": "provider_code",
              "definition": "text"
            },
            {
              "name": "provider_message",
              "definition": "text"
            },
            {
              "name": "document_ref",
              "definition": "text"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "completed_at",
              "definition": "timestamptz"
            }
          ],
          "constraints": [
            "unique (tenant_id,id)",
            "unique (tenant_id,idempotency_key)",
            "foreign key (tenant_id,payment_attempt_id)\n    references public.ev1_payment_attempts(tenant_id,id)"
          ],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            },
            {
              "columns": "tenant_id,payment_attempt_id",
              "target": "public.ev1_payment_attempts",
              "targetColumns": "tenant_id,id"
            }
          ]
        },
        {
          "id": "public.lne_account_deletion_requests",
          "schema": "public",
          "name": "lne_account_deletion_requests",
          "source": "supabase/migrations/20261111155528_mobile_onboarding_and_deletion_requests.sql",
          "scope": "catalog",
          "legacy": false,
          "columns": [
            {
              "name": "id",
              "definition": "uuid primary key default gen_random_uuid()"
            },
            {
              "name": "clerk_user_id",
              "definition": "text not null\n    check (clerk_user_id ~ '^user_[A-Za-z0-9]{5,100}$')"
            },
            {
              "name": "status",
              "definition": "text not null default 'requested'\n    check (status in ('requested','in_review','completed'))"
            },
            {
              "name": "requested_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "updated_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "completed_at",
              "definition": "timestamptz"
            },
            {
              "name": "retention_summary",
              "definition": "text\n    check (retention_summary is null or length(retention_summary) <= 2000)"
            }
          ],
          "constraints": [
            "constraint lne_deletion_completed_state check (\n    (status = 'completed') = (completed_at is not null)\n  )"
          ],
          "relations": []
        },
        {
          "id": "public.lne_clerk_org_provision_claims",
          "schema": "public",
          "name": "lne_clerk_org_provision_claims",
          "source": "supabase/migrations/20261111161830_clerk_org_provision_claims.sql",
          "scope": "tenant",
          "legacy": false,
          "columns": [
            {
              "name": "tenant_id",
              "definition": "uuid primary key references public.ev1_tenants(id)"
            },
            {
              "name": "owner_user_id",
              "definition": "text not null check (length(owner_user_id) > 0)"
            },
            {
              "name": "status",
              "definition": "text not null default 'creating'\n    check (status in ('creating', 'linked'))"
            },
            {
              "name": "clerk_org_id",
              "definition": "text\n    check (clerk_org_id is null or clerk_org_id ~ '^org_[A-Za-z0-9]{5,100}$')"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "updated_at",
              "definition": "timestamptz not null default now()"
            }
          ],
          "constraints": [
            "constraint lne_org_claim_linked_state check (\n    (status = 'linked') = (clerk_org_id is not null)\n  )"
          ],
          "relations": [
            {
              "columns": "tenant_id",
              "target": "public.ev1_tenants",
              "targetColumns": "id"
            }
          ]
        },
        {
          "id": "ev1_private.charging_fee_queue",
          "schema": "ev1_private",
          "name": "charging_fee_queue",
          "source": "supabase/migrations/20261121230000_uniform_charging_commission.sql",
          "scope": "private",
          "legacy": false,
          "columns": [
            {
              "name": "tenant_id",
              "definition": "uuid not null"
            },
            {
              "name": "session_id",
              "definition": "uuid not null"
            },
            {
              "name": "policy_version",
              "definition": "text not null default '1.4.0' check(policy_version='1.4.0')"
            },
            {
              "name": "provider_gross_minor",
              "definition": "bigint check(provider_gross_minor between 0 and 100000000)"
            },
            {
              "name": "status",
              "definition": "text not null check(status in\n    ('waiting_completion','pending','waiting_payment','created','no_charge','ignored','review'))"
            },
            {
              "name": "obligation_id",
              "definition": "uuid"
            },
            {
              "name": "attempts",
              "definition": "integer not null default 0 check(attempts>=0)"
            },
            {
              "name": "last_error_code",
              "definition": "text"
            },
            {
              "name": "next_attempt_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "created_at",
              "definition": "timestamptz not null default now()"
            },
            {
              "name": "updated_at",
              "definition": "timestamptz not null default now()"
            }
          ],
          "constraints": [
            "primary key(tenant_id,session_id)",
            "foreign key(tenant_id,session_id) references public.ev1_fleet_sessions(tenant_id,id) on delete cascade",
            "foreign key(tenant_id,obligation_id) references public.ev1_billing_obligations(tenant_id,id)",
            "check((status='created')=(obligation_id is not null))"
          ],
          "relations": [
            {
              "columns": "tenant_id,session_id",
              "target": "public.ev1_fleet_sessions",
              "targetColumns": "tenant_id,id"
            },
            {
              "columns": "tenant_id,obligation_id",
              "target": "public.ev1_billing_obligations",
              "targetColumns": "tenant_id,id"
            }
          ]
        }
      ]
    }