1795506124
a:52:{s:2:"id";a:5:{s:4:"type";s:7:"integer";s:4:"null";b:0;s:7:"default";N;s:6:"length";N;s:3:"key";s:7:"primary";}s:8:"sys_code";a:6:{s:4:"type";s:6:"string";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:50;s:7:"collate";s:18:"utf8mb3_unicode_ci";s:7:"charset";s:7:"utf8mb3";}s:8:"track_id";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:10:"company_id";a:5:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;s:3:"key";s:5:"index";}s:9:"branch_id";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:11:"customer_id";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:19:"customer_contact_id";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:7:"room_id";a:5:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;s:3:"key";s:5:"index";}s:7:"card_id";a:5:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;s:3:"key";s:5:"index";}s:12:"quotation_id";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:16:"quotation_number";a:7:{s:4:"type";s:6:"string";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:50;s:3:"key";s:5:"index";s:7:"collate";s:18:"utf8mb3_unicode_ci";s:7:"charset";s:7:"utf8mb3";}s:10:"order_code";a:6:{s:4:"type";s:6:"string";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:50;s:7:"collate";s:18:"utf8mb3_unicode_ci";s:7:"charset";s:7:"utf8mb3";}s:10:"order_date";a:4:{s:4:"type";s:4:"date";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:18:"currency_center_id";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:8:"discount";a:4:{s:4:"type";s:5:"float";s:4:"null";b:1;s:7:"default";N;s:6:"length";s:4:"15,3";}s:16:"discount_percent";a:4:{s:4:"type";s:5:"float";s:4:"null";b:1;s:7:"default";N;s:6:"length";s:3:"6,3";}s:9:"total_vat";a:4:{s:4:"type";s:5:"float";s:4:"null";b:1;s:7:"default";N;s:6:"length";s:4:"15,3";}s:11:"vat_percent";a:4:{s:4:"type";s:5:"float";s:4:"null";b:1;s:7:"default";N;s:6:"length";s:3:"5,3";}s:14:"vat_setting_id";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:13:"vat_calculate";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:12:"total_amount";a:4:{s:4:"type";s:5:"float";s:4:"null";b:1;s:7:"default";N;s:6:"length";s:4:"15,3";}s:13:"total_deposit";a:4:{s:4:"type";s:5:"float";s:4:"null";b:1;s:7:"default";N;s:6:"length";s:4:"15,3";}s:16:"total_deposit_by";a:6:{s:4:"type";s:6:"string";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:255;s:7:"collate";s:18:"utf8mb3_unicode_ci";s:7:"charset";s:7:"utf8mb3";}s:20:"customer_credit_card";a:6:{s:4:"type";s:6:"string";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:255;s:7:"collate";s:18:"utf8mb3_unicode_ci";s:7:"charset";s:7:"utf8mb3";}s:13:"price_type_id";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:4:"note";a:6:{s:4:"type";s:4:"text";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;s:7:"collate";s:18:"utf8mb3_unicode_ci";s:7:"charset";s:7:"utf8mb3";}s:9:"full_name";a:6:{s:4:"type";s:4:"text";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;s:7:"collate";s:18:"utf8mb3_unicode_ci";s:7:"charset";s:7:"utf8mb3";}s:12:"phone_number";a:6:{s:4:"type";s:4:"text";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;s:7:"collate";s:18:"utf8mb3_unicode_ci";s:7:"charset";s:7:"utf8mb3";}s:7:"id_card";a:6:{s:4:"type";s:4:"text";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;s:7:"collate";s:18:"utf8mb3_unicode_ci";s:7:"charset";s:7:"utf8mb3";}s:7:"created";a:4:{s:4:"type";s:8:"datetime";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:10:"created_by";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:6:"edited";a:4:{s:4:"type";s:8:"datetime";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:9:"edited_by";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:8:"modified";a:4:{s:4:"type";s:8:"datetime";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:11:"modified_by";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:8:"approved";a:4:{s:4:"type";s:8:"datetime";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:11:"approved_by";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:4:"long";a:6:{s:4:"type";s:6:"string";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:50;s:7:"collate";s:18:"utf8mb3_unicode_ci";s:7:"charset";s:7:"utf8mb3";}s:3:"lat";a:6:{s:4:"type";s:6:"string";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:50;s:7:"collate";s:18:"utf8mb3_unicode_ci";s:7:"charset";s:7:"utf8mb3";}s:8:"is_close";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";s:1:"0";s:6:"length";N;}s:10:"is_approve";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";s:1:"0";s:6:"length";N;}s:16:"is_apply_monthly";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";s:1:"0";s:6:"length";N;}s:10:"is_pending";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";s:1:"0";s:6:"length";N;}s:11:"is_document";a:5:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";s:1:"0";s:6:"length";N;s:7:"comment";s:23:"1: Passport; 2: ID Card";}s:6:"status";a:5:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";s:1:"1";s:6:"length";N;s:7:"comment";s:34:"-3: Delete; 3: checkIn; 5:CheckOut";}s:8:"is_clean";a:5:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";s:1:"0";s:6:"length";N;s:7:"comment";s:20:"0:check in; 1: clean";}s:14:"is_reservation";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";s:1:"0";s:6:"length";N;}s:14:"reservation_id";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:16:"invoice_split_id";a:4:{s:4:"type";s:7:"integer";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:18:"number_of_customer";a:4:{s:4:"type";s:5:"float";s:4:"null";b:1;s:7:"default";N;s:6:"length";N;}s:9:"card_code";a:6:{s:4:"type";s:6:"string";s:4:"null";b:1;s:7:"default";N;s:6:"length";i:50;s:7:"collate";s:18:"utf8mb3_unicode_ci";s:7:"charset";s:7:"utf8mb3";}s:22:"price_booking_facility";a:4:{s:4:"type";s:5:"float";s:4:"null";b:0;s:7:"default";N;s:6:"length";s:4:"15,3";}}