Database Schema Designer

-- E-Commerce Database Schema -- PostgreSQL 15+ -- Designed for 100K daily orders ----------------------------------- -- USERS TABLE ----------------------------------- CREATE TABLE users ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), email VARCHAR(255) NOT NULL UNIQUE, password_hash VARCHAR(255) NOT NULL, first_name VARCHAR(100), last_name VARCHAR(100), phone VARCHAR(20), email_verified BOOLEAN DEFAULT FALSE, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), deleted_at TIMESTAMP WITH TIME ZONE ); -- Index for email lookups (login) CREATE INDEX idx_users_email ON users(email) WHERE deleted_at IS NULL; -- Index for recent users (admin dashboard) CREATE INDEX idx_users_created_at ON users(created_at DESC); ----------------------------------- -- ADDRESSES TABLE ----------------------------------- ...