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)