MariaDB Database Live Viewer (Read-only)

id (varchar(50)) order_number (varchar(50)) branch_id (varchar(50)) order_type (enum('dine_in','takeaway','delivery')) table_number (varchar(20)) subtotal (decimal(10,2)) discount_amount (decimal(10,2)) coupon_code (varchar(50)) delivery_fee (decimal(10,2)) rider_fee (decimal(10,2)) total_amount (decimal(10,2)) payment_method (enum('qr_promptpay','bank_transfer','cash')) payment_status (enum('pending','slip_uploaded','verified_paid','rejected','cod_pending')) order_status (enum('pending','confirmed','kitchen_cooking','ready_for_pickup','out_for_delivery','delivered','cancelled')) slip_image_url (text) customer_name (varchar(150)) customer_phone (varchar(50)) delivery_address (text) latitude (decimal(10,7)) longitude (decimal(10,7)) delivery_landmark (text) distance_km (decimal(5,2)) rider_name (varchar(100)) created_at (datetime)