| id | int(11) | NOT NULL AUTO_INCREMENT, | PK |
| owner_id | int(11) | NOT NULL, | |
| property_id | int(11) | NOT NULL, | |
| room_id | int(11) | NOT NULL, | |
| sub_room_id | int(11) | NOT NULL, | |
| rateplan_id | int(11) | NOT NULL, | |
| booking_date | date | NOT NULL, | |
| res_fetch_date | varchar(255) | COLLATE utf8_bin NOT NULL, | |
| extraBed | varchar(255) | COLLATE utf8_bin NOT NULL, | |
| breakfast | int(11) | NOT NULL, | |
| non_refundable | int(11) | NOT NULL, | |
| country | varchar(255) | COLLATE utf8_bin NOT NULL, | |
| city | varchar(30) | COLLATE utf8_bin NOT NULL, | |
| booking_userid | int(11) | NOT NULL, | |
| check_in | date | NOT NULL, | |
| check_out | date | NOT NULL, | |
| adults | int(11) | NOT NULL, | |
| children | varchar(400) | COLLATE utf8_bin NOT NULL, | |
| rooms | int(11) | NOT NULL, | |
| nights | int(11) | NOT NULL, | |
| extra_adults | int(11) | NOT NULL, | |
| extra_childs | int(11) | NOT NULL, | |
| room_rate | double(15,2) | NOT NULL, | |
| currency_code | varchar(10) | COLLATE utf8_bin NOT NULL, | |
| extra_adult_rate | double(15,2) | NOT NULL, | |
| extra_child_rate | double(15,2) | NOT NULL, | |
| taxes_service_fees | double(15,2) | NOT NULL, | |
| payment_tax | varchar(100) | COLLATE utf8_bin NOT NULL, | |
| adjustment | double(15,2) | NOT NULL, | |
| extras | double(15,2) | NOT NULL, | |
| extras_adjustment | double(15,2) | NOT NULL, | |
| booking_status | varchar(30) | COLLATE utf8_bin NOT NULL, | |
| total | double(20,2) | NOT NULL, | |
| amount_paid | double(20,2) | NOT NULL, | |
| balance_amount | double(15,2) | NOT NULL, | |
| due_date | date | NOT NULL, | |
| default_currency | varchar(10) | COLLATE utf8_bin NOT NULL, | |
| customer_prefered_currency | varchar(10) | COLLATE utf8_bin NOT NULL, | |
| prefered_currency | varchar(50) | COLLATE utf8_bin NOT NULL, | |
| amount_in_default_currency | double(15,2) | NOT NULL, | |
| payment | varchar(30) | COLLATE utf8_bin NOT NULL, | |
| date | date | NOT NULL, | |
| cancelled_date | date | NOT NULL, | |
| promotion_code | mediumtext | COLLATE utf8_bin NOT NULL, | |
| special_id | int(11) | NOT NULL, | |
| cancellation_policy | text | COLLATE utf8_bin NOT NULL, | |
| payment_type | varchar(200) | COLLATE utf8_bin NOT NULL, | |
| bank_details | varchar(400) | COLLATE utf8_bin NOT NULL, | |
| card_type | varchar(50) | COLLATE utf8_bin NOT NULL, | |
| credit_card_number | varchar(50) | COLLATE utf8_bin NOT NULL, | |
| card_expiry_month | int(11) | NOT NULL, | |
| card_expiry_year | int(11) | NOT NULL, | |
| cvv_code | varchar(10) | COLLATE utf8_bin NOT NULL, | |
| card_holder_name | varchar(100) | COLLATE utf8_bin NOT NULL, | |
| admin_ipay | enum('0','1') | COLLATE utf8_bin NOT NULL, | |
| arrival_date | date | NOT NULL, | |
| arrival_time | varchar(30) | COLLATE utf8_bin NOT NULL, | |
| arrival_by | varchar(50) | COLLATE utf8_bin NOT NULL, | |
| transportation_name | varchar(200) | COLLATE utf8_bin NOT NULL, | |
| transport_arrival_time | varchar(20) | COLLATE utf8_bin NOT NULL, | |
| request_comment | mediumtext | COLLATE utf8_bin NOT NULL, | |
| About_customerview | varchar(100) | COLLATE utf8_bin NOT NULL, | |
| news_letter_subscription | int(11) | NOT NULL, | |
| payment_success | int(11) | DEFAULT '0', | |
| booking_number | varchar(100) | COLLATE utf8_bin NOT NULL, | |
| business_number | varchar(15) | COLLATE utf8_bin NOT NULL, | |
| eta | varchar(50) | COLLATE utf8_bin NOT NULL, | |
| room_acces_code | varchar(100) | COLLATE utf8_bin NOT NULL, | |
| marketing_emails | int(11) | NOT NULL, | |
| modification_date | datetime | NOT NULL, | |
| guest_name | varchar(255) | COLLATE utf8_bin NOT NULL, | |
| guest_comment | mediumtext | COLLATE utf8_bin NOT NULL, | |
| address | mediumtext | COLLATE utf8_bin NOT NULL, | |
| email | varchar(90) | COLLATE utf8_bin NOT NULL, | |
| phone | varchar(60) | COLLATE utf8_bin NOT NULL, | |
| Smoking | varchar(255) | COLLATE utf8_bin NOT NULL, | |
| ota_name | varchar(60) | COLLATE utf8_bin NOT NULL, | |
| ota_room_id | varchar(200) | COLLATE utf8_bin NOT NULL, | |
| ota_room_name | varchar(200) | COLLATE utf8_bin NOT NULL, | |
| ota_response | longtext | COLLATE utf8_bin NOT NULL, | |
| check_in_old | varchar(12) | COLLATE utf8_bin NOT NULL, | |
| check_out_old | varchar(12) | COLLATE utf8_bin NOT NULL, | |
| bot_run_date | date | NOT NULL, | |
| update_Flag | int(11) | NOT NULL, | |
| resv_status | varchar(1) | COLLATE utf8_bin NOT NULL, | |
| booking_details | mediumtext | COLLATE utf8_bin NOT NULL, | |
| extra_info | text | COLLATE utf8_bin NOT NULL, | |
| group_time | datetime | NOT NULL, | |
| status | varchar(20) | COLLATE utf8_bin NOT NULL, | |
| timestamp | timestamp | NULL DEFAULT CURRENT_TIMESTAMP, | |
| expedia_conf_flg | int(11) | NOT NULL, | |
| ETP | varchar(30) | COLLATE utf8_bin NOT NULL, | |
| syspay_token | mediumtext | COLLATE utf8_bin NOT NULL, | |
| token | mediumtext | COLLATE utf8_bin NOT NULL, | |
| doku_paymentcode | varchar(200) | COLLATE utf8_bin NOT NULL, | |
| doku_merchantid | varchar(200) | COLLATE utf8_bin NOT NULL, | |
| fee_type | varchar(50) | COLLATE utf8_bin NOT NULL, | |
| fee | varchar(50) | COLLATE utf8_bin NOT NULL, | |
| notify_start | timestamp | NULL DEFAULT '0000-00-00 00:00:00', | |
| notify_end | timestamp | NULL DEFAULT '0000-00-00 00:00:00', | |
| notify_count | int(11) | DEFAULT '1', | |
| notify_count_api | int(11) | NOT NULL, | |
| notify_message | text | COLLATE utf8_bin NOT NULL | |
| room_AlertFlag | int(11) | NOT NULL, | |
| booking_modify | tinyint(4) | NOT NULL, | |
| not_confirm_status | int(11) | NOT NULL, | |
| stuck_count | int(11) | NOT NULL, | |
| powerpro_flag | tinyint(4) | DEFAULT '1', | |
| powerpro_referenceNumber | varchar(100) | COLLATE utf8_bin NOT NULL, | |
| pms_flag | int(11) | NOT NULL DEFAULT '1', | |
| tokenid | varchar(200) | COLLATE utf8_bin NOT NULL, | |
| booking_referenceNumber | varchar(200) | COLLATE utf8_bin NOT NULL, | |
| price_desc | varchar(500) | COLLATE utf8_bin NOT NULL, | |
| maintenance | int(11) | NOT NULL, | |
| private_comment | mediumtext | COLLATE utf8_bin NOT NULL, | |
| color | varchar(10) | COLLATE utf8_bin NOT NULL, | |
| check_status | int(11) | NOT NULL, | |
| manual_cancel | int(11) | NOT NULL, | |
| invoice_no | varchar(50) | COLLATE utf8_bin NOT NULL, | |
| no_show | int(11) | NOT NULL, | |
| invalid_cc | int(11) | NOT NULL, | |
| invoice_date | varchar(20) | COLLATE utf8_bin NOT NULL, | |
| extra_detail | longtext | COLLATE utf8_bin NOT NULL, | |
| direct_source | varchar(10) | COLLATE utf8_bin NOT NULL, | |
| created_by | varchar(100) | COLLATE utf8_bin NOT NULL, | |
| modified_by | mediumtext | COLLATE utf8_bin NOT NULL, | |
| res_source | varchar(200) | COLLATE utf8_bin NOT NULL, | |
| agency_id | int(11) | NOT NULL, | |
| pos_total | varchar(30) | COLLATE utf8_bin NOT NULL, | |
| old_room_id | varchar(12) | COLLATE utf8_bin NOT NULL, | |
| booking_group | varchar(10) | COLLATE utf8_bin NOT NULL, | |
| release_date | date | NOT NULL, | |
| created_at | timestamp | NULL DEFAULT CURRENT_TIMESTAMP, | |
| updated_at | timestamp | NULL DEFAULT CURRENT_TIMESTAMP, | |