asd

Tables (3)

department_details (부서-사원)

  • department_id (부서 코드) — VARCHAR — Foreign key → departments.department_id — NOT NULL
  • member_serial_number (사원 식별자) — INT — Foreign key → members.member_serial_number — NOT NULL

departments (부서)

  • department_id (부서 코드) — VARCHAR — Primary key — NOT NULL
  • department_name (부서 이름) — VARCHAR

members (사원)

  • member_serial_number (사원 식별자) — INT — Primary key — NOT NULL
  • member_name (사원 이름) — VARCHAR