Forum
Campus event scheduling, resource allocation, and facility booking — modeled after the jhcsc-venue stack with Refine and Supabase.
Problem
Coordinating venues, payment status, and booking schedules across departments needs a single system of record. Forum (repo: jhcsc-venue) centralizes facility reservations, manager dashboards, and audit-friendly booking history.
Data model
Bookings link users to venues with confirmation flags, payment status foreign keys, and schedule rows. Generated Supabase types keep the Refine data provider aligned with Postgres views for manager summaries and remaining balances.
What it covers
- Venue catalog and multi-step booking flows
- Payment status tracking per reservation
- Manager dashboards via database views
- Refine + Supabase auth with OAuth and password login
export type BookingRow = {
id: number;
venue_id: number;
user_id: string | null;
payment_status_id: number | null;
total_amount: number | null;
is_confirmed: boolean;
is_deleted: boolean;
};