payment

Tables (3)

Member (Untitled)

  • memberId (Key) — Primary key — NOT NULL

Order (이건 toss api에서 주는값들을 대부문 넣는여역 orderidmemberid제외)

  • orderId (Key) — Primary key — NOT NULL
  • memberId (Key2) — Foreign key → Member.memberId — NOT NULL
  • paymentKey (Field)
  • balanceAmount (Field9)
  • 부문결제가능여부 (Field4)
  • orderName (Field2)
  • ispartialCancleAble (Field3)

orderlog (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • orderId (Key2) — Foreign key → Order.orderId — NOT NULL
  • memberId (Key22) — Foreign key → Order.memberId — NOT NULL
  • status (Field)
  • requestAt (Field2)
  • approveAt (Field3)
  • amount (Field4)
  • type (Field5)
  • cancleAt (Field6)