2
Tables (12)
analysis_report
- report_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- report_type — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- error_code — VARCHAR(50)
- pdf_object_key — VARCHAR(500)
- created_at — TIMESTAMP — NOT NULL
- completed_at — TIMESTAMP
analysis_report_company
- report_company_id — BIGINT — Primary key — NOT NULL
- report_id — BIGINT — Foreign key → analysis_report.report_id — NOT NULL
- company_code — VARCHAR(20) — Foreign key → company.company_code — NOT NULL
- position_id — BIGINT — Foreign key → job_position.position_id — NOT NULL
- rank — INTEGER
- fit_score — NUMERIC(5,2)
analysis_report_item
- item_id — BIGINT — Primary key — NOT NULL
- report_company_id — BIGINT — Foreign key → analysis_report_company.report_company_id — NOT NULL
- item_type — VARCHAR(30) — NOT NULL
- content — TEXT — NOT NULL
company
- company_code — VARCHAR(20) — Primary key — NOT NULL
- company_name — VARCHAR(100) — NOT NULL
- industry — VARCHAR(50)
- people — INTEGER — NOT NULL
- insight — INTEGER — NOT NULL
company_insight
- insight_id — BIGINT — Primary key — NOT NULL
- company_code — VARCHAR(20) — Foreign key → company.company_code — NOT NULL
- created_by — BIGINT — Foreign key → users.user_id
- category — VARCHAR(20) — NOT NULL
- position_id — BIGINT — Foreign key → job_position.position_id
- content — TEXT — NOT NULL
- content_hash — VARCHAR(64)
- embedding — VECTOR(1536)
- created_at — TIMESTAMP — NOT NULL
company_insight_tech
- insight_id — BIGINT — Foreign key → company_insight.insight_id — NOT NULL
- tech_id — BIGINT — Foreign key → tech_stack.tech_id — NOT NULL
job_position
- position_id — BIGINT — Primary key — NOT NULL
- position_name — VARCHAR(100) — NOT NULL
job_seeker_profile
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- desired_position_id — BIGINT — Foreign key → job_position.position_id
job_seeker_tech
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- tech_id — BIGINT — Foreign key → tech_stack.tech_id — NOT NULL
profile_content
- content_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- category — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- content_hash — VARCHAR(64)
- embedding — VECTOR(1536)
- created_at — TIMESTAMP — NOT NULL
tech_stack
- tech_id — BIGINT — Primary key — NOT NULL
- tech_name — VARCHAR(50) — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL