BBangDb
Tables (8)
Breads (Untitled2)
- 빵식별자 (BreadId) — Primary key — NOT NULL
- 빵이름 (BreadName)
- 가격 (Price)
- 재고 (Stock)
- 빵이미지 (ImageUrl)
Cart (Untitled3)
- 카트식별자 (CartId) — Primary key — NOT NULL
- UserId (유저식별자) — Foreign key → Customer.UserId — NOT NULL
Customer (Untitled)
- UserId (유저식별자) — Primary key — NOT NULL
- UserName (유저ID)
- Password (비밀번호)
- quick_password (간편 비밀번호)
Favorite (Untitled7)
- FavoriteId (찜 식별자) — Primary key — NOT NULL
- UserId (유저식별자) — Foreign key → Customer.UserId — NOT NULL
Order (Untitled5)
- OrderId (주문 식별자) — Primary key — NOT NULL
- UserId (유저식별자) — Foreign key → Customer.UserId — NOT NULL
- order_date (주문날짜)
- total_price (총 가격)
cart_Item (Untitled4)
- 카트식별자 (CartId) — Foreign key → Cart.카트식별자 — NOT NULL
- 빵식별자 (BreadId) — Foreign key → Breads.빵식별자 — NOT NULL
- UserId (유저식별자) — Foreign key → Cart.UserId — NOT NULL
- 수량 (quantity)
- 가격 (price)
favorite_item (Untitled8)
- FavoriteId (찜 식별자) — Foreign key → Favorite.FavoriteId — NOT NULL
- UserId (유저식별자) — Foreign key → Favorite.UserId — NOT NULL
- 빵식별자 (BreadId) — Foreign key → Breads.빵식별자 — NOT NULL
order_item (Untitled6)
- OrderId (주문 식별자) — Foreign key → Order.OrderId — NOT NULL
- UserId (유저식별자) — Foreign key → Order.UserId — NOT NULL
- 빵식별자 (BreadId) — Foreign key → Breads.빵식별자 — NOT NULL
- quantity (수량)
- price (가격)