hodoo

Tables (7)

Reserve_log (Untitled6)

  • reserve_log_id (Key) — Primary key — NOT NULL
  • reserve_id (Key2) — Foreign key → Reserves.reserve_id — NOT NULL
  • 적립금 (Field)
  • DATE (Field2)
  • STATUS (Field3)

Reserves (적립금테이블)

  • reserve_id (Key) — Primary key — NOT NULL
  • account_id (Key2) — Foreign key → account.account_id — NOT NULL
  • reserve_point (Field)

account (Untitled)

  • account_id (Key) — Primary key — NOT NULL
  • login_id (Field)
  • password (Field2)
  • Field3
  • Field4
  • Field5

coupon (Untitled5)

  • coupon_id (Key2) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

coupon_code (Untitled3)

  • coupon_code (Key) — Primary key — NOT NULL
  • coupon_id (Key2) — Foreign key → coupon.coupon_id — NOT NULL
  • Field
  • Field2
  • Field3

subscription (Untitled4)

  • start_date (Key) — Primary key — NOT NULL
  • end_date (Key3) — Primary key — NOT NULL
  • coupon_code (Key2) — Foreign key → coupon_code.coupon_code — NOT NULL
  • coupon_id (Key22) — Foreign key → coupon_code.coupon_id — NOT NULL
  • Field
  • Field2

user_coupon_code (Untitled2)

  • account_id (Key) — Foreign key → account.account_id — NOT NULL
  • coupon_id (Key22) — Foreign key → coupon_code.coupon_id — NOT NULL
  • Field
  • Field2
  • Field3