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