WorkPlan
Tables (11)
ANALYSIS_REPORT
- report_id — NUMBER — Primary key — NOT NULL
- session_id — NUMBER — Foreign key → ANALYSIS_SESSION.session_id — NOT NULL
- category_id — NUMBER — Foreign key → JOB_CATEGORY.category_id — NOT NULL
- match_score — NUMBER(5,2)
- status — VARCHAR2(20) — NOT NULL
- is_primary — CHAR(1) — NOT NULL
- created_at — DATE — NOT NULL
ANALYSIS_SESSION
- session_id — NUMBER — Primary key — NOT NULL
- user_id — NUMBER — Foreign key → APP_USER.user_id — NOT NULL
- resume_file_path — VARCHAR2(500) — NOT NULL
- cover_letter_file_path — VARCHAR2(500)
- parsed_text — CLOB
- created_at — DATE — NOT NULL
APP_USER
- user_id — NUMBER — Primary key — NOT NULL
- email — VARCHAR2(255) — NOT NULL
- password_hash — VARCHAR2(255) — NOT NULL
- nickname — VARCHAR2(50) — NOT NULL
- role — VARCHAR2(10) — NOT NULL
- reset_code — VARCHAR2(10)
- reset_code_expires_at — DATE
- terms_agreed_at — DATE — NOT NULL
- created_at — DATE — NOT NULL
COMPANY
- company_id — NUMBER — Primary key — NOT NULL
- corp_nm — VARCHAR2(200) — NOT NULL
- co_clcd_nm — VARCHAR2(50)
- home_pg — VARCHAR2(300)
- logo_img_url — VARCHAR2(500)
COMPETENCY_ITEM
- competency_id — NUMBER — Primary key — NOT NULL
- report_id — NUMBER — Foreign key → ANALYSIS_REPORT.report_id — NOT NULL
- name — VARCHAR2(100) — NOT NULL
- status — VARCHAR2(20) — NOT NULL
EMBEDDING_LOG
- log_id — NUMBER — Primary key — NOT NULL
- posting_id — NUMBER — Foreign key → JOB_POSTING.posting_id — NOT NULL
- chunk_field — VARCHAR2(30)
- status — VARCHAR2(20) — NOT NULL
- processed_at — DATE
INTERVIEW_QUESTION
- question_id — NUMBER — Primary key — NOT NULL
- report_id — NUMBER — Foreign key → ANALYSIS_REPORT.report_id — NOT NULL
- posting_id — NUMBER — Foreign key → JOB_POSTING.posting_id
- question_text — CLOB — NOT NULL
- source_field — VARCHAR2(20)
- source_quote — CLOB
- answer_guide — CLOB
- created_at — DATE
JOB_CATEGORY
- category_id — NUMBER — Primary key — NOT NULL
- parent_category_id — NUMBER — Foreign key → JOB_CATEGORY.category_id
- name — VARCHAR2(100) — NOT NULL
- category_level — VARCHAR2(20) — NOT NULL
- worknet_code — VARCHAR2(20)
JOB_POSTING
- posting_id — NUMBER — Primary key — NOT NULL
- company_id — NUMBER — Foreign key → COMPANY.company_id — NOT NULL
- category_id — NUMBER — Foreign key → JOB_CATEGORY.category_id — NOT NULL
- emp_seqno — VARCHAR2(30) — NOT NULL
- title — VARCHAR2(300) — NOT NULL
- jobs_cd — VARCHAR2(20)
- jobs_cd_nm — VARCHAR2(200)
- job_cont — CLOB
- pf_cond — CLOB
- career_nm — VARCHAR2(100)
- edu_nm — VARCHAR2(100)
- region_nm — VARCHAR2(100)
- emp_type_nm — VARCHAR2(100)
- reg_dt — DATE
- close_dt — DATE
- source_url — VARCHAR2(500)
- vector_doc_id — VARCHAR2(100)
- collected_at — DATE — NOT NULL
REPORT_EVIDENCE
- evidence_id — NUMBER — Primary key — NOT NULL
- report_id — NUMBER — Foreign key → ANALYSIS_REPORT.report_id — NOT NULL
- posting_id — NUMBER — Foreign key → JOB_POSTING.posting_id
- source_field — VARCHAR2(30)
- type — VARCHAR2(20) — NOT NULL
- description — CLOB — NOT NULL
- quoted_text — CLOB
- resume_quote — CLOB
- match_status — VARCHAR2(20)
SOLUTION_SUGGESTION
- suggestion_id — NUMBER — Primary key — NOT NULL
- report_id — NUMBER — Foreign key → ANALYSIS_REPORT.report_id — NOT NULL
- competency_id — NUMBER — Foreign key → COMPETENCY_ITEM.competency_id
- suggestion_text — CLOB — NOT NULL