배달앱 찐 디비
테이블 (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)