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)