패스파인더해커톤
테이블 (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)