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