* id company_id actor_username ticket_id order_id event_type description metadata_json created_at

* id company_id name active trigger_json conditions_json actions_json

* id name slug timezone shopify_domain shopify_api_key shopify_api_token send_from_email created_at

* id company_id entity_type key_name label field_type options_json required

* id field_id ticket_id order_id val_text val_number val_bool val_date val_datetime val_enum

* id code name

* id company_id name description actions_json

* id ticket_id direction message_type author_name author_email body_text body_html language_code is_private created_at

* id message_id filename mime_type size_bytes storage_url

* id message_id source_lang target_lang translated_text engine created_at

* id company_id shopify_order_id admin_graphql_api_id name order_number source_name shopify_customer_id email phone financial_status fulfillment_status confirmed cancelled_at cancel_reason closed_at created_at_utc processed_at_utc updated_at_utc currency subtotal_price total_price total_discounts total_tax total_weight presentment_currency current_total_price current_total_tax ship_name ship_company ship_phone ship_address1 ship_address2 ship_city ship_province ship_zip ship_country ship_country_code est_delivery_start est_delivery_end latest_tracking_number latest_carrier delivered_at gateway tags_raw note

* id company_id code name sort_order

* id company_id name color

* id company_id name language_code subject_tpl body_tpl

* id company_id subject customer_name customer_email order_number status priority ai_category ai_overview order_id priority_id owner_username assigned_agent language_code inbox_category_id source last_update_preview created_at updated_at closed_at

* id company_id subject customer_name customer_email order_number status priority assigned_agent ai_category ai_overview created_at updated_at

* id ticket_id direction message_type author_name author_email body_text body_html language_code is_private created_at

* id company_id code name is_closed sort_order

* ticket_id tag_id

* ticket_id username last_read_at pinned muted

* id company_id owner_username name filters_json sort_json is_shared

select table activity_log automations companies custom_field_defs custom_field_values inbox_categories macros messages_import message_attachments message_translations orders priorities tags templates tickets tickets_import ticket_messages ticket_statuses ticket_tags ticket_user_state views . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table activity_log automations companies custom_field_defs custom_field_values inbox_categories macros messages_import message_attachments message_translations orders priorities tags templates tickets tickets_import ticket_messages ticket_statuses ticket_tags ticket_user_state views .	select column