배달앱 찐 디비

테이블 (13)

Copy Of Untitled (reply)

  • Key (id) — 기본 키 — NOT NULL
  • Key (reivew_id) — 외래 키 → Untitled.Key — NOT NULL
  • Field (comment)
  • Field (create_at)
  • Field (update_at)
  • Field (delete_at)
  • Key (user_id) — 외래 키 → 회원.Key — NOT NULL
  • Key (store_id) — 외래 키 → Untitled.Key — NOT NULL

Copy Of Untitled2 (cart)

  • Key (user_id) — 외래 키 → 회원.Key — NOT NULL
  • Field (cartStatus)
  • Field (totlaPrice)
  • Field (updated_at)
  • Field (created_at)
  • Field (store_id)

Copy Of Untitled3 (cart_item)

  • Key (menu_id) — 외래 키 → Untitled.Key — NOT NULL
  • Field (photo)
  • Field (count)
  • Key (user_id) — 외래 키 → Copy Of Untitled2.Key — NOT NULL

Destination (Untitled4)

  • destination_id (Key) — 기본 키 — NOT NULL
  • name (Field)

Untitled (order)

  • Key (order_id) — 기본 키 — NOT NULL
  • Field (orderStatus)
  • Key (store_id) — 외래 키 → Untitled.Key — NOT NULL
  • Field (created_at)
  • Field (updated_at) — NOTNULL
  • Field (endTime)
  • Field2 (startTIme)
  • destination_id (Key) — 외래 키 → Destination.destination_id — NOT NULL

Untitled (store)

  • Key (store_id) — 기본 키 — NOT NULL
  • Field (name) — NOT NULL
  • Field (distance) — NOT NULL
  • Field (info) — NOT NULL
  • Field (grade)
  • Field (minOrderPrice) — NOTNULL
  • Field (storeImageUrl)
  • Field (businessLicense)
  • Key (owner_id) — 외래 키 → 회원.Key — NOT NULL
  • Field (created_at) — NOT NULL
  • Field (updated_at) — NOT NULL
  • Field (category)

Untitled (pay)

  • Key (id) — 기본 키 — NOT NULL
  • Field (pay_type)
  • Field (price)
  • Field (status)
  • Key (order_id) — 외래 키 → Untitled.Key — NOT NULL
  • Field (create_at)

Untitled (order_menu)

  • Key (menu_id) — 외래 키 → Untitled.Key — NOT NULL
  • Field (count)
  • Field (photo)
  • Key (order_id) — 외래 키 → Untitled.Key — NOT NULL

Untitled (menu)

  • Key (menu_id) — 기본 키 — NOT NULL
  • Field (name)
  • Field (price)
  • Field (imageUrl)
  • Field (created_at)
  • Field (updated_at) — NOT NULL
  • Key (store_id) — 외래 키 → Untitled.Key — NOT NULL
  • Field (visible)
  • Field (menuDetail)

Untitled (reivew)

  • Key (id) — 기본 키 — NOT NULL
  • Key (order_id) — 외래 키 → Untitled.Key — NOT NULL
  • Field (rating)
  • Field (comment)
  • Field (create_at)
  • Field (update_at)
  • Field (delete_at)
  • Field (photo)
  • Field (reply_count)
  • Key (user_id) — 외래 키 → 회원.Key — NOT NULL
  • Key (store_id) — 외래 키 → Untitled.Key — NOT NULL

도장판 (Untitled)

  • Key (sotre_id) — 외래 키 → Untitled.Key — NOT NULL
  • Key (member_id) — 외래 키 → 회원.Key — NOT NULL
  • Field (order_count) — NOTNULL
  • Field (service_count) — NOTNULL
  • Field (service) — NOTNULL

주차별 피드백 (Untitled3)

  • Key (store_id) — 외래 키 → Untitled.Key — NOT NULL
  • Field (star_average)
  • Field (feedback)

회원 (user)

  • Key (id) — 기본 키 — NOT NULL
  • Key (email) — NOT NULL
  • Field (password) — NOT NULL
  • Field (nickname) — NOTNULL
  • Field (address) — NOT NULL
  • Field (create_at) — NOT NULL
  • Field (updated_at) — NOT NULL
  • Field (delete_at)