database.mmd
Rama main · réplica de lectura del repositorio original.
erDiagram
fleetbase_groups {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
CHAR company_uuid FK
VARCHAR public_id
VARCHAR name
VARCHAR description
VARCHAR slug
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_activity {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR log_name
TEXT description
CHAR company_id
CHAR subject_id
VARCHAR subject_type
VARCHAR event
CHAR causer_id
VARCHAR causer_type
TEXT properties
CHAR batch_uuid
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_ai_admin_access_logs {
INTUNSIGNED id PK, UK
CHAR uuid UK
CHAR company_uuid FK
CHAR ai_session_uuid FK
CHAR ai_task_uuid FK
CHAR viewed_by_uuid FK
VARCHAR action
VARCHAR ip_address
TEXT user_agent
JSON metadata
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_ai_knowledge_chunks {
INTUNSIGNED id PK, UK
CHAR uuid UK
CHAR ai_knowledge_document_uuid FK
VARCHAR heading
VARCHAR heading_path
VARCHAR anchor
VARCHAR audience
INTUNSIGNED position
MEDIUMTEXT content
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_ai_knowledge_documents {
INTUNSIGNED id PK, UK
CHAR uuid UK
VARCHAR source
VARCHAR url UK
VARCHAR path
VARCHAR title
TEXT description
VARCHAR module
VARCHAR section
VARCHAR audience
VARCHAR content_hash
TIMESTAMP fetched_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_ai_sessions {
INTUNSIGNED id PK, UK
CHAR uuid UK
CHAR company_uuid FK
CHAR created_by_uuid FK
VARCHAR title
VARCHAR status
JSON metadata
TIMESTAMP last_message_at
TIMESTAMP ended_at
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_ai_task_steps {
INTUNSIGNED id PK, UK
CHAR uuid UK
CHAR ai_task_uuid FK
CHAR company_uuid FK
CHAR created_by_uuid FK
VARCHAR type
VARCHAR status
VARCHAR provider
VARCHAR model
VARCHAR tool
JSON input
JSON output
JSON usage
JSON metadata
JSON error
TIMESTAMP started_at
TIMESTAMP completed_at
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_ai_tasks {
INTUNSIGNED id PK, UK
CHAR uuid UK
CHAR ai_session_uuid FK
CHAR company_uuid FK
CHAR created_by_uuid FK
VARCHAR task_type
VARCHAR status
MEDIUMTEXT prompt
MEDIUMTEXT response
MEDIUMTEXT response_summary
VARCHAR provider
VARCHAR model
INTUNSIGNED input_tokens
INTUNSIGNED output_tokens
INTUNSIGNED total_tokens
TINYINT feedback_rating
TEXT feedback_comment
TIMESTAMP feedback_at
JSON context
JSON usage
JSON metadata
JSON error
TIMESTAMP started_at
TIMESTAMP completed_at
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_alerts {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR public_id UK
VARCHAR _key
CHAR company_uuid FK
CHAR category_uuid FK
CHAR acknowledged_by_uuid FK
CHAR resolved_by_uuid FK
CHAR snoozed_by_uuid FK
CHAR assigned_to_uuid FK
VARCHAR type
VARCHAR severity
VARCHAR status
VARCHAR subject_type
CHAR subject_uuid
TEXT message
JSON rule
JSON context
JSON meta
TIMESTAMP triggered_at
TIMESTAMP acknowledged_at
TIMESTAMP snoozed_until
TIMESTAMP planned_at
TIMESTAMP resolved_at
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_api_credentials {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
CHAR user_uuid FK
CHAR company_uuid FK
VARCHAR name
VARCHAR key
VARCHAR secret
INT test_mode
VARCHAR api
CHAR oauth_client_id
VARCHAR oauth_installation
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, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid
CHAR api_credential_uuid
BIGINTUNSIGNED access_token_id FK
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, UK
VARCHAR _key
CHAR uuid UK
CHAR company_uuid FK
CHAR api_credential_uuid FK
BIGINTUNSIGNED access_token_id 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_asset_connections {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid FK
VARCHAR connector_type
CHAR connector_uuid
VARCHAR connected_type
CHAR connected_uuid
CHAR active_connected_uuid UK
VARCHAR active_connector_position UK
VARCHAR relationship_type
SMALLINTUNSIGNED position
TIMESTAMP connected_at
TIMESTAMP disconnected_at
VARCHAR source
VARCHAR confidence
TEXT notes
JSON meta
CHAR created_by_uuid FK
CHAR updated_by_uuid FK
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_assets {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR public_id UK
VARCHAR _key
CHAR company_uuid FK, UK
CHAR category_uuid FK
VARCHAR operator_type
CHAR operator_uuid
VARCHAR assigned_to_type
CHAR assigned_to_uuid
VARCHAR name
MEDIUMTEXT description
VARCHAR code UK
VARCHAR measurement_system
VARCHAR usage_type
VARCHAR type
VARCHAR asset_class
VARCHAR ownership_type
VARCHAR status
GEOMETRY location
VARCHAR speed
VARCHAR heading
VARCHAR altitude
BIT online
TIMESTAMP last_online_at
INT acquisition_cost
INT current_value
INT depreciation_rate
INT insurance_value
VARCHAR currency
VARCHAR financing_status
DATE lease_expires_at
DATE purchased_at
VARCHAR vin
VARCHAR plate_number
VARCHAR make
VARCHAR model
SMALLINTUNSIGNED year
VARCHAR color
VARCHAR serial_number
VARCHAR call_sign
VARCHAR slug
CHAR vendor_uuid FK
CHAR current_place_uuid FK
CHAR photo_uuid FK
CHAR telematic_uuid FK
BIGINTUNSIGNED odometer
VARCHAR odometer_unit
BIGINTUNSIGNED engine_hours
VARCHAR fuel_type
VARCHAR fuel_volume_unit
VARCHAR transmission
DECIMAL gvw
JSON capacity
JSON specs
JSON attributes
JSON telematics
MEDIUMTEXT notes
CHAR created_by_uuid FK
CHAR updated_by_uuid FK
CHAR warranty_uuid FK
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
DECIMAL length
DECIMAL width
DECIMAL height
DECIMAL tare_weight
DECIMAL gvwr
DECIMAL payload_capacity
DECIMAL cargo_volume
SMALLINTUNSIGNED axle_count
SMALLINTUNSIGNED tire_count
SMALLINTUNSIGNED door_count
VARCHAR body_type
VARCHAR coupling_type
VARCHAR brake_type
BIT abs_equipped
BIT ebs_equipped
BIT refrigerated
DECIMAL temperature_min
DECIMAL temperature_max
DECIMAL reefer_engine_hours
}
fleetbase_categories {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id
CHAR company_uuid
CHAR parent_uuid
CHAR 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
BIT core_category
VARCHAR slug
VARCHAR order
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
CHAR icon_file_uuid FK
}
fleetbase_chat_attachments {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR public_id
CHAR company_uuid FK
CHAR sender_uuid FK
CHAR chat_channel_uuid FK
CHAR chat_message_uuid FK
CHAR file_uuid FK
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_chat_channels {
INTUNSIGNED id PK, UK
CHAR uuid
CHAR company_uuid FK
CHAR created_by_uuid FK
VARCHAR public_id
VARCHAR name
VARCHAR slug
JSON meta
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_chat_logs {
BIGINTUNSIGNED id PK, UK
CHAR uuid
VARCHAR public_id
CHAR company_uuid FK
CHAR chat_channel_uuid FK
CHAR initiator_uuid FK
VARCHAR event_type
MEDIUMTEXT content
JSON subjects
JSON meta
VARCHAR status
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_chat_messages {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR public_id
CHAR company_uuid FK
CHAR sender_uuid FK
CHAR chat_channel_uuid FK
JSON meta
MEDIUMTEXT content
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_chat_participants {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR public_id
CHAR company_uuid FK
CHAR user_uuid FK
CHAR chat_channel_uuid FK
JSON meta
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_chat_receipts {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR public_id
CHAR company_uuid FK
CHAR participant_uuid FK
CHAR chat_message_uuid FK
TIMESTAMP read_at
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_comments {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR public_id UK
CHAR company_uuid FK
CHAR author_uuid FK
CHAR parent_comment_uuid FK
CHAR subject_uuid
VARCHAR subject_type
MEDIUMTEXT content
JSON tags
JSON meta
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_companies {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
VARCHAR stripe_id
VARCHAR stripe_connect_id
TIMESTAMP trial_ends_at
VARCHAR card_last_four
VARCHAR card_brand
CHAR owner_uuid FK
CHAR logo_uuid FK
CHAR backdrop_uuid FK
VARCHAR name
VARCHAR website_url
VARCHAR description
JSON options
JSON meta
VARCHAR phone
VARCHAR currency
VARCHAR country
VARCHAR timezone
CHAR place_uuid FK
VARCHAR plan
VARCHAR status
VARCHAR type
VARCHAR slug
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP onboarding_completed_at
VARCHAR onboarding_completed_by_uuid
}
fleetbase_company_users {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
CHAR company_uuid FK
CHAR user_uuid FK
VARCHAR status
BIT external
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_contacts {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
VARCHAR internal_id
CHAR company_uuid FK
CHAR user_uuid FK
CHAR place_uuid FK
CHAR photo_uuid FK
VARCHAR name
VARCHAR title
VARCHAR email
VARCHAR phone
VARCHAR type
MEDIUMTEXT notes
VARCHAR slug
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_custom_field_values {
INTUNSIGNED id PK, UK
CHAR uuid
CHAR company_uuid FK
CHAR custom_field_uuid FK
CHAR subject_uuid
VARCHAR subject_type
TEXT value
VARCHAR value_type
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_custom_fields {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR public_id
CHAR company_uuid FK
CHAR category_uuid
CHAR subject_uuid
VARCHAR subject_type
VARCHAR name
VARCHAR label
VARCHAR type
VARCHAR for
VARCHAR component
JSON options
BIT required
BIT editable
TEXT default_value
JSON validation_rules
JSON meta
MEDIUMTEXT description
MEDIUMTEXT help_text
INT order
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_dashboard_widgets {
BIGINTUNSIGNED id PK, UK
CHAR uuid
CHAR dashboard_uuid FK
VARCHAR name
VARCHAR component
JSON grid_options
JSON options
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_dashboards {
BIGINTUNSIGNED id PK, UK
CHAR uuid
CHAR company_uuid
CHAR user_uuid
VARCHAR name
BIT is_default
VARCHAR extension
JSON tags
JSON options
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_database_backups {
CHAR uuid PK, UK
VARCHAR connection_name
VARCHAR database
VARCHAR status
VARCHAR trigger
VARCHAR disk
VARCHAR path
BIGINTUNSIGNED size_bytes
BIGINTUNSIGNED duration_ms
TEXT error
TIMESTAMP started_at
TIMESTAMP completed_at
TIMESTAMP pruned_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_device_events {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR public_id
VARCHAR _key
CHAR company_uuid FK
CHAR device_uuid FK
JSON payload
JSON data
JSON meta
VARCHAR ident
VARCHAR severity
TEXT message
TIMESTAMP occurred_at
TIMESTAMP processed_at
VARCHAR event_type
VARCHAR protocol
VARCHAR provider
GEOMETRY location
VARCHAR mileage
VARCHAR state
VARCHAR code
VARCHAR reason
MEDIUMTEXT comment
TIMESTAMP resolved_at
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_device_installations {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
CHAR company_uuid FK
CHAR device_uuid FK
VARCHAR attachable_type
CHAR attachable_uuid
CHAR active_device_uuid UK
TIMESTAMP installed_at
TIMESTAMP removed_at
VARCHAR source
JSON metadata
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_devices {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR public_id
VARCHAR _key
CHAR company_uuid FK
CHAR telematic_uuid FK
CHAR photo_uuid FK
CHAR attachable_uuid
VARCHAR attachable_type
CHAR warranty_uuid FK
VARCHAR device_id
VARCHAR firmware_version
VARCHAR imsi
VARCHAR imei
VARCHAR internal_id
VARCHAR provider
VARCHAR type
VARCHAR name
VARCHAR location
VARCHAR model
VARCHAR manufacturer
VARCHAR serial_number
GEOMETRY last_position
DATE installation_date
DATE last_maintenance_date
JSON meta
JSON options
JSON data
BIT online
VARCHAR status
VARCHAR slug
VARCHAR data_frequency
TEXT notes
TIMESTAMP last_online_at
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_directives {
INTUNSIGNED id PK, UK
CHAR uuid
CHAR company_uuid FK
CHAR permission_uuid FK
VARCHAR subject_type
CHAR subject_uuid
MEDIUMTEXT key
JSON rules
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_driver_geofence_states {
BIGINTUNSIGNED id PK, UK
CHAR driver_uuid FK, UK
CHAR geofence_uuid UK
VARCHAR geofence_type
BIT is_inside
TIMESTAMP entered_at
TIMESTAMP exited_at
VARCHAR dwell_job_id
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_drivers {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
VARCHAR internal_id
CHAR company_uuid FK
CHAR vehicle_uuid FK
CHAR vendor_uuid FK
VARCHAR vendor_type
CHAR current_job_uuid FK
CHAR user_uuid FK
VARCHAR auth_token
VARCHAR drivers_license_number
DATE license_expiry
VARCHAR signup_token_used
MEDIUMTEXT avatar_url
GEOMETRY location
VARCHAR latitude
VARCHAR longitude
VARCHAR heading
VARCHAR bearing
VARCHAR speed
VARCHAR altitude
VARCHAR country
VARCHAR city
VARCHAR currency
INT online
VARCHAR current_status
VARCHAR status
JSON skills
INTUNSIGNED max_travel_time "Seconds"
INTUNSIGNED max_distance "Metres"
TIME time_window_start
TIME time_window_end
VARCHAR slug
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_entities {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR payload_uuid FK
CHAR company_uuid FK
CHAR driver_assigned_uuid FK
CHAR supplier_uuid FK
CHAR destination_uuid FK
CHAR customer_uuid
VARCHAR customer_type
CHAR tracking_number_uuid FK
CHAR photo_uuid
CHAR category_uuid FK
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_equipments {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR _key
VARCHAR public_id UK
CHAR company_uuid FK
CHAR category_uuid FK
VARCHAR name
VARCHAR code
VARCHAR type
VARCHAR status
VARCHAR slug
VARCHAR serial_number
VARCHAR manufacturer
VARCHAR model
VARCHAR equipable_type
CHAR equipable_uuid
DATE purchased_at
INT purchase_price
VARCHAR currency
CHAR warranty_uuid FK
CHAR photo_uuid FK
JSON meta
CHAR created_by_uuid FK
CHAR updated_by_uuid FK
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_extension_installs {
BIGINTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
CHAR extension_uuid FK
CHAR company_uuid FK
JSON config
JSON meta
JSON overwrite
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_extensions {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
VARCHAR extension_id UK
CHAR author_uuid FK
CHAR category_uuid FK
CHAR 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
CHAR 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, UK
CHAR uuid UK
TEXT connection
TEXT queue
LONGTEXT payload
LONGTEXT exception
TIMESTAMP failed_at
}
fleetbase_files {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id
CHAR company_uuid
CHAR uploader_uuid
CHAR 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, UK
VARCHAR _key
CHAR uuid UK
CHAR fleet_uuid FK, UK
CHAR driver_uuid FK, UK
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_fleet_vehicles {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
CHAR fleet_uuid FK, UK
CHAR vehicle_uuid FK, UK
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_fleets {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid FK
CHAR service_area_uuid FK
CHAR zone_uuid FK
CHAR vendor_uuid FK
CHAR parent_fleet_uuid FK
CHAR image_uuid
VARCHAR name
VARCHAR color
VARCHAR task
VARCHAR status
VARCHAR slug
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_fuel_provider_connections {
INTUNSIGNED id PK, UK
VARCHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid UK
VARCHAR provider UK
VARCHAR name
VARCHAR environment UK
VARCHAR status
JSON credentials
JSON sync_settings
JSON last_sync_state
TIMESTAMP last_synced_at
TIMESTAMP last_tested_at
TEXT last_error
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_fuel_provider_sync_runs {
INTUNSIGNED id PK, UK
VARCHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid
CHAR fuel_provider_connection_uuid
VARCHAR provider
VARCHAR status
TIMESTAMP from
TIMESTAMP to
INTUNSIGNED imported
INTUNSIGNED matched
INTUNSIGNED unmatched
INTUNSIGNED fuel_reports_created
DECIMAL liters
BIGINTUNSIGNED amount
TIMESTAMP started_at
TIMESTAMP finished_at
TEXT error
JSON summary
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_fuel_provider_transactions {
INTUNSIGNED id PK, UK
VARCHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid UK
CHAR fuel_provider_connection_uuid UK
CHAR fuel_report_uuid
CHAR vehicle_uuid
CHAR driver_uuid
CHAR order_uuid
VARCHAR provider UK
VARCHAR provider_transaction_id
VARCHAR provider_vehicle_id
VARCHAR vehicle_card_id
VARCHAR internal_number
VARCHAR structure_number
VARCHAR plate_number
VARCHAR vin
VARCHAR serial_number
VARCHAR call_sign
VARCHAR trip_number
VARCHAR station_name
DECIMAL station_latitude
DECIMAL station_longitude
TIMESTAMP transaction_at
DECIMAL volume
VARCHAR metric_unit
BIGINTUNSIGNED amount
VARCHAR currency
VARCHAR odometer
VARCHAR sync_status
TIMESTAMP matched_at
JSON normalized_payload
JSON raw_payload
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
VARCHAR active_provider_transaction_id UK
}
fleetbase_fuel_reports {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid FK
CHAR driver_uuid FK
CHAR vehicle_uuid FK
CHAR reported_by_uuid FK
MEDIUMTEXT report
VARCHAR odometer
GEOMETRY location
VARCHAR amount
VARCHAR currency
VARCHAR volume
VARCHAR metric_unit
JSON meta
VARCHAR status
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_geofence_events_log {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
CHAR company_uuid
CHAR driver_uuid "(DC2Type:guid)"
CHAR vehicle_uuid
CHAR order_uuid
CHAR subject_uuid
VARCHAR subject_type
VARCHAR subject_name
CHAR geofence_uuid
VARCHAR geofence_type
VARCHAR geofence_name
ENUM event_type
DECIMAL latitude
DECIMAL longitude
DECIMAL speed_kmh
INTUNSIGNED dwell_duration_minutes
TIMESTAMP occurred_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_group_users {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
CHAR group_uuid FK
CHAR user_uuid FK
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_inspection_forms {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR _key
VARCHAR public_id UK
CHAR company_uuid FK
VARCHAR name
TEXT description
VARCHAR type
VARCHAR status
VARCHAR frequency
VARCHAR subject_type
CHAR subject_uuid
JSON items
JSON settings
JSON meta
TIMESTAMP published_at
CHAR created_by_uuid FK
CHAR updated_by_uuid FK
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_inspection_item_results {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR _key
CHAR company_uuid FK
CHAR inspection_submission_uuid FK
CHAR issue_uuid FK
CHAR work_order_uuid FK
VARCHAR item_key
VARCHAR label
VARCHAR category
VARCHAR status
VARCHAR severity
BIT passed
TEXT comments
JSON photos
JSON meta
CHAR created_by_uuid FK
CHAR updated_by_uuid FK
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_inspection_links {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR _key
VARCHAR public_id UK
CHAR company_uuid FK
CHAR inspection_form_uuid FK
CHAR driver_uuid FK
CHAR vehicle_uuid FK
CHAR assignee_uuid FK
CHAR created_by_uuid FK
VARCHAR token_hash UK
TEXT token
VARCHAR pin_hash
TEXT pin
SMALLINTUNSIGNED pin_attempts
VARCHAR pin_sent_via
TIMESTAMP pin_sent_at
VARCHAR status
BIT single_use
TIMESTAMP expires_at
TIMESTAMP last_viewed_at
TIMESTAMP used_at
VARCHAR used_ip
TEXT used_user_agent
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_inspection_submissions {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR _key
VARCHAR public_id UK
CHAR company_uuid FK
CHAR inspection_form_uuid FK
CHAR vehicle_uuid FK
CHAR driver_uuid FK
CHAR submitted_by_uuid FK
CHAR issue_uuid FK
CHAR work_order_uuid FK
VARCHAR type
VARCHAR status
VARCHAR result
VARCHAR source
BIGINTUNSIGNED odometer
BIGINTUNSIGNED engine_hours
INTUNSIGNED total_items
INTUNSIGNED failed_items
TIMESTAMP started_at
TIMESTAMP submitted_at
TIMESTAMP resolved_at
JSON location
JSON signature
JSON attachments
JSON meta
CHAR created_by_uuid FK
CHAR updated_by_uuid FK
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_integrated_vendors {
BIGINTUNSIGNED id PK, UK
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 provider_options
JSON credentials
JSON options
BIT sandbox
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_invites {
BIGINTUNSIGNED id PK, UK
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
JSON meta
DATETIME expires_at
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_issues {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
VARCHAR issue_id UK
CHAR company_uuid FK
CHAR driver_uuid FK
CHAR vehicle_uuid FK
CHAR order_uuid
CHAR assigned_to_uuid FK
CHAR reported_by_uuid FK
VARCHAR title
GEOMETRY location
VARCHAR type
VARCHAR category
MEDIUMTEXT report
VARCHAR priority
JSON meta
JSON tags
DATETIME resolved_at
VARCHAR status
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_ledger_accounts {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid UK
CHAR created_by_uuid
CHAR updated_by_uuid
VARCHAR name
VARCHAR code UK
VARCHAR type
TEXT description
BIT is_system_account
INT balance
VARCHAR currency
VARCHAR status
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_ledger_gateway_transactions {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid
CHAR gateway_uuid
CHAR transaction_uuid
VARCHAR gateway_reference_id UK
VARCHAR type UK
VARCHAR event_type UK
BIGINTUNSIGNED amount
CHAR currency
VARCHAR status
TEXT message
JSON raw_response
TIMESTAMP processed_at
VARCHAR reconciliation_status
TIMESTAMP reconciliation_checked_at
JSON reconciliation_data
VARCHAR refund_status
TIMESTAMP refund_accepted_at
TIMESTAMP refund_expires_at
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_ledger_gateways {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid
CHAR created_by_uuid
VARCHAR name
VARCHAR driver
TEXT description
TEXT config
JSON capabilities
BIT is_sandbox
VARCHAR environment
VARCHAR status
VARCHAR return_url
VARCHAR webhook_url
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_ledger_invoice_items {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
CHAR invoice_uuid
VARCHAR description
INT quantity
INT unit_price
INT amount
DECIMAL tax_rate
INT tax_amount
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_ledger_invoices {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid
CHAR created_by_uuid
CHAR updated_by_uuid
CHAR customer_uuid
VARCHAR customer_type
CHAR order_uuid
CHAR transaction_uuid
CHAR template_uuid
VARCHAR number UK
DATE date
DATE due_date
INT subtotal
INT tax
INT total_amount
INT amount_paid
INT balance
VARCHAR currency
VARCHAR status
TEXT notes
TEXT terms
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP sent_at
TIMESTAMP viewed_at
TIMESTAMP paid_at
}
fleetbase_ledger_journals {
INTUNSIGNED id PK, UK
VARCHAR _key
VARCHAR public_id UK
VARCHAR number UK
VARCHAR type
VARCHAR status
VARCHAR reference
VARCHAR memo
BIT is_system_entry
CHAR uuid UK
CHAR company_uuid
CHAR transaction_uuid
CHAR debit_account_uuid
CHAR credit_account_uuid
INT amount
VARCHAR currency
TEXT description
DATE entry_date
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_ledger_wallets {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid UK
CHAR created_by_uuid
CHAR updated_by_uuid
CHAR subject_uuid UK
VARCHAR subject_type UK
VARCHAR name UK
TEXT description
INT balance
VARCHAR currency
VARCHAR status
BIT is_frozen
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_login_attempts {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR identity
VARCHAR password
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_maintenance_schedule_reminders {
BIGINTUNSIGNED id PK, UK
VARCHAR schedule_uuid UK
TINYINTUNSIGNED offset_days UK "Which offset fired, e.g. 15 or 3"
DATE due_date_snapshot UK "The next_due_date at time of sending; advances each cycle so reminders re-fire"
TIMESTAMP sent_at
}
fleetbase_maintenance_schedules {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR _key
VARCHAR public_id UK
CHAR company_uuid FK
VARCHAR subject_type
CHAR subject_uuid
VARCHAR name
VARCHAR type
VARCHAR status
VARCHAR interval_method
VARCHAR interval_type
INTUNSIGNED interval_value
VARCHAR interval_unit
BIGINTUNSIGNED interval_distance
BIGINTUNSIGNED interval_engine_hours
BIGINTUNSIGNED last_service_odometer
BIGINTUNSIGNED last_service_engine_hours
TIMESTAMP last_service_date
TIMESTAMP next_due_date
BIGINTUNSIGNED next_due_odometer
BIGINTUNSIGNED next_due_engine_hours
VARCHAR default_priority
VARCHAR default_assignee_type
CHAR default_assignee_uuid
TEXT instructions
JSON reminder_offsets "Array of integers: days before next_due_date to send reminder emails, e.g. [15, 7, 3]"
JSON meta
CHAR created_by_uuid FK
CHAR updated_by_uuid FK
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_maintenances {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR _key
VARCHAR public_id UK
CHAR company_uuid FK
CHAR category_uuid FK
VARCHAR maintainable_type
CHAR maintainable_uuid
CHAR work_order_uuid FK
VARCHAR type
VARCHAR status
VARCHAR priority
TIMESTAMP scheduled_at
TIMESTAMP started_at
TIMESTAMP completed_at
BIGINTUNSIGNED odometer
BIGINTUNSIGNED engine_hours
INT estimated_downtime_hours
TIMESTAMP downtime_start
TIMESTAMP downtime_end
VARCHAR performed_by_type
CHAR performed_by_uuid
TEXT summary
TEXT notes
JSON line_items
INT labor_cost
INT parts_cost
INT tax
INT total_cost
VARCHAR currency
JSON attachments
JSON meta
CHAR created_by_uuid FK
CHAR updated_by_uuid FK
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_manifest_stops {
CHAR uuid PK, UK
VARCHAR public_id UK
CHAR manifest_uuid FK
CHAR order_uuid
CHAR place_uuid
CHAR waypoint_uuid
VARCHAR status
SMALLINTUNSIGNED sequence
TIMESTAMP estimated_arrival
TIMESTAMP actual_arrival
INTUNSIGNED distance_from_prev_m
INTUNSIGNED duration_from_prev_s
JSON meta
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_manifests {
CHAR uuid PK, UK
VARCHAR public_id UK
VARCHAR internal_id
CHAR company_uuid
CHAR driver_uuid
CHAR vehicle_uuid
VARCHAR status
DATE scheduled_date
TIMESTAMP started_at
TIMESTAMP completed_at
INTUNSIGNED total_distance_m
INTUNSIGNED total_duration_s
INTUNSIGNED stop_count
TEXT notes
JSON meta
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_migrations {
INTUNSIGNED id PK, UK
VARCHAR migration
INT batch
}
fleetbase_model_has_permissions {
CHAR permission_id PK, FK, UK
VARCHAR model_type PK, UK
CHAR model_uuid PK, UK
}
fleetbase_model_has_policies {
CHAR policy_id PK, FK, UK
VARCHAR model_type PK, UK
CHAR model_uuid PK, UK
}
fleetbase_model_has_roles {
CHAR role_id PK, FK, UK
VARCHAR model_type PK, UK
CHAR model_uuid PK, UK
}
fleetbase_monitored_scheduled_task_log_items {
BIGINTUNSIGNED id PK, UK
BIGINTUNSIGNED monitored_scheduled_task_id FK
VARCHAR type
JSON meta
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_monitored_scheduled_tasks {
BIGINTUNSIGNED id PK, UK
VARCHAR name
VARCHAR type
VARCHAR cron_expression
VARCHAR timezone
VARCHAR ping_url
DATETIME last_started_at
DATETIME last_finished_at
DATETIME last_failed_at
DATETIME last_skipped_at
DATETIME registered_on_oh_dear_at
DATETIME last_pinged_at
INT grace_time_in_minutes
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_notifications {
CHAR id PK, UK
VARCHAR type
VARCHAR notifiable_type
CHAR notifiable_id
TEXT data
TIMESTAMP read_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_oauth_access_tokens {
VARCHAR id PK, UK
CHAR grant_uuid
CHAR client_id
CHAR user_uuid
CHAR company_uuid
VARCHAR auth_code_id
JSON scopes
BIT revoked
DATETIME expires_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_oauth_auth_codes {
VARCHAR id PK, UK
CHAR grant_uuid
CHAR client_id
CHAR user_uuid
CHAR company_uuid
JSON scopes
VARCHAR nonce
TIMESTAMP auth_time
BIT revoked
DATETIME expires_at
TIMESTAMP created_at
}
fleetbase_oauth_clients {
CHAR id PK, UK
VARCHAR name
TEXT description
VARCHAR secret
JSON redirect_uris
JSON allowed_scopes
VARCHAR logo_url
VARCHAR website_url
VARCHAR privacy_url
VARCHAR terms_url
BIT official
BIT development
VARCHAR software_id
CHAR registration_key UK
CHAR created_by_uuid
TIMESTAMP secret_rotated_at
TIMESTAMP disabled_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_oauth_grants {
INTUNSIGNED id PK, UK
CHAR uuid UK
CHAR user_uuid FK
CHAR client_id FK
CHAR company_uuid
JSON scopes
TIMESTAMP last_used_at
TIMESTAMP revoked_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_oauth_identities {
INTUNSIGNED id PK, UK
CHAR uuid
CHAR user_uuid FK
VARCHAR provider UK
VARCHAR provider_user_id UK
VARCHAR provider_email
BIT email_verified
JSON meta
TIMESTAMP last_login_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_oauth_refresh_tokens {
VARCHAR id PK, UK
VARCHAR access_token_id
CHAR grant_uuid
BIT revoked
DATETIME expires_at
TIMESTAMP created_at
}
fleetbase_oauth_states {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR purpose
CHAR token_hash UK
VARCHAR provider
VARCHAR intent
CHAR user_uuid FK
TEXT payload
CHAR ip_hash
TIMESTAMP expires_at
TIMESTAMP consumed_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_order_configs {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR public_id
CHAR company_uuid FK
CHAR author_uuid FK
CHAR category_uuid FK
CHAR icon_uuid FK
VARCHAR name
VARCHAR namespace
MEDIUMTEXT description
VARCHAR key
VARCHAR status
VARCHAR version
BIT core_service
JSON flow
JSON entities
JSON tags
JSON meta
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_orders {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid FK
CHAR created_by_uuid FK
CHAR updated_by_uuid FK
CHAR order_config_uuid FK
VARCHAR internal_id
CHAR customer_uuid
VARCHAR customer_type
CHAR facilitator_uuid
VARCHAR facilitator_type
CHAR session_uuid
CHAR payload_uuid FK
CHAR route_uuid FK
CHAR transaction_uuid FK
CHAR purchase_rate_uuid FK
CHAR tracking_number_uuid FK
CHAR driver_assigned_uuid FK
CHAR vehicle_assigned_uuid FK
CHAR manifest_uuid
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
TINYINTUNSIGNED orchestrator_priority
JSON required_skills
DATETIME time_window_start
DATETIME time_window_end
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_parts {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR _key
VARCHAR public_id UK
CHAR company_uuid FK, UK
CHAR category_uuid FK
VARCHAR sku
VARCHAR name
VARCHAR manufacturer
VARCHAR model
VARCHAR serial_number
VARCHAR barcode
VARCHAR type
VARCHAR status
VARCHAR slug
TEXT description
CHAR vendor_uuid FK
INT quantity_on_hand
BIGINT unit_cost
BIGINT msrp
VARCHAR currency
INT reorder_point
INT reorder_quantity
INT max_stock_level
INT reserved_quantity
INT allocated_quantity
VARCHAR inventory_method
VARCHAR asset_type
CHAR asset_uuid
CHAR warranty_uuid FK
CHAR photo_uuid FK
JSON specs
JSON meta
CHAR created_by_uuid FK
CHAR updated_by_uuid FK
TIMESTAMP last_ordered_at
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
VARCHAR active_sku UK
}
fleetbase_payloads {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid FK
CHAR pickup_uuid FK
CHAR pickup_tracking_number_uuid
CHAR dropoff_uuid FK
CHAR dropoff_tracking_number_uuid
CHAR return_uuid FK
CHAR return_tracking_number_uuid
CHAR 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
VARCHAR service
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_personal_access_tokens {
BIGINTUNSIGNED id PK, UK
VARCHAR tokenable_type
CHAR tokenable_id "(DC2Type:guid)"
VARCHAR name
VARCHAR token UK
TEXT abilities
TIMESTAMP last_used_at
TIMESTAMP expires_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_places {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
VARCHAR _import_id
CHAR 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
MEDIUMTEXT avatar_url
VARCHAR type
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_policies {
CHAR id PK, UK
VARCHAR _key
CHAR company_uuid FK
VARCHAR name
VARCHAR guard_name
VARCHAR service
VARCHAR description
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_positions {
BIGINTUNSIGNED id PK, UK
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, UK
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, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
JSON meta
CHAR customer_uuid
VARCHAR customer_type
CHAR company_uuid FK
CHAR transaction_uuid FK
CHAR service_quote_uuid FK
CHAR payload_uuid FK
VARCHAR status
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_registry_developer_accounts {
INTUNSIGNED id PK, UK
CHAR uuid UK
VARCHAR username UK
VARCHAR email UK
VARCHAR password
VARCHAR name
VARCHAR avatar_url
VARCHAR github_username
VARCHAR website
TEXT bio
TIMESTAMP email_verified_at
VARCHAR verification_token
ENUM status
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_registry_extension_bundles {
INTUNSIGNED id PK, UK
CHAR uuid
CHAR public_id
CHAR bundle_id
CHAR company_uuid FK
CHAR created_by_uuid FK
CHAR extension_uuid FK
CHAR bundle_uuid FK
VARCHAR bundle_number
VARCHAR version
VARCHAR status
JSON meta
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_registry_extension_installs {
INTUNSIGNED id PK, UK
CHAR uuid
CHAR company_uuid FK
CHAR extension_uuid FK
JSON meta
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_registry_extension_purchases {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR purchaser_uuid
VARCHAR purchaser_type
CHAR company_uuid FK
CHAR extension_uuid FK
VARCHAR stripe_checkout_session_id
VARCHAR stripe_payment_intent_id
BIT is_subcription
INT locked_price
VARCHAR subscription_billing_period
VARCHAR subscription_model
JSON meta
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_registry_extensions {
INTUNSIGNED id PK, UK
CHAR uuid
CHAR company_uuid FK
ENUM publisher_type
CHAR publisher_uuid
CHAR created_by_uuid FK
CHAR registry_user_uuid FK
CHAR current_bundle_uuid FK
CHAR next_bundle_uuid FK
CHAR icon_uuid FK
CHAR category_uuid FK
VARCHAR public_id
VARCHAR stripe_product_id
VARCHAR name
VARCHAR subtitle
BIT self_managed
BIT payment_required
INT price
INT sale_price
BIT on_sale
BIT subscription_required
VARCHAR subscription_billing_period
VARCHAR subscription_model
INT subscription_amount
JSON subscription_tiers
VARCHAR currency
VARCHAR slug
VARCHAR version
VARCHAR fa_icon
MEDIUMTEXT description
MEDIUMTEXT promotional_text
VARCHAR website_url
VARCHAR repo_url
VARCHAR support_url
VARCHAR privacy_policy_url
VARCHAR tos_url
VARCHAR copyright
VARCHAR primary_language
JSON tags
JSON languages
JSON meta
BIT core_extension
VARCHAR status
TIMESTAMP published_at
TIMESTAMP accepted_at
TIMESTAMP rejected_at
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_registry_users {
INTUNSIGNED id PK, UK
CHAR uuid
ENUM account_type
CHAR developer_account_uuid FK
CHAR company_uuid FK "(DC2Type:guid)"
CHAR user_uuid FK "(DC2Type:guid)"
VARCHAR public_id
VARCHAR token
VARCHAR registry_token
VARCHAR scope
TIMESTAMP expires_at
TIMESTAMP last_used_at
VARCHAR name
JSON meta
BIT revoked
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_report_audit_logs {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
CHAR report_uuid FK
CHAR user_uuid FK
CHAR company_uuid FK
VARCHAR action
VARCHAR status
JSON query_config
JSON metadata
TEXT error_message
INT execution_time
INT row_count
VARCHAR export_format
VARCHAR ip_address
VARCHAR user_agent
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_report_cache {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
CHAR report_uuid FK
VARCHAR cache_key UK
LONGTEXT cached_data
JSON metadata
INT row_count
INT execution_time
TIMESTAMP expires_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_report_executions {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
CHAR report_uuid FK
CHAR user_uuid FK
CHAR company_uuid FK
DECIMAL execution_time "Execution time in milliseconds"
INT result_count
JSON query_config
ENUM status
TEXT error_message
TIMESTAMP started_at
TIMESTAMP completed_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_report_templates {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
VARCHAR public_id UK
VARCHAR name
TEXT description
VARCHAR category
JSON query_config
JSON default_parameters
JSON required_parameters
BIT is_public
BIT is_system
CHAR company_uuid FK
CHAR created_by_uuid FK
CHAR updated_by_uuid FK
INT usage_count
TIMESTAMP last_used_at
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_reports {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR public_id UK
VARCHAR _key
CHAR company_uuid FK
CHAR category_uuid FK
CHAR created_by_uuid FK
CHAR updated_by_uuid FK
VARCHAR type
VARCHAR title
VARCHAR description
VARCHAR subject_type
CHAR subject_uuid
TIMESTAMP period_start
TIMESTAMP period_end
JSON data
TEXT body
JSON query_config
JSON result_columns
TIMESTAMP last_executed_at
INT execution_time "Execution time in milliseconds"
INT row_count
INTUNSIGNED execution_count
DOUBLE average_execution_time "Mean execution time in milliseconds across all runs"
INT last_result_count
BIT is_scheduled
JSON schedule_config
JSON export_formats
BIT is_generated
JSON options
JSON meta
JSON tags
VARCHAR status
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_review_accesses {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
CHAR company_uuid
VARCHAR subject_type UK
CHAR subject_uuid UK
BIT enabled
VARCHAR code
TIMESTAMP code_generated_at
TIMESTAMP enabled_at
CHAR updated_by_uuid
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_role_has_permissions {
CHAR permission_id PK, FK, UK
CHAR role_id PK, FK, UK
}
fleetbase_roles {
CHAR id
CHAR company_uuid FK
VARCHAR name UK
VARCHAR guard_name UK
VARCHAR service
VARCHAR description
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_routes {
BIGINTUNSIGNED id PK, UK
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_schedule_availability {
INTUNSIGNED id PK, UK
VARCHAR _key
VARCHAR uuid UK
VARCHAR subject_uuid
VARCHAR subject_type
TIMESTAMP start_at
TIMESTAMP end_at
BIT is_available
TINYINT preference_level "1-5 preference strength"
TEXT rrule "RFC 5545 recurrence rule"
VARCHAR reason
TEXT notes
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_schedule_constraints {
INTUNSIGNED id PK, UK
VARCHAR _key
VARCHAR uuid UK
VARCHAR company_uuid
VARCHAR subject_uuid
VARCHAR subject_type
VARCHAR name
TEXT description
VARCHAR type "e.g., hos, labor, business, capacity"
VARCHAR category "e.g., compliance, optimization"
VARCHAR constraint_key
TEXT constraint_value
VARCHAR jurisdiction "e.g., US-Federal, US-CA, EU"
INT priority "Higher = more important"
BIT is_active
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_schedule_exceptions {
INTUNSIGNED id PK, UK
VARCHAR _key
VARCHAR uuid UK
VARCHAR public_id UK
VARCHAR company_uuid
VARCHAR subject_uuid
VARCHAR subject_type
VARCHAR schedule_uuid
TIMESTAMP start_at
TIMESTAMP end_at
VARCHAR type "e.g., time_off, sick, holiday, swap, training"
VARCHAR status "pending | approved | rejected | cancelled"
VARCHAR reason
TEXT notes
VARCHAR reviewed_by_uuid
TIMESTAMP reviewed_at
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_schedule_items {
INTUNSIGNED id PK, UK
VARCHAR _key
VARCHAR uuid UK
VARCHAR company_uuid
VARCHAR public_id UK
VARCHAR schedule_uuid
VARCHAR template_uuid "The ScheduleTemplate that generated this item via RRULE expansion"
VARCHAR assignee_uuid
VARCHAR assignee_type
VARCHAR resource_uuid
VARCHAR resource_type
TIMESTAMP start_at
TIMESTAMP end_at
INT duration "Duration in minutes"
TIMESTAMP break_start_at
TIMESTAMP break_end_at
ENUM status
BIT is_exception "True when this item has been manually edited and should not be overwritten by re-materialization"
VARCHAR exception_for_date "The original RRULE occurrence date (YYYY-MM-DD) this item is an exception for"
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_schedule_templates {
INTUNSIGNED id PK, UK
VARCHAR _key
VARCHAR uuid UK
VARCHAR public_id UK
VARCHAR company_uuid
VARCHAR schedule_uuid "UUID of the Schedule this template is applied to; NULL for library templates"
VARCHAR subject_uuid
VARCHAR subject_type
VARCHAR name
TEXT description
TIME start_time
TIME end_time
INT duration "Duration in minutes"
INT break_duration "Break duration in minutes"
TEXT rrule "RFC 5545 recurrence rule"
VARCHAR color "Hex colour for calendar rendering, e.g. #6366f1"
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_schedules {
INTUNSIGNED id PK, UK
VARCHAR _key
VARCHAR uuid UK
VARCHAR public_id UK
VARCHAR company_uuid
VARCHAR subject_uuid
VARCHAR subject_type
VARCHAR name
TEXT description
DATE start_date
DATE end_date
VARCHAR timezone
TINYINTUNSIGNED hos_daily_limit "Max driving hours per day. NULL = use global default (11h)."
TINYINTUNSIGNED hos_weekly_limit "Max driving hours per rolling 7-day period. NULL = use global default (70h)."
VARCHAR hos_source "Source used to calculate HOS hours: schedule | telematics | manual"
ENUM status
TIMESTAMP last_materialized_at "Timestamp of the last successful RRULE materialization run"
DATE materialization_horizon "The furthest future date up to which ScheduleItems have been generated"
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_sensors {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR public_id
VARCHAR _key
CHAR company_uuid FK
CHAR telematic_uuid FK
CHAR photo_uuid FK
VARCHAR name
VARCHAR internal_id
VARCHAR serial_number
GEOMETRY last_position
VARCHAR imsi
VARCHAR imei
VARCHAR firmware_version
VARCHAR slug
VARCHAR unit
DOUBLE min_threshold
DOUBLE max_threshold
BIT threshold_inclusive
VARCHAR type
TIMESTAMP last_reading_at
VARCHAR last_value
VARCHAR status
JSON calibration
INTUNSIGNED report_frequency_sec
VARCHAR sensorable_type
CHAR sensorable_uuid
CHAR device_uuid FK
CHAR warranty_uuid FK
JSON meta
CHAR created_by_uuid FK
CHAR updated_by_uuid FK
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_service_areas {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid FK
VARCHAR name
VARCHAR type
VARCHAR country
GEOMETRY border
VARCHAR color
VARCHAR stroke_color
BIT trigger_on_entry
BIT trigger_on_exit
SMALLINTUNSIGNED dwell_threshold_minutes
SMALLINTUNSIGNED speed_limit_kmh
CHAR parent_uuid FK
VARCHAR status
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_service_quote_items {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
CHAR 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, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
VARCHAR request_id
CHAR company_uuid FK
CHAR payload_uuid FK
CHAR service_rate_uuid FK
BIGINT 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, UK
VARCHAR _key
CHAR uuid UK
CHAR service_rate_uuid FK
CHAR service_area_uuid
CHAR zone_uuid
VARCHAR label
INT priority
BIT is_fallback
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, UK
VARCHAR _key
CHAR uuid UK
CHAR 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, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid FK
CHAR service_area_uuid FK
CHAR zone_uuid FK
CHAR order_config_uuid FK
VARCHAR service_name
VARCHAR service_type
INT base_fee
INT max_distance
VARCHAR max_distance_unit
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, UK
VARCHAR key UK
JSON value
}
fleetbase_sms_sends {
CHAR uuid PK, UK
CHAR company_uuid
VARCHAR tenant_type
CHAR tenant_uuid
VARCHAR purpose
VARCHAR source
VARCHAR destination
VARCHAR destination_hash
CHAR destination_country
VARCHAR destination_type
VARCHAR status
VARCHAR block_reason
VARCHAR provider
VARCHAR provider_message_id
TEXT error
VARCHAR subject_type
CHAR subject_uuid
CHAR verification_code_uuid
VARCHAR ip_address
VARCHAR user_agent
JSON meta
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_telematic_deliveries {
CHAR uuid PK, UK
CHAR telematic_uuid
CHAR run_uuid
VARCHAR source
VARCHAR status
CHAR payload_hash
LONGTEXT payload
LONGTEXT retry_payload
INTUNSIGNED invalid_count
INTUNSIGNED attempts
INTUNSIGNED queue_delay_seconds
INTUNSIGNED source_delay_seconds
INTUNSIGNED applied
INTUNSIGNED failed
TEXT error
TIMESTAMP received_at
TIMESTAMP available_at
TIMESTAMP processed_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_telematic_sync_runs {
CHAR uuid PK, UK
CHAR telematic_uuid
VARCHAR status
INTUNSIGNED pages
INTUNSIGNED units
INTUNSIGNED applied
INTUNSIGNED failed
TEXT error
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_telematic_webhook_credentials {
CHAR telematic_uuid PK, UK
TEXT token
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_telematics {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR public_id
VARCHAR _key
CHAR company_uuid FK
VARCHAR name
VARCHAR provider
VARCHAR model
VARCHAR serial_number
VARCHAR firmware_version
VARCHAR status
VARCHAR imei
VARCHAR iccid
VARCHAR imsi
VARCHAR msisdn
VARCHAR type
JSON last_metrics
JSON config
JSON credentials
JSON meta
CHAR created_by_uuid FK
CHAR updated_by_uuid FK
CHAR warranty_uuid FK
TIMESTAMP last_seen_at
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_template_queries {
BIGINTUNSIGNED id PK, UK
VARCHAR uuid UK
VARCHAR public_id UK
VARCHAR company_uuid FK
VARCHAR template_uuid FK
VARCHAR created_by_uuid FK
VARCHAR model_type
VARCHAR variable_name
VARCHAR label
JSON conditions
JSON sort
INTUNSIGNED limit
JSON with
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_templates {
BIGINTUNSIGNED id PK, UK
VARCHAR uuid UK
VARCHAR public_id UK
VARCHAR company_uuid FK
VARCHAR created_by_uuid FK
VARCHAR updated_by_uuid FK
VARCHAR name
TEXT description
VARCHAR context_type
VARCHAR unit
DECIMAL width
DECIMAL height
VARCHAR orientation
JSON margins
VARCHAR background_color
VARCHAR background_image_uuid
LONGTEXT content
JSON element_schemas
BIT is_default
BIT is_system
BIT is_public
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_tracking_numbers {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid FK
CHAR owner_uuid
VARCHAR owner_type
CHAR status_uuid FK
VARCHAR tracking_number
VARCHAR region
MEDIUMTEXT qr_code
MEDIUMTEXT barcode
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_tracking_session_grants {
INTUNSIGNED id PK, UK
CHAR uuid UK
CHAR tracking_session_uuid
CHAR company_uuid
CHAR order_uuid
VARCHAR customer_type
CHAR customer_uuid
VARCHAR channel
TIMESTAMP expires_at
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_tracking_sessions {
INTUNSIGNED id PK, UK
CHAR uuid UK
VARCHAR token_hash UK
VARCHAR ip
VARCHAR user_agent
TIMESTAMP last_seen_at
TIMESTAMP expires_at
TIMESTAMP revoked_at
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_tracking_statuses {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid FK
CHAR tracking_number_uuid FK
CHAR proof_uuid
JSON meta
VARCHAR status
MEDIUMTEXT details
VARCHAR code
BIT complete
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, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR transaction_uuid FK
INT quantity
INT unit_price
BIGINT amount
VARCHAR currency
DECIMAL tax_rate
INT tax_amount
VARCHAR details
TEXT description
SMALLINTUNSIGNED sort_order
VARCHAR code
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_transactions {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR owner_uuid
VARCHAR owner_type
CHAR subject_uuid
VARCHAR subject_type
CHAR payer_uuid
VARCHAR payer_type
CHAR payee_uuid
VARCHAR payee_type
CHAR initiator_uuid
VARCHAR initiator_type
CHAR context_uuid
VARCHAR context_type
CHAR customer_uuid
VARCHAR customer_type
CHAR company_uuid FK
CHAR gateway_uuid
VARCHAR gateway_transaction_id
JSON gateway_response
VARCHAR payment_method
VARCHAR payment_method_last4
VARCHAR payment_method_brand
VARCHAR gateway
INT amount
INT fee_amount
INT tax_amount
INT net_amount
VARCHAR currency
DECIMAL exchange_rate
VARCHAR settled_currency
INT settled_amount
VARCHAR description
VARCHAR reference UK
CHAR parent_transaction_uuid
VARCHAR type
VARCHAR status
VARCHAR settlement_status
VARCHAR direction
INT balance_after
JSON meta
VARCHAR ip_address
TEXT notes
VARCHAR failure_reason
VARCHAR failure_code
VARCHAR period
JSON tags
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP settled_at
TIMESTAMP voided_at
TIMESTAMP reversed_at
TIMESTAMP expires_at
}
fleetbase_types {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
CHAR 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, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id
CHAR user_uuid FK
VARCHAR platform
VARCHAR app_identifier
VARCHAR environment
MEDIUMTEXT token
VARCHAR status
TIMESTAMP last_seen_at
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_users {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid FK
CHAR avatar_uuid FK
VARCHAR username UK
VARCHAR email
VARCHAR apple_user_id UK
VARCHAR facebook_user_id UK
VARCHAR google_user_id UK
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
JSON options
VARCHAR remember_token
DATETIME email_verified_at
DATETIME phone_verified_at
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_vehicle_geofence_states {
BIGINTUNSIGNED id PK, UK
CHAR vehicle_uuid FK, UK
CHAR geofence_uuid UK
VARCHAR geofence_type
BIT is_inside
TIMESTAMP entered_at
TIMESTAMP exited_at
VARCHAR dwell_job_id
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_vehicles {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
VARCHAR internal_id
CHAR company_uuid FK
CHAR telematic_uuid FK
CHAR category_uuid FK
CHAR warranty_uuid FK
CHAR vendor_uuid FK
CHAR photo_uuid FK
VARCHAR name
MEDIUMTEXT description
MEDIUMTEXT avatar_url
GEOMETRY location
VARCHAR speed
VARCHAR heading
VARCHAR altitude
VARCHAR make
VARCHAR model
VARCHAR model_type
VARCHAR year
VARCHAR trim
VARCHAR fuel_type
VARCHAR fuel_volume_unit
DECIMAL fuel_capacity
DECIMAL bed_length
DECIMAL ground_clearance
TINYINTUNSIGNED seating_capacity
DECIMAL payload_capacity
VARCHAR emission_standard
BIT dpf_equipped
BIT scr_equipped
DECIMAL gvwr
DECIMAL gcwr
DECIMAL towing_capacity
DECIMAL height
DECIMAL length
DECIMAL width
DECIMAL weight
DECIMAL interior_volume
DECIMAL passenger_volume
DECIMAL cargo_volume
VARCHAR color
VARCHAR transmission
VARCHAR type
VARCHAR class
VARCHAR measurement_system
VARCHAR body_type
VARCHAR body_sub_type
VARCHAR usage_type
VARCHAR ownership_type
VARCHAR odometer
INTUNSIGNED odometer_at_purchase
VARCHAR odometer_unit
VARCHAR plate_number
VARCHAR call_sign
VARCHAR fuel_card_number
VARCHAR serial_number
VARCHAR engine_number UK
VARCHAR engine_model
VARCHAR engine_make
VARCHAR engine_family
VARCHAR engine_configuration
DECIMAL engine_displacement
DECIMAL engine_size
DECIMAL horsepower
INTUNSIGNED horsepower_rpm
DECIMAL torque
INTUNSIGNED torque_rpm
TINYINTUNSIGNED number_of_cylinders
VARCHAR cylinder_arrangement
VARCHAR vin
JSON vin_data
VARCHAR financing_status
VARCHAR currency
INT insurance_value
INT depreciation_rate
INT current_value
INT acquisition_cost
INTUNSIGNED estimated_service_life_months
INTUNSIGNED estimated_service_life_distance
VARCHAR estimated_service_life_distance_unit
DECIMAL loan_amount
DATE loan_first_payment
INTUNSIGNED loan_number_of_payments
JSON meta
MEDIUMTEXT notes
JSON telematics
JSON specs
JSON details
VARCHAR status
JSON skills
DECIMALUNSIGNED payload_capacity_volume
INTUNSIGNED payload_capacity_pallets
INTUNSIGNED payload_capacity_parcels
INTUNSIGNED max_tasks
TIME time_window_start
TIME time_window_end
BIT return_to_depot
BIT online
VARCHAR slug
TIMESTAMP purchased_at
TIMESTAMP lease_expires_at
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_vendor_personnels {
INTUNSIGNED id PK, UK
CHAR uuid
CHAR vendor_uuid FK
CHAR contact_uuid FK
VARCHAR role
VARCHAR status
CHAR invited_by_uuid FK
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_vendors {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid FK
CHAR place_uuid FK
CHAR type_uuid FK
CHAR connect_company_uuid FK
CHAR 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
MEDIUMTEXT notes
VARCHAR status
VARCHAR slug
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_verification_codes {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
CHAR subject_uuid
VARCHAR subject_type
CHAR company_uuid
VARCHAR identity
VARCHAR channel
VARCHAR ip_address
VARCHAR user_agent
CHAR sms_send_uuid
VARCHAR code
VARCHAR for
JSON meta
DATETIME expires_at
DATETIME consumed_at
VARCHAR status
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_warranties {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR _key
CHAR company_uuid FK
CHAR vendor_uuid FK
CHAR category_uuid FK
CHAR created_by_uuid FK
CHAR updated_by_uuid FK
VARCHAR subject_type
CHAR subject_uuid
VARCHAR provider
VARCHAR policy_number
VARCHAR type
DATE start_date
DATE end_date
JSON coverage
JSON terms
TEXT policy
JSON meta
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_waypoints {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id
CHAR company_uuid FK
CHAR place_uuid FK
CHAR payload_uuid FK
CHAR tracking_number_uuid FK
CHAR customer_uuid
VARCHAR customer_type
VARCHAR _import_id
VARCHAR type
DATETIME time_window_start
DATETIME time_window_end
INTUNSIGNED service_time "Seconds"
TEXT notes
VARCHAR pod_method
BIT pod_required
INT order
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_webhook_endpoints {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
CHAR company_uuid FK
CHAR updated_by_uuid FK
CHAR created_by_uuid FK
CHAR api_credential_uuid FK
VARCHAR url
VARCHAR mode
VARCHAR version
TEXT secret
VARCHAR description
JSON events
VARCHAR status
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_webhook_request_logs {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid FK
CHAR webhook_uuid FK
CHAR api_credential_uuid FK
BIGINTUNSIGNED access_token_id 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_work_orders {
INTUNSIGNED id PK, UK
CHAR uuid
VARCHAR _key
VARCHAR public_id UK
CHAR company_uuid FK
CHAR schedule_uuid
CHAR category_uuid FK
VARCHAR code
VARCHAR subject
VARCHAR category
VARCHAR status
VARCHAR priority
VARCHAR target_type
CHAR target_uuid
VARCHAR assignee_type
CHAR assignee_uuid
TIMESTAMP opened_at
TIMESTAMP due_at
TIMESTAMP closed_at
JSON required_skills
JSON required_certifications
INT estimated_duration_hours
INT actual_duration_hours
JSON resource_requirements
TIMESTAMP earliest_start_date
TIMESTAMP latest_completion_date
VARCHAR scheduling_priority
BIT can_be_split
INT estimated_cost
INT approved_budget
INT actual_cost
VARCHAR currency
JSON cost_breakdown
VARCHAR cost_center
VARCHAR budget_code
TEXT instructions
TEXT completion_notes
JSON checklist
JSON meta
CHAR created_by_uuid FK
CHAR updated_by_uuid FK
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_zones {
INTUNSIGNED id PK, UK
VARCHAR _key
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid FK
CHAR service_area_uuid FK
VARCHAR name
MEDIUMTEXT description
GEOMETRY border
VARCHAR color
VARCHAR stroke_color
BIT trigger_on_entry
BIT trigger_on_exit
SMALLINTUNSIGNED dwell_threshold_minutes
SMALLINTUNSIGNED speed_limit_kmh
VARCHAR status
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_storefront_apple_sign_in_tokens {
INTUNSIGNED id PK, UK
CHAR uuid UK
CHAR company_uuid
CHAR customer_uuid UK
CHAR user_uuid
VARCHAR apple_user_id
VARCHAR client_id UK
TEXT refresh_token
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_storefront_campaigns {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid FK
CHAR created_by_uuid FK
CHAR owner_uuid
VARCHAR owner_type
CHAR segment_uuid FK
CHAR promotion_uuid FK
JSON recipients
VARCHAR name
VARCHAR status
JSON channels
VARCHAR title
TEXT body
CHAR image_uuid
JSON action
TIMESTAMP send_at
TIMESTAMP started_at
TIMESTAMP sent_at
JSON stats
JSON meta
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_storefront_carts {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
VARCHAR public_id
CHAR company_uuid FK
CHAR user_uuid FK
CHAR checkout_uuid FK
VARCHAR status
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_catalog_category_products {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
CHAR catalog_category_uuid FK
CHAR product_uuid FK
INT price
BIT is_available
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_storefront_catalog_hours {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
CHAR catalog_uuid FK
VARCHAR day_of_week
TIME start
TIME end
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_storefront_catalog_subjects {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
CHAR catalog_uuid FK
VARCHAR subject_type
CHAR subject_uuid
CHAR company_uuid FK
CHAR created_by_uuid FK
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_storefront_catalogs {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
VARCHAR public_id UK
CHAR store_uuid FK
CHAR company_uuid FK
CHAR created_by_uuid FK
VARCHAR name
TEXT description
VARCHAR status
JSON meta
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_storefront_checkouts {
BIGINTUNSIGNED id PK, UK
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
VARCHAR stripe_payment_intent_id UK
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_customer_segments {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid FK
CHAR created_by_uuid FK
CHAR owner_uuid
VARCHAR owner_type
VARCHAR name
TEXT description
JSON rules
JSON meta
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_storefront_food_trucks {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
VARCHAR public_id UK
CHAR vehicle_uuid FK
CHAR service_area_uuid FK
CHAR zone_uuid FK
CHAR store_uuid FK
CHAR network_uuid
CHAR company_uuid FK
CHAR created_by_uuid FK
VARCHAR status
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_storefront_gateways {
BIGINTUNSIGNED id PK, UK
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_inventory_movements {
INTUNSIGNED id PK, UK
CHAR uuid UK
CHAR company_uuid
CHAR inventory_uuid
VARCHAR type
INT quantity
INT quantity_after
CHAR reference_uuid
VARCHAR reference_type
CHAR actor_uuid
VARCHAR note
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_storefront_inventory_reservations {
INTUNSIGNED id PK, UK
CHAR uuid UK
CHAR company_uuid
CHAR inventory_uuid
CHAR checkout_uuid
CHAR order_uuid
VARCHAR cart_item_id
INT quantity
TIMESTAMP expires_at
VARCHAR status
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_storefront_network_stores {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
VARCHAR network_uuid FK
VARCHAR store_uuid FK
CHAR category_uuid FK
VARCHAR status
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_storefront_networks {
BIGINTUNSIGNED id PK, UK
VARCHAR public_id
CHAR uuid UK
VARCHAR created_by_uuid FK
VARCHAR company_uuid FK
CHAR logo_uuid FK
CHAR backdrop_uuid FK
CHAR order_config_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, UK
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, UK
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, UK
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, UK
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, UK
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_inventories {
INTUNSIGNED id PK, UK
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid
CHAR product_uuid UK
CHAR location_uuid UK
VARCHAR location_type
INT quantity
INT reserved
INT low_stock_threshold
BIT allow_backorder
JSON meta
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_storefront_product_store_locations {
BIGINTUNSIGNED id PK, UK
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, UK
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, UK
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, UK
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 track_inventory
BIT is_recommended
BIT can_pickup
VARCHAR currency
VARCHAR status
VARCHAR slug
TIMESTAMP deleted_at
TIMESTAMP created_at
TIMESTAMP updated_at
}
fleetbase_storefront_promotion_codes {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid FK, UK
CHAR promotion_uuid FK
VARCHAR code UK
VARCHAR status
INTUNSIGNED usage_limit
CHAR customer_uuid
TIMESTAMP expires_at
JSON meta
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_storefront_promotion_redemptions {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
CHAR company_uuid FK
CHAR promotion_uuid FK
CHAR promotion_code_uuid
CHAR customer_uuid
CHAR checkout_uuid
CHAR order_uuid
BIGINTUNSIGNED amount
VARCHAR currency
VARCHAR status
TIMESTAMP redeemed_at
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_storefront_promotions {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
VARCHAR public_id UK
CHAR company_uuid FK
CHAR created_by_uuid FK
CHAR owner_uuid
VARCHAR owner_type
VARCHAR name
TEXT description
VARCHAR status
VARCHAR trigger
VARCHAR type
DECIMAL value
BIGINTUNSIGNED max_discount_amount
VARCHAR currency
BIGINTUNSIGNED min_subtotal
INTUNSIGNED min_items
JSON applies_to
JSON bogo_config
BIT first_order_only
INTUNSIGNED usage_limit
INTUNSIGNED usage_limit_per_customer
BIGINTUNSIGNED budget_amount
BIT stackable
INT priority
BIT is_public
TIMESTAMP starts_at
TIMESTAMP ends_at
JSON schedule
VARCHAR timezone
CHAR image_uuid
JSON translations
JSON meta
TIMESTAMP created_at
TIMESTAMP updated_at
TIMESTAMP deleted_at
}
fleetbase_storefront_reviews {
BIGINTUNSIGNED id PK, UK
CHAR uuid UK
VARCHAR public_id UK
VARCHAR created_by_uuid FK
CHAR customer_uuid FK
CHAR order_uuid
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, UK
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, UK
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, UK
VARCHAR public_id
CHAR uuid UK
VARCHAR created_by_uuid FK
VARCHAR company_uuid FK
VARCHAR logo_uuid FK
CHAR backdrop_uuid FK
CHAR order_config_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, UK
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_ai_knowledge_documents ||--o{ fleetbase_ai_knowledge_chunks : "foreign key"
fleetbase_ai_sessions ||--o{ fleetbase_ai_admin_access_logs : "foreign key"
fleetbase_ai_sessions ||--o{ fleetbase_ai_tasks : "foreign key"
fleetbase_ai_tasks ||--o{ fleetbase_ai_admin_access_logs : "foreign key"
fleetbase_ai_tasks ||--o{ fleetbase_ai_task_steps : "foreign key"
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_categories ||--o{ fleetbase_alerts : "foreign key"
fleetbase_categories ||--o{ fleetbase_assets : "foreign key"
fleetbase_categories ||--o{ fleetbase_entities : "foreign key"
fleetbase_categories ||--o{ fleetbase_equipments : "foreign key"
fleetbase_categories ||--o{ fleetbase_extensions : "foreign key"
fleetbase_categories ||--o{ fleetbase_maintenances : "foreign key"
fleetbase_categories ||--o{ fleetbase_order_configs : "foreign key"
fleetbase_categories ||--o{ fleetbase_parts : "foreign key"
fleetbase_categories ||--o{ fleetbase_registry_extensions : "foreign key"
fleetbase_categories ||--o{ fleetbase_reports : "foreign key"
fleetbase_categories ||--o{ fleetbase_storefront_catalog_category_products : "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_categories ||--o{ fleetbase_vehicles : "foreign key"
fleetbase_categories ||--o{ fleetbase_warranties : "foreign key"
fleetbase_categories ||--o{ fleetbase_work_orders : "foreign key"
fleetbase_chat_channels ||--o{ fleetbase_chat_attachments : "foreign key"
fleetbase_chat_channels ||--o{ fleetbase_chat_logs : "foreign key"
fleetbase_chat_channels ||--o{ fleetbase_chat_messages : "foreign key"
fleetbase_chat_channels ||--o{ fleetbase_chat_participants : "foreign key"
fleetbase_chat_messages ||--o{ fleetbase_chat_attachments : "foreign key"
fleetbase_chat_messages ||--o{ fleetbase_chat_receipts : "foreign key"
fleetbase_chat_participants ||--o{ fleetbase_chat_attachments : "foreign key"
fleetbase_chat_participants ||--o{ fleetbase_chat_logs : "foreign key"
fleetbase_chat_participants ||--o{ fleetbase_chat_messages : "foreign key"
fleetbase_chat_participants ||--o{ fleetbase_chat_receipts : "foreign key"
fleetbase_comments ||--o{ fleetbase_comments : "foreign key"
fleetbase_companies ||--o{ fleetbase_ai_admin_access_logs : "foreign key"
fleetbase_companies ||--o{ fleetbase_ai_sessions : "foreign key"
fleetbase_companies ||--o{ fleetbase_ai_task_steps : "foreign key"
fleetbase_companies ||--o{ fleetbase_ai_tasks : "foreign key"
fleetbase_companies ||--o{ fleetbase_alerts : "foreign key"
fleetbase_companies ||--o{ fleetbase_api_credentials : "foreign key"
fleetbase_companies ||--o{ fleetbase_api_request_logs : "foreign key"
fleetbase_companies ||--o{ fleetbase_asset_connections : "foreign key"
fleetbase_companies ||--o{ fleetbase_assets : "foreign key"
fleetbase_companies ||--o{ fleetbase_chat_attachments : "foreign key"
fleetbase_companies ||--o{ fleetbase_chat_channels : "foreign key"
fleetbase_companies ||--o{ fleetbase_chat_logs : "foreign key"
fleetbase_companies ||--o{ fleetbase_chat_messages : "foreign key"
fleetbase_companies ||--o{ fleetbase_chat_participants : "foreign key"
fleetbase_companies ||--o{ fleetbase_chat_receipts : "foreign key"
fleetbase_companies ||--o{ fleetbase_comments : "foreign key"
fleetbase_companies ||--o{ fleetbase_company_users : "foreign key"
fleetbase_companies ||--o{ fleetbase_contacts : "foreign key"
fleetbase_companies ||--o{ fleetbase_custom_field_values : "foreign key"
fleetbase_companies ||--o{ fleetbase_custom_fields : "foreign key"
fleetbase_companies ||--o{ fleetbase_device_events : "foreign key"
fleetbase_companies ||--o{ fleetbase_device_installations : "foreign key"
fleetbase_companies ||--o{ fleetbase_devices : "foreign key"
fleetbase_companies ||--o{ fleetbase_directives : "foreign key"
fleetbase_companies ||--o{ fleetbase_drivers : "foreign key"
fleetbase_companies ||--o{ fleetbase_entities : "foreign key"
fleetbase_companies ||--o{ fleetbase_equipments : "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_inspection_forms : "foreign key"
fleetbase_companies ||--o{ fleetbase_inspection_item_results : "foreign key"
fleetbase_companies ||--o{ fleetbase_inspection_links : "foreign key"
fleetbase_companies ||--o{ fleetbase_inspection_submissions : "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_maintenance_schedules : "foreign key"
fleetbase_companies ||--o{ fleetbase_maintenances : "foreign key"
fleetbase_companies ||--o{ fleetbase_order_configs : "foreign key"
fleetbase_companies ||--o{ fleetbase_orders : "foreign key"
fleetbase_companies ||--o{ fleetbase_parts : "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_registry_extension_bundles : "foreign key"
fleetbase_companies ||--o{ fleetbase_registry_extension_installs : "foreign key"
fleetbase_companies ||--o{ fleetbase_registry_extension_purchases : "foreign key"
fleetbase_companies ||--o{ fleetbase_registry_extensions : "foreign key"
fleetbase_companies ||--o{ fleetbase_registry_users : "foreign key"
fleetbase_companies ||--o{ fleetbase_report_audit_logs : "foreign key"
fleetbase_companies ||--o{ fleetbase_report_executions : "foreign key"
fleetbase_companies ||--o{ fleetbase_report_templates : "foreign key"
fleetbase_companies ||--o{ fleetbase_reports : "foreign key"
fleetbase_companies ||--o{ fleetbase_roles : "foreign key"
fleetbase_companies ||--o{ fleetbase_routes : "foreign key"
fleetbase_companies ||--o{ fleetbase_sensors : "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_storefront_campaigns : "foreign key"
fleetbase_companies ||--o{ fleetbase_storefront_carts : "foreign key"
fleetbase_companies ||--o{ fleetbase_storefront_catalog_subjects : "foreign key"
fleetbase_companies ||--o{ fleetbase_storefront_catalogs : "foreign key"
fleetbase_companies ||--o{ fleetbase_storefront_checkouts : "foreign key"
fleetbase_companies ||--o{ fleetbase_storefront_customer_segments : "foreign key"
fleetbase_companies ||--o{ fleetbase_storefront_food_trucks : "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_promotion_codes : "foreign key"
fleetbase_companies ||--o{ fleetbase_storefront_promotion_redemptions : "foreign key"
fleetbase_companies ||--o{ fleetbase_storefront_promotions : "foreign key"
fleetbase_companies ||--o{ fleetbase_storefront_stores : "foreign key"
fleetbase_companies ||--o{ fleetbase_telematics : "foreign key"
fleetbase_companies ||--o{ fleetbase_template_queries : "foreign key"
fleetbase_companies ||--o{ fleetbase_templates : "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_warranties : "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_work_orders : "foreign key"
fleetbase_companies ||--o{ fleetbase_zones : "foreign key"
fleetbase_contacts ||--o{ fleetbase_storefront_reviews : "foreign key"
fleetbase_contacts ||--o{ fleetbase_storefront_votes : "foreign key"
fleetbase_contacts ||--o{ fleetbase_vendor_personnels : "foreign key"
fleetbase_custom_fields ||--o{ fleetbase_custom_field_values : "foreign key"
fleetbase_dashboards ||--o{ fleetbase_dashboard_widgets : "foreign key"
fleetbase_devices ||--o{ fleetbase_device_events : "foreign key"
fleetbase_devices ||--o{ fleetbase_device_installations : "foreign key"
fleetbase_devices ||--o{ fleetbase_sensors : "foreign key"
fleetbase_drivers ||--o{ fleetbase_driver_geofence_states : "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_inspection_links : "foreign key"
fleetbase_drivers ||--o{ fleetbase_inspection_submissions : "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_assets : "foreign key"
fleetbase_files ||--o{ fleetbase_categories : "foreign key"
fleetbase_files ||--o{ fleetbase_chat_attachments : "foreign key"
fleetbase_files ||--o{ fleetbase_companies : "foreign key"
fleetbase_files ||--o{ fleetbase_contacts : "foreign key"
fleetbase_files ||--o{ fleetbase_devices : "foreign key"
fleetbase_files ||--o{ fleetbase_equipments : "foreign key"
fleetbase_files ||--o{ fleetbase_extensions : "foreign key"
fleetbase_files ||--o{ fleetbase_order_configs : "foreign key"
fleetbase_files ||--o{ fleetbase_parts : "foreign key"
fleetbase_files ||--o{ fleetbase_proofs : "foreign key"
fleetbase_files ||--o{ fleetbase_registry_extension_bundles : "foreign key"
fleetbase_files ||--o{ fleetbase_registry_extensions : "foreign key"
fleetbase_files ||--o{ fleetbase_sensors : "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_files ||--o{ fleetbase_users : "foreign key"
fleetbase_files ||--o{ fleetbase_vehicles : "foreign key"
fleetbase_files ||--o{ fleetbase_vendors : "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_inspection_forms ||--o{ fleetbase_inspection_links : "foreign key"
fleetbase_inspection_forms ||--o{ fleetbase_inspection_submissions : "foreign key"
fleetbase_inspection_submissions ||--o{ fleetbase_inspection_item_results : "foreign key"
fleetbase_integrated_vendors ||--o{ fleetbase_service_quotes : "foreign key"
fleetbase_issues ||--o{ fleetbase_inspection_item_results : "foreign key"
fleetbase_issues ||--o{ fleetbase_inspection_submissions : "foreign key"
fleetbase_manifests ||--o{ fleetbase_manifest_stops : "foreign key"
fleetbase_monitored_scheduled_tasks ||--o{ fleetbase_monitored_scheduled_task_log_items : "foreign key"
fleetbase_oauth_clients ||--o{ fleetbase_oauth_grants : "foreign key"
fleetbase_order_configs ||--o{ fleetbase_orders : "foreign key"
fleetbase_order_configs ||--o{ fleetbase_service_rates : "foreign key"
fleetbase_order_configs ||--o{ fleetbase_storefront_networks : "foreign key"
fleetbase_order_configs ||--o{ fleetbase_storefront_stores : "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_directives : "foreign key"
fleetbase_permissions ||--o{ fleetbase_model_has_permissions : "foreign key"
fleetbase_permissions ||--o{ fleetbase_role_has_permissions : "foreign key"
fleetbase_personal_access_tokens ||--o{ fleetbase_api_events : "foreign key"
fleetbase_personal_access_tokens ||--o{ fleetbase_api_request_logs : "foreign key"
fleetbase_personal_access_tokens ||--o{ fleetbase_webhook_request_logs : "foreign key"
fleetbase_places ||--o{ fleetbase_assets : "foreign key"
fleetbase_places ||--o{ fleetbase_companies : "foreign key"
fleetbase_places ||--o{ fleetbase_contacts : "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_storefront_store_locations : "foreign key"
fleetbase_places ||--o{ fleetbase_vendors : "foreign key"
fleetbase_places ||--o{ fleetbase_waypoints : "foreign key"
fleetbase_policies ||--o{ fleetbase_model_has_policies : "foreign key"
fleetbase_purchase_rates ||--o{ fleetbase_orders : "foreign key"
fleetbase_registry_developer_accounts ||--o{ fleetbase_registry_users : "foreign key"
fleetbase_registry_extension_bundles ||--o{ fleetbase_registry_extensions : "foreign key"
fleetbase_registry_extensions ||--o{ fleetbase_registry_extension_bundles : "foreign key"
fleetbase_registry_extensions ||--o{ fleetbase_registry_extension_installs : "foreign key"
fleetbase_registry_extensions ||--o{ fleetbase_registry_extension_purchases : "foreign key"
fleetbase_registry_users ||--o{ fleetbase_registry_extensions : "foreign key"
fleetbase_reports ||--o{ fleetbase_report_audit_logs : "foreign key"
fleetbase_reports ||--o{ fleetbase_report_cache : "foreign key"
fleetbase_reports ||--o{ fleetbase_report_executions : "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_storefront_food_trucks : "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_storefront_carts ||--o{ fleetbase_storefront_checkouts : "foreign key"
fleetbase_storefront_catalogs ||--o{ fleetbase_storefront_catalog_hours : "foreign key"
fleetbase_storefront_catalogs ||--o{ fleetbase_storefront_catalog_subjects : "foreign key"
fleetbase_storefront_checkouts ||--o{ fleetbase_storefront_carts : "foreign key"
fleetbase_storefront_customer_segments ||--o{ fleetbase_storefront_campaigns : "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_catalog_category_products : "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_promotions ||--o{ fleetbase_storefront_campaigns : "foreign key"
fleetbase_storefront_promotions ||--o{ fleetbase_storefront_promotion_codes : "foreign key"
fleetbase_storefront_promotions ||--o{ fleetbase_storefront_promotion_redemptions : "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_catalogs : "foreign key"
fleetbase_storefront_stores ||--o{ fleetbase_storefront_checkouts : "foreign key"
fleetbase_storefront_stores ||--o{ fleetbase_storefront_food_trucks : "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"
fleetbase_telematics ||--o{ fleetbase_assets : "foreign key"
fleetbase_telematics ||--o{ fleetbase_devices : "foreign key"
fleetbase_telematics ||--o{ fleetbase_sensors : "foreign key"
fleetbase_telematics ||--o{ fleetbase_vehicles : "foreign key"
fleetbase_templates ||--o{ fleetbase_template_queries : "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_ai_admin_access_logs : "foreign key"
fleetbase_users ||--o{ fleetbase_ai_sessions : "foreign key"
fleetbase_users ||--o{ fleetbase_ai_task_steps : "foreign key"
fleetbase_users ||--o{ fleetbase_ai_tasks : "foreign key"
fleetbase_users ||--o{ fleetbase_alerts : "foreign key"
fleetbase_users ||--o{ fleetbase_api_credentials : "foreign key"
fleetbase_users ||--o{ fleetbase_asset_connections : "foreign key"
fleetbase_users ||--o{ fleetbase_assets : "foreign key"
fleetbase_users ||--o{ fleetbase_chat_channels : "foreign key"
fleetbase_users ||--o{ fleetbase_chat_participants : "foreign key"
fleetbase_users ||--o{ fleetbase_comments : "foreign key"
fleetbase_users ||--o{ fleetbase_companies : "foreign key"
fleetbase_users ||--o{ fleetbase_company_users : "foreign key"
fleetbase_users ||--o{ fleetbase_contacts : "foreign key"
fleetbase_users ||--o{ fleetbase_drivers : "foreign key"
fleetbase_users ||--o{ fleetbase_equipments : "foreign key"
fleetbase_users ||--o{ fleetbase_fuel_reports : "foreign key"
fleetbase_users ||--o{ fleetbase_group_users : "foreign key"
fleetbase_users ||--o{ fleetbase_inspection_forms : "foreign key"
fleetbase_users ||--o{ fleetbase_inspection_item_results : "foreign key"
fleetbase_users ||--o{ fleetbase_inspection_links : "foreign key"
fleetbase_users ||--o{ fleetbase_inspection_submissions : "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_maintenance_schedules : "foreign key"
fleetbase_users ||--o{ fleetbase_maintenances : "foreign key"
fleetbase_users ||--o{ fleetbase_oauth_grants : "foreign key"
fleetbase_users ||--o{ fleetbase_oauth_identities : "foreign key"
fleetbase_users ||--o{ fleetbase_oauth_states : "foreign key"
fleetbase_users ||--o{ fleetbase_order_configs : "foreign key"
fleetbase_users ||--o{ fleetbase_orders : "foreign key"
fleetbase_users ||--o{ fleetbase_parts : "foreign key"
fleetbase_users ||--o{ fleetbase_registry_extension_bundles : "foreign key"
fleetbase_users ||--o{ fleetbase_registry_extensions : "foreign key"
fleetbase_users ||--o{ fleetbase_registry_users : "foreign key"
fleetbase_users ||--o{ fleetbase_report_audit_logs : "foreign key"
fleetbase_users ||--o{ fleetbase_report_executions : "foreign key"
fleetbase_users ||--o{ fleetbase_report_templates : "foreign key"
fleetbase_users ||--o{ fleetbase_reports : "foreign key"
fleetbase_users ||--o{ fleetbase_sensors : "foreign key"
fleetbase_users ||--o{ fleetbase_storefront_campaigns : "foreign key"
fleetbase_users ||--o{ fleetbase_storefront_carts : "foreign key"
fleetbase_users ||--o{ fleetbase_storefront_catalog_subjects : "foreign key"
fleetbase_users ||--o{ fleetbase_storefront_catalogs : "foreign key"
fleetbase_users ||--o{ fleetbase_storefront_customer_segments : "foreign key"
fleetbase_users ||--o{ fleetbase_storefront_food_trucks : "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_promotions : "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_users ||--o{ fleetbase_telematics : "foreign key"
fleetbase_users ||--o{ fleetbase_template_queries : "foreign key"
fleetbase_users ||--o{ fleetbase_templates : "foreign key"
fleetbase_users ||--o{ fleetbase_user_devices : "foreign key"
fleetbase_users ||--o{ fleetbase_vendor_personnels : "foreign key"
fleetbase_users ||--o{ fleetbase_warranties : "foreign key"
fleetbase_users ||--o{ fleetbase_webhook_endpoints : "foreign key"
fleetbase_users ||--o{ fleetbase_work_orders : "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_inspection_links : "foreign key"
fleetbase_vehicles ||--o{ fleetbase_inspection_submissions : "foreign key"
fleetbase_vehicles ||--o{ fleetbase_issues : "foreign key"
fleetbase_vehicles ||--o{ fleetbase_orders : "foreign key"
fleetbase_vehicles ||--o{ fleetbase_storefront_food_trucks : "foreign key"
fleetbase_vehicles ||--o{ fleetbase_vehicle_geofence_states : "foreign key"
fleetbase_vendors ||--o{ fleetbase_assets : "foreign key"
fleetbase_vendors ||--o{ fleetbase_drivers : "foreign key"
fleetbase_vendors ||--o{ fleetbase_entities : "foreign key"
fleetbase_vendors ||--o{ fleetbase_fleets : "foreign key"
fleetbase_vendors ||--o{ fleetbase_parts : "foreign key"
fleetbase_vendors ||--o{ fleetbase_vehicles : "foreign key"
fleetbase_vendors ||--o{ fleetbase_vendor_personnels : "foreign key"
fleetbase_vendors ||--o{ fleetbase_warranties : "foreign key"
fleetbase_warranties ||--o{ fleetbase_assets : "foreign key"
fleetbase_warranties ||--o{ fleetbase_devices : "foreign key"
fleetbase_warranties ||--o{ fleetbase_equipments : "foreign key"
fleetbase_warranties ||--o{ fleetbase_parts : "foreign key"
fleetbase_warranties ||--o{ fleetbase_sensors : "foreign key"
fleetbase_warranties ||--o{ fleetbase_telematics : "foreign key"
fleetbase_warranties ||--o{ fleetbase_vehicles : "foreign key"
fleetbase_webhook_endpoints ||--o{ fleetbase_webhook_request_logs : "foreign key"
fleetbase_work_orders ||--o{ fleetbase_inspection_item_results : "foreign key"
fleetbase_work_orders ||--o{ fleetbase_inspection_submissions : "foreign key"
fleetbase_work_orders ||--o{ fleetbase_maintenances : "foreign key"
fleetbase_zones ||--o{ fleetbase_fleets : "foreign key"
fleetbase_zones ||--o{ fleetbase_service_rates : "foreign key"
fleetbase_zones ||--o{ fleetbase_storefront_food_trucks : "foreign key"