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