This document describes the database schema for staticSend, a form submission management system.
Stores user accounts for form management
id- Primary key, auto-incrementemail- Unique user emailpassword_hash- Hashed passwordcreated_at- Account creation timestampupdated_at- Last update timestamp
Stores contact form configurations
id- Primary key, auto-incrementuser_id- Foreign key to usersname- Form name/identifiertitle- Display titledescription- Form descriptionredirect_url- URL to redirect after submissioncreated_at- Creation timestampupdated_at- Last update timestamp
Stores form submissions
id- Primary key, auto-incrementform_id- Foreign key to formsip_address- Submitter IP addressuser_agent- Browser user agentsubmitted_data- JSON blob of form datacreated_at- Submission timestampprocessed_at- When email was sent (nullable)status- Submission status (pending, processed, failed)
Tracks email sending for submissions
id- Primary key, auto-incrementsubmission_id- Foreign key to submissionssent_at- When email was sentstatus- Delivery status (sent, failed)error_message- Error if delivery failed
- One user can have multiple forms
- One form can have multiple submissions
- One submission has one email tracking record
users.email- Unique index for loginforms.user_id- For user form queriessubmissions.form_id- For form submission queriessubmissions.created_at- For time-based queriessubmission_emails.submission_id- For email tracking