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
project_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
547dd352-c3b9-4d38-a2d1-5a2d5ba37e82 - 547dd352-c3b9-4d38-a2d1-5a2d5ba37e82 547dd352-c3b9-4d38-a2d1-5a2d5ba37e82 - 547dd352-c3b9-4d38-a2d1-5a2d5ba37e82
parent_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
ticket_id
varchar(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
title
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
description
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
status
enum('todo', 'in_progress', 'review', 'done')
utf8mb4_general_ci
= != IS NULL IS NOT NULL
todo
in_progress
review
done
priority
enum('low', 'medium', 'high', 'urgent')
utf8mb4_general_ci
= != IS NULL IS NOT NULL
low
medium
high
urgent
start_date
date
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
due_date
date
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
estimated_hrs
decimal(6,2)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
actual_hrs
decimal(6,2)
= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
created_by
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
position
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
task_type
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
meeting_location
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
