id
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
table_id
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
1 - 1 2 - 2 3 - 3 4 - 4 5 - 5 6 - 6 7 - 7 8 - 8 9 - 9 10 - 10 11 - 11 12 - 12 13 - 13 14 - 14 15 - 15 16 - 16 17 - 17 18 - 18 19 - 19 20 - 20 21 - 21 22 - 22 23 - 23 24 - 24 25 - 25 26 - 26 27 - 27 28 - 28 29 - 29 30 - 30 31 - 31 32 - 32 33 - 33 34 - 34 1 - 1 2 - 2 3 - 3 4 - 4 5 - 5 6 - 6 7 - 7 8 - 8 9 - 9 10 - 10 11 - 11 12 - 12 13 - 13 14 - 14 15 - 15 16 - 16 17 - 17 18 - 18 19 - 19 20 - 20 21 - 21 22 - 22 23 - 23 24 - 24 25 - 25 26 - 26 27 - 27 28 - 28 29 - 29 30 - 30 31 - 31 32 - 32 33 - 33 34 - 34
user_id
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
admin - 1 camila - 7 Dairo1 - 10 daladier123 - 9 danna - 5 Juan - 11 Juan123 - 13 Juanmanuel - 15 Juanmuñoz3333 - 18 Luisa 07 - 17 Made123 - 12 marinela - 6 Miguel galarcio - 16 propietario - 2 valentina - 8 yenifer - 3 Yor201617 - 19 yorlenis - 4 1 - admin 2 - propietario 3 - yenifer 4 - yorlenis 5 - danna 6 - marinela 7 - camila 8 - valentina 9 - daladier123 10 - Dairo1 11 - Juan 12 - Made123 13 - Juan123 15 - Juanmanuel 16 - Miguel galarcio 17 - Luisa 07 18 - Juanmuñoz3333 19 - Yor201617
client_id
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
total
decimal(10,2)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
status
enum('pending', 'preparing', 'ready', 'paid', 'cancelled')
utf8mb4_general_ci
= != IS NULL IS NOT NULL
pending
preparing
ready
paid
cancelled
payment_method
varchar(30)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
payment_detail
text
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
amount_paid
decimal(10,2)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
change_amount
decimal(10,2)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
order_type
enum('local', 'takeout', 'delivery')
utf8mb4_general_ci
= != IS NULL IS NOT NULL
local
takeout
delivery
delivery_fee
decimal(10,2)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
client_name
varchar(100)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
client_phone
varchar(20)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
client_address
text
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
created_at
timestamp
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
updated_at
timestamp
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
cash_session_id
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
closed - 50 closed - 63 closed - 64 closed - 65 closed - 66 closed - 67 closed - 68 closed - 69 closed - 70 closed - 71 closed - 72 closed - 62 closed - 61 closed - 51 closed - 52 closed - 53 closed - 54 closed - 55 closed - 56 closed - 57 closed - 58 closed - 59 closed - 60 closed - 73 closed - 74 closed - 75 closed - 88 closed - 89 closed - 90 closed - 91 closed - 92 closed - 93 closed - 94 closed - 95 closed - 96 closed - 97 closed - 87 closed - 86 closed - 76 closed - 77 closed - 78 closed - 79 closed - 80 closed - 81 closed - 82 closed - 83 closed - 84 closed - 85 closed - 98 closed - 1 closed - 14 closed - 15 closed - 16 closed - 17 closed - 18 closed - 19 closed - 20 closed - 21 closed - 22 closed - 23 closed - 13 closed - 12 closed - 2 closed - 3 closed - 4 closed - 5 closed - 6 closed - 7 closed - 8 closed - 9 closed - 10 closed - 11 closed - 24 closed - 25 closed - 26 closed - 39 closed - 40 closed - 41 closed - 42 closed - 43 closed - 44 closed - 45 closed - 46 closed - 47 closed - 48 closed - 38 closed - 37 closed - 27 closed - 28 closed - 29 closed - 30 closed - 31 closed - 32 closed - 33 closed - 34 closed - 35 closed - 36 closed - 49 1 - closed 2 - closed 3 - closed 4 - closed 5 - closed 6 - closed 7 - closed 8 - closed 9 - closed 10 - closed 11 - closed 12 - closed 13 - closed 14 - closed 15 - closed 16 - closed 17 - closed 18 - closed 19 - closed 20 - closed 21 - closed 22 - closed 23 - closed 24 - closed 25 - closed 26 - closed 27 - closed 28 - closed 29 - closed 30 - closed 31 - closed 32 - closed 33 - closed 34 - closed 35 - closed 36 - closed 37 - closed 38 - closed 39 - closed 40 - closed 41 - closed 42 - closed 43 - closed 44 - closed 45 - closed 46 - closed 47 - closed 48 - closed 49 - closed 50 - closed 51 - closed 52 - closed 53 - closed 54 - closed 55 - closed 56 - closed 57 - closed 58 - closed 59 - closed 60 - closed 61 - closed 62 - closed 63 - closed 64 - closed 65 - closed 66 - closed 67 - closed 68 - closed 69 - closed 70 - closed 71 - closed 72 - closed 73 - closed 74 - closed 75 - closed 76 - closed 77 - closed 78 - closed 79 - closed 80 - closed 81 - closed 82 - closed 83 - closed 84 - closed 85 - closed 86 - closed 87 - closed 88 - closed 89 - closed 90 - closed 91 - closed 92 - closed 93 - closed 94 - closed 95 - closed 96 - closed 97 - closed 98 - closed
external_id
varchar(50)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
is_hotel
tinyint(1)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
deduct_delivery
tinyint(1)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tip_amount
decimal(10,2)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
tip_percentage
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
client_email
varchar(100)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
driver_name
varchar(100)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
