-- Reports (abuse) CREATE TABLE reports ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), reporter_id UUID REFERENCES users(id) ON DELETE SET NULL, target_type TEXT NOT NULL CHECK (target_type IN ('user','repo','issue','pr','comment')), target_id UUID NOT NULL, reason TEXT NOT NULL, details TEXT, status TEXT NOT NULL DEFAULT 'pending', -- pending, resolved, dismissed created_at TIMESTAMPTZ DEFAULT now(), resolved_at TIMESTAMPTZ );
All endpoints require ( Authorization: Bearer <token> ). Errors follow the RFC 7807 problem‑details format. gaytybe
-- Repo_Objects (git objects stored in S3; only metadata here) CREATE TABLE repo_objects ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), repo_id UUID REFERENCES repositories(id) ON DELETE CASCADE, path TEXT NOT NULL, -- e.g., "src/index.js" sha256 BYTEA NOT NULL, size_bytes BIGINT NOT NULL, mime_type TEXT, s3_key TEXT NOT NULL, created_at TIMESTAMPTZ DEFAULT now() ); -- Reports (abuse) CREATE TABLE reports ( id
-- Users CREATE TABLE users ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), email TEXT UNIQUE NOT NULL, password_hash TEXT NOT NULL, username TEXT UNIQUE NOT NULL, display_name TEXT, pronouns TEXT, -- e.g., "they/them" gender_tag TEXT, -- optional free‑form tag avatar_url TEXT, two_fa_secret TEXT, created_at TIMESTAMPTZ DEFAULT now(), updated_at TIMESTAMPTZ DEFAULT now() ); | | Target Users | LGBTQ+ developers, allies,
| Item | Description | |------|-------------| | | GayTybe | | Tagline | “Your safe space to code, collaborate, and celebrate LGBTQ+ tech.” | | Primary Goal | Provide a fully‑featured source‑code repository service with social‑networking features, all built with inclusivity, privacy, and accessibility in mind. | | Target Users | LGBTQ+ developers, allies, open‑source maintainers, community organizers. | | Core Modules | 1️⃣ Auth & Identity 2️⃣ Repository Management 3️⃣ Issue & PR System 4️⃣ Community Feed 5️⃣ Safe‑Space Controls (content filters, harassment‑reporting) | | Tech Stack (suggested) | Front‑end: React 18 + TypeScript + TailwindCSS Back‑end: Node 20 (Express) + TypeScript Database: PostgreSQL (with pg‑crypto for encryption) Storage: AWS S3 (or any S3‑compatible bucket) CI/CD: GitHub Actions (or self‑hosted) | | Compliance | GDPR, CCPA, WCAG 2.1 AA (accessibility), and a custom “Safe‑Space Policy”. |
Sexuality is a multifaceted concept that encompasses a wide range of emotions, attractions, and behaviors. It is an integral part of the human experience, influencing how individuals perceive themselves and interact with others. The spectrum of sexuality is broad, encompassing various orientations, including but not limited to heterosexuality, homosexuality, bisexuality, asexuality, and pansexuality. Each of these orientations represents a unique experience, and it's essential to approach them with respect, curiosity, and an open mind.