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