1
Tables (3)
Untitled (user)
- Key (사번) — VARCHAR(50) — Primary key — NOT NULL
- Field3 (전화번호) — CHAR(50) — Primary key
- Field (이름) — CHAR(50)
- Field2 (재직상태) — CHAR(50)
- Field4 (전체 포인트) — INT(11)
- Field5 (사용 포인트) — INT(11)
- Field6 (현재 포인트) — INT(11)
- Field7 (최근결제일) — DATETME
- Field (입사일자) — DATE
- Field (퇴사일자) — DATE
Untitled (menu)
- Key (품목번호) — INT — Primary key — NOT NULL
- Field (품목명) — CHAR
- Field (금액) — INT
Untitled (order)
- Key (주문번호) — INT — Primary key — NOT NULL
- Field3 (전화번호) — CHAR(50) — Foreign key → Untitled.Field3
- Key (품목번호) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (결제수량) — INT
- Field (결제금액) — INT
- Field (결제시간) — DATETIME