ㄹㅇㅁㄹㅇㅁ

Tables (3)

Department (부서)

  • id (아이디) — varchar(255) — Primary key — NOT NULL
  • name (이름) — varchar(255)

Employee (직원)

  • id (아이디) — varcher(255) — Primary key — NOT NULL
  • name (이름) — varchar(255)

Employee-Department (직원-부서)

  • id (Key) — int — Primary key — NOT NULL
  • department_id (부서아이디) — varchar(255) — Foreign key → Department.id — NOT NULL
  • employee_id (직원아이디) — varcher(255) — Foreign key → Employee.id — NOT NULL