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