jpashop

Tables (7)

Category (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • parent_id (Key2) — Long — Foreign key → Category.id — NOT NULL

Category_Item (Untitled7)

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

Delivery (Untitled6)

  • id (Key) — Long — Primary key — NOT NULL
  • address (Field) — Address
  • status (Field2) — DeliveryStatus(READY, COMP)

Item (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • price (Field2) — int
  • stock_quantity (Field3) — int

Member (Untitled)

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

Order_Item (Untitled4)

  • id (Key) — Long — Primary key — NOT NULL
  • count (Field) — int
  • order_price (Field2) — Long
  • order_id (Key2) — Long — Foreign key → Orders.id — NOT NULL
  • item_id (Key3) — Long — Foreign key → Item.id — NOT NULL

Orders (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • order_date (Field) — LocalDate
  • status (Field2) — OrderStauts(ORDER, CANCEL)
  • member_id (Key2) — Long — Foreign key → Member.id — NOT NULL
  • delivery_id (Key3) — Long — Foreign key → Delivery.id — NOT NULL