Rota App

Rota App (Weekline) is a scheduling system for restaurant managers and staff. It replaces ad-hoc messaging with a clear, shared weekly plan and controlled requests.

The focus is on predictability: consistent coverage, clear responsibilities, and an auditable trail of changes.

• Weekly rota with role-based views and legend.
• Requests for holidays and shift swaps with approvals.
• Exportable schedules and historical visibility.

Restaurants often run rotas through WhatsApp threads and spreadsheets. Approvals are unclear, coverage gaps appear late, and swaps happen without visibility.

Managers need speed, while staff need clarity and a reliable way to request changes without constant back-and-forth.

The system must support multiple roles and multiple restaurants without data leakage. Workflows need to be fast, predictable, and safe under concurrent updates.

• Multi-role access with clear permissions.
• Multi-restaurant isolation by design.
• Data integrity and audit trail mindset.
• Speed of use for daily operations.

The core experience is a weekly rota grid with role legend, shift actions, and clear request workflows. Managers can add shifts, approve holidays, handle swaps, and export PDFs without breaking context.

Multi-tenant design is built around restaurant_id and membership roles. Supabase Auth connects auth.users to a profiles table for consistent ownership and access.

Key tables: restaurants, restaurant_members, staff, shifts, holidays, holiday_requests, swap_requests. Each record is scoped to a restaurant and designed for audit-ready history.

• Normalised schema for traceability and reporting.
• Status fields to model request workflows explicitly.
• Server-side enforcement mindset, RLS-ready.