| id |
bigint(20)
|
|
|
|
| order_number |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| user_id |
bigint(20)
|
|
|
|
| technician_id |
bigint(20)
|
|
|
|
| service_id |
bigint(20)
|
|
|
|
| address_id |
bigint(20)
|
|
|
|
| city_id |
bigint(20)
|
|
|
|
| status |
enum('pending', 'accepted', 'technician_on_way', 'inspecting', 'awaiting_price_approval', 'in_progress', 'completed', 'cancelled', 'rejected')
|
utf8mb4_unicode_ci
|
|
|
| description |
text
|
utf8mb4_unicode_ci
|
|
|
| proposed_price |
decimal(12,2)
|
|
|
|
| proposed_price_note |
text
|
utf8mb4_unicode_ci
|
|
|
| price_approved_at |
timestamp
|
|
|
|
| price_rejected_at |
timestamp
|
|
|
|
| final_price |
decimal(12,2)
|
|
|
|
| cancellation_reason |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| assigned_by |
bigint(20)
|
|
|
|
| assigned_at |
timestamp
|
|
|
|
| accepted_at |
timestamp
|
|
|
|
| inspecting_at |
timestamp
|
|
|
|
| completed_at |
timestamp
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|