NEW

Tables (4)

Coupon (Untitled)

  • id (Key) — PK — Primary key — NOT NULL
  • coupon_types (Field) — char
  • is_target (Field10) — boolean
  • coupon_code (Field2) — char
  • coupon_name (Field9) — char
  • points (Field3) — float
  • valid_from (Field4) — dateTime
  • valid_until (Field5) — dateTime
  • description (Field6) — text
  • created_at (Field7) — dateTime
  • updated_at (Field8) — dateTime
  • used_date (Field11) — dateTime
  • deleted (Field12) — boolean

Coupon Manager (Untitled4)

  • id (Key) — PK — Primary key — NOT NULL
  • user_id (Key2) — FK — Foreign key → User.id — NOT NULL
  • coupon_id (Key4) — PK — Foreign key → Coupon.id — NOT NULL
  • donation (Key3) — Foreign key → User.id — NOT NULL
  • created_at (Field)
  • upadated_at (Field2)

UnmatchedCoupon (unique)

  • coupon_id (Field) — FK
  • coupon_code (Field2) — pk
  • is_used (Field3) — boolean
  • created_at (Field4)
  • updated_at (Field5)

User (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • email (Field5) — char
  • password (Field8)
  • name (Field2) — char
  • tel (Field4) — char
  • co_tel (Field)
  • manager_name (Field3)
  • manager_tel (Field6) — deciaml
  • registration_num (Field7)
  • co_registration_num (Field9)
  • zip_code (Field10)
  • street_name (Field11)
  • lot_name (Field12)
  • detailed_addr (Field13)
  • subscribe_email (Field14)
  • subscribe_kakao (Field15)
  • subscribe_sms (Field16)
  • sms_notification (Field17)
  • now_point (Field18)
  • now_balance (Field19)
  • user_recommend (Field20)
  • subscription (Field21)
  • grade (Field22)
  • created_at (Field23)
  • level (Field24)
  • blocked_email (Field25)
  • blocked_time (Field26)
  • login_count (Field27)
  • deleted (Field28)
  • social_id (Field29)