패스파인더해커톤

테이블 (4)

Coupon (coupon)

  • coupon_id (couponId) — 기본 키 — NOT NULL
  • event_id (eventId) — 외래 키 → Event.event_id — NOT NULL
  • user_id (userId) — 외래 키 — NOT NULL
  • coupon_name (couponName)
  • is_userd (isUsed)
  • created_date (createdDate)
  • updated_date (updatedDate)

Event (event)

  • event_id (eventId) — 기본 키 — NOT NULL
  • event_name (eventName)
  • created_time (createdTime)
  • updated_time (updatedTime)
  • Field

ReceivedCoupon (receivedCoupon)

  • receivedCoupon_id (receivedCouponId) — 기본 키 — NOT NULL
  • user_id (userId) — 외래 키 → User.user_id — NOT NULL
  • receivedCoupon_name (receivedCouponName)
  • is_used (isUsed)
  • created_date (createdDate)
  • updated_date (updatedDate)

User (user)

  • user_id (userId) — 기본 키 — NOT NULL
  • user_name (useName)
  • grape_count (grapeCount)
  • created_time (createdTime)
  • updated_time (updatedTIme)