shopping
Tables (5)
Category (카테고리)
- id — Long — Primary key — NOT NULL
- title — String
Item (상품)
- id — Long — Primary key — NOT NULL
- orderId (order_id) — Long — Foreign key → Order.id — NOT NULL
- id (id2) — Long — Foreign key → Order.memberId — NOT NULL
- id (id3) — Long — Foreign key → Category.id — NOT NULL
- title — string
- price — int
- description — string
Member (회원)
- id — Long — Primary key — NOT NULL
- Field
Order (주문)
- id — Long — Primary key — NOT NULL
- memberId (member_id) — Long — Foreign key → Member.id — NOT NULL
Untitled (답글)
- Key — Primary key — NOT NULL