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