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 (생성일)