ERD-Department&Employee
Tables (3)
Department (부서)
- id — varchar — Primary key — NOT NULL — 부서코드
- name — varhcar — 부서명
DepartmentMember (부서사원)
- departmentMemberId (department_member_id) — bigint — Primary key — NOT NULL — 인조키
- departmentId (department_id) — varchar — Foreign key → Department.id — NOT NULL — 부서코드
- employeeId (employee_id) — varchar — Foreign key → Employee.id — NOT NULL — 사번
Employee (사원)
- id — varchar — Primary key — NOT NULL — 사번
- name — varchar — 이름