coupon

Tables (5)

Coupon (coupon)

  • id (PK) — Long — Primary key — NOT NULL
  • Field
  • Field2

CouponCategory (coupon_category)

  • id (PK) — Long — Primary key — NOT NULL
  • name (Field) — String
  • createAt (Field2) — LocalDateTime
  • updatedAt (Field3) — LocalDateTime

CouponSendCode (coupon_send_code)

  • id (PK) — Long — Primary key — NOT NULL
  • category_id (FK) — Long — Foreign key → CouponCategory.id — NOT NULL
  • userPhoneId (FK2) — Long — Foreign key → CouponUserPhone.id — NOT NULL
  • user_id (FK3) — Long — Foreign key → User.Key — NOT NULL
  • coupon_id (FK4) — Long — Foreign key → Coupon.id — NOT NULL
  • couponCode (Field2) — String
  • createAt (Field3) — LocalDateTime
  • updatedAt (Field4) — LocalDateTime

CouponUserPhone (coupon_user_phone)

  • id (PK) — Long — Primary key — NOT NULL
  • categoryId (FK) — Long — Foreign key → CouponCategory.id — NOT NULL
  • phone (Field) — String
  • send (Field2) — Boolean
  • createdAt (Field4) — LocalDateTime
  • updatedAt (Field5) — LocalDateTime

User (user)

  • Key (PK) — Primary key — NOT NULL