Connect-Platform

Tables (3)

Coupon (쿠폰)

  • id (Key) — Long — Primary key — NOT NULL
  • code (Field) — String
  • type (Field2) — Enum
  • discountValue (Field3) — int
  • maxDiscountAmount (Field4) — Integer
  • expiresAt (Field5) — LocalDateTime
  • used (Field6) — boolean
  • memberId (Key2) — Long — Foreign key → Member.id — NOT NULL

Member (회원프로필)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • createdAt (Field2) — LocalDateTime
  • viewCount (Field3) — int
  • point (Field4) — int

Payment (결제정보)

  • id (Key) — Long — Primary key — NOT NULL
  • paymentKey (Field) — String
  • orderId (Field2) — String
  • chargeAmount (Field3) — int
  • paidAmount (Field4) — int
  • discountAmount (Field5) — int
  • paymentGateway (Field6) — Enum
  • memberId (Key2) — Long — Foreign key → Member.id — NOT NULL
  • CouponId (Key3) — Long — Foreign key → Coupon.id — NOT NULL