System Architecture & MySQLi Engine Diagnostics MySQLi Active
Inspect relational tables, database schema integrity, connection pools, and real-time query latencies.
Database Engine
MySQL / MariaDB
v11.4.13-MariaDB-cll-lve
Total Indexed Records
203
Across 16 core relational tables
Host Connection
Localhost via UNIX socket
Charset: utf8mb4 / Persistent: Active
Database Tables & Row Counts
16 Tables Verified| Table Name | Primary Key | Foreign Keys | Row Count | Health Status | REST Endpoint |
|---|---|---|---|---|---|
| users | id (VARCHAR 36 / UUID) | N/A | 7 | Operational | /api/users.php → |
| farms | id (VARCHAR 36 / UUID) | owner_id | 9 | Operational | /api/farms.php → |
| flocks | id (VARCHAR 36 / UUID) | farm_id, flock_id | 7 | Operational | /api/flocks.php → |
| daily_performance | id (VARCHAR 36 / UUID) | farm_id, flock_id | 7 | Operational | /api/daily_performance.php → |
| egg_records | id (VARCHAR 36 / UUID) | farm_id, flock_id | 21 | Operational | /api/egg_records.php → |
| feed_records | id (VARCHAR 36 / UUID) | farm_id, flock_id | 11 | Operational | /api/feed_records.php → |
| feed_inventory | id (VARCHAR 36 / UUID) | N/A | 4 | Operational | /api/feed_inventory.php → |
| flock_tasks | id (VARCHAR 36 / UUID) | N/A | 93 | Operational | /api/flock_tasks.php → |
| health_records | id (VARCHAR 36 / UUID) | farm_id, flock_id | 4 | Operational | /api/health_records.php → |
| biosecurity_audits | id (VARCHAR 36 / UUID) | N/A | 5 | Operational | /api/biosecurity_audits.php → |
| telemetry_logs | id (VARCHAR 36 / UUID) | N/A | 9 | Operational | /api/telemetry_logs.php → |
| finance_records | id (VARCHAR 36 / UUID) | farm_id, flock_id | 18 | Operational | /api/finance_records.php → |
| inventory_items | id (VARCHAR 36 / UUID) | farm_id, flock_id | 3 | Operational | /api/inventory_items.php → |
| breeding_pairs | id (VARCHAR 36 / UUID) | farm_id, flock_id | 0 | Operational | /api/breeding_pairs.php → |
| hatchery_batches | id (VARCHAR 36 / UUID) | farm_id, flock_id | 0 | Operational | /api/hatchery_batches.php → |
| subscriptions | id (VARCHAR 36 / UUID) | N/A | 5 | Operational | /api/subscriptions.php → |