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