1

테이블 (13)

Address

  • address_id — INT — 기본 키 — NOT NULL
  • address_name — VARCHAR(10)
  • address — VARCHAR(80) — NOT NULL
  • user_id — INT — 외래 키 → User.user_id — NOT NULL
  • isCurrentAddress — TINYINT(1) — NOT NULL
  • address_code — INT — NOT NULL

Category

  • category_id — INT — 기본 키 — NOT NULL
  • category_name — VARCHAR(20) — NOT NULL
  • category_image — TEXT — NOT NULL

Delivery

  • delivery_id — INT — 기본 키 — NOT NULL
  • delivery_start_time — TIMESTAMP — NOT NULL
  • delivery_end_time — TIMESTAMP
  • store_id — INT — 외래 키 → 배달팁.store_id — NOT NULL
  • user_id — INT — 외래 키 → User.user_id — NOT NULL
  • order_id — INT — 외래 키 → 주문.order_id — NOT NULL

Like

  • user_id — INT — 외래 키 → User.user_id — NOT NULL
  • store_id — INT — 외래 키 → Store.store_id — NOT NULL
  • date — TIMESTAMP — NOT NULL

Menu

  • menu_id — INT — 기본 키 — NOT NULL
  • menu_name — VARCHAR(20) — NOT NULL
  • price — INT — NOT NULL
  • menu_picture_url — TEXT
  • store_id — INT — 외래 키 → Store.store_id — NOT NULL

Review

  • user_id — INT — 외래 키 → User.user_id — NOT NULL
  • store_id — INT — 외래 키 → Store.store_id — NOT NULL
  • rating — INT — NOT NULL
  • review — TEXT
  • review_picture_url — TEXT
  • review_datetime — TIMESTAMP — NOT NULL
  • isLocked — TINYINT(1) — NOT NULL
  • menu_id — INT — 외래 키 → Menu.menu_id — NOT NULL

Store

  • store_id — INT — 기본 키 — NOT NULL
  • store_name — VARCHAR(20) — NOT NULL
  • store_address — VARCHAR(50) — NOT NULL
  • store_picture_url — TEXT
  • address_code — INT — NOT NULL

StoreCategory

  • store_id — INT — 외래 키 → Store.store_id — NOT NULL
  • category_id — INT — 외래 키 → Category.category_id — NOT NULL

User

  • user_id — INT — 기본 키 — NOT NULL
  • user_name — VARCHAR(10) — NOT NULL
  • nickname — VARCHAR(20) — NOT NULL
  • review_num — INT — NOT NULL
  • rating_average — DOUBLE — NOT NULL

배달팁 (DeliveryTip)

  • store_id — INT — 외래 키 → Store.store_id — NOT NULL
  • delievery_tip — INT — NOT NULL
  • minimum_order — INT — NOT NULL
  • maximum_order — INT

주문 (Order)

  • order_id — INT — 기본 키 — NOT NULL
  • order_datetime — TIMESTAMP — NOT NULL
  • order_status — VARCHAR(20) — NOT NULL
  • payment_info — VARCHAR(80) — NOT NULL
  • request_notes — VARCHAR(50)
  • user_id — INT — 외래 키 → User.user_id — NOT NULL
  • store_id — INT — 외래 키 → Store.store_id — NOT NULL

주문에 담긴 메뉴 (OrderMenu)

  • order_id — INT — 외래 키 → 주문.order_id — NOT NULL
  • menu_id — INT — 외래 키 → Menu.menu_id — NOT NULL
  • quantity — INT — NOT NULL

쿠폰 (Coupon)

  • coupon_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → User.user_id — NOT NULL
  • store_id — INT — 외래 키 → Store.store_id — NOT NULL
  • coupon_name — VARCHAR(50) — NOT NULL
  • discount — INT — NOT NULL
  • isRatio — TINYINT(1) — NOT NULL
  • order_id — INT — 외래 키 → 주문.order_id