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