연습문제3
테이블 (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)