spartamarket

Tables (4)

Follow (팔로우)

  • 팔로우ID (follow_id) — bigint — Primary key — NOT NULL
  • 팔로잉 (following_id) — bigint — Foreign key → User.유저ID — NOT NULL
  • 팔로워 (follower_id) — bigint — Foreign key → User.유저ID — NOT NULL

Product (상품)

  • 상품ID (product_id) — bigint — Primary key — NOT NULL
  • 유저ID (user_id) — varchar(20) — Foreign key → User.유저ID — NOT NULL
  • 등록일 (product_register) — datetime
  • 조회수 (product_view) — int
  • 가격 (product_price) — int
  • 상품명 (product_name) — varchar(100)
  • 내용 (product_content) — text
  • 해시태그 (product_hashtag) — set

User (사용자)

  • 유저ID (user_id) — bigint — Primary key — NOT NULL
  • 이메일 (email) — varchar(100) — NOT NULL
  • 비밀번호 (password) — varchar(20) — NOT NULL
  • 가입일자 (joindate) — datetime — NOT NULL
  • 프로필사진 (image) — blob
  • 권한 (auth_grade) — set — NOT NULL

Wishlist (찜)

  • 찜ID (wish_id) — bigint — Primary key — NOT NULL
  • 유저ID (user_id) — varchar(20) — Foreign key → User.유저ID — NOT NULL
  • 상품ID (product_id) — bigint — Foreign key → Product.상품ID — NOT NULL
  • 찜 일자 (wish_date) — datetime — NOT NULL