Job Break

job break ERD

Tables (4)

Untitled (User)

  • Key (user_id) — VARCHAR(100) — Primary key — NOT NULL
  • Field (user_name) — VARCHAR(255)
  • Field (user_password) — VARCHAR(255)
  • Field (email) — VARCHAR(100)
  • Field (phone) — VARCHAR(20)

Untitled (Company Notice)

  • Key (company_id) — INT(11) — Primary key — NOT NULL
  • Field (company_name) — VARCHAR(100)
  • Field (start_date) — CHAR(8)
  • Field (end_date) — CHAR(8)
  • Field (company_size) — INT(10)
  • Key (user_id) — VARCHAR(100) — Foreign key → Untitled.Key — NOT NULL

Untitled (Coding Test)

  • Key (solve_id) — INT(11) — Primary key — NOT NULL
  • Key (company_id) — INT(11) — Foreign key → Untitled.Key — NOT NULL
  • Field (type) — VARCHAR(100)
  • Field (link) — VARCHAR(255)

Untitled (Interview)

  • Key (interview_id) — INT(11) — Primary key — NOT NULL
  • Key (company_id) — INT(11) — Foreign key → Untitled.Key — NOT NULL
  • Field (interview_question) — VARCHAR(255)
  • Field (answer) — VARCHAR(255)
  • Field (interview_kinds) — INT(11)