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