nhnExamDepartment

Tables (3)

Department (부서)

  • depart_code (부서코드) — VARCHAR(20) — Primary key — NOT NULL
  • depart_name (부서이름) — VARCHAR(20)

Employee (사원)

  • employee_id (사번) — VARCHAR(20) — Primary key — NOT NULL
  • employee_name (이름) — VARCHAR(20)
  • Field

Employee_Department (사원_부서)

  • employee_id (사번) — VARCHAR(20) — Foreign key → Employee.employee_id — NOT NULL
  • depart_code (부서코드) — VARCHAR(20) — Foreign key → Department.depart_code — NOT NULL