# Database Schema

## Core Entities
- **admins**: Super admins and staff accessing the web dashboard.
- **customers**: App users who are looking for maids.
- **vendors**: Agencies/companies providing maids.
- **maids**: The domestic helpers linked to specific vendors.

## Lookups
- **countries, cities**: For addressing and filtering.
- **nationalities, languages, specialties, skills**: For maid profiling and customer search criteria.
- **service_models, accommodation_types**: To specify the type of service requested.
- **document_types**: System-defined requirements for uploads.
- **interview_platforms**: Platforms used for conducting interviews.

## Transactions & Workflows
- **interview_requests**: Customers requesting to interview a maid.
- **interview_reschedules**: Tracking table for customer or vendor-initiated interview rescheduling history.
- **quotation_requests**: Customer inquiries asking for pricing details. Includes nested requests (skills, specialties).
- **quotations**: Pricing offers generated by vendors based on quotation requests.
- **contracts**: Finalized agreements linked to a quotation, signed by both parties.
- **contract_status_logs**: Audit trail for contract changes.
- **payments**: Financial transactions related to contracts, subscriptions, or ads.

## Vendor Features
- **vendor_subscriptions**: Vendor subscription history and current status.
- **subscription_plans**: Available tier packages.
- **vendor_ads**: Promotional boosts for vendors or specific maids.
- **vendor_interview_settings & availability**: Vendor defined times and rules for interviews.

## User Engagement
- **reviews**: Customer ratings on vendors and maids.
- **favorite_vendors, favorite_maids**: Customer bookmarks.
- **chat_references**: Links a Firebase Chat ID to MySQL entities (Customer, Vendor, Maid, Contract) to facilitate finding the chat room.

## CMS & App Management
- **app_sliders, onboarding_screens, home_sections**: Content dynamically served to mobile apps.
- **faqs, support_tickets**: Customer service.
- **notifications, device_tokens**: Push notification management.