Reservation + Table Selection App

HTML
DevelopmentHTML/JavaScript
Oracle
DatabaseOracle
SQL
SchemaSQL
ORDS
API LayerORDS

Pipeline Explorer

Click a step

Client: HTML/CSS/JS seat map for selecting seats and confirming a reservation.

// JavaScript (concept) — load seats
const params = new URLSearchParams({ datetime: iso, party_size: partySize });
const res = await fetch(`${availabilityUrl}?${params}`);
const data = await res.json();
renderSeats(data);

Interactive Demo

Entity Relationship Diagram

Entity Relationship Diagram for reservation database

Oracle Tables

Oracle tables screenshot

Backend (Oracle + ORDS)

GET Set ORDS_BASE in the script below
POST Set reserve endpoint in the script below