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