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)