nhn-academy-exam-department-student
Tables (3)
Department (부서)
- department-code (부서코드) — VARCHAR — Primary key — NOT NULL
- department_name (부서) — VARCHAR
Employee (사원)
- employee_id (사번) — BIGINT — Primary key — NOT NULL
- name (이름) — VARCHAR
EmployeeDepartment (사원부서)
- employee_id (사번) — BIGINT — Foreign key → Employee.employee_id — NOT NULL
- department-code (부서코드) — VARCHAR — Foreign key → Department.department-code — NOT NULL