Department

Tables (3)

department (Untitled2)

  • department_id (Key) — varchar(10) — Primary key — NOT NULL
  • department_name (Field) — varchar(10)

department_employee (Untitled3)

  • department_employee_id (Key3) — Long — Primary key — NOT NULL
  • employee_id (Key) — Long — Foreign key → employee.employee_id — NOT NULL
  • department_id (Key2) — varchar(10) — Foreign key → department.department_id — NOT NULL

employee (emplyee)

  • employee_id (Key) — Long — Primary key — NOT NULL
  • employee_name (Field) — varchar(10)