CREATE TABLE users ( user_id BIGSERIAL PRIMARY KEY, username VARCHAR(50) UNIQUE NOT NULL, email_hash CHAR(64), -- SHA‑256 of email for privacy created_at TIMESTAMP DEFAULT NOW() );