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