연습문제
테이블 (4)
assignments
- assignment_id — int
- emp_id — int
- project_id — int
departments
- dept_id — int
- dept_name — varchar(255)
- location — varchar(255)
employees
- emp_id — int
- emp_name — varchar(10) — NOT NULL
- hire_date — date — NOT NULL
- salary — int — NOT NULL
- dept_id — int
- check — (salary > 0)
projects
- project_id — int
- project_name — varchar(10) — NOT NULL
- start_date — DATE
- end_date — DATE