Coopon

Tables (3)

Coopon (Untitled)

  • id — UUID — Primary key — NOT NULL
  • type — VARCHAR(10)
  • expiredDate (expdate) — TIMESTAMP
  • uid

User (Untitled2)

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(10) — NOT NULL
  • account — VARCHAR(20) — NOT NULL
  • password — VARCHAR(20) — NOT NULL
  • checked — BOOLEAN — NOT NULL

UserCoupon (Untitled3)

  • user_id — Primary key — NOT NULL
  • coupon_id — Primary key — NOT NULL
  • Field