Shop

Tables (5)

Delivery (Untitled7)

  • 주문id (id) — bigint — Foreign key → Orders.주문id — NOT NULL

Item (Untitled)

  • 상품id (id) — bigint — Primary key — NOT NULL
  • 이름 (name) — varchar
  • 가격 (price) — Integer
  • 상품설명 (feature) — varchar(500)
  • 멤버id (id2) — bigint — Foreign key → Member.멤버id — NOT NULL

Member (Untitled2)

  • 멤버id (id) — bigint — Primary key — NOT NULL
  • Field

Order_Item (Untitled4)

  • 주문id (id) — bigint — Foreign key → Orders.주문id — NOT NULL
  • 상품id (id2) — bigint — Foreign key → Item.상품id — NOT NULL

Orders (Untitled3)

  • 주문id (id) — bigint — Primary key — NOT NULL
  • 멤버id (id2) — bigint — Foreign key → Member.멤버id — NOT NULL