QREcode

테이블 (7)

Coupon(쿠폰) (Untitled3)

  • idx (Key) — 기본 키 — NOT NULL
  • coupon_num (Field)
  • coupon_name (Field2)
  • coupon_discount_rate (Field3)
  • coupon_store_idx (Field4)
  • coupon_flyer_idx (Field5)

Flyer(전단지) (Untitled4)

  • idx (Key) — 기본 키 — NOT NULL
  • flyer_url (Field)
  • flyer_name (Field2)
  • flyer_tag (Field3)
  • flyer_qr_count (Field4)
  • flyer_store_name (Field5)
  • flyer_store_address (Field6)
  • flyer_store_phone (Field7)
  • flyer_store_start (Field8)
  • flyer_store_end (Field9)
  • flyer_store_idx (Field10)
  • flyer_scan_count (Field12)

Log(로그) (Untitled6)

  • idx (Key) — 기본 키 — NOT NULL
  • member_id (Field)
  • grade (Field2)
  • store_num (Field3)
  • flyer_url (Field4)
  • qr_num (Field5)
  • time_stamp (Field6)

Member(회원) (Untitled)

  • idx (Key) — 기본 키 — NOT NULL
  • member_id (Field)
  • member_password (Field2)
  • member_phone (Field3)
  • member_name (Field4)
  • member_point (Field5)
  • member_scan_count (Field6)
  • member_grade (Field7)
  • member_store_idx (Field8)

Point(포인트) (Untitled7)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

QR (Untitled5)

  • idx (Key) — 기본 키 — NOT NULL
  • qr_num (Field)
  • qr_scan_count (Field2)
  • qr_start (Field3)
  • qr_end (Field4)
  • qr_ptj_name (Field5)
  • qr_ptj_phone (Field8)
  • qr_flyer_idx (Field6)
  • qr_time_stamp (Field7)

Store(가게) (Untitled2)

  • idx (Key) — 기본 키 — NOT NULL
  • store_num (Key2) — 기본 키 — NOT NULL
  • store_name (Field)
  • store_phone (Field2)
  • store_address (Field3)
  • store_start (Field4)
  • store_end (Field5)
  • store_lat (Field6)
  • store_long (Field7)
  • store_tag (Field8)