Capstone 2: Restaurant Website - Miami Delights

For my Capstone 2 project, my team and I built a full-stack web application for a restaurant named Miami Delights. The restaurant requested several features, including:

• Order Tracking: Allowing customers to track their orders in real-time.
• Payment Processing: Seamless and secure online payment functionality.
• Shopping Cart: A fully functional cart for customers to manage their orders before checkout.
• Admin Management: Tools for the restaurant owner or admin to manage orders and products efficiently.

Technologies Used

Miami Delights was built using the following technologies:

• Typescript: For static type checking.
• Next.js: Framework for the front-end and server-side rendering.
• PostgreSQL: SQL Database.
• TanStack Query: Data-fetching and state management.
• React Formik: Form handling and validation.
• Zod Validation: Client and server side validation for forms and API.
• ShadCN UI: UI components for a sleek and responsive design.
• Vercel Hosting: Deployment platform for the application.
• Supabase: Database hosting and backend-as-a-service.
• Stripe: Payment processing.

Database Schema

Here is the SQL schema for the application's tables:

Users Table

CREATE TABLE IF NOT EXISTS users (
    user_id SERIAL PRIMARY KEY,
    first_name VARCHAR(255) NOT NULL,
    last_name VARCHAR(255) NOT NULL,
    email VARCHAR(255) UNIQUE NOT NULL,
    password TEXT NOT NULL
);

Products Table

CREATE TABLE IF NOT EXISTS products(
    product_id SERIAL PRIMARY KEY,
    product_name VARCHAR(255) NOT NULL,
    price NUMERIC(10, 2) NOT NULL,
    product_category VARCHAR (50) NOT NULL,
    image_url VARCHAR(50) NOT NULL
);

Toppings Table

CREATE TABLE IF NOT EXISTS toppings (
    topping_id SERIAL PRIMARY KEY,
    topping_name VARCHAR(255) NOT NULL,
    additional_price NUMERIC(10, 2) DEFAULT 0,
    product_id INTEGER NOT NULL,
    FOREIGN KEY (product_id) REFERENCES products (product_id) ON DELETE CASCADE
);

Cart Table

CREATE TABLE IF NOT EXISTS cart (
    cart_id SERIAL PRIMARY KEY,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    user_id INTEGER NOT NULL UNIQUE, 
    FOREIGN KEY (user_id) REFERENCES users (user_id) ON DELETE CASCADE
);

Cart Items Table

CREATE TABLE IF NOT EXISTS cart_items (
    cart_item_id SERIAL PRIMARY KEY,
    quantity INT NOT NULL DEFAULT 1,
    total_price NUMERIC(10, 2) NOT NULL,
    cart_id INTEGER NOT NULL,
    product_id INTEGER NOT NULL,
    FOREIGN KEY (product_id) REFERENCES products (product_id) ON DELETE CASCADE,
    FOREIGN KEY (cart_id) REFERENCES cart (cart_id) ON DELETE CASCADE
);

Cart Item Toppings

CREATE TABLE IF NOT EXISTS cart_item_toppings (
    cart_item_topping_id SERIAL PRIMARY KEY,
    cart_item_id INTEGER NOT NULL,
    topping_id INTEGER NOT NULL,
    FOREIGN KEY (cart_item_id) REFERENCES cart_items(cart_item_id) ON DELETE CASCADE,
    FOREIGN KEY (topping_id) REFERENCES toppings(topping_id) ON DELETE CASCADE
);

Orders Table

CREATE TABLE IF NOT EXISTS orders (
    order_id SERIAL PRIMARY KEY,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    total_amount NUMERIC(10, 2) NOT NULL,
    order_status VARCHAR(50) NOT NULL CHECK (order_status IN ('preparing', 'oven', 'ready', 'delivered')),
    user_id INTEGER NOT NULL,
    FOREIGN KEY (user_id) REFERENCES users (user_id) ON DELETE CASCADE
);

Order Items Table

CREATE TABLE IF NOT EXISTS order_items (
    order_item_id SERIAL PRIMARY KEY,
    quantity INT NOT NULL DEFAULT 1,
    total_price NUMERIC(10, 2) NOT NULL,
    product_name VARCHAR(255) NOT NULL,
    order_id INTEGER NOT NULL,
    FOREIGN KEY (order_id) REFERENCES orders (order_id) ON DELETE CASCADE
);

Order Item Toppings Table

CREATE TABLE IF NOT EXISTS order_item_toppings (
    order_item_topping_id SERIAL PRIMARY KEY,
    topping_name VARCHAR(255) NOT NULL,
    order_item_id INTEGER NOT NULL,
    FOREIGN KEY (order_item_id) REFERENCES order_items (order_item_id) ON DELETE CASCADE
);