: GayTube operates as a "platform," meaning it hosts both professionally produced content and amateur "prosumer" uploads.
-- Pull Requests (simplified) CREATE TABLE pull_requests ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), repo_id UUID REFERENCES repositories(id) ON DELETE CASCADE, source_branch TEXT NOT NULL, target_branch TEXT NOT NULL, title TEXT NOT NULL, body TEXT, author_id UUID REFERENCES users(id) ON DELETE SET NULL, state TEXT NOT NULL DEFAULT 'open', -- open, merged, closed created_at TIMESTAMPTZ DEFAULT now(), merged_at TIMESTAMPTZ, updated_at TIMESTAMPTZ DEFAULT now() ); gaytybe