jobaboso

Tables (26)

activities

  • id — int — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → personalusers.user_id — NOT NULL
  • type — enum('contest','club','intern')
  • title — varchar(30)
  • detail — varchar(300)
  • date — date

application_documents

  • id — int — Primary key — NOT NULL
  • application_id — int — Foreign key → company_applications.id — NOT NULL
  • document_type — enum('resume','cover_letter','portfolio','certificate','other') — NOT NULL
  • file_name — varchar(255) — NOT NULL
  • file_path — varchar(500) — NOT NULL
  • file_size — int
  • original_name — varchar(255)
  • uploaded_at — datetime

application_events

  • id — int — Primary key — NOT NULL
  • event_type — varchar(20)
  • event_date — date
  • memo — varchar(255)
  • application_id — int

application_files

  • id — int — Primary key — NOT NULL
  • file_type — varchar(20)
  • file_path — varchar(255)
  • application_id — int

application_schedules

  • id — int — Primary key — NOT NULL
  • application_id — int — Foreign key → company_applications.id — NOT NULL
  • schedule_type — enum('document_deadline','document_result_announcement','test_date','test_result_announcement','assignment_deadline','interview_date','interview_result_announcement','final_result_announcement') — NOT NULL
  • start_date — datetime — NOT NULL
  • end_date — datetime — NOT NULL
  • notes — text
  • is_completed — tinyint(1)
  • created_at — datetime
  • updated_at — datetime

career_challenges

  • id — int — Primary key — NOT NULL
  • type — varchar(30) — NOT NULL
  • description — varchar(100) — NOT NULL
  • is_quiz — tinyint(1)
  • quiz_answer — varchar(255)
  • created_at — datetime

certificates

  • id — int — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → personalusers.user_id — NOT NULL
  • cert_name — varchar(20)
  • score — varchar(20)
  • date — date

community_comments

  • id — int — Primary key — NOT NULL
  • post_id — int — Foreign key → community_posts.id — NOT NULL
  • user_id — varchar(20) — NOT NULL
  • parent_id — int
  • content — text — NOT NULL
  • is_secret — tinyint(1)
  • created_at — datetime

community_post_tags

  • id — int — Primary key — NOT NULL
  • post_id — int — Foreign key → community_posts.id — NOT NULL
  • tag — varchar(30) — NOT NULL

community_posts

  • id — int — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → personalusers.user_id — NOT NULL
  • category — varchar(20) — NOT NULL
  • title — varchar(100) — NOT NULL
  • content — text — NOT NULL
  • status — varchar(20)
  • created_at — datetime

companies

  • id — int — Primary key — NOT NULL
  • company_type — varchar(30)
  • registration_name — varchar(100)
  • company_name — varchar(30)
  • company_address — varchar(200)
  • business_license_no — varchar(50)
  • is_partner — tinyint(1)

company_applications

  • id — int — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → personalusers.user_id — NOT NULL
  • company_name — varchar(100) — NOT NULL
  • position — varchar(100) — NOT NULL
  • application_date — datetime — NOT NULL
  • status — enum('preparing_documents','documents_submitted','documents_under_review','documents_passed','documents_failed','preparing_test','test_completed','test_under_review','test_passed','test_failed','preparing_assignment','assignment_submitted','assignment_under_review','assignment_passed','assignment_failed','preparing_interview','interview_completed','interview_under_review','interview_passed','interview_failed','final_accepted','final_rejected','offer_declined')
  • created_at — datetime
  • updated_at — datetime

company_contents

  • id — int — Primary key — NOT NULL
  • company_id — int — Foreign key → companies.id — NOT NULL
  • title — varchar(100) — NOT NULL
  • body — text — NOT NULL
  • file_addr — varchar(255)
  • youtube_url — varchar(255)
  • hashtags — varchar(255)
  • content_type — varchar(30)
  • created_at — datetime

company_likes_personal

  • id — int — Primary key — NOT NULL
  • company_id — int — Foreign key → companies.id — NOT NULL
  • user_id — varchar(20) — Foreign key → personalusers.user_id — NOT NULL
  • message — text — NOT NULL
  • contact_email — varchar(100)
  • contact_phone — varchar(30)
  • suggested_position — varchar(50)
  • company_name — varchar(30)
  • hr_manager_name — varchar(50)
  • created_at — datetime

company_users

  • id — int — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → users.user_id — NOT NULL
  • company_id — int — Foreign key → companies.id — NOT NULL

educations

  • user_id — varchar(20) — Foreign key → personalusers.user_id — NOT NULL
  • school_name — varchar(20)
  • major — varchar(20)
  • admission_year — date
  • graduation_year — date
  • status — varchar(10)
  • score — float

hopes

  • id — int — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → users.user_id — NOT NULL
  • company — varchar(20)
  • job — varchar(30)
  • region — varchar(20)

interview_questions

  • id — int — Primary key — NOT NULL
  • job_review_id — int — Foreign key → job_reviews.id — NOT NULL
  • question — text — NOT NULL
  • created_at — datetime

job_positions

  • id — int — Primary key — NOT NULL
  • job_review_id — int — Foreign key → job_reviews.id — NOT NULL
  • position — varchar(100) — NOT NULL
  • created_at — datetime

job_reviews

  • id — int — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → personalusers.user_id — NOT NULL
  • application_id — int — Foreign key → company_applications.id
  • company_name — varchar(100) — NOT NULL
  • experience_level — enum('entry','experienced') — NOT NULL
  • interview_date — date — NOT NULL
  • overall_evaluation — enum('positive','neutral','negative') — NOT NULL
  • difficulty — enum('easy','medium','hard') — NOT NULL
  • interview_review — text — NOT NULL
  • final_result — enum('final_pass','second_pass','first_pass','fail') — NOT NULL
  • created_at — datetime
  • updated_at — datetime

personalusers

  • id — int — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → users.user_id — NOT NULL
  • birth_date — date
  • gender — char(1)
  • profile_addr — varchar(300)
  • privacy_consent — tinyint(1) — NOT NULL

projects

  • id — int — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → users.user_id — NOT NULL
  • project_name — varchar(20)
  • description — varchar(300)
  • start_date — date
  • end_date — date

skills

  • id — int — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → users.user_id — NOT NULL
  • skill_name — varchar(20)

university_staff

  • id — int — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → users.user_id — NOT NULL
  • univ_name — varchar(20)
  • Field — varchar(255)

user_challenge_histories

  • id — int — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → personalusers.user_id — NOT NULL
  • challenge_id — int — Foreign key → career_challenges.id — NOT NULL
  • challenge_date — date — NOT NULL
  • user_answer — text
  • is_completed — tinyint(1)
  • is_correct — tinyint(1)

users

  • id — int — Primary key — NOT NULL
  • user_id — varchar(20) — NOT NULL
  • password — varchar(255)
  • user_type — enum('personal','company','university_staff')
  • name — varchar(50)
  • phone — varchar(20)
  • email — varchar(100)
  • points — int — NOT NULL