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