Verify Letter Manager database readiness | Pixie CRM Help Centre Canonical: https://pixiecrm.com/help-centre/verify-letter-manager-database-tables-and-columns Publisher: Pixie Technologies LLC Setup, version, access and architecture Verify Letter Manager database readiness Pixie CRM guidance. Follow the route for your workspace, check your role and enabled modules, and verify the result before moving on. Confirm the history, templates and email-open records required by current features are present. Audience: Administrators and developers; Permission: Authorised database administrator; Module v1.0.0; Where to goServer/database diagnostics → CRM database → Letter Manager tables Before you start - Use an authorised account and confirm the customer, external recipient, template, letter or configuration is the intended one. - Follow the exact route shown above and verify the stored record, generated file and delivery evidence instead of relying on an alert alone. What this guide helps you do Confirm the history, templates and email-open records required by current features are present. These instructions follow the inspected module’s live hook, route, controller, model, installer, PDF helper and view flow. Follow these steps - Verify the prefixed letter_manager_history table exists. - Verify the prefixed letter_manager_templates table exists. - Verify the prefixed letter_manager_email_opens table exists when read tracking is used. - Check the history table contains delivery, signature, verification, enclosure and read-receipt columns. - Return to the UI and test create, verify, sign and email-open flows. Fields and options History tableLetter content, recipient, reference, public tokens, email, postal, signature, enclosure and audit metadata. Templates tableInternal template name, subject and HTML content. Email opens tableOne row per detected tracking-pixel request with letter, token, time, IP, user agent and referer. Rules and limits - Do not rename module-owned tables or columns. - Runtime guards can add selected missing columns, but production changes must still be controlled and backed by a tested rollback. Check it worked - The requested letter, template, setting, file or tracking detail is created or updated through the supported route. - The history row, generated PDF, email/send metadata, public verification, signature evidence, client view or postal display agrees with the action. - Any warning, missing file or failed send is investigated rather than bypassed. Security, privacy and operational checks - Apply least privilege and verify recipient identity before sending or exposing public links. - Protect PDFs, enclosures, signatures, verification URLs, email-open metadata, IP addresses and customer data under organisational policy. - Test configuration and deployment changes with controlled records before production-wide use. - Interpret email opens and e-signatures according to their documented technical limitations. Related guides Letter Manager module overview (https://pixiecrm.com/help-centre/letter-manager-module-overview)Install and activate Letter Manager v1.0.0 (https://pixiecrm.com/help-centre/install-and-activate-letter-manager)Run the Letter Manager schema-version upgrade (https://pixiecrm.com/help-centre/run-the-letter-manager-schema-version-upgrade)Prepare Letter Manager upload storage (https://pixiecrm.com/help-centre/prepare-letter-manager-upload-storage)Open the Letter Manager dashboard (https://pixiecrm.com/help-centre/open-the-letter-manager-dashboard)Open Letter Manager Templates (https://pixiecrm.com/help-centre/open-letter-manager-templates)Configure SMTP email delivery (https://pixiecrm.com/help-centre/configure-smtp-email-delivery)Add and manage customer contacts (https://pixiecrm.com/help-centre/add-and-manage-customer-contacts)Client portal overview (https://pixiecrm.com/help-centre/client-portal-overview)