How ResumeForge Works

-- PostgreSQL 16 + pgvector TABLE users id UUID PRIMARY KEY email TEXT UNIQUE NOT NULL password_hash TEXT NOT NULL credits INT DEFAULT 1 subscription_active BOOL DEFAULT FALSE gdpr_consent_at TIMESTAMPTZ deleted_at TIMESTAMPTZ -- soft delete TABLE resumes id UUID PRIMARY KEY user_id UUID REFERENCES users s3_raw_key TEXT -- AES-256 at rest file_type TEXT -- pdf | docx parsed_json JSONB -- structured sections raw_text TEXT TABLE resume_embeddings resume_id UUID REFERENCES resumes chunk_index INT embedding VECTOR(384) -- all-MiniLM-L6-v2 -- INDEX: ivfflat(embedding vector_cosine_ops) WITH (lists=100) TABLE tailoring_jobs id UUID PRIMARY KEY user_id UUID REFERENCES users resume_id UUID REFERENCES resumes job_description TEXT jd_keywords JSONB status TEXT -- QUEUED|EXTRACTING|ANALYZING|REWRITING|VALIDATING|GENERATING|DONE|FAILED ats_score FLOAT validation_report JSONB TABLE tailored_resumes id UUID PRIMARY KEY job_id UUID REFERENCES tailoring_jobs rewritten_json JSONB pdf_s3_key TEXT template_id TEXT DEFAULT 'classic' TABLE credit_transactions id UUID PRIMARY KEY user_id UUID REFERENCES users amount INT -- positive=add, negative=deduct reason TEXT -- PURCHASE|JOB_DEDUCTION|REFUND|PROMO stripe_payment_id TEXT created_at TIMESTAMPTZ DEFAULT now()