shopping

Tables (5)

Category (카테고리)

  • id — Long — Primary key — NOT NULL
  • title — String

Item (상품)

  • id — Long — Primary key — NOT NULL
  • orderId (order_id) — Long — Foreign key → Order.id — NOT NULL
  • id (id2) — Long — Foreign key → Order.memberId — NOT NULL
  • id (id3) — Long — Foreign key → Category.id — NOT NULL
  • title — string
  • price — int
  • description — string

Member (회원)

  • id — Long — Primary key — NOT NULL
  • Field

Order (주문)

  • id — Long — Primary key — NOT NULL
  • memberId (member_id) — Long — Foreign key → Member.id — NOT NULL

Untitled (답글)

  • Key — Primary key — NOT NULL