id
char(36)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
account_id
char(36)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
0afdadf9-eb62-43c8-b9cd-ae3c031003d2 - 0afdadf9-eb62-43c8-b9cd-ae3c031003d2 0c6ced71-a50c-4aaf-a26b-a95e762fa611 - 0c6ced71-a50c-4aaf-a26b-a95e762fa611 04c194f5-2f0e-4e15-a761-73c5762af469 - 04c194f5-2f0e-4e15-a761-73c5762af469 511f8fcf-c7ff-43ab-b089-d73d3fad98d5 - 511f8fcf-c7ff-43ab-b089-d73d3fad98d5 a50c956a-a3f6-4860-801f-b2fbac793617 - a50c956a-a3f6-4860-801f-b2fbac793617 b6be1a87-c0c8-468e-a436-35a765f5dad0 - b6be1a87-c0c8-468e-a436-35a765f5dad0 c9838cac-4610-428d-b38d-c47557c19656 - c9838cac-4610-428d-b38d-c47557c19656 f33e3c20-6576-4bef-b3d9-0664e2d14215 - f33e3c20-6576-4bef-b3d9-0664e2d14215 0afdadf9-eb62-43c8-b9cd-ae3c031003d2 - 0afdadf9-eb62-43c8-b9cd-ae3c031003d2 0c6ced71-a50c-4aaf-a26b-a95e762fa611 - 0c6ced71-a50c-4aaf-a26b-a95e762fa611 04c194f5-2f0e-4e15-a761-73c5762af469 - 04c194f5-2f0e-4e15-a761-73c5762af469 511f8fcf-c7ff-43ab-b089-d73d3fad98d5 - 511f8fcf-c7ff-43ab-b089-d73d3fad98d5 a50c956a-a3f6-4860-801f-b2fbac793617 - a50c956a-a3f6-4860-801f-b2fbac793617 b6be1a87-c0c8-468e-a436-35a765f5dad0 - b6be1a87-c0c8-468e-a436-35a765f5dad0 c9838cac-4610-428d-b38d-c47557c19656 - c9838cac-4610-428d-b38d-c47557c19656 f33e3c20-6576-4bef-b3d9-0664e2d14215 - f33e3c20-6576-4bef-b3d9-0664e2d14215
imap_uid
int(10)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
message_id
varchar(500)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
thread_id
varchar(500)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
subject
varchar(1000)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
from_email
varchar(255)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
from_name
varchar(255)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
to_recipients
longtext
utf8mb4_bin
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
cc_recipients
longtext
utf8mb4_bin
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
body_html
mediumtext
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
body_text
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
is_read
tinyint(1)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
is_starred
tinyint(1)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
folder
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
assigned_to
char(36)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
0d5735e7-26de-466d-bf2f-83672388c26a - 0d5735e7-26de-466d-bf2f-83672388c26a 6d62007f-5903-438e-ab0a-e0f797f630e2 - 6d62007f-5903-438e-ab0a-e0f797f630e2 7be59cc1-9d8d-472a-9bea-aff79723b4cf - 7be59cc1-9d8d-472a-9bea-aff79723b4cf 7d94f5b1-79a8-497b-bc7c-828a31436117 - 7d94f5b1-79a8-497b-bc7c-828a31436117 57bfe763-aa1d-4188-9aad-8a13e1dc3761 - 57bfe763-aa1d-4188-9aad-8a13e1dc3761 106edf1f-c02c-4b1c-b291-385b24b02b4b - 106edf1f-c02c-4b1c-b291-385b24b02b4b 308cac96-187c-46b6-a5b5-f49fda8bd459 - 308cac96-187c-46b6-a5b5-f49fda8bd459 1806acc1-dd15-4191-b132-95dbf898cf40 - 1806acc1-dd15-4191-b132-95dbf898cf40 a0e53105-a717-40fc-92b9-dfbc41445b83 - a0e53105-a717-40fc-92b9-dfbc41445b83 b62d6cf8-cd16-41ee-b8c1-4ad1c8885428 - b62d6cf8-cd16-41ee-b8c1-4ad1c8885428 bf8d17eb-6dcf-42d9-9015-36b0a2c45b50 - bf8d17eb-6dcf-42d9-9015-36b0a2c45b50 c36650df-18a1-426c-9027-a44aba6002d0 - c36650df-18a1-426c-9027-a44aba6002d0 d0250431-5835-4dcc-9a36-c6c21bdc2a55 - d0250431-5835-4dcc-9a36-c6c21bdc2a55 dfcb102c-d22c-4b04-8e55-ca9d92f80f0b - dfcb102c-d22c-4b04-8e55-ca9d92f80f0b e03521b6-cd7f-465b-8a5d-c14639dae1e4 - e03521b6-cd7f-465b-8a5d-c14639dae1e4 f50ba731-f04a-4e65-8dec-b8775571d15f - f50ba731-f04a-4e65-8dec-b8775571d15f fe069ab5-8476-48ca-9a90-31c147d15266 - fe069ab5-8476-48ca-9a90-31c147d15266 0d5735e7-26de-466d-bf2f-83672388c26a - 0d5735e7-26de-466d-bf2f-83672388c26a 6d62007f-5903-438e-ab0a-e0f797f630e2 - 6d62007f-5903-438e-ab0a-e0f797f630e2 7be59cc1-9d8d-472a-9bea-aff79723b4cf - 7be59cc1-9d8d-472a-9bea-aff79723b4cf 7d94f5b1-79a8-497b-bc7c-828a31436117 - 7d94f5b1-79a8-497b-bc7c-828a31436117 57bfe763-aa1d-4188-9aad-8a13e1dc3761 - 57bfe763-aa1d-4188-9aad-8a13e1dc3761 106edf1f-c02c-4b1c-b291-385b24b02b4b - 106edf1f-c02c-4b1c-b291-385b24b02b4b 308cac96-187c-46b6-a5b5-f49fda8bd459 - 308cac96-187c-46b6-a5b5-f49fda8bd459 1806acc1-dd15-4191-b132-95dbf898cf40 - 1806acc1-dd15-4191-b132-95dbf898cf40 a0e53105-a717-40fc-92b9-dfbc41445b83 - a0e53105-a717-40fc-92b9-dfbc41445b83 b62d6cf8-cd16-41ee-b8c1-4ad1c8885428 - b62d6cf8-cd16-41ee-b8c1-4ad1c8885428 bf8d17eb-6dcf-42d9-9015-36b0a2c45b50 - bf8d17eb-6dcf-42d9-9015-36b0a2c45b50 c36650df-18a1-426c-9027-a44aba6002d0 - c36650df-18a1-426c-9027-a44aba6002d0 d0250431-5835-4dcc-9a36-c6c21bdc2a55 - d0250431-5835-4dcc-9a36-c6c21bdc2a55 dfcb102c-d22c-4b04-8e55-ca9d92f80f0b - dfcb102c-d22c-4b04-8e55-ca9d92f80f0b e03521b6-cd7f-465b-8a5d-c14639dae1e4 - e03521b6-cd7f-465b-8a5d-c14639dae1e4 f50ba731-f04a-4e65-8dec-b8775571d15f - f50ba731-f04a-4e65-8dec-b8775571d15f fe069ab5-8476-48ca-9a90-31c147d15266 - fe069ab5-8476-48ca-9a90-31c147d15266
assigned_dept
char(36)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
4be28211-0817-407d-a40f-56a4d4f13155 - 4be28211-0817-407d-a40f-56a4d4f13155 6f15cff8-628f-496f-a4ef-dddf4b2e776c - 6f15cff8-628f-496f-a4ef-dddf4b2e776c 7bc15389-852b-4868-8bfd-b86f07f6b075 - 7bc15389-852b-4868-8bfd-b86f07f6b075 73c476ab-a577-44e0-8490-7e18810554af - 73c476ab-a577-44e0-8490-7e18810554af 90f5dd3f-7ba3-40ce-b33f-24edfa9e9b05 - 90f5dd3f-7ba3-40ce-b33f-24edfa9e9b05 49001039-15df-48c3-ac4a-4e40c90ce801 - 49001039-15df-48c3-ac4a-4e40c90ce801 be14d7db-94ef-4f6e-b514-f959ac0819b4 - be14d7db-94ef-4f6e-b514-f959ac0819b4 cfa3f9e9-b0e1-4a37-ba29-389183886f67 - cfa3f9e9-b0e1-4a37-ba29-389183886f67 e118dfb0-3e71-4948-88b5-742305535978 - e118dfb0-3e71-4948-88b5-742305535978 f87e6e0c-57de-477b-908e-1538156afd61 - f87e6e0c-57de-477b-908e-1538156afd61 f9345225-230f-42db-8e99-65778bf6bb05 - f9345225-230f-42db-8e99-65778bf6bb05 4be28211-0817-407d-a40f-56a4d4f13155 - 4be28211-0817-407d-a40f-56a4d4f13155 6f15cff8-628f-496f-a4ef-dddf4b2e776c - 6f15cff8-628f-496f-a4ef-dddf4b2e776c 7bc15389-852b-4868-8bfd-b86f07f6b075 - 7bc15389-852b-4868-8bfd-b86f07f6b075 73c476ab-a577-44e0-8490-7e18810554af - 73c476ab-a577-44e0-8490-7e18810554af 90f5dd3f-7ba3-40ce-b33f-24edfa9e9b05 - 90f5dd3f-7ba3-40ce-b33f-24edfa9e9b05 49001039-15df-48c3-ac4a-4e40c90ce801 - 49001039-15df-48c3-ac4a-4e40c90ce801 be14d7db-94ef-4f6e-b514-f959ac0819b4 - be14d7db-94ef-4f6e-b514-f959ac0819b4 cfa3f9e9-b0e1-4a37-ba29-389183886f67 - cfa3f9e9-b0e1-4a37-ba29-389183886f67 e118dfb0-3e71-4948-88b5-742305535978 - e118dfb0-3e71-4948-88b5-742305535978 f87e6e0c-57de-477b-908e-1538156afd61 - f87e6e0c-57de-477b-908e-1538156afd61 f9345225-230f-42db-8e99-65778bf6bb05 - f9345225-230f-42db-8e99-65778bf6bb05
task_id
char(36)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
3f294eea-a17f-44f6-917d-299e54ed68fe - 3f294eea-a17f-44f6-917d-299e54ed68fe 715db18a-3428-4dd3-8fc3-52caaa9cafa7 - 715db18a-3428-4dd3-8fc3-52caaa9cafa7 a4b209fe-efd8-4796-ae1f-f10c01e66c66 - a4b209fe-efd8-4796-ae1f-f10c01e66c66 e97a2716-6255-425b-84ba-f7c4a112dc87 - e97a2716-6255-425b-84ba-f7c4a112dc87 3f294eea-a17f-44f6-917d-299e54ed68fe - 3f294eea-a17f-44f6-917d-299e54ed68fe 715db18a-3428-4dd3-8fc3-52caaa9cafa7 - 715db18a-3428-4dd3-8fc3-52caaa9cafa7 a4b209fe-efd8-4796-ae1f-f10c01e66c66 - a4b209fe-efd8-4796-ae1f-f10c01e66c66 e97a2716-6255-425b-84ba-f7c4a112dc87 - e97a2716-6255-425b-84ba-f7c4a112dc87
approval_id
char(36)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
received_at
timestamp
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% 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
