Coupon
Tables (4)
Category_coupon (Untitled7)
- category_coupon_id (Key) — Primary key — NOT NULL
- coupon_id (Key3) — long — Foreign key → Coupon.coupon_id — NOT NULL
Coupon (Untitled)
- coupon_id (Key) — long — Primary key — NOT NULL
- coupon_name (Field5) — String
- discount_amount (Field) — int
- coupon_valid (Field2) — LocalDateTime
Coupon_Book (Untitled5)
- coupon_book_id (Key) — Primary key — NOT NULL
- coupon_id (Key3) — long — Foreign key → Coupon.coupon_id — NOT NULL
Coupon_User (Untitled2)
- coupon_user_id (Key) — Primary key — NOT NULL
- coupon_created_at (Field2) — LocalDateTime
- coupon_id (Key3) — long — Foreign key → Coupon.coupon_id — NOT NULL
- coupon_expiry_date (Field) — LocalDateTime
- used (Field3) — boolean