final

Tables (3)

branch (지점)

  • branch_no (지점번호) — Primary key — NOT NULL
  • branch_name (지점이름)

emp (직원)

  • emp_no (직원번호) — int — Primary key — NOT NULL
  • branch_no (지점번호) — Foreign key → branch.branch_no — NOT NULL
  • emp_id (직원아이디) — varchar(15) — NOT NULL
  • emp_pw (직원PW) — varchar(10) — NOT NULL
  • emp_name (직원이름)
  • emp_hiredate (입사일)
  • emp_position (포지션(level))

emp_pw_history (직원 비밀번호 이력)

  • emp_pw_history_no (이력번호) — Primary key — NOT NULL
  • emp_no (직원번호) — int — Foreign key → emp.emp_no — NOT NULL
  • branch_no (지점번호) — Foreign key → emp.branch_no — NOT NULL
  • emp_pw (직원PW)
  • createdate (생성일)