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