SQL reference: 30_automotive

Production API: https://asi-database-node-api.arybit.co.ke

Source: Database/30_automotive.sql

Engine: MySQL legacy. Status: disabled; qualification pending.

Migration ID: 30_automotive. SHA-256 (LF): ddd0fa5b44cb657e62dfb5f20dc8632edc23fa7a57c1ff5f74ae75dbe46af9fc.

Pending isolated MySQL/MariaDB compatibility, dependency and tenant-isolation validation.

Source overview

================================================================= Arybit Mobility v2.0 - Intelligent Transportation Platform Database Schema Production-Ready MySQL Schema MODULE: 30_automotive Version: 2.1.0 (Integrated) • January 2026 Integrated into Arybit Auth Master Schema (Modular Bridge)

Description: Complete, scalable, and secure database schema for a modern telematics and mobility platform.

Declared objects

• auto_carbon_emissions
• auto_diagnostics_reports
• auto_driver_events
• auto_fleets
• auto_location_logs
• auto_media
• auto_organization_invites
• auto_organizations
• auto_personas
• auto_system_logs
• auto_tasks
• auto_telematics_devices
• auto_trips
• auto_user_capabilities
• auto_users
• auto_vehicle_persona_assignments
• auto_vehicle_valuations
• auto_vehicles

This is a static source reference, not a runtime qualification. Object extraction does not interpret SQL semantics. Review the source and manifest before any schema change.

Connection guide · Migration qualification · SQL catalog