배달앱

테이블 (7)

MEMBER (Member)

  • 회원id (member_id) — BIGINT — 기본 키 — NOT NULL
  • Field (email) — varchar(255)
  • Field2 (username) — varchar(255)
  • Field3 (nickname) — varchar(255)
  • Field4 (password) — varchar(255)
  • Field5 (role) — varchar(255)
  • Field6 (deActive) — tinyint
  • Field7 (address) — varchar(255)
  • Field8 (phone) — varchar(255)

Menu

  • id — BIGINT — 기본 키 — NOT NULL
  • Field (name) — varchar(255)
  • Field2 (price) — int
  • Field3 (description) — varchar(255)
  • Field4 (status) — varchar(255)
  • 가게id (store_id) — BIGINT — 외래 키 → Store.가게id — NOT NULL

ORDER (Order)

  • id — BIGINT — 기본 키 — NOT NULL
  • Field (details) — varchar(255)
  • Field2 (status) — varchar(255)
  • Field3 (total_price) — int
  • 가게id (store_id) — BIGINT — 외래 키 → Store.가게id — NOT NULL
  • 회원id (member_id) — BIGINT — 외래 키 → MEMBER.회원id — NOT NULL

Order_Menu

  • id — BIGINT — 기본 키 — NOT NULL
  • Field (quantity)
  • Field2 (price)
  • id (menu_id) — BIGINT — 외래 키 → Menu.id — NOT NULL
  • id (order_id) — BIGINT — 외래 키 → ORDER.id — NOT NULL

Review

  • id — BIGINT — 기본 키 — NOT NULL
  • Field (score) — int
  • Field2 (comment) — varchar(255)
  • Field3 (member_nickname) — varchar(255)
  • 가게id (store_id) — BIGINT — 외래 키 → Store.가게id — NOT NULL
  • 회원id (member_id) — BIGINT — 외래 키 → MEMBER.회원id — NOT NULL

Store

  • 가게id (store_id) — BIGINT — 기본 키 — NOT NULL
  • Field (name) — varchar(255)
  • Field (open_time) — DATETIME
  • Field2 (close_time) — DATETIME
  • Field3 (min_price) — int
  • Field4 (category) — varchar(255)
  • Field5 (address) — varchar(255)
  • Field6 (license) — varchar(255)
  • Field7 (togo) — tinyint
  • Field8 (status) — varchar(255)
  • 회원id (member_id) — BIGINT — 외래 키 → MEMBER.회원id — NOT NULL

Timestamped

  • created_at — DATETIME
  • updated_at — DATETIME