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

> תיעוד מקור. מקור: lib/systems/dictionary.json · 6a466bf.

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

```json
{
  "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"
        }
      ]
    }
  ]
}
```
