Grids&Circles

Tables (3)

Order (주문)

  • id (아이디) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR(100)
  • address (배송지주소) — VARCHAR(100)
  • postcode (우편번호) — INT
  • createdat (주문등록날짜) — datetime
  • updatedat (상품수정날짜) — datetime
  • orderstatus (주문 처리 상태) — enum

OrderItem (주문 상품)

  • id (아이디) — BIGINT — Primary key — NOT NULL
  • product_id (상품정보) — BIGINT — Foreign key → Product.id — NOT NULL
  • order_id (주문정보) — BIGINT — Foreign key → Order.id — NOT NULL
  • category (카테고리) — enum
  • price (가격) — INT
  • quantity (수량) — INT

Product (상품)

  • id (아이디) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR(30)
  • category (카테고리) — enum
  • price (가격) — INT
  • description (설명) — VARCHAR(100)
  • imageurl (이미지) — VARCHAR(300)
  • createdat (상품등록날짜) — datetime
  • updatedat (상품수정날짜) — datetime