Personal Project

Tables (5)

Card (CARD)

  • Key (SID) — int — Primary key — NOT NULL
  • money (돈) — long
  • Card_number (카드번호) — long
  • cvc (CVC) — int
  • password (비밀번호) — long
  • name (이름) — Varchar

Coupon

  • Key (SID) — int — Primary key — NOT NULL
  • money (돈) — long
  • Coupon_number (쿠폰번호) — long
  • coupon_stamp (이벤트) — Varchar
  • name (이름) — Varchar

Log

  • Key (Tid) — long — Primary key — NOT NULL
  • money (돈) — long
  • how (구매수단) — Varchar
  • time (구매시간) — datetime

Login

  • ID (아이디) — Varchar — Primary key — NOT NULL
  • Salt — Varchar
  • HashPW (해시비밀번호) — Varchar
  • Permission (유저/관리자) — Varchar

Seat

  • Key (Tid) — long — Primary key — NOT NULL
  • Seat_bool (앉기 가능 여부) — bool
  • Ticket_money (티켓 가격) — long
  • time (결제 시간) — datetime