coffeeShop

Tables (3)

Order (order)

  • id (아이디) — NOT NULL — Primary key — NOT NULL
  • email (이메일) — NOT NULL
  • address (주소) — NOT NULL
  • zipcode (우편번호) — NOT NULL
  • total_price (총 가격) — NOT NULL
  • status (주문 상태) — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL

OrderItem (order_item)

  • product_id (상품 아이디) — NOT NULL — Primary key — NOT NULL
  • order_id (주문 아이디) — NOT NULL — Primary key — NOT NULL
  • quantity (수량) — NOT NULL
  • price (가격) — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL

Product (product)

  • id (아이디) — NOT NULL — Primary key — NOT NULL
  • name (이름) — NOT NULL
  • category (카테고리) — NOT NULL
  • decription (설명) — NOT NULL
  • price (가격) — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL