JPA_TEST

Tables (6)

Untitled (member)

  • Key (no) — INT — Primary key — NOT NULL
  • Field (id) — varchar(255)
  • Field2 (role) — varchar(255)
  • Field3 (reg_date) — datetime

Untitled (item)

  • Key (no) — INT — Primary key — NOT NULL
  • Field (name) — varchar(255)
  • Field (price) — INT
  • Field2 (stock_quantity)

Untitled (category)

  • Key (no) — INT — Primary key — NOT NULL
  • Key (parent_no) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — varchar(255)

Untitled (category_item)

  • Key (no) — INT — Primary key — NOT NULL
  • Key (category_no) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (item_no) — INT — Foreign key → Untitled.Key — NOT NULL

Untitled (orders)

  • Key (no) — INT — Primary key — NOT NULL
  • Key (member_no) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (status) — varchar(255)
  • Field (reg_date) — datetime

Untitled (order_item)

  • Key (no) — INT — Primary key — NOT NULL
  • Field (count) — INT
  • Key (item_no) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (orders_no) — INT — Foreign key → Untitled.Key — NOT NULL