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
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
display_name
varchar(200)
utf8mb4_general_ci
LIKE LIKE %...% NOT LIKE NOT LIKE %...% = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
imap_host
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
imap_port
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
imap_secure
tinyint(1)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
smtp_host
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
smtp_port
int(11)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
smtp_secure
tinyint(1)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
encrypted_pass
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
assigned_user_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
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
department_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
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
is_active
tinyint(1)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
last_sync_at
timestamp
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
last_synced_uid
int(11)
= > >= < <= != 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
updated_at
timestamp
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
auto_reply_enabled
tinyint(1)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
auto_reply_subject
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
auto_reply_body
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
auto_reply_only_once
tinyint(1)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
auto_reply_active_from
date
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
auto_reply_active_until
date
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
