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 (가격)