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