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