jpashop

Tables (7)

Category (카테고리)

  • Key — Primary key — NOT NULL
  • name (Field)

Delivery (배송)

  • delivery_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → Order.user_id — NOT NULL
  • status (Field) — DeliveryStatus
  • address (Field2) — Address

Item (상품)

  • item_id (Key) — Primary key — NOT NULL
  • name (Field)
  • price (Field2) — int
  • stockQuantity (Field3)

Order (주문)

  • user_id (Key) — Foreign key → User.user_id — NOT NULL
  • orderDate (Field) — Date
  • status (Field2) — OrderStatus

OrderItem (Untitled)

  • orderItem_id (Key2) — Primary key — NOT NULL
  • item_id (Key3) — Foreign key → Item.item_id — NOT NULL
  • user_id (Key) — Foreign key → Order.user_id — NOT NULL
  • orderPrice (Field)
  • count (Field2)

User (회원)

  • user_id (Key) — Primary key — NOT NULL
  • name (Field) — String
  • address (Field2) — Address

categoryItem (Untitled2)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Category.Key — NOT NULL
  • item_id (Key3) — Foreign key → Item.item_id — NOT NULL