cafeProject ERD

Tables (3)

order_item (주문상품)

  • id (주문상품번호) — BIGINT — Primary key — NOT NULL
  • order_price (주문가격) — BIGINT — NOT NULL
  • quantity (수량) — INTEGER — NOT NULL
  • order_result_id (주문번호) — BIGINT — Foreign key → order_result.id — NOT NULL
  • product_id (상품번호) — BIGINT — Foreign key → product.id — NOT NULL

order_result (주문)

  • id (주문번호) — BIGINT — Primary key — NOT NULL
  • email (주문자 이메일) — VARCHAR(255) — NOT NULL
  • shipping_address (배송주소) — VARCHAR(255) — NOT NULL
  • zip_code (우편번호) — VARCHAR(255) — NOT NULL
  • total_price (총 주문금액) — BIGINT — NOT NULL
  • shipping_date (배송예정일) — DATE
  • create_date (생성일시) — TIMESTAMP(6)
  • modify_date (수정일시) — TIMESTAMP(6)

product (상품)

  • id (상품번호) — BIGINT — Primary key — NOT NULL
  • name (상품명) — VARCHAR(255) — NOT NULL
  • category (카테고리) — VARCHAR(255) — NOT NULL
  • price (가격) — INTEGER — NOT NULL
  • photo_url (상품이미지URL) — VARCHAR(255)
  • create_date (생성일시) — TIMESTAMP(6)
  • modify_date (수정일시) — TIMESTAMP(6)