| id |
int(11)
|
|
|
|
| invoice_no |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| invoice_date |
datetime
|
|
|
|
| registration_no |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| room_id |
int(11)
|
|
|
 Browse foreign values
|
| customer_id |
int(11)
|
|
|
|
| booking_type |
enum('hotel', 'meeting')
|
utf8mb4_unicode_ci
|
|
|
| check_in_date |
date
|
|
|
|
| check_out_date |
date
|
|
|
|
| actual_checkout_date |
date
|
|
|
|
| check_in_time |
time
|
|
|
|
| check_out_time |
time
|
|
|
|
| total_price |
decimal(10,2)
|
|
|
|
| deposit |
decimal(10,2)
|
|
|
|
| deposit_transfer |
decimal(10,2)
|
|
|
|
| status |
enum('pending', 'confirmed', 'checked_in', 'checked_out', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| payment_status |
enum('unpaid', 'paid')
|
utf8mb4_unicode_ci
|
|
|
| payment_method |
enum('cash', 'transfer', 'card')
|
utf8mb4_unicode_ci
|
|
|
| paid_at |
datetime
|
|
|
|
| paid_by |
int(11)
|
|
|
|
| discount_type |
enum('none', 'amount', 'percent')
|
utf8mb4_unicode_ci
|
|
|
| discount_value |
decimal(10,2)
|
|
|
|
| discount_note |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| slip_image |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
