shop
Tables (5)
CATEGORY
- Key (category_id) — Primary key — NOT NULL
- 카테고리명 (name)
ITEM
- (item_id) — Primary key — NOT NULL
- Key (category_id) — Foreign key → CATEGORY.Key — NOT NULL
- 상품명 (name)
- 가격 (price)
- 좋아요 개수 (heartNum)
TOKEN
- Key (token_id) — Primary key — NOT NULL
- (user_id) — Foreign key → USER.user_id — NOT NULL
- Field (token)
- Field2 (tokenType)
- Field3 (revoked)
- Field (expired)
USER
- (user_id) — Primary key — NOT NULL
- 아이디 (userId)
- 비밀번호 (password)
- 이름 (name)
- 이메일 (email)
- Field (role)
Untitled (HEART)
- Key (heart_id) — Primary key — NOT NULL
- (user_id) — Foreign key → USER.user_id — NOT NULL
- (item_id) — Foreign key → ITEM.item_id — NOT NULL