| id |
int(10)
|
|
|
|
| date_issue |
date
|
|
|
|
| flight_date |
date
|
|
|
|
| trip_type |
enum('One Way', 'Round Trip')
|
utf8mb4_unicode_ci
|
|
|
| return_date |
date
|
|
|
|
| customer_dept |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| portal |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| airline |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| warrant_no |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| pnr |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| flight_class |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| pax |
tinyint(3)
|
|
|
|
| wpua_amt |
decimal(12,2)
|
|
|
|
| infant_amt |
decimal(12,2)
|
|
|
|
| tax_amt |
decimal(12,2)
|
|
|
|
| sst_amt |
decimal(12,2)
|
|
|
|
| fare_amt |
decimal(12,2)
|
|
|
|
| service_charge |
decimal(12,2)
|
|
|
|
| status |
enum('Flown', 'In Progress', 'Extend', 'Refund', 'Cancel Waran', 'Cancel', 'Void')
|
utf8mb4_unicode_ci
|
|
|
| assigned_to |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(10)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
