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 — 이름