Debug Event Booking Data
Latest Event: FACING INFINITY (ID: 4630)
Showtimes (0 found):
No showtimes found.
Event Booking Page:
Page exists with ID: 2569
Template: page-event-booking.php
URL: https://lenngan.com/event-booking/
Database Tables:
wp_event_order_seats
| Field | Type | Null | Key | Default |
|---|
| id | int(11) | NO | PRI | |
| order_id | int(11) | NO | MUL | |
| seat_id | int(11) | NO | MUL | |
| price | bigint(20) | NO | | |
| created_at | datetime | NO | | current_timestamp() |
wp_event_orders
| Field | Type | Null | Key | Default |
|---|
| id | int(11) | NO | PRI | |
| order_code | varchar(50) | YES | UNI | |
| event_id | int(11) | YES | MUL | |
| showtime_id | int(11) | YES | MUL | |
| user_id | int(11) | YES | MUL | |
| customer_name | varchar(255) | YES | | |
| customer_email | varchar(255) | YES | | |
| customer_phone | varchar(20) | YES | | |
| total_amount | bigint(20) | NO | | 0 |
| status | varchar(20) | NO | MUL | pending |
| notes | text | YES | | |
| voucher_id | int(11) | YES | | |
| voucher_type | varchar(10) | YES | | |
| voucher_value | int(11) | YES | | |
| created_at | datetime | NO | | current_timestamp() |
| updated_at | datetime | NO | | current_timestamp() |
wp_event_payments
| Field | Type | Null | Key | Default |
|---|
| id | int(11) | NO | PRI | |
| order_id | int(11) | NO | MUL | |
| provider | varchar(50) | NO | | |
| transaction_id | varchar(255) | NO | MUL | |
| amount | bigint(20) | NO | | |
| status | varchar(20) | NO | MUL | |
| raw_response | longtext | YES | | |
| created_at | datetime | NO | | current_timestamp() |
wp_event_rooms
| Field | Type | Null | Key | Default |
|---|
| id | int(11) | NO | PRI | |
| name | varchar(255) | NO | | |
| schema_json | longtext | NO | | |
| status | tinyint(1) | NO | | 1 |
| created_at | datetime | NO | | current_timestamp() |
| updated_at | datetime | NO | | current_timestamp() |
| description | text | YES | | |
wp_event_seat_locks
| Field | Type | Null | Key | Default |
|---|
| seat_id | int(11) | NO | PRI | |
| room_id | int(11) | YES | | |
| showtime_id | int(11) | NO | PRI | |
| device_id | varchar(255) | NO | MUL | |
| expired_at | datetime | NO | MUL | |
| created_at | datetime | NO | | current_timestamp() |
wp_event_seat_types
| Field | Type | Null | Key | Default |
|---|
| id | int(11) | NO | PRI | |
| code | varchar(50) | NO | UNI | |
| name | varchar(255) | NO | | |
| color | varchar(7) | NO | | #000000 |
| icon | varchar(255) | YES | | |
| base_price | bigint(20) | NO | | 0 |
| description | varchar(500) | YES | | |
| status | tinyint(1) | NO | | 1 |
| created_at | datetime | NO | | current_timestamp() |
| updated_at | datetime | NO | | current_timestamp() |
wp_event_seats
| Field | Type | Null | Key | Default |
|---|
| id | int(11) | NO | PRI | |
| room_id | int(11) | NO | MUL | |
| seat_code | varchar(20) | NO | | |
| floor | int(11) | NO | | 1 |
| block | varchar(10) | NO | | |
| row_label | varchar(5) | NO | | |
| col_number | int(11) | NO | | |
| seat_type_id | int(11) | NO | MUL | |
| created_at | datetime | NO | | current_timestamp() |
| updated_at | datetime | NO | | current_timestamp() |
wp_event_showtime_pricing
| Field | Type | Null | Key | Default |
|---|
| id | int(11) | NO | PRI | |
| showtime_id | int(11) | NO | MUL | |
| seat_type_id | int(11) | NO | MUL | |
| price | bigint(20) | NO | | 0 |
| created_at | datetime | NO | | current_timestamp() |
| updated_at | datetime | NO | | current_timestamp() |
wp_event_showtimes
| Field | Type | Null | Key | Default |
|---|
| id | int(11) | NO | PRI | |
| event_id | int(11) | NO | MUL | |
| room_id | int(11) | NO | MUL | |
| start_time | datetime | NO | MUL | |
| end_time | datetime | NO | | |
| status | tinyint(1) | NO | | 1 |
| created_at | datetime | NO | | current_timestamp() |
| updated_at | datetime | NO | | current_timestamp() |
wp_event_vouchers
| Field | Type | Null | Key | Default |
|---|
| id | int(11) | NO | PRI | |
| code | varchar(50) | NO | UNI | |
| type | varchar(20) | NO | | percent |
| value | bigint(20) | NO | | |
| event_id | int(11) | YES | MUL | |
| start_time | datetime | NO | MUL | |
| end_time | datetime | NO | | |
| usage_limit | int(11) | NO | | 0 |
| used_count | int(11) | NO | | 0 |
| status | tinyint(1) | NO | MUL | 1 |
| created_at | datetime | NO | | current_timestamp() |
| updated_at | datetime | NO | | current_timestamp() |
