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