Jobhub

Tables (21)

administrator

  • admin_ID — VARCHAR2(50) — Primary key
  • admin_PW — VARCHAR2(50)
  • employee_ID — VARCHAR2(50)
  • permission_code — VARCHAR2(50)
  • creation_code — VARCHAR2(200)
  • deactivation_date — VARCHAR2(200)
  • user_status — varchar2(100)

administrator_request

  • id — number — Primary key
  • name — VARCHAR2(100)
  • birth — VARCHAR2(200)
  • gender — VARCHAR2(6)
  • request_date — VARCHAR2(100)

apply

  • apply_id — VARCHAR2(50) — Primary key
  • resume_id (resume_id2) — VARCHAR2(50) — Foreign key → resume_info.resume_id
  • jobs_id (jobs_id2) — NUMBER — Foreign key → resume_info.jobs_id
  • applied_date — VARCHAR2(200)
  • status — VARCHAR2(50)

apply_status

  • status_id — number — Primary key
  • resume_id (resume_id2) — VARCHAR2(50) — Foreign key → resume_info.resume_id
  • status_name — VARCHAR2(200)

attached_data

  • file_id — NUMBER — Primary key
  • resume_id — VARCHAR2(50) — Foreign key → resume_info.resume_id
  • file_name — VARCHAR2(255)
  • original_file_name — VARCHAR2(255)
  • file_path — VARCHAR2(255)
  • file_extension — VARCHAR2(50)
  • file_size — VARCHAR2(255)
  • save_datetime — VARCHAR2(50)

career

  • car_id — NUMBER — Primary key
  • career_id — number
  • company_name — VARCHAR2(50)
  • department_name — VARCHAR2(50)
  • joined_date_of_company — varchar2(50)
  • resignation_date_of_company — VARCHAR2(50)
  • duty — VARCHAR2(255)
  • position — VARCHAR2(100)
  • details_of_work — VARCHAR2(4000)

certificate

  • cert_id — NUMBER — Primary key
  • certificate_id — NUMBER
  • sortation — VARCHAR2(50)
  • certificate_type — VARCHAR2(255)
  • certificate_level — VARCHAR2(255)
  • date_of_acquisition — VARCHAR2(50)
  • issuing_authority — VARCHAR2(255)
  • language — VARCHAR2(50)
  • test — VARCHAR2(50)
  • language_grade — VARCHAR2(50)

common_code_master

  • code_name — VARCHAR2(50)
  • group_code — VARCHAR2(50)
  • name — VARCHAR2(255)
  • description — VARCHAR2(4000)

company

  • company_id — NUMBER
  • company_name — VARCHAR2(255)

customer_faq

  • user_id (user_id2) — VARCHAR2(50) — Foreign key → job_customer.user_id
  • customer_faq_id — varchar2(50)
  • faq_title — varchar2(255)
  • faq_content — varchar2(4000)
  • faq_status — varchar2(50)

description

  • description_id — VARCHAR2(50) — Primary key
  • posting_id (posting_id2) — VARCHAR2(50) — Foreign key → job_posting.posting_id
  • creation_date — VARCHAR2(50)
  • assigned_task — VARCHAR2(4000)
  • requirements — VARCHAR2(4000)
  • preferential_treatment — VARCHAR2(4000)
  • screening_guide — VARCHAR2(4000)
  • work_form — VARCHAR2(4000)
  • work_place — VARCHAR2(4000)
  • working_hours — VARCHAR2(4000)
  • etc — VARCHAR2(4000)
  • submission_guide — VARCHAR2(4000)

education

  • edu_id — NUMBER — Primary key
  • academic_id — NUMBER
  • sortation — VARCHAR2(50)
  • school_name — VARCHAR2(255)
  • the_year_of_admission — VARCHAR2(255)
  • the_year_of_graduation — VARCHAR2(255)
  • major — VARCHAR2(255)
  • minor — VARCHAR2(255)
  • grade — VARCHAR2(50)
  • total_score — VARCHAR2(50)
  • graduation_status — VARCHAR2(50)

employee

  • employee_id — VARCHAR2(50) — Primary key
  • jobs_id (jobs_id2) — NUMBER — Foreign key → jobs.jobs_id
  • image_path — VARCHAR2(255)
  • name — VARCHAR2(100)
  • phone — VARCHAR2(20)
  • tel — VARCHAR2(20)
  • birth — VARCHAR2(200)
  • gender — VARCHAR2(6)
  • address — VARCHAR2(255)
  • hire_date — VARCHAR2(200)
  • resignation_date — VARCHAR2(200)
  • email — VARCHAR2(255)

faqs

  • faqs_id — VARCHAR2(50) — Primary key
  • category — VARCHAR2(50)
  • title — VARCHAR2(255)
  • content — VARCHAR2(4000)

job_customer

  • user_id — VARCHAR2(50) — Primary key
  • email — VARCHAR2(255)
  • password — VARCHAR2(50)
  • name — VARCHAR2(100)
  • birth — VARCHAR2(20)
  • phone — VARCHAR2(20)
  • created_date — VARCHAR2(200)
  • gender — VARCHAR2(10)
  • customer_status — VARCHAR2(10)

job_posting

  • posting_id — VARCHAR2(50) — Primary key
  • jobs_id (jobs_id2) — NUMBER — Foreign key → jobs.jobs_id
  • title — VARCHAR2(4000)
  • career_condition — VARCHAR2(4000)
  • employment_type — VARCHAR2(4000)
  • post_written_date — VARCHAR2(4000)
  • post_start_date — VARCHAR2(4000)
  • post_end_date — VARCHAR2(4000)
  • application_start — VARCHAR2(4000)
  • application_deadline — VARCHAR2(4000)
  • post_status — VARCHAR2(4000)
  • modify_date — VARCHAR2(4000)
  • admin_ID — VARCHAR2(4000)
  • question_1 — VARCHAR2(4000)
  • question_2 — VARCHAR2(4000)
  • question_3 — VARCHAR2(4000)

job_question

  • answer_id — NUMBER — Primary key
  • content1 — VARCHAR2(4000)
  • content2 — VARCHAR2(4000)
  • content3 — VARCHAR2(4000)

jobs

  • jobs_id — NUMBER — Primary key
  • jobs_name — VARCHAR2(100)
  • job_type — VARCHAR2(50)
  • jobs_level — NUMBER
  • jobs_pid — NUMBER

resume_info

  • resume_id — VARCHAR2(50) — Primary key
  • career_id (car_id) — NUMBER — Foreign key → career.car_id
  • academic_id (edu_id) — NUMBER — Foreign key → education.edu_id
  • certificate_id (cert_id) — NUMBER — Foreign key → certificate.cert_id
  • answer_id (answer_id2) — NUMBER — Foreign key → job_question.answer_id
  • user_id (user_id2) — VARCHAR2(50) — Foreign key → job_customer.user_id
  • posting_id (posting_id2) — VARCHAR2(50) — Foreign key → job_posting.posting_id
  • jobs_id (jobs_id2) — NUMBER — Foreign key → job_posting.jobs_id
  • support_path — VARCHAR2(255)
  • military_service_matters — VARCHAR2(255)
  • veterans_target_status — VARCHAR2(50)
  • disorder_status — VARCHAR2(255)
  • submission_status — VARCHAR2(50)
  • revision_date — VARCHAR2(200)

school

  • school_id — NUMBER
  • school_name — VARCHAR2(255)

scrap

  • scrap_id — varchar2(50) — Primary key
  • user_id (user_id2) — VARCHAR2(50) — Foreign key → job_customer.user_id
  • posting_id — varchar2(50)
  • scrap_status — varchar2(50)