articlue

Tables (29)

action_plan

  • action_plan_id — NUMBER — Primary key — NOT NULL
  • diagnosis_id — NUMBER — Foreign key → portfolio_diagnosis.diagnosis_id — NOT NULL
  • action_plan_title — VARCHAR2(300) — NOT NULL
  • action_plan_summary — CLOB
  • recommended_learning — CLOB
  • recommended_content_url — CLOB
  • priority — NUMBER
  • expected_period — VARCHAR2(100)
  • created_date — DATE — NOT NULL

career

  • career_id — NUMBER — Primary key — NOT NULL
  • resume_id — NUMBER — Foreign key → resume.resume_id — NOT NULL
  • company_name — VARCHAR2(150) — NOT NULL
  • department — VARCHAR2(100)
  • position — VARCHAR2(100)
  • start_ym — VARCHAR2(7)
  • end_ym — VARCHAR2(7)
  • main_achievement — CLOB

certificate

  • certificate_id — NUMBER — Primary key — NOT NULL
  • resume_id — NUMBER — Foreign key → resume.resume_id — NOT NULL
  • certificate_name — VARCHAR2(150) — NOT NULL
  • acquired_ym — VARCHAR2(7)
  • issuer — VARCHAR2(150)

company

  • company_id — NUMBER — Primary key — NOT NULL
  • company_name — VARCHAR2(150) — NOT NULL
  • industry_category — VARCHAR2(100)
  • company_size — VARCHAR2(100)
  • company_description — CLOB
  • homepage_url — VARCHAR2(500)
  • average_salary — NUMBER
  • welfare_info — CLOB
  • work_location — VARCHAR2(200)

company_recommendation

  • recommendation_id — NUMBER — Primary key — NOT NULL
  • resume_id — NUMBER — Foreign key → resume.resume_id — NOT NULL
  • job_posting_id — NUMBER — Foreign key → job_posting.job_posting_id — NOT NULL
  • pass_predict_rate — NUMBER — NOT NULL
  • job_fit_score — NUMBER
  • tech_match_score — NUMBER
  • experience_fit_score — NUMBER
  • talent_fit_score — NUMBER
  • recommend_rank — NUMBER
  • recommend_reason — CLOB
  • recommended_date — DATE — NOT NULL

cover_letter

  • cover_letter_id — NUMBER — Primary key — NOT NULL
  • resume_id — NUMBER — Foreign key → resume.resume_id — NOT NULL
  • create_at — DATE — NOT NULL
  • update_at — DATE — NOT NULL

cover_letter_item

  • cover_letter_item_id — NUMBER — Primary key — NOT NULL
  • cover_letter_id — NUMBER — Foreign key → cover_letter.cover_letter_id — NOT NULL
  • question_order — NUMBER — NOT NULL
  • sub_title — VARCHAR2(200) — NOT NULL
  • content — CLOB — NOT NULL
  • create_at — DATE — NOT NULL
  • update_at — DATE — NOT NULL

education

  • education_id — NUMBER — Primary key — NOT NULL
  • resume_id — NUMBER — Foreign key → resume.resume_id — NOT NULL
  • school_type — VARCHAR2(30) — NOT NULL
  • school_name — VARCHAR2(100) — NOT NULL
  • major — VARCHAR2(100)
  • graduation_status — VARCHAR2(30)
  • gpa — NUMBER(3,2)
  • start_ym — VARCHAR2(7)
  • end_ym — VARCHAR2(7)

experience

  • experience_id — NUMBER — Primary key — NOT NULL
  • resume_id — NUMBER — Foreign key → resume.resume_id — NOT NULL
  • experience_type — VARCHAR2(30) — NOT NULL
  • experience_name — VARCHAR2(200) — NOT NULL
  • start_ym — VARCHAR2(7)
  • end_ym — VARCHAR2(7)

generated_document

  • generated_document_id — NUMBER — Primary key — NOT NULL
  • resume_id — NUMBER — Foreign key → resume.resume_id — NOT NULL
  • job_posting_id — NUMBER — Foreign key → job_posting.job_posting_id — NOT NULL
  • document_type — VARCHAR2(30) — NOT NULL
  • document_title — VARCHAR2(300) — NOT NULL
  • document_content — CLOB — NOT NULL
  • created_date — DATE — NOT NULL
  • save_status — VARCHAR2(20) — NOT NULL

github_account

  • github_account_id — NUMBER — Primary key — NOT NULL
  • member_id — NUMBER — Foreign key → member.member_id — NOT NULL
  • github_user_id — NUMBER — NOT NULL
  • login — VARCHAR2(100) — NOT NULL
  • html_url — VARCHAR2(500) — NOT NULL
  • access_token — CLOB
  • refresh_token — CLOB
  • expires_at — DATE
  • connected_at — DATE — NOT NULL
  • last_sync_at — DATE

github_repo_commit_daily

  • github_repo_commit_daily_id — NUMBER — Primary key — NOT NULL
  • github_repository_id — NUMBER — Foreign key → github_repository.github_repository_id — NOT NULL
  • commit_date — DATE — NOT NULL
  • commit_count — NUMBER — NOT NULL
  • collected_at — DATE — NOT NULL

github_repo_tech_stack

  • github_repo_tech_id — NUMBER — Primary key — NOT NULL
  • github_repository_id — NUMBER — Foreign key → github_repository.github_repository_id — NOT NULL
  • tech_category_code — VARCHAR2(20) — Foreign key → tech_category.tech_category_code — NOT NULL
  • language_name — VARCHAR2(100) — NOT NULL
  • usage_ratio — NUMBER(5,2)
  • collected_at — DATE — NOT NULL

github_repository

  • github_repository_id — NUMBER — Primary key — NOT NULL
  • github_account_id — NUMBER — Foreign key → github_account.github_account_id — NOT NULL
  • github_repo_external_id — NUMBER — NOT NULL
  • name — VARCHAR2(200) — NOT NULL
  • full_name — VARCHAR2(300) — NOT NULL
  • html_url — VARCHAR2(500) — NOT NULL
  • description — CLOB
  • fork — CHAR(1) — NOT NULL
  • archived — CHAR(1) — NOT NULL
  • default_branch — VARCHAR2(100)
  • created_at — DATE
  • updated_at — DATE
  • pushed_at — DATE
  • last_sync_at — DATE

interview_qa

  • interview_qa_id — NUMBER — Primary key — NOT NULL
  • interview_session_id — NUMBER — Foreign key → interview_session.interview_session_id — NOT NULL
  • question_order — NUMBER — NOT NULL
  • question_content — CLOB — NOT NULL
  • answer_content — CLOB
  • follow_up_yn — CHAR(1) — NOT NULL
  • question_created_at — DATE — NOT NULL
  • answered_at — DATE

interview_report

  • interview_report_id — NUMBER — Primary key — NOT NULL
  • interview_session_id — NUMBER — Foreign key → interview_session.interview_session_id — NOT NULL
  • logic_score — NUMBER(5,2)
  • tech_understanding_score — NUMBER(5,2)
  • business_link_score — NUMBER(5,2)
  • evidence_score — NUMBER(5,2)
  • job_fit_score — NUMBER(5,2)
  • total_score — NUMBER(5,2)
  • weakness_summary — CLOB
  • best_answer_guide — CLOB
  • created_date — DATE — NOT NULL

interview_session

  • interview_session_id — NUMBER — Primary key — NOT NULL
  • resume_id — NUMBER — Foreign key → resume.resume_id — NOT NULL
  • job_posting_id — NUMBER — Foreign key → job_posting.job_posting_id — NOT NULL
  • portfolio_id — NUMBER — Foreign key → portfolio_file.portfolio_id — NOT NULL
  • apply_industry — VARCHAR2(100)
  • apply_job — VARCHAR2(100)
  • interview_level — VARCHAR2(20) — NOT NULL
  • start_time — DATE — NOT NULL
  • end_time — DATE
  • session_status — VARCHAR2(20) — NOT NULL
  • total_question_count — NUMBER — NOT NULL
  • total_answer_count — NUMBER — NOT NULL

job_posting

  • job_posting_id — NUMBER — Primary key — NOT NULL
  • company_id — NUMBER — Foreign key → company.company_id — NOT NULL
  • posting_title — VARCHAR2(300) — NOT NULL
  • job_name — VARCHAR2(100) — NOT NULL
  • career_condition — VARCHAR2(100)
  • employment_type — VARCHAR2(100)
  • work_location — VARCHAR2(200)
  • main_task — CLOB
  • qualification — CLOB
  • preferred_qualification — CLOB
  • talent_profile — CLOB
  • original_url — VARCHAR2(1000)
  • posted_date — DATE
  • deadline_date — DATE
  • posting_status — VARCHAR2(20)

job_posting_tech_stack

  • posting_tech_id — NUMBER — Primary key — NOT NULL
  • job_posting_id — NUMBER — Foreign key → job_posting.job_posting_id — NOT NULL
  • tech_category_code — VARCHAR2(20) — Foreign key → tech_category.tech_category_code — NOT NULL
  • tech_name — VARCHAR2(100) — NOT NULL
  • tech_category — VARCHAR2(100)
  • requirement_type — VARCHAR2(20) — NOT NULL
  • importance — NUMBER
  • required_level — VARCHAR2(50)

member

  • member_id — NUMBER — Primary key — NOT NULL
  • login_id — VARCHAR2(50)
  • password — VARCHAR2(255)
  • email — VARCHAR2(100) — NOT NULL
  • nickname — VARCHAR2(50)
  • user_type — VARCHAR2(20) — NOT NULL
  • create_at — DATE — NOT NULL
  • update_at — DATE

member_profile

  • profile_id — NUMBER — Primary key — NOT NULL
  • member_id — NUMBER — Foreign key → member.member_id — NOT NULL
  • name — VARCHAR2(50) — NOT NULL
  • phone — VARCHAR2(255) — NOT NULL
  • birth_date — DATE — NOT NULL
  • address — VARCHAR2(300) — NOT NULL
  • gender — VARCHAR2(20)
  • military_status — VARCHAR2(50)
  • profile_image_url — VARCHAR2(500)
  • create_at — DATE — NOT NULL
  • update_at — DATE — NOT NULL

portfolio_diagnosis

  • diagnosis_id — NUMBER — Primary key — NOT NULL
  • resume_id — NUMBER — Foreign key → resume.resume_id — NOT NULL
  • job_posting_id — NUMBER — Foreign key → job_posting.job_posting_id — NOT NULL
  • diagnosis_summary — CLOB
  • tech_stack_weakness — CLOB
  • project_experience_weakness — CLOB
  • business_result_weakness — CLOB
  • domain_understanding_weakness — CLOB
  • improvement_priority — VARCHAR2(100)
  • diagnosis_date — DATE

portfolio_file

  • portfolio_id — NUMBER — Primary key — NOT NULL
  • resume_id — NUMBER — Foreign key → resume.resume_id — NOT NULL
  • original_file_name — VARCHAR2(255) — NOT NULL
  • stored_file_name — VARCHAR2(255) — NOT NULL
  • file_extension — VARCHAR2(10) — NOT NULL
  • file_path — VARCHAR2(1000) — NOT NULL
  • file_size — NUMBER — NOT NULL
  • upload_at — DATE — NOT NULL
  • file_status — VARCHAR2(20) — NOT NULL

resume

  • resume_id — NUMBER — Primary key — NOT NULL
  • member_id — NUMBER — Foreign key → member.member_id — NOT NULL
  • resume_title — VARCHAR2(200) — NOT NULL
  • desired_job — VARCHAR2(100) — NOT NULL
  • introduction — VARCHAR2(500) — NOT NULL
  • resume_status — VARCHAR2(20) — NOT NULL
  • representative_yn — CHAR(1) — NOT NULL
  • create_at — DATE — NOT NULL
  • update_at — DATE — NOT NULL

resume_desired_location

  • desired_location_id — NUMBER — Primary key — NOT NULL
  • resume_id — NUMBER — Foreign key → resume.resume_id — NOT NULL
  • location_name — VARCHAR2(100) — NOT NULL

resume_github_repository

  • resume_github_repo_id — NUMBER — Primary key — NOT NULL
  • resume_id — NUMBER — Foreign key → resume.resume_id — NOT NULL
  • github_repository_id — NUMBER — Foreign key → github_repository.github_repository_id — NOT NULL
  • display_order — NUMBER
  • project_description — CLOB
  • created_date — DATE — NOT NULL

resume_tech_stack

  • resume_tech_id — NUMBER — Primary key — NOT NULL
  • resume_id — NUMBER — Foreign key → resume.resume_id — NOT NULL
  • tech_category_code — VARCHAR2(20) — Foreign key → tech_category.tech_category_code — NOT NULL
  • create_at — DATE — NOT NULL

social_account

  • social_account_id — NUMBER — Primary key — NOT NULL
  • member_id — NUMBER — Foreign key → member.member_id — NOT NULL
  • provider — VARCHAR2(30) — NOT NULL
  • provider_user_id — VARCHAR2(200) — NOT NULL
  • access_token — CLOB
  • refresh_token — CLOB
  • expires_at — DATE
  • last_refresh_at — DATE
  • connected_at — DATE — NOT NULL

tech_category

  • tech_category_code — VARCHAR2(20) — Primary key — NOT NULL
  • tech_category_name — VARCHAR2(100) — NOT NULL
  • tech_name — VARCHAR2(100) — NOT NULL