Orderlix/docs/04-database.md

Database

Task

Create database schema.

Tables

users

• id
• email
• password
• role

clubs

• id
• name

memberships

• user_id
• club_id

bookings

• id
• user_id
• club_id
• amount
• created_at

Task

• Generate SQL schema
• Connect Supabase
• Create service for DB access