kuit_week9
Tables (8)
Address (주소)
- PK (address_id) — NOT NULL — Primary key — NOT NULL
- Field2 (address) — NOTNULL
- Field3 (createdDate) — NOTNULL
- Field4 (modifiedDate) — NOTNULL
- PK (member_id) — NOT NULL — Foreign key → Member.PK — NOT NULL
Like (찜)
- PK (member_id) — NOT NULL — Foreign key → Member.PK — NOT NULL
- PK (store_id) — NOT NULL — Foreign key → Store.PK — NOT NULL
- Field3 (createdDate) — NOTNULL
- Field4 (modifiedDate) — NOTNULL
- Field5 (status) — NOT NULL
Member (회원)
- PK (member_id) — NOT NULL — Primary key — NOT NULL
- Field (password) — NOT NULL
- Field2 (nickname) — NOT NULL
- Field3 (phone) — NOT NULL
- Field4 (role) — NOT NULL
- Field5 (createdDate) — NOTNULL
- Field (modifiedDate) — NOTNULL
- Field (grade) — NOT NULL
Menu (메뉴)
- PK (menu_id) — NOTNULL — Primary key — NOT NULL
- Field2 (category) — NOT NULL
- Field3 (name) — NOT NULL
- Field4 (price) — NOT NULL
- Field (createdDate) — NOTNULL
- Field (modifiedDate) — NOTNULL
- Field (status) — NOT NULL
- PK (store_id) — NOT NULL — Foreign key → Store.PK — NOT NULL
Order (주문)
- PK (order_id) — NOTNULL — Primary key — NOT NULL
- Field3 (payment) — NOT NULL
- Field4 (request) — NOT NULL
- Field5 (createdDate) — NOTNULL
- Field (modifiedDate) — NOTNULL
- Field (totalPrice) — NOTNULL
- Field (status) — NOT NULL
- PK (member_id) — NOT NULL — Foreign key → Member.PK — NOT NULL
- PK (store_id) — NOT NULL — Foreign key → Store.PK — NOT NULL
Review (리뷰)
- PK (review_id) — NOTNULL — Primary key — NOT NULL
- Field4 (rating) — NOTNULL
- Field5 (content) — NOT NULL
- Field (createdDate) — NOTNULL
- Field (modifiedDate) — NOTNULL
- Field (status) — NOT NULL
- PK (member_id) — NOT NULL — Foreign key → Member.PK — NOT NULL
- PK (store_id) — NOT NULL — Foreign key → Store.PK — NOT NULL
- PK (menu_id) — NOTNULL — Foreign key → Menu.PK — NOT NULL
ShoppingCart (장바구니)
- PK (cart_id) — NOTNULL — Primary key — NOT NULL
- Field (quantity) — NOTNULL
- Field (createdDate) — NOTNULL
- Field (modifiedDate) — NOTNULL
- Field
- PK (member_id) — NOT NULL — Foreign key → Member.PK — NOT NULL
- PK (store_id) — NOT NULL — Foreign key → Store.PK — NOT NULL
- PK (menu_id) — NOTNULL — Foreign key → Menu.PK — NOT NULL
- PK (order_id) — NOTNULL — Foreign key → Order.PK — NOT NULL
Store (가게)
- PK (store_id) — NOT NULL — Primary key — NOT NULL
- Field (name) — NOT NULL
- Field2 (category) — NOT NULL
- Field3 (address) — NOT NULL
- Field4 (storeImageUrl)
- Field (minPrice) — NOT NULL
- Field (deliveryTip) — NOT NULL
- Field (rating) — NOTNULL
- Field (reviewCount) — NOTNULL
- Field (operationTime) — NOT NULL
- Field (likesCount) — NOTNULL
- Field (createdDate) — NOTNULL
- Field (modifiedDate) — NOTNULL