백업
테이블 (8)
admin
- admin_id — NOT — 기본 키 — NOT NULL
- admin_pwd — NOT — NOT NULL
- admin_grade — NULL
coupon
- coupon_code — NOT — 기본 키 — NOT NULL
- food_code (food_code2) — NOT — 외래 키 → food.food_code — NOT NULL
- coupon_name — NOT — NOT NULL
- coupon_startdate — NOT — NOT NULL
- coupon_enddate — NOT — NOT NULL
- coupon_costori — NOT — NOT NULL
- coupon_salerate — NOT — NOT NULL
- coupon_costsale — NOT — NOT NULL
- coupon_intro — NULL
- coupon_status — NULL
favorite
- food_code (food_code2) — NOT — 외래 키 → food.food_code — NOT NULL
- member_code (member_code2) — NOT — 외래 키 → member.member_code — NOT NULL
- favorite_date — NOT — NOT NULL
food
- food_code — NOT — 기본 키 — NOT NULL
- member_code (member_code2) — NOT — 외래 키 → member.member_code — NOT NULL
- food_name — NOT — NOT NULL
- food_addr — NOT — NOT NULL
- food_area — NULL
- food_phone — NOT — NOT NULL
- food_kind — NOT — NOT NULL
- food_menu — NULL
- food_time — NULL
- food_break — NULL
- food_intro — NULL
- food_date — NOT — NOT NULL
- food_read — NOT — NOT NULL
- food_status — NULL
- food_tag — NULL
image
- image_code — NOT — 기본 키 — NOT NULL
- refer_code — NOT — NOT NULL
- image_name — NOT — NOT NULL
- image_size — NOT — NOT NULL
- image_path — NOT — NOT NULL
member
- member_code — NOT — 기본 키 — NOT NULL
- member_date — NOT — NOT NULL
- member_mail — NOT — NOT NULL
- member_pwd — NOT — NOT NULL
- member_name — NOT — NOT NULL
- member_phone — NULL
- member_status — NULL
- member_kakao — NULL
purchase
- purchase_code — NOT — 기본 키 — NOT NULL
- coupon_code (coupon_code2) — NOT — 외래 키 → coupon.coupon_code — NOT NULL
- member_code (member_code2) — NOT — 외래 키 → member.member_code — NOT NULL
- purchase_date — NOT — NOT NULL
- purchase_cost — NOT — NOT NULL
- purchase_status — NULL
- purchase_phone — NOT — NOT NULL
review
- review_code — NOT — 기본 키 — NOT NULL
- food_code (food_code2) — NOT — 외래 키 → food.food_code — NOT NULL
- review_date — NOT — NOT NULL
- review_cont — NOT — NOT NULL
- review_score — NOT — NOT NULL