company matching

Tables (8)

address

  • address_id — INT — Primary key — NOT NULL
  • city — VARCHAR(10)
  • district — VARCHAR(20)
  • street — VARCHAR(20)
  • latitude — DECIMAL
  • longitude — DECIMAL

career_history

  • record_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id
  • comp_id — INT — Foreign key → company.comp_id
  • startdate — DATE
  • enddate — DATE

company

  • comp_id — INT — Primary key
  • industry_id — INT — Foreign key → industry.industry_id — NOT NULL
  • comp_name — VARCHAR(20)

current_job

  • current_job_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id
  • comp_id — INT — Foreign key → company.comp_id
  • jobgroup_id — INT — Foreign key → jobgroup.jobgroup_id — NOT NULL

industry

  • industry_id (indusrty_id) — INT — Primary key — NOT NULL
  • industry_name — VARCHAR(20)

jobgroup

  • jobgroup_id — INT — Primary key — NOT NULL
  • jobgroup_name — VARCHAR(20)

tutor

  • tutor_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id
  • rating — DECIMAL

user

  • user_id — INT — Primary key
  • address_id — INT — Foreign key → address.address_id — NOT NULL
  • preferred_industry_id (preferred_indusrty_id) — INT — Foreign key → industry.industry_id — NOT NULL
  • preferred_jobgroup_id — INT — Foreign key → jobgroup.jobgroup_id — NOT NULL
  • name — VARCHAR(20)
  • gender — VARCHAR(2)
  • univ_name — VARCHAR(20) — NOT NULL
  • degree — VARCHAR(20)
  • toeic — INT
  • GPA — DECIMAL
  • certificate — INT
  • working_ysno — VARCHAR(2)