| ID | Número | Cliente | Total | Estado |
|---|---|---|---|---|
| 289 | 00279 | Mauricio Aundulio Mendoza García | 325.00 | reservado |
| 288 | 00278 | Estefana Perez | 180.00 | entregado |
| 287 | 00277 | Pablo ramirez | 345.00 | entregado |
| 286 | 00276 | Keyly | 325.00 | entregado |
| 285 | 00275 | Carlos mendoza | 325.00 | reservado |
| ID | Número | Cliente | Modelo |
|---|---|---|---|
| 289 | 00279 | Mauricio Aundulio Mendoza García | CBF 150 S |
| 288 | 00278 | Estefana Perez | ACTIVA 2026 INYECTADA |
| 287 | 00277 | Pablo ramirez | XR 190L |
| 286 | 00276 | Keyly | XR 150L |
| 285 | 00275 | Carlos mendoza | CBF 150 S |
| Campo | Tipo | Nulo | Defecto |
|---|---|---|---|
| id | int(11) | NO | NULL |
| order_no | varchar(20) | NO | NULL |
| order_date | date | NO | NULL |
| fecha_registro | datetime | YES | current_timestamp() |
| customer_name | varchar(100) | NO | NULL |
| recibio | varchar(100) | YES | NULL |
| phone | varchar(20) | YES | NULL |
| nit | varchar(20) | YES | NULL |
| plate | varchar(20) | YES | NULL |
| motorcycle_model_id | int(11) | YES | NULL |
| service_type | enum('primer_servicio','servicio_menor','servicio_mayor','mano_obra','garantia') | NO | NULL |
| first_mechanic | varchar(50) | YES | NULL |
| oil_id | int(11) | YES | NULL |
| oil_qty | int(11) | YES | 0 |
| oil_charge | tinyint(1) | YES | 0 |
| labor_desc | text | YES | NULL |
| labor_amount | decimal(10,2) | YES | 0.00 |
| service_amount | decimal(10,2) | YES | 0.00 |
| oil_amount | decimal(10,2) | YES | 0.00 |
| total | decimal(10,2) | YES | 0.00 |
| discount | decimal(10,2) | YES | 0.00 |
| darwin_commission | decimal(10,2) | YES | 0.00 |
| luis_commission | decimal(10,2) | YES | 0.00 |
| status | enum('reservado','recibido','en_diagnostico','en_reparacion','en_proceso','reparado','lista_entrega','entregado') | NO | reservado |
| notes | text | YES | NULL |
| avance | text | YES | NULL |
| created_at | timestamp | NO | current_timestamp() |
| updated_at | timestamp | NO | current_timestamp() |
| fecha_reserva | date | YES | NULL |
| fecha_entrega | date | YES | NULL |
| color | varchar(80) | YES | NULL |
| chassis_last4 | varchar(4) | YES | NULL |
| condition_notes | text | YES | NULL |
| last_progress_at | datetime | YES | NULL |