배달의 민족 연습
테이블 (7)
Untitled (menu)
- Key (menu_id) — bigint(20) — 기본 키 — NOT NULL
- Key (store_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (category) — varchar(50)
- Field (name) — varchar(100)
- Field (price) — decimal
- Field (status) — varchar(50)
Untitled (store)
- Key (store_id) — bigint(20) — 기본 키 — NOT NULL
- Field (name) — varchar(200)
- Field (type) — int(1)
- Field (address) — varchar(255)
- Field (phone) — varchar(20)
- Field (rating) — int
- Field (operationHours) — int
- Field (least_order_price) — decimal
- Field (status) — varchar(50)
Untitled (cart)
- Key (cart_id) — bigint(20) — 기본 키 — NOT NULL
- Key (menu_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (store_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (order_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (user_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (quantity) — int — NOT NULL
- Field (status) — varchar(50)
Untitled (order)
- Key (order_id) — bigint(20) — 기본 키 — NOT NULL
- Key (user_id) — bigint(20) — 외래 키 → 회원.Key — NOT NULL
- Field (status) — varchar(50)
- Field (payment) — varchar(255)
- Key (store_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (review)
- Key (review_id) — bigint(20) — 기본 키 — NOT NULL
- Key (store_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (rating) — int
- Field (content) — varchar(255)
- Field (status) — varchar(50)
Untitled (option)
- Key (option_id) — bigint(20) — 기본 키 — NOT NULL
- Key (menu_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (store_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — varchar(100)
- Field (is_checked) — boolean
회원 (user)
- Key (user_id) — bigint(20) — 기본 키 — NOT NULL
- Field (password) — varchar(255)
- Field (name) — varchar(100)
- Field (phone) — varchar(11)
- Field (email) — varchar(100)
- Field (grade) — varchar(100)
- Field (address) — varchar(100)
- Field (createAt) — timestamp
- Field (status) — varchar(50)
- Field (role) — varchar(50)