GET /api/availability?type=room&in=…&out=… GET /api/availability?type=table&date=… POST /api/reservations GET /api/reservations?status=&q= (admin) PATCH /api/reservations/:code (admin) GET /api/reports/occupancy (admin) -- schema (excerpt) CREATE TABLE reservations ( id bigserial PRIMARY KEY, code text UNIQUE NOT NULL, kind text CHECK (kind IN ('room','table')), room_unit int REFERENCES room_units(id), stay daterange, service_at timestamptz, party smallint CHECK (party > 0), guest_id bigint REFERENCES guests(id), status text DEFAULT 'confirmed', total_cents int DEFAULT 0, source text DEFAULT 'web', created_at timestamptz DEFAULT now() ); CREATE INDEX ON reservations USING gist (stay);