test

Tables (6)

Untitled (주문)

  • Key (주문번호) — Primary key — NOT NULL
  • Field (회원번호)
  • Field (배달지번호)
  • Field (주문날짜)
  • Field (상태)

Untitled (Order)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (member)
  • Field

Untitled2 (주문상품)

  • Key (주문상품번호) — Primary key — NOT NULL
  • Key (주문번호) — Foreign key → Untitled.Key — NOT NULL
  • Key (상품번호) — Foreign key → Untitled3.Key — NOT NULL
  • Field (가격)
  • Field (수량)

Untitled2

    Untitled3 (상품)

    • Key (상품번호) — Primary key — NOT NULL
    • Field (상품이름)
    • Field (가격)
    • Field (재고)

    Untitled3