Platform data
Use this library before moving screens from JSON records to MySQL-backed operations.
Library
Database table groups, MySQL migration planning, permissions, schema governance, and app data readiness for ZartsAlgo.
Accounts, users, roles, clients, contacts, sessions, password resets, login attempts, and audit records. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guidePortal users, sessions, permissions, notes, and client-facing data access. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guideLead sources, leads, lead events, estimates, follow-ups, and sales pipeline state. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guideProjects, milestones, tasks, blockers, approvals, and launch execution records. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guideServices, service subscriptions, service areas, deliverables, and managed scope. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guideAutomations, triggers, destinations, versions, runs, provider status, and QA records. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guideSMS, email, owner notifications, approval language, templates, and delivery records. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guidePages, content approvals, local SEO work, page refreshes, FAQ updates, and publishing workflow. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guideWebsite audits, automation audits, form checks, technical reviews, and remediation notes. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guideMonthly reports, weekly updates, report sections, report metrics, and handoff notes. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guideMetric definitions, snapshots, baseline values, current values, and movement over time. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guideSearch Console properties, query snapshots, page snapshots, and organic visibility deltas. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guideProvider accounts, sync jobs, import batches, webhook logs, field mappings, and connection state. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guideCampaign plans, landing pages, events, attribution, experiment notes, and results. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guideClient approvals, internal approvals, change requests, content decisions, and due dates. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guideRecurring checks, backups, provider status, technical health, and ongoing care. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guideIncident reports, impact notes, fixes, verification, and recurrence monitoring. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guideAdmin actions, portal activity, customer events, operational logs, and activity timelines. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guideUploads, exports, screenshots, documents, reports, and downloadable client artifacts. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guideSchema migrations, operational settings, background job state, and system health data. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guideHistorical snapshots, retired records, old imports, and long-term reference data. This guide explains how the table group supports admin records, client portal reporting, and future MySQL wiring.
Open guidePrimary App Database Environment Checklist for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guideMySQL Runtime User Privilege Model for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guideAdmin Authentication Table Migration Plan for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guidePortal Authentication Table Migration Plan for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guideJSON Operations File to MySQL Migration for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guideLarge Client Volume Indexing Checklist for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guideMulti Tenant Client Isolation Plan for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guideDatabase Backup and Restore Drill for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guideSchema Migration Release Checklist for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guideForeign Key Integrity Review for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guideSoft Delete and Archive Strategy for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guideAudit Log Data Governance for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guideUser Role Permission Matrix for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guideClient Contact Data Hygiene Plan for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guideReport Metric Source Label Policy for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guideProvider Token Storage Policy for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guideWebhook Dedupe and Retry Policy for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guideManual Import Approval Workflow for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guideHigh Volume Read Replica Planning for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guideSlow Query Review Checklist for preparing ZartsAlgo admin, portal, integrations, and reporting for a larger MySQL-backed platform.
Open guide