Database And Model Reference

Prefer model classes and REST endpoints over direct writes. Direct SQL can bypass hooks, permission checks, derived ticket state, and notification queues.

Table	Purpose	Source
`alsp_action_user_role_change`	Awedesk table discovered in source.	classes/users/user.php:449
`alsp_agent_department`	Staff-to-department assignment map.	activation/model references
`alsp_app_push`	Mobile app push token storage.	activation/model references
`alsp_attachments`	Awedesk table discovered in source.	classes/pro/activation.php:210
`alsp_awecommerce_integrations`	Awedesk table discovered in source.	classes/pro/integrations/awecommerce/awecommerce-data.php:29
`alsp_chatbot_rules`	Chatbot rules and FAQ entries.	activation/model references
`alsp_config`	Awedesk table discovered in source.	classes/models/tickets.php:351
`alsp_csat_responses`	Customer satisfaction survey records.	activation/model references
`alsp_debug`	Awedesk table discovered in source.	classes/boot/dbdelta.php:14
`alsp_demo`	Demo-mode user/session records.	activation/model references
`alsp_demo_mode`	Awedesk table discovered in source.	classes/utilities/wp_activation.php:625
`alsp_departments`	Support departments.	activation/model references
`alsp_email_piping_spam_quarantine`	Awedesk table discovered in source.	classes/utilities/wp_activation.php:350
`alsp_ep_spam_quarantine`	Email-piping spam quarantine records.	activation/model references
`alsp_labels`	Ticket and client labels.	activation/model references
`alsp_labels_assignments`	Label assignment map.	activation/model references
`alsp_log`	AweCloud/devops log records.	activation/model references
`alsp_mail_queue`	Queued notification emails.	activation/model references
`alsp_mayfly`	Temporary storage.	activation/model references
`alsp_model_csat_response`	Awedesk table discovered in source.	classes/utilities/wp_activation.php:310
`alsp_multi_inbox`	Email-piping inbox and forwarder settings.	activation/model references
`alsp_notifications`	Awedesk table discovered in source.	classes/utilities/wp_activation.php:621
`alsp_predefined_replies`	Saved replies for staff.	activation/model references
`alsp_recent_tickets`	Recently viewed ticket records.	activation/model references
`alsp_staff_notes`	Private staff notes.	activation/model references
`alsp_ticket_attachments`	Pro attachment metadata.	activation/model references
`alsp_ticket_messages`	Ticket messages and timeline entries.	activation/model references
`alsp_ticket_preferences`	Per-ticket/user preferences and locks.	activation/model references
`alsp_ticket_watchers`	Pro ticket watcher assignments.	activation/model references
`alsp_tickets`	Core ticket records: subject, author, client, agent, status, department, timestamps, private-note state, spam and attention flags.	activation/model references
`alsp_user_preferences`	Per-user frontend preferences.	activation/model references
`alsp_user_profile_fields`	Awedesk table discovered in source.	classes/users/admin.php:103
`alsp_users`	Awedesk role/profile mapping for WordPress users.	activation/model references
`alsp_utility_wp`	Awedesk table discovered in source.	classes/boot/dbdelta.php:30
`alsp_wipe`	Awedesk table discovered in source.	classes/utilities/wp_activation.php:351

Discovered model classes:

Class	Table if detected	Source
`ALSP_Model_Agent`	`alsp_users`	classes/models/agent.php
`ALSP_Model_Agent_Department`	`alsp_agent_department`	classes/models/agent_department.php
`ALSP_Model_Agents`	–	classes/models/agents.php
`ALSP_Model_CSAT_Eligibility`	–	classes/models/csat_eligibility.php
`ALSP_Model_CSAT_Hooks`	–	classes/models/csat_hooks.php
`ALSP_Model_CSAT_Response`	`alsp_csat_responses`	classes/models/csat_response.php
`ALSP_Model_CSAT_Token`	–	classes/models/csat_token.php
`ALSP_Model_Dashboard_Agent_Stats`	–	classes/models/dashboard_agent_stats.php
`ALSP_Model_Dashboard_Stats`	–	classes/models/dashboard_stats.php
`ALSP_Model_Department`	`alsp_departments`	classes/models/department.php
`ALSP_Model_Departments`	–	classes/models/departments.php
`ALSP_Model_Email_Piping_Forwarder`	`alsp_multi_inbox`	classes/models/email_piping_forwarder.php
`ALSP_Model_Email_Piping_Forwarders`	–	classes/models/email_piping_forwarders.php
`ALSP_Model_Label`	`alsp_labels`	classes/models/label.php
`ALSP_Model_Labels`	–	classes/models/labels.php
`ALSP_Model_Labels_Assignments`	–	classes/models/labels_assignments.php
`ALSP_Model_List`	–	classes/models/abstract_listing.php
`ALSP_Model_Predefined_Replies`	–	classes/models/predefined_replies.php
`ALSP_Model_Predefined_Reply`	`alsp_predefined_replies`	classes/models/predefined_reply.php
`ALSP_Model_Single`	–	classes/models/abstract_single.php
`ALSP_Model_Ticket`	`alsp_tickets`	classes/models/ticket.php
`ALSP_Model_Ticket_Attachment`	`alsp_ticket_attachments`	classes/pro/attachments/model/ticket_attachment.php
`ALSP_Model_Ticket_Attachments`	–	classes/pro/attachments/model/ticket_attachments.php
`ALSP_Model_Ticket_Lock`	–	classes/models/ticket_lock.php
`ALSP_Model_Ticket_Message`	`alsp_ticket_messages`	classes/models/ticket_message.php
`ALSP_Model_Ticket_Messages`	–	classes/models/ticket_messages.php
`ALSP_Model_Ticket_Status`	–	classes/models/ticket_status.php
`ALSP_Model_Ticket_Watcher`	`alsp_ticket_watchers`	classes/pro/watchers/model/ticket_watcher.php
`ALSP_Model_Tickets`	–	classes/models/tickets.php
`ALSP_Model_Tickets_Bulk`	–	classes/models/tickets_bulk.php
`ALSP_Signature`	–	classes/models/signature.php
`ALSP_Value_Validation`	–	classes/models/sanitize_validate.php
`class`	–	classes/models/staff_notes.php

$ticket = new ALSP_Model_Ticket($ticket_id);
$item = $ticket->get_item();

if (!$item) {
    return;
}