Database Setup & Recovery

    Monitor all 21 application tables and export the schema blueprint for seamless recreation after a database failure.

    Content2 tables
    Blog Postsblog_posts#83427
    News and blog articles published on the website
    13 cols
    Newsletter Subscribersnewsletter_subscribers#83431
    Email subscribers for the newsletter
    3 cols
    CRM / Leads2 tables
    Contact Leadscontact_leads#83428
    Inquiries submitted through the contact form
    8 cols
    Partner Applicationspartner_applications#83429
    Applications submitted through the partner program form
    7 cols
    Users & Access2 tables
    Admin Invitationsadmin_invitations#83436
    Pending and accepted admin user invitations
    3 cols
    User Permissionsuser_permissions#83825
    Role and module access permissions for admin users
    12 cols
    Sales7 tables
    Customerssales_customers#83441
    Customer master list for the sales module
    8 cols
    Product/Service Catalogsales_items#83442
    Catalog of products and services used in quotations and invoices
    8 cols
    Quotationsquotations#83438
    Sales quotations sent to clients
    22 cols
    Invoicesinvoices#83439
    Invoices billed to clients, converted from quotations or standalone
    29 cols
    Invoice Paymentsinvoice_payments#84042
    Payment records linked to invoices
    6 cols
    Recurring Invoicesrecurring_invoices#83440
    Templates for auto-generating recurring invoices
    21 cols
    CRM Notescrm_notes#83832
    Activity notes linked to quotations or invoices
    8 cols
    Payroll / HR4 tables
    Employeespayroll_employees#83483
    Employee master list for the payroll module
    15 cols
    Cash Advancespayroll_cash_advances#83484
    Employee cash advance records for payroll deductions
    9 cols
    Payroll Periodspayroll_periods#83485
    Semi-monthly payroll cutoff periods
    8 cols
    Payroll Recordspayroll_records#83486
    Per-employee payroll computation records for each period
    33 cols
    Projects2 tables
    Projectsprojects#83833
    Project headers for the Gantt chart project management module
    9 cols
    Project Tasksproject_tasks#83834
    Gantt chart task bars linked to projects
    13 cols
    BNI Pipeline2 tables
    BNI Prospectsbni_prospects#83837
    BNI pipeline prospects tracked through meeting stages
    8 cols
    BNI Emails Sentbni_emails#83838
    Log of emails sent to BNI prospects
    6 cols
    Disaster Recovery Guide
    1. Export the Schema

    Click Export Schema above to download a JSON file containing all 21 table definitions with every column, type, and default. Store this file safely outside the database.

    2. Detect Issues

    Run Health Check at any time to query all tables. Any inaccessible table will appear in red with the error message so you know exactly what needs to be recreated.

    3. Recreate Tables

    Share the exported schema JSON with your platform administrator. All 21 tables can be recreated instantly from this single file without losing any structural knowledge.

    Schema version generated: 2026-07-29 • 21 tables • 249 total columns documented