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