Bookings Table Structure:
| Field | Type | Null | Key | Default | Extra |
|---|
| id | int | NO | PRI | | auto_increment |
| user_id | int | YES | MUL | | |
| equipment_id | int | YES | MUL | | |
| quantity | int | YES | | | |
| rental_days | int | YES | | | |
| total_amount | decimal(10,2) | YES | | | |
| booking_date | timestamp | NO | | CURRENT_TIMESTAMP | DEFAULT_GENERATED |
| event_id | int | YES | | | |
| status | enum('pending','accepted','rejected') | YES | | pending | |
| start_date | date | YES | | | |
| end_date | date | YES | | | |
| time_slot | varchar(50) | YES | | | |
| customer_name | varchar(100) | YES | | | |
| customer_phone | varchar(20) | YES | | | |
| delivery_address | text | YES | | | |
Recent 5 Bookings:
Array
(
[id] => 1
[user_id] => 1
[equipment_id] => 1
[quantity] => 1
[rental_days] => 2
[total_amount] => 2000.00
[booking_date] => 2026-10-05 06:23:19
[event_id] =>
[status] => pending
[start_date] => 2026-01-16
[end_date] => 2026-01-18
[time_slot] => Full Day
[customer_name] => Test User
[customer_phone] => 9876543210
[delivery_address] => Test Address
)