연습문제

테이블 (4)

assignments

  • assignment_id — INT
  • emp_id — INT — 외래 키 → employees.emp_id
  • project_id — INT — 외래 키 → projects.project_id

departments

  • dept_id — INT
  • dept_name — VARCHAR(255) — NOT NULL
  • location — VARCHAR(255)

employees

  • emp_id — INT
  • emp_name — VARCHAR(255) — NOT NULL
  • hire_date — DATE — NOT NULL
  • salary — INT — NOT NULL
  • dept_id — INT — 외래 키 → departments.dept_id

projects

  • project_id — INT
  • project_name — VARCHAR(255) — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • CHECK — (end_date IS NULL OR end_date > start_date)