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