database.mmd

erDiagram

  fleetbase_activity {
    INTUNSIGNED id PK
    CHAR uuid
    VARCHAR log_name
    TEXT description
    CHAR company_id
    CHAR subject_id
    VARCHAR subject_type
    CHAR causer_id
    VARCHAR causer_type
    TEXT properties
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_api_credentials {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR user_uuid FK
    VARCHAR company_uuid FK
    VARCHAR name
    VARCHAR key
    VARCHAR secret
    INT test_mode
    VARCHAR api
    JSON browser_origins
    DATETIME last_used_at
    DATETIME expires_at
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_api_events {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR company_uuid
    VARCHAR api_credential_uuid
    VARCHAR event
    VARCHAR source
    JSON data
    VARCHAR description
    VARCHAR method
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_api_request_logs {
    INTUNSIGNED id PK
    VARCHAR _key
    CHAR uuid UK
    CHAR company_uuid FK
    CHAR api_credential_uuid FK
    VARCHAR public_id
    VARCHAR method
    VARCHAR path
    VARCHAR full_url
    VARCHAR status_code
    VARCHAR reason_phrase
    DECIMAL duration
    VARCHAR ip_address
    VARCHAR version
    VARCHAR source
    VARCHAR content_type
    JSON related
    JSON query_params
    JSON request_headers
    JSON request_body
    MEDIUMTEXT request_raw_body
    JSON response_headers
    JSON response_body
    MEDIUMTEXT response_raw_body
    TIMESTAMP created_at
    TIMESTAMP updated_at
    TIMESTAMP deleted_at
  }

  fleetbase_billing_customers {
    BIGINTUNSIGNED id PK
    CHAR uuid
    CHAR company_uuid FK
    VARCHAR payment_gateway_id
    VARCHAR pm_type
    VARCHAR pm_last_four
    TIMESTAMP trial_ends_at
    JSON options
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_billing_payment_gateways {
    BIGINTUNSIGNED id PK
    CHAR uuid
    VARCHAR name
    VARCHAR code
    VARCHAR description
    VARCHAR api_key
    VARCHAR api_secret
    VARCHAR callback_url
    VARCHAR return_url
    VARCHAR webhook_secret
    CHAR logo_uuid FK
    CHAR backdrop_uuid FK
    JSON options
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_billing_plans {
    BIGINTUNSIGNED id PK
    CHAR uuid
    CHAR payment_gateway_uuid FK
    VARCHAR name
    TEXT description
    VARCHAR payment_gateway_id
    INT price
    BIT recurring
    VARCHAR billing_period
    VARCHAR interval
    INT trial_period_days
    JSON options
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_billing_subscription_items {
    BIGINTUNSIGNED id PK
    CHAR uuid
    CHAR subscription_uuid FK
    VARCHAR payment_gateway_id
    VARCHAR payment_gateway_product
    VARCHAR payment_gateway_price
    INT quantity
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_billing_subscriptions {
    BIGINTUNSIGNED id PK
    CHAR uuid
    CHAR company_uuid FK
    CHAR payment_gateway_uuid FK
    CHAR plan_uuid FK
    VARCHAR name
    VARCHAR payment_gateway_id
    VARCHAR payment_gateway_status
    VARCHAR payment_gateway_price
    INT quantity
    TIMESTAMP trial_ends_at
    TIMESTAMP ends_at
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_categories {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id
    VARCHAR company_uuid
    VARCHAR parent_uuid
    VARCHAR owner_uuid
    VARCHAR owner_type
    VARCHAR name
    VARCHAR internal_id
    VARCHAR description
    JSON translations
    JSON tags
    JSON meta
    VARCHAR icon
    VARCHAR icon_color
    VARCHAR for
    VARCHAR slug
    VARCHAR order
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
    CHAR icon_file_uuid FK
  }

  fleetbase_companies {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR stripe_id
    VARCHAR stripe_connect_id
    TIMESTAMP trial_ends_at
    VARCHAR card_last_four
    VARCHAR card_brand
    VARCHAR owner_uuid FK
    VARCHAR logo_uuid FK
    VARCHAR backdrop_uuid FK
    VARCHAR name
    VARCHAR website_url
    VARCHAR description
    JSON options
    VARCHAR phone
    VARCHAR currency
    VARCHAR country
    VARCHAR timezone
    VARCHAR place_uuid FK
    VARCHAR plan
    VARCHAR status
    VARCHAR type
    VARCHAR slug
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_company_users {
    INTUNSIGNED id PK
    VARCHAR _key
    CHAR uuid UK
    CHAR company_uuid FK
    CHAR user_uuid FK
    VARCHAR status
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_contacts {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR internal_id
    VARCHAR company_uuid FK
    CHAR user_uuid
    VARCHAR photo_uuid FK
    VARCHAR name
    VARCHAR title
    VARCHAR email
    VARCHAR phone
    VARCHAR type
    VARCHAR slug
    JSON meta
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_drivers {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR internal_id
    VARCHAR company_uuid FK
    VARCHAR vehicle_uuid FK
    VARCHAR vendor_uuid FK
    VARCHAR vendor_type
    VARCHAR current_job_uuid FK
    VARCHAR user_uuid FK
    VARCHAR auth_token
    VARCHAR drivers_license_number
    VARCHAR signup_token_used
    GEOMETRY location
    VARCHAR latitude
    VARCHAR longitude
    VARCHAR heading
    VARCHAR bearing
    VARCHAR speed
    VARCHAR altitude
    VARCHAR country
    VARCHAR city
    VARCHAR currency
    INT online
    VARCHAR status
    VARCHAR slug
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_entities {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR payload_uuid FK
    VARCHAR company_uuid FK
    VARCHAR driver_assigned_uuid FK
    VARCHAR destination_uuid FK
    VARCHAR customer_uuid
    VARCHAR customer_type
    VARCHAR tracking_number_uuid FK
    MEDIUMTEXT photo_uuid
    VARCHAR _import_id
    VARCHAR internal_id
    VARCHAR name
    VARCHAR type
    MEDIUMTEXT description
    VARCHAR currency
    MEDIUMTEXT barcode
    MEDIUMTEXT qr_code
    VARCHAR weight
    VARCHAR weight_unit
    VARCHAR length
    VARCHAR width
    VARCHAR height
    VARCHAR dimensions_unit
    INT declared_value
    VARCHAR sku
    VARCHAR price
    VARCHAR sale_price
    JSON meta
    VARCHAR slug
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_extension_installs {
    BIGINTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    CHAR extension_uuid FK
    VARCHAR company_uuid FK
    JSON config
    JSON meta
    JSON overwrite
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_extensions {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR extension_id UK
    VARCHAR author_uuid FK
    VARCHAR category_uuid FK
    VARCHAR type_uuid FK
    VARCHAR name
    VARCHAR display_name
    VARCHAR key
    MEDIUMTEXT description
    JSON tags
    VARCHAR namespace
    VARCHAR version
    VARCHAR component_url
    VARCHAR website_url
    VARCHAR privacy_policy_url
    VARCHAR tos_url
    VARCHAR contact_email
    VARCHAR icon_uuid FK
    JSON domains
    BIT core_service
    VARCHAR internal_route
    VARCHAR fa_icon
    JSON meta
    VARCHAR meta_type
    JSON config
    VARCHAR secret
    VARCHAR client_token
    VARCHAR status
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
    VARCHAR slug
  }

  fleetbase_failed_jobs {
    BIGINTUNSIGNED id PK
    VARCHAR uuid UK
    TEXT connection
    TEXT queue
    LONGTEXT payload
    LONGTEXT exception
    TIMESTAMP failed_at
  }

  fleetbase_files {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id
    VARCHAR company_uuid
    VARCHAR uploader_uuid
    VARCHAR subject_uuid
    VARCHAR disk
    VARCHAR caption
    LONGTEXT path
    VARCHAR subject_type
    VARCHAR bucket
    VARCHAR folder
    VARCHAR etag
    JSON meta
    MEDIUMTEXT data_params
    VARCHAR original_filename
    VARCHAR type
    VARCHAR content_type
    INT file_size
    VARCHAR slug
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_fleet_drivers {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR fleet_uuid FK
    VARCHAR driver_uuid FK
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_fleet_vehicles {
    INTUNSIGNED id PK
    VARCHAR _key
    CHAR uuid UK
    CHAR fleet_uuid FK
    CHAR vehicle_uuid FK
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_fleets {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR company_uuid FK
    VARCHAR service_area_uuid FK
    VARCHAR zone_uuid FK
    CHAR vendor_uuid FK
    CHAR parent_fleet_uuid FK
    VARCHAR image_uuid
    VARCHAR name
    VARCHAR color
    VARCHAR task
    VARCHAR status
    VARCHAR slug
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_fuel_reports {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR company_uuid FK
    VARCHAR driver_uuid FK
    VARCHAR vehicle_uuid FK
    VARCHAR odometer
    GEOMETRY location
    VARCHAR latitude
    VARCHAR longitude
    VARCHAR amount
    VARCHAR currency
    VARCHAR volume
    VARCHAR metric_unit
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_group_users {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    CHAR group_uuid FK
    CHAR user_uuid FK
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_groups {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR company_uuid FK
    VARCHAR name
    VARCHAR description
    VARCHAR slug
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_integrated_vendors {
    BIGINTUNSIGNED id PK
    VARCHAR _key
    CHAR uuid UK
    CHAR company_uuid FK
    CHAR created_by_uuid FK
    VARCHAR public_id
    VARCHAR host
    VARCHAR namespace
    VARCHAR webhook_url
    VARCHAR provider
    JSON credentials
    JSON options
    BIT sandbox
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_invites {
    BIGINTUNSIGNED id PK
    VARCHAR _key
    CHAR uuid UK
    CHAR company_uuid FK
    CHAR created_by_uuid FK
    CHAR subject_uuid
    VARCHAR subject_type
    VARCHAR public_id
    VARCHAR uri
    VARCHAR code
    VARCHAR protocol
    JSON recipients
    VARCHAR reason
    DATETIME expires_at
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_issues {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR issue_id UK
    VARCHAR company_uuid FK
    VARCHAR driver_uuid FK
    VARCHAR vehicle_uuid FK
    VARCHAR assigned_to_uuid FK
    VARCHAR odometer
    GEOMETRY location
    VARCHAR latitude
    VARCHAR longitude
    VARCHAR type
    VARCHAR report
    VARCHAR priority
    DATETIME resolved_at
    VARCHAR status
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_login_attempts {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR identity
    VARCHAR password
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_migrations {
    INTUNSIGNED id PK
    VARCHAR migration
    INT batch
  }

  fleetbase_model_has_permissions {
    CHAR permission_id PK
    VARCHAR model_type PK
    CHAR model_id PK
  }

  fleetbase_model_has_policies {
    CHAR policy_id PK
    VARCHAR model_type PK
    CHAR model_uuid PK
  }

  fleetbase_model_has_roles {
    CHAR role_id PK
    VARCHAR model_type PK
    CHAR model_id PK
  }

  fleetbase_orders {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR company_uuid FK
    CHAR created_by_uuid FK
    CHAR updated_by_uuid FK
    VARCHAR internal_id
    VARCHAR customer_uuid
    VARCHAR customer_type
    VARCHAR facilitator_uuid
    VARCHAR facilitator_type
    VARCHAR session_uuid
    VARCHAR payload_uuid FK
    CHAR route_uuid FK
    VARCHAR transaction_uuid FK
    VARCHAR purchase_rate_uuid FK
    VARCHAR tracking_number_uuid FK
    VARCHAR driver_assigned_uuid FK
    JSON meta
    JSON options
    BIT dispatched
    DATETIME dispatched_at
    BIT adhoc
    INT adhoc_distance
    BIT started
    DATETIME started_at
    INT distance
    INT time
    BIT pod_required
    BIT is_route_optimized
    VARCHAR pod_method
    MEDIUMTEXT notes
    DATETIME scheduled_at
    VARCHAR type
    VARCHAR status
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_payloads {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR company_uuid FK
    VARCHAR pickup_uuid FK
    VARCHAR dropoff_uuid FK
    VARCHAR return_uuid FK
    VARCHAR current_waypoint_uuid FK
    VARCHAR provider
    VARCHAR payment_method
    INT cod_amount
    VARCHAR cod_currency
    VARCHAR cod_payment_method
    VARCHAR type
    JSON meta
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_permissions {
    CHAR id
    VARCHAR name UK
    VARCHAR guard_name UK
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_personal_access_tokens {
    BIGINTUNSIGNED id PK
    VARCHAR tokenable_type
    CHAR tokenable_id "(DC2Type:guid)"
    VARCHAR name
    VARCHAR token UK
    TEXT abilities
    TIMESTAMP last_used_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_places {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR _import_id
    VARCHAR company_uuid FK
    CHAR owner_uuid
    VARCHAR owner_type
    VARCHAR name
    VARCHAR street1
    VARCHAR street2
    VARCHAR city
    VARCHAR province
    VARCHAR postal_code
    VARCHAR neighborhood
    VARCHAR district
    VARCHAR building
    VARCHAR security_access_code
    VARCHAR country
    GEOMETRY location
    VARCHAR latitude
    VARCHAR longitude
    JSON meta
    VARCHAR phone
    MEDIUMTEXT remarks
    VARCHAR type
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_policies {
    CHAR id PK
    VARCHAR _key
    CHAR company_uuid FK
    VARCHAR name
    VARCHAR guard_name
    VARCHAR description
    TIMESTAMP created_at
    TIMESTAMP updated_at
    TIMESTAMP deleted_at
  }

  fleetbase_positions {
    BIGINTUNSIGNED id PK
    VARCHAR _key
    CHAR uuid UK
    CHAR company_uuid FK
    CHAR order_uuid FK
    CHAR destination_uuid FK
    CHAR subject_uuid
    VARCHAR subject_type
    GEOMETRY coordinates
    VARCHAR heading
    VARCHAR bearing
    VARCHAR speed
    VARCHAR altitude
    TIMESTAMP created_at
    TIMESTAMP updated_at
    TIMESTAMP deleted_at
  }

  fleetbase_proofs {
    INTUNSIGNED id PK
    VARCHAR _key
    CHAR uuid UK
    VARCHAR public_id UK
    CHAR order_uuid
    CHAR subject_uuid
    VARCHAR subject_type
    CHAR company_uuid FK
    CHAR file_uuid FK
    LONGTEXT remarks
    LONGTEXT raw_data
    JSON data
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_purchase_rates {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    JSON meta
    VARCHAR customer_uuid
    VARCHAR customer_type
    VARCHAR company_uuid FK
    VARCHAR transaction_uuid FK
    VARCHAR service_quote_uuid FK
    VARCHAR payload_uuid FK
    VARCHAR status
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_role_has_permissions {
    CHAR permission_id PK
    CHAR role_id PK
  }

  fleetbase_roles {
    CHAR id
    CHAR company_uuid FK
    VARCHAR name UK
    VARCHAR guard_name UK
    VARCHAR description
    TIMESTAMP created_at
    TIMESTAMP updated_at
    TIMESTAMP deleted_at
  }

  fleetbase_routes {
    BIGINTUNSIGNED id PK
    VARCHAR _key
    CHAR uuid UK
    CHAR company_uuid FK
    CHAR order_uuid FK
    JSON details
    DOUBLE total_distance
    DOUBLE total_time
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_service_areas {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR company_uuid FK
    VARCHAR name
    VARCHAR type
    VARCHAR country
    GEOMETRY border
    VARCHAR color
    VARCHAR stroke_color
    VARCHAR parent_uuid FK
    VARCHAR status
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_service_quote_items {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR service_quote_uuid FK
    VARCHAR amount
    VARCHAR currency
    VARCHAR details
    VARCHAR code
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_service_quotes {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR request_id
    VARCHAR company_uuid FK
    VARCHAR payload_uuid FK
    VARCHAR service_rate_uuid FK
    INT amount
    VARCHAR currency
    JSON meta
    VARCHAR expired_at
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
    CHAR integrated_vendor_uuid FK
  }

  fleetbase_service_rate_fees {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR service_rate_uuid FK
    INT distance
    INT min
    INT max
    VARCHAR unit
    VARCHAR distance_unit
    INT fee
    VARCHAR currency
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_service_rate_parcel_fees {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR service_rate_uuid FK
    VARCHAR size
    VARCHAR length
    VARCHAR width
    VARCHAR height
    VARCHAR dimensions_unit
    VARCHAR weight
    VARCHAR weight_unit
    INT fee
    VARCHAR currency
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_service_rates {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR company_uuid FK
    VARCHAR service_area_uuid FK
    VARCHAR zone_uuid FK
    VARCHAR service_name
    VARCHAR service_type
    INT base_fee
    INT per_meter_flat_rate_fee
    VARCHAR per_meter_unit
    VARCHAR algorithm
    VARCHAR rate_calculation_method
    INT has_cod_fee
    VARCHAR cod_calculation_method
    INT cod_flat_fee
    INT cod_percent
    INT has_peak_hours_fee
    VARCHAR peak_hours_calculation_method
    INT peak_hours_flat_fee
    INT peak_hours_percent
    VARCHAR peak_hours_start
    VARCHAR peak_hours_end
    VARCHAR currency
    VARCHAR duration_terms
    INT estimated_days
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_settings {
    INTUNSIGNED id PK
    VARCHAR key UK
    JSON value
  }

  fleetbase_tracking_numbers {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR company_uuid FK
    VARCHAR owner_uuid
    VARCHAR owner_type
    VARCHAR status_uuid FK
    VARCHAR tracking_number
    VARCHAR region
    MEDIUMTEXT qr_code
    MEDIUMTEXT barcode
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_tracking_statuses {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR company_uuid FK
    VARCHAR tracking_number_uuid FK
    CHAR proof_uuid
    JSON meta
    VARCHAR status
    MEDIUMTEXT details
    VARCHAR code
    VARCHAR city
    VARCHAR province
    VARCHAR postal_code
    VARCHAR country
    GEOMETRY location
    VARCHAR latitude
    VARCHAR longitude
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_transaction_items {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR transaction_uuid FK
    VARCHAR amount
    VARCHAR currency
    VARCHAR details
    VARCHAR code
    JSON meta
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_transactions {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    CHAR owner_uuid
    VARCHAR owner_type
    VARCHAR customer_uuid
    VARCHAR customer_type
    VARCHAR company_uuid FK
    CHAR gateway_uuid
    VARCHAR gateway_transaction_id
    VARCHAR gateway
    INT amount
    VARCHAR currency
    VARCHAR description
    VARCHAR type
    VARCHAR status
    JSON meta
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_types {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR company_uuid FK
    CHAR subject_uuid
    VARCHAR subject_type
    VARCHAR name
    VARCHAR description
    VARCHAR key
    VARCHAR slug
    VARCHAR for
    JSON meta
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_user_devices {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id
    VARCHAR user_uuid FK
    VARCHAR platform
    MEDIUMTEXT token
    VARCHAR status
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_users {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR company_uuid FK
    VARCHAR avatar_uuid FK
    VARCHAR username UK
    VARCHAR email
    VARCHAR phone
    VARCHAR password
    VARCHAR name
    VARCHAR date_of_birth
    VARCHAR timezone
    VARCHAR country
    VARCHAR ip_address
    VARCHAR last_login
    VARCHAR slug
    VARCHAR type
    VARCHAR status
    JSON meta
    VARCHAR remember_token
    DATETIME email_verified_at
    DATETIME phone_verified_at
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_vehicle_devices {
    INTUNSIGNED id PK
    CHAR uuid
    CHAR vehicle_uuid FK
    VARCHAR device_id
    VARCHAR device_provider
    VARCHAR device_type
    VARCHAR device_name
    VARCHAR device_location
    VARCHAR device_model
    VARCHAR manufacturer
    VARCHAR serial_number
    DATE installation_date
    DATE last_maintenance_date
    JSON meta
    JSON data
    BIT online
    VARCHAR status
    VARCHAR data_frequency
    TEXT notes
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_vehicles {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR company_uuid FK
    VARCHAR vendor_uuid FK
    VARCHAR photo_uuid FK
    VARCHAR avatar_url
    GEOMETRY location
    VARCHAR speed
    VARCHAR heading
    VARCHAR altitude
    VARCHAR make
    VARCHAR model
    VARCHAR year
    VARCHAR trim
    VARCHAR type
    VARCHAR plate_number
    VARCHAR vin
    MEDIUMTEXT vin_data
    JSON meta
    JSON telematics
    JSON model_data
    VARCHAR status
    BIT online
    VARCHAR slug
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_vendors {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR company_uuid FK
    VARCHAR place_uuid FK
    VARCHAR type_uuid FK
    VARCHAR connect_company_uuid FK
    VARCHAR logo_uuid FK
    VARCHAR name
    VARCHAR internal_id
    VARCHAR business_id
    INT connected
    VARCHAR email
    VARCHAR phone
    VARCHAR website_url
    VARCHAR country
    JSON meta
    JSON callbacks
    VARCHAR type
    VARCHAR status
    VARCHAR slug
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_verification_codes {
    INTUNSIGNED id PK
    VARCHAR _key
    CHAR uuid UK
    CHAR subject_uuid
    VARCHAR subject_type
    VARCHAR code
    VARCHAR for
    JSON meta
    DATETIME expires_at
    VARCHAR status
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_waypoints {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id
    VARCHAR company_uuid FK
    VARCHAR place_uuid FK
    VARCHAR payload_uuid FK
    VARCHAR tracking_number_uuid FK
    VARCHAR _import_id
    VARCHAR type
    INT order
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_webhook_endpoints {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR company_uuid FK
    CHAR updated_by_uuid FK
    CHAR created_by_uuid FK
    VARCHAR api_credential_uuid FK
    VARCHAR url
    VARCHAR mode
    VARCHAR version
    VARCHAR description
    JSON events
    VARCHAR status
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_webhook_request_logs {
    INTUNSIGNED id PK
    VARCHAR _key
    CHAR uuid UK
    VARCHAR public_id UK
    CHAR company_uuid FK
    CHAR webhook_uuid FK
    CHAR api_credential_uuid FK
    CHAR api_event_uuid FK
    VARCHAR method
    VARCHAR status_code
    VARCHAR reason_phrase
    DECIMAL duration
    VARCHAR url
    INT attempt
    JSON meta
    JSON headers
    JSON response
    VARCHAR status
    DATETIME sent_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
    TIMESTAMP deleted_at
  }

  fleetbase_zones {
    INTUNSIGNED id PK
    VARCHAR _key
    VARCHAR uuid UK
    VARCHAR public_id UK
    VARCHAR company_uuid FK
    VARCHAR service_area_uuid FK
    VARCHAR name
    MEDIUMTEXT description
    GEOMETRY border
    VARCHAR color
    VARCHAR stroke_color
    VARCHAR status
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_carts {
    BIGINTUNSIGNED id PK
    CHAR uuid UK
    VARCHAR public_id
    CHAR company_uuid FK
    CHAR user_uuid FK
    CHAR checkout_uuid FK
    VARCHAR customer_id
    VARCHAR unique_identifier
    VARCHAR currency
    VARCHAR discount_code
    JSON items
    JSON events
    DATETIME expires_at
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_checkouts {
    BIGINTUNSIGNED id PK
    CHAR uuid UK
    VARCHAR public_id
    CHAR company_uuid FK
    CHAR order_uuid FK
    CHAR cart_uuid FK
    CHAR store_uuid FK
    CHAR network_uuid FK
    CHAR gateway_uuid FK
    CHAR service_quote_uuid FK
    CHAR owner_uuid
    VARCHAR owner_type
    VARCHAR token
    INT amount
    VARCHAR currency
    BIT is_cod
    BIT is_pickup
    JSON options
    JSON cart_state
    BIT captured
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_gateways {
    BIGINTUNSIGNED id PK
    CHAR uuid UK
    VARCHAR public_id
    CHAR company_uuid FK
    CHAR created_by_uuid FK
    CHAR logo_file_uuid FK
    CHAR owner_uuid
    VARCHAR owner_type
    VARCHAR name
    VARCHAR description
    VARCHAR code
    VARCHAR type
    BIT sandbox
    JSON meta
    JSON config
    VARCHAR return_url
    VARCHAR callback_url
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_network_stores {
    BIGINTUNSIGNED id PK
    CHAR uuid UK
    VARCHAR network_uuid FK
    VARCHAR store_uuid FK
    CHAR category_uuid FK
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_networks {
    BIGINTUNSIGNED id PK
    VARCHAR public_id
    CHAR uuid UK
    VARCHAR created_by_uuid FK
    VARCHAR company_uuid FK
    CHAR logo_uuid FK
    CHAR backdrop_uuid FK
    VARCHAR name
    LONGTEXT key
    BIT online
    VARCHAR currency
    VARCHAR timezone
    VARCHAR pod_method
    JSON options
    JSON alertable
    VARCHAR description
    VARCHAR phone
    VARCHAR email
    VARCHAR website
    VARCHAR facebook
    VARCHAR instagram
    VARCHAR twitter
    JSON tags
    JSON translations
    VARCHAR slug
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_notification_channels {
    BIGINTUNSIGNED id PK
    CHAR uuid
    CHAR company_uuid FK
    CHAR created_by_uuid FK
    VARCHAR owner_uuid
    VARCHAR owner_type
    CHAR certificate_uuid FK
    JSON config
    JSON options
    VARCHAR name
    VARCHAR scheme
    VARCHAR app_key
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_payment_methods {
    BIGINTUNSIGNED id PK
    CHAR uuid UK
    VARCHAR public_id
    CHAR company_uuid FK
    CHAR store_uuid FK
    CHAR gateway_uuid FK
    CHAR owner_uuid
    VARCHAR owner_type
    VARCHAR gateway_id
    VARCHAR type
    VARCHAR brand
    VARCHAR last4
    JSON meta
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_product_addon_categories {
    BIGINTUNSIGNED id PK
    CHAR uuid UK
    VARCHAR product_uuid FK
    VARCHAR category_uuid FK
    JSON excluded_addons
    MEDIUMINT max_selectable
    BIT is_required
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_product_addons {
    BIGINTUNSIGNED id PK
    VARCHAR public_id
    CHAR uuid UK
    VARCHAR created_by_uuid FK
    VARCHAR category_uuid FK
    VARCHAR name
    VARCHAR description
    JSON translations
    INT price
    INT sale_price
    BIT is_on_sale
    VARCHAR slug
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_product_hours {
    BIGINTUNSIGNED id PK
    CHAR uuid UK
    VARCHAR product_uuid FK
    VARCHAR day_of_week
    TIME start
    TIME end
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_product_store_locations {
    BIGINTUNSIGNED id PK
    VARCHAR product_uuid FK
    VARCHAR store_location_uuid FK
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_product_variant_options {
    BIGINTUNSIGNED id PK
    VARCHAR public_id
    CHAR uuid UK
    VARCHAR product_variant_uuid FK
    VARCHAR name
    VARCHAR description
    JSON translations
    JSON meta
    INT additional_cost
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_product_variants {
    BIGINTUNSIGNED id PK
    VARCHAR public_id
    CHAR uuid UK
    VARCHAR product_uuid FK
    VARCHAR name
    VARCHAR description
    JSON translations
    JSON meta
    BIT is_multiselect
    BIT is_required
    MEDIUMINT min
    MEDIUMINT max
    VARCHAR slug
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_products {
    BIGINTUNSIGNED id PK
    VARCHAR public_id
    CHAR uuid UK
    VARCHAR company_uuid FK
    VARCHAR created_by_uuid FK
    VARCHAR primary_image_uuid FK
    VARCHAR store_uuid FK
    VARCHAR category_uuid FK
    VARCHAR name
    LONGTEXT description
    JSON tags
    JSON meta
    JSON translations
    MEDIUMTEXT qr_code
    MEDIUMTEXT barcode
    JSON youtube_urls
    VARCHAR sku
    INT price
    INT sale_price
    BIT is_on_sale
    BIT is_service
    BIT is_bookable
    BIT is_available
    BIT is_recommended
    BIT can_pickup
    VARCHAR currency
    VARCHAR status
    VARCHAR slug
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_reviews {
    BIGINTUNSIGNED id PK
    CHAR uuid UK
    VARCHAR public_id UK
    VARCHAR created_by_uuid FK
    CHAR customer_uuid FK
    CHAR subject_uuid
    VARCHAR subject_type
    MEDIUMINT rating
    TEXT content
    BIT rejected
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_store_hours {
    BIGINTUNSIGNED id PK
    CHAR uuid UK
    CHAR store_location_uuid FK
    VARCHAR day_of_week
    TIME start
    TIME end
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_store_locations {
    BIGINTUNSIGNED id PK
    VARCHAR public_id
    CHAR uuid UK
    VARCHAR store_uuid FK
    VARCHAR created_by_uuid FK
    VARCHAR place_uuid FK
    VARCHAR name
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_stores {
    BIGINTUNSIGNED id PK
    VARCHAR public_id
    CHAR uuid UK
    VARCHAR created_by_uuid FK
    VARCHAR company_uuid FK
    VARCHAR logo_uuid FK
    CHAR backdrop_uuid FK
    VARCHAR name
    LONGTEXT description
    VARCHAR phone
    VARCHAR email
    VARCHAR website
    VARCHAR facebook
    VARCHAR instagram
    VARCHAR twitter
    JSON tags
    JSON translations
    LONGTEXT key
    BIT online
    VARCHAR currency
    VARCHAR timezone
    VARCHAR pod_method
    JSON options
    JSON alertable
    JSON meta
    VARCHAR slug
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_storefront_votes {
    BIGINTUNSIGNED id PK
    CHAR uuid UK
    VARCHAR public_id UK
    VARCHAR created_by_uuid FK
    CHAR customer_uuid FK
    CHAR subject_uuid
    VARCHAR subject_type
    VARCHAR type
    TIMESTAMP deleted_at
    TIMESTAMP created_at
    TIMESTAMP updated_at
  }

  fleetbase_api_credentials ||--o{ fleetbase_api_request_logs : "foreign key"
  fleetbase_api_credentials ||--o{ fleetbase_webhook_endpoints : "foreign key"
  fleetbase_api_credentials ||--o{ fleetbase_webhook_request_logs : "foreign key"
  fleetbase_api_events ||--o{ fleetbase_webhook_request_logs : "foreign key"
  fleetbase_billing_payment_gateways ||--o{ fleetbase_billing_plans : "foreign key"
  fleetbase_billing_payment_gateways ||--o{ fleetbase_billing_subscriptions : "foreign key"
  fleetbase_billing_plans ||--o{ fleetbase_billing_subscriptions : "foreign key"
  fleetbase_billing_subscriptions ||--o{ fleetbase_billing_subscription_items : "foreign key"
  fleetbase_categories ||--o{ fleetbase_extensions : "foreign key"
  fleetbase_categories ||--o{ fleetbase_storefront_network_stores : "foreign key"
  fleetbase_categories ||--o{ fleetbase_storefront_product_addon_categories : "foreign key"
  fleetbase_categories ||--o{ fleetbase_storefront_product_addons : "foreign key"
  fleetbase_categories ||--o{ fleetbase_storefront_products : "foreign key"
  fleetbase_companies ||--o{ fleetbase_api_credentials : "foreign key"
  fleetbase_companies ||--o{ fleetbase_api_request_logs : "foreign key"
  fleetbase_companies ||--o{ fleetbase_billing_customers : "foreign key"
  fleetbase_companies ||--o{ fleetbase_billing_subscriptions : "foreign key"
  fleetbase_companies ||--o{ fleetbase_company_users : "foreign key"
  fleetbase_companies ||--o{ fleetbase_contacts : "foreign key"
  fleetbase_companies ||--o{ fleetbase_drivers : "foreign key"
  fleetbase_companies ||--o{ fleetbase_entities : "foreign key"
  fleetbase_companies ||--o{ fleetbase_extension_installs : "foreign key"
  fleetbase_companies ||--o{ fleetbase_extensions : "foreign key"
  fleetbase_companies ||--o{ fleetbase_fleets : "foreign key"
  fleetbase_companies ||--o{ fleetbase_fuel_reports : "foreign key"
  fleetbase_companies ||--o{ fleetbase_groups : "foreign key"
  fleetbase_companies ||--o{ fleetbase_integrated_vendors : "foreign key"
  fleetbase_companies ||--o{ fleetbase_invites : "foreign key"
  fleetbase_companies ||--o{ fleetbase_issues : "foreign key"
  fleetbase_companies ||--o{ fleetbase_orders : "foreign key"
  fleetbase_companies ||--o{ fleetbase_payloads : "foreign key"
  fleetbase_companies ||--o{ fleetbase_places : "foreign key"
  fleetbase_companies ||--o{ fleetbase_policies : "foreign key"
  fleetbase_companies ||--o{ fleetbase_positions : "foreign key"
  fleetbase_companies ||--o{ fleetbase_proofs : "foreign key"
  fleetbase_companies ||--o{ fleetbase_purchase_rates : "foreign key"
  fleetbase_companies ||--o{ fleetbase_roles : "foreign key"
  fleetbase_companies ||--o{ fleetbase_routes : "foreign key"
  fleetbase_companies ||--o{ fleetbase_service_areas : "foreign key"
  fleetbase_companies ||--o{ fleetbase_service_quotes : "foreign key"
  fleetbase_companies ||--o{ fleetbase_service_rates : "foreign key"
  fleetbase_companies ||--o{ fleetbase_tracking_numbers : "foreign key"
  fleetbase_companies ||--o{ fleetbase_tracking_statuses : "foreign key"
  fleetbase_companies ||--o{ fleetbase_transactions : "foreign key"
  fleetbase_companies ||--o{ fleetbase_types : "foreign key"
  fleetbase_companies ||--o{ fleetbase_users : "foreign key"
  fleetbase_companies ||--o{ fleetbase_vehicles : "foreign key"
  fleetbase_companies ||--o{ fleetbase_vendors : "foreign key"
  fleetbase_companies ||--o{ fleetbase_waypoints : "foreign key"
  fleetbase_companies ||--o{ fleetbase_webhook_endpoints : "foreign key"
  fleetbase_companies ||--o{ fleetbase_webhook_request_logs : "foreign key"
  fleetbase_companies ||--o{ fleetbase_zones : "foreign key"
  fleetbase_companies ||--o{ fleetbase_storefront_carts : "foreign key"
  fleetbase_companies ||--o{ fleetbase_storefront_checkouts : "foreign key"
  fleetbase_companies ||--o{ fleetbase_storefront_gateways : "foreign key"
  fleetbase_companies ||--o{ fleetbase_storefront_networks : "foreign key"
  fleetbase_companies ||--o{ fleetbase_storefront_notification_channels : "foreign key"
  fleetbase_companies ||--o{ fleetbase_storefront_payment_methods : "foreign key"
  fleetbase_companies ||--o{ fleetbase_storefront_products : "foreign key"
  fleetbase_companies ||--o{ fleetbase_storefront_stores : "foreign key"
  fleetbase_contacts ||--o{ fleetbase_storefront_reviews : "foreign key"
  fleetbase_contacts ||--o{ fleetbase_storefront_votes : "foreign key"
  fleetbase_drivers ||--o{ fleetbase_entities : "foreign key"
  fleetbase_drivers ||--o{ fleetbase_fleet_drivers : "foreign key"
  fleetbase_drivers ||--o{ fleetbase_fuel_reports : "foreign key"
  fleetbase_drivers ||--o{ fleetbase_issues : "foreign key"
  fleetbase_drivers ||--o{ fleetbase_orders : "foreign key"
  fleetbase_extensions ||--o{ fleetbase_extension_installs : "foreign key"
  fleetbase_files ||--o{ fleetbase_billing_payment_gateways : "foreign key"
  fleetbase_files ||--o{ fleetbase_categories : "foreign key"
  fleetbase_files ||--o{ fleetbase_companies : "foreign key"
  fleetbase_files ||--o{ fleetbase_contacts : "foreign key"
  fleetbase_files ||--o{ fleetbase_extensions : "foreign key"
  fleetbase_files ||--o{ fleetbase_proofs : "foreign key"
  fleetbase_files ||--o{ fleetbase_users : "foreign key"
  fleetbase_files ||--o{ fleetbase_vehicles : "foreign key"
  fleetbase_files ||--o{ fleetbase_vendors : "foreign key"
  fleetbase_files ||--o{ fleetbase_storefront_gateways : "foreign key"
  fleetbase_files ||--o{ fleetbase_storefront_networks : "foreign key"
  fleetbase_files ||--o{ fleetbase_storefront_notification_channels : "foreign key"
  fleetbase_files ||--o{ fleetbase_storefront_products : "foreign key"
  fleetbase_files ||--o{ fleetbase_storefront_stores : "foreign key"
  fleetbase_fleets ||--o{ fleetbase_fleet_drivers : "foreign key"
  fleetbase_fleets ||--o{ fleetbase_fleet_vehicles : "foreign key"
  fleetbase_fleets ||--o{ fleetbase_fleets : "foreign key"
  fleetbase_groups ||--o{ fleetbase_group_users : "foreign key"
  fleetbase_integrated_vendors ||--o{ fleetbase_service_quotes : "foreign key"
  fleetbase_orders ||--o{ fleetbase_drivers : "foreign key"
  fleetbase_orders ||--o{ fleetbase_positions : "foreign key"
  fleetbase_orders ||--o{ fleetbase_routes : "foreign key"
  fleetbase_orders ||--o{ fleetbase_storefront_checkouts : "foreign key"
  fleetbase_payloads ||--o{ fleetbase_entities : "foreign key"
  fleetbase_payloads ||--o{ fleetbase_orders : "foreign key"
  fleetbase_payloads ||--o{ fleetbase_purchase_rates : "foreign key"
  fleetbase_payloads ||--o{ fleetbase_service_quotes : "foreign key"
  fleetbase_payloads ||--o{ fleetbase_waypoints : "foreign key"
  fleetbase_permissions ||--o{ fleetbase_model_has_permissions : "foreign key"
  fleetbase_permissions ||--o{ fleetbase_role_has_permissions : "foreign key"
  fleetbase_places ||--o{ fleetbase_companies : "foreign key"
  fleetbase_places ||--o{ fleetbase_entities : "foreign key"
  fleetbase_places ||--o{ fleetbase_payloads : "foreign key"
  fleetbase_places ||--o{ fleetbase_positions : "foreign key"
  fleetbase_places ||--o{ fleetbase_vendors : "foreign key"
  fleetbase_places ||--o{ fleetbase_waypoints : "foreign key"
  fleetbase_places ||--o{ fleetbase_storefront_store_locations : "foreign key"
  fleetbase_policies ||--o{ fleetbase_model_has_policies : "foreign key"
  fleetbase_purchase_rates ||--o{ fleetbase_orders : "foreign key"
  fleetbase_roles ||--o{ fleetbase_model_has_roles : "foreign key"
  fleetbase_roles ||--o{ fleetbase_role_has_permissions : "foreign key"
  fleetbase_routes ||--o{ fleetbase_orders : "foreign key"
  fleetbase_service_areas ||--o{ fleetbase_fleets : "foreign key"
  fleetbase_service_areas ||--o{ fleetbase_service_areas : "foreign key"
  fleetbase_service_areas ||--o{ fleetbase_service_rates : "foreign key"
  fleetbase_service_areas ||--o{ fleetbase_zones : "foreign key"
  fleetbase_service_quotes ||--o{ fleetbase_purchase_rates : "foreign key"
  fleetbase_service_quotes ||--o{ fleetbase_service_quote_items : "foreign key"
  fleetbase_service_quotes ||--o{ fleetbase_storefront_checkouts : "foreign key"
  fleetbase_service_rates ||--o{ fleetbase_service_quotes : "foreign key"
  fleetbase_service_rates ||--o{ fleetbase_service_rate_fees : "foreign key"
  fleetbase_service_rates ||--o{ fleetbase_service_rate_parcel_fees : "foreign key"
  fleetbase_tracking_numbers ||--o{ fleetbase_entities : "foreign key"
  fleetbase_tracking_numbers ||--o{ fleetbase_orders : "foreign key"
  fleetbase_tracking_numbers ||--o{ fleetbase_tracking_statuses : "foreign key"
  fleetbase_tracking_numbers ||--o{ fleetbase_waypoints : "foreign key"
  fleetbase_tracking_statuses ||--o{ fleetbase_tracking_numbers : "foreign key"
  fleetbase_transactions ||--o{ fleetbase_orders : "foreign key"
  fleetbase_transactions ||--o{ fleetbase_purchase_rates : "foreign key"
  fleetbase_transactions ||--o{ fleetbase_transaction_items : "foreign key"
  fleetbase_types ||--o{ fleetbase_extensions : "foreign key"
  fleetbase_types ||--o{ fleetbase_vendors : "foreign key"
  fleetbase_users ||--o{ fleetbase_api_credentials : "foreign key"
  fleetbase_users ||--o{ fleetbase_companies : "foreign key"
  fleetbase_users ||--o{ fleetbase_company_users : "foreign key"
  fleetbase_users ||--o{ fleetbase_drivers : "foreign key"
  fleetbase_users ||--o{ fleetbase_group_users : "foreign key"
  fleetbase_users ||--o{ fleetbase_integrated_vendors : "foreign key"
  fleetbase_users ||--o{ fleetbase_invites : "foreign key"
  fleetbase_users ||--o{ fleetbase_issues : "foreign key"
  fleetbase_users ||--o{ fleetbase_orders : "foreign key"
  fleetbase_users ||--o{ fleetbase_user_devices : "foreign key"
  fleetbase_users ||--o{ fleetbase_webhook_endpoints : "foreign key"
  fleetbase_users ||--o{ fleetbase_storefront_carts : "foreign key"
  fleetbase_users ||--o{ fleetbase_storefront_gateways : "foreign key"
  fleetbase_users ||--o{ fleetbase_storefront_networks : "foreign key"
  fleetbase_users ||--o{ fleetbase_storefront_notification_channels : "foreign key"
  fleetbase_users ||--o{ fleetbase_storefront_product_addons : "foreign key"
  fleetbase_users ||--o{ fleetbase_storefront_products : "foreign key"
  fleetbase_users ||--o{ fleetbase_storefront_reviews : "foreign key"
  fleetbase_users ||--o{ fleetbase_storefront_store_locations : "foreign key"
  fleetbase_users ||--o{ fleetbase_storefront_stores : "foreign key"
  fleetbase_users ||--o{ fleetbase_storefront_votes : "foreign key"
  fleetbase_vehicles ||--o{ fleetbase_drivers : "foreign key"
  fleetbase_vehicles ||--o{ fleetbase_fleet_vehicles : "foreign key"
  fleetbase_vehicles ||--o{ fleetbase_fuel_reports : "foreign key"
  fleetbase_vehicles ||--o{ fleetbase_issues : "foreign key"
  fleetbase_vehicles ||--o{ fleetbase_vehicle_devices : "foreign key"
  fleetbase_vendors ||--o{ fleetbase_drivers : "foreign key"
  fleetbase_vendors ||--o{ fleetbase_fleets : "foreign key"
  fleetbase_vendors ||--o{ fleetbase_vehicles : "foreign key"
  fleetbase_webhook_endpoints ||--o{ fleetbase_webhook_request_logs : "foreign key"
  fleetbase_zones ||--o{ fleetbase_fleets : "foreign key"
  fleetbase_zones ||--o{ fleetbase_service_rates : "foreign key"
  fleetbase_storefront_carts ||--o{ fleetbase_storefront_checkouts : "foreign key"
  fleetbase_storefront_checkouts ||--o{ fleetbase_storefront_carts : "foreign key"
  fleetbase_storefront_gateways ||--o{ fleetbase_storefront_checkouts : "foreign key"
  fleetbase_storefront_gateways ||--o{ fleetbase_storefront_payment_methods : "foreign key"
  fleetbase_storefront_networks ||--o{ fleetbase_storefront_checkouts : "foreign key"
  fleetbase_storefront_networks ||--o{ fleetbase_storefront_network_stores : "foreign key"
  fleetbase_storefront_product_variants ||--o{ fleetbase_storefront_product_variant_options : "foreign key"
  fleetbase_storefront_products ||--o{ fleetbase_storefront_product_addon_categories : "foreign key"
  fleetbase_storefront_products ||--o{ fleetbase_storefront_product_hours : "foreign key"
  fleetbase_storefront_products ||--o{ fleetbase_storefront_product_store_locations : "foreign key"
  fleetbase_storefront_products ||--o{ fleetbase_storefront_product_variants : "foreign key"
  fleetbase_storefront_store_locations ||--o{ fleetbase_storefront_product_store_locations : "foreign key"
  fleetbase_storefront_store_locations ||--o{ fleetbase_storefront_store_hours : "foreign key"
  fleetbase_storefront_stores ||--o{ fleetbase_storefront_checkouts : "foreign key"
  fleetbase_storefront_stores ||--o{ fleetbase_storefront_network_stores : "foreign key"
  fleetbase_storefront_stores ||--o{ fleetbase_storefront_payment_methods : "foreign key"
  fleetbase_storefront_stores ||--o{ fleetbase_storefront_products : "foreign key"
  fleetbase_storefront_stores ||--o{ fleetbase_storefront_store_locations : "foreign key"