Matching

Tables (7)

address

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

career_hitory (career_history)

  • Key (record_ID) — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id
  • Field (from) — DATE
  • Field2 (to) — DATE
  • Field

company

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

industry (Untitled5)

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

jobgroup (Untitled6)

  • jobgroup_id (Key) — INT — Primary key — NOT NULL
  • jobgroup_name (Field) — 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
  • name — VARCHAR(20)
  • gender — BOOLEAN
  • univ_name — VARCHAR(20) — NOT NULL
  • degree — VARCHAR(20)
  • toeic — INT
  • GPA — DECIMAL
  • certificate — INT
  • working_ysno — BOOLEAN