title

Tables (4)

item (상품)

  • item_id (BIgInt) — auto_increment — Primary key — NOT NULL
  • member_id (BigInt) — auto_increment — Foreign key → member.member_id — NOT NULL
  • 상품명 (Field) — BigInt
  • 상품재고 (Field2)
  • 상품가격 (Field3)

member (회원가입)

  • member_id (BigInt) — auto_increment — Primary key — NOT NULL
  • role (Varchar) — enum{"user":"seller"}

order (Untitled2)

  • order_id (Bigint) — auto_increment — Primary key — NOT NULL
  • member_id (BigInt) — auto_increment — Foreign key → member.member_id — NOT NULL
  • 주문생성일자 (Field)

orderItem (Untitled3)

  • orderItemId (Bigint) — auto_increment — Primary key — NOT NULL
  • item_id (BIgInt) — auto_increment — Foreign key → item.item_id — NOT NULL
  • order_id (Bigint2) — auto_increment — Foreign key → order.order_id — NOT NULL
  • quantity (Bigint3) — BigInt