Database Schema

This document outlines the database schema used in BridalBliss. Understanding our data structure will help you better integrate with our platform and make the most of our API.

Core Tables

Users

CREATE TABLE users (
  id UUID PRIMARY KEY,
  email VARCHAR(255) UNIQUE NOT NULL,
  name VARCHAR(255),
  created_at TIMESTAMP DEFAULT NOW()
);

Weddings

CREATE TABLE weddings (
  id UUID PRIMARY KEY,
  user_id UUID REFERENCES users(id),
  date DATE NOT NULL,
  venue VARCHAR(255),
  budget DECIMAL(10,2),
  created_at TIMESTAMP DEFAULT NOW()
);

Guests

CREATE TABLE guests (
  id UUID PRIMARY KEY,
  wedding_id UUID REFERENCES weddings(id),
  name VARCHAR(255) NOT NULL,
  email VARCHAR(255),
  rsvp_status VARCHAR(50),
  created_at TIMESTAMP DEFAULT NOW()
);