Ticket & Payment
Tables (3)
PAYMENT (결제원장)
- PAYMENT_KEY (결제 고유번호) — VARCHAR — Primary key — NOT NULL
- USER_ID (사용자_KEY) — NUMBER
- MONEY (금액) — NUMBER
- CREATED_AT (생성일자) — VARCHAR
PAYMENT_HISTORY (결제원장_내역)
- STATUS (상태) — VARCHAR — Primary key — NOT NULL
- PAYMENT_KEY (결제 고유번호) — VARCHAR — Foreign key → PAYMENT.PAYMENT_KEY — NOT NULL
- CREATED_AT (생성일자) — VARCHAR
TICKET (티켓)
- ID (Key) — NUMBER — Primary key — NOT NULL
- TICKET_KEY (티켓 고유번호) — VARCHAR
- PAYMENT_KEY (결제 고유번호) — VARCHAR — NOT NULL
- Field