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