Nhn-Department

Tables (3)

Copy Of Employees (Departments)

  • Key (department_code) — varchar(255) — Primary key — NOT NULL
  • Field (name) — varchar(255)

Employees

  • Key (employee_num) — int — Primary key — NOT NULL
  • Field (name) — varchar(255)

Untitled (Employee_In_Department)

  • Key (employee_in_department_id) — int — Primary key — NOT NULL
  • Key (employee_num) — int — Foreign key → Employees.Key — NOT NULL
  • Key (department_code) — varchar(255) — Foreign key → Copy Of Employees.Key — NOT NULL