department

Tables (3)

department (부서)

  • id (.) — Long — Primary key — NOT NULL
  • name (부서이름) — String
  • department_id (부서코드)

employee (사원)

  • id (.) — Long — Primary key — NOT NULL
  • name (이름) — String
  • employee_id (사번)

employee-department (사원-부서관계)

  • employee-department id (employee_id + department_id 복합키) — Long — Primary key — NOT NULL
  • employee_id (사번) — String — Foreign key → employee.id — NOT NULL
  • department_id (부서코드) — String — Foreign key → department.id — NOT NULL