Keeping the raw résumé text, not just the structured JSON

01 The endpoint & current flow

POST /upload_resume_portal is handled by _upload_resume_portal_core() in flask_service/services/positions_service.py:329. It stores the PDF to S3, then runs a two-stage extraction pipeline whose only persisted output is the structured résumé.

02 Where résumé data lands today

main_fyi_users is already the canonical 1:1 record per parsed résumé, holding the structured data and the S3 link side by side and linked to users via users_id. The raw text belongs in the same row.

03 Why a text column, over the alternatives

• Colocated with the record it describes. Every consumer already joins here; the DAO has bulk-fetch methods. No new join, no new lookup path.
• The right type for unstructured data. Plain text — no schema, no JSON wrapping to unwrap.
• Free when unused. Postgres auto-TOASTs large values out-of-line, so the column costs nothing on reads that don't SELECT it. Résumé markdown is only a few KB anyway.
• Near-zero code change. The text already exists one call up the stack; we surface it instead of recomputing.

04 Change points

Only the fact that extract_structured_content() returns just the model — hiding the raw text from its caller — needs addressing. Two clean options:

# shared/pdf/extractor.py — surface the text that already exists
def extract_structured_content(file_path, doc_type):
    text = extract_text(file_path)
    ...
    return result, text        # return (model, raw_text)

# — or — call extract_text() once in the service and pass it into the structurer
#     (avoids a second extraction round-trip)

Then persist it and widen the model:

# flask_service/services/positions_service.py
main_fyi_user_dao.create({
    "user_id":     user_id,
    "resume_data": detailed_parsed_data,
    "resume_link": ...,
    "resume_text": text,        # NEW
})

# shared/models/main_fyi_user.py
resume_text: Optional[str] = None

Plus a migration adding resume_text text to main_fyi_users (written to supabase/migrations/ — file only, not pushed).

05 When to go further