백업

테이블 (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