Skip to main content

Database Schema Map

Database schema map​

This page gives a high-level map of core table relationships and frequently changing data areas.

Critical table zones​

  • User identity and member profiles.
  • Membership benefits and transaction history.
  • Reservation records and scheduling slots.
  • Promo/coupon/stamp rules and validity.

Verification flow​

  • Inspect latest migrations in database/migrations/.
  • Cross-check model relationships in app/Models/.
  • Validate foreign key naming consistency.

Schema-change discipline​

Always include rollback planning, legacy data impact notes, and phased migration strategy for large tables.