123
Tables (4)
assignments
- assignment_id — int — Primary key — NOT NULL
- emp_id — int
- project_id — int
departments
- dept_id — int — Primary key — NOT NULL
- dept_name — varchar(255)
- location — varchar(255)
employees
- emp_id — int — Primary key — NOT NULL
- emp_name — varchar(255) — NOT NULL
- hire_date — date — NOT NULL
- salary — int — NOT NULL
- dept_id — int — Foreign key → departments.dept_id
projects
- project_id — int — Primary key — NOT NULL
- project_name — varchar(255) — NOT NULL
- start_date — date
- end_date — date