dongsan
Tables (8)
Bookmark (북마크)
- id — Primary key — NOT NULL
- member_id — Foreign key → Members.id — NOT NULL
- 제목 (name) — NOT NULL
- createdAt
- updatedAt
Hashtags (해시태그)
- id — Primary key — NOT NULL
- 이름 (name) — NOT NULL
- createdAt — NOT NULL
- updatedAt
Likes (좋아요)
- id — Primary key — NOT NULL
- member_id — Foreign key → Members.id — NOT NULL
- walkway_id — Foreign key → Walkways.id — NOT NULL
- createdAt — NOT NULL
- updatedAt — NOT NULL
MarkedWalkway (북마크에 저장된 산책로)
- id — Primary key — NOT NULL
- bookmark_id — Foreign key → Bookmark.id — NOT NULL
- walkway_id — Foreign key → Walkways.id — NOT NULL
- created_at — NOT NULL
- updated_at
Members (사용자)
- id — Primary key — NOT NULL
- email — NOT NULL
- nickname — NOT NULL
- profileImageUrl — NOT NULL
- createdAt — NOT NULL
- updatedAt
Reviews (리뷰)
- id — Primary key — NOT NULL
- member_id — Foreign key → Members.id — NOT NULL
- walkway_id — Foreign key → Walkways.id — NOT NULL
- 별점 (rating) — NOT NULL
- 내용 (content)
- createdAt — NOT NULL
- updatedAt
WalkwayTags (산책로에 포함된 해시태그)
- id — Primary key — NOT NULL
- 산책로 (walkway_id) — Foreign key → Walkways.id — NOT NULL
- 해시태그 (hashtag_id) — Foreign key → Hashtags.id — NOT NULL
- createdAt — NOT NULL
- updatedAt
Walkways (산책로)
- id — Primary key — NOT NULL
- 등록자 (member_id) — Foreign key → Members.id — NOT NULL
- 산책로이름 (name) — NOT NULL
- 산책로 길이(km) (distance) — NOT NULL
- 시간(분) (time) — NOT NULL
- 공개 여부 (accessLevel) — NOT NULL
- 시작위치 (startLocation) — NOT NULL
- 종료위치 (endLocation) — NOT NULL
- memo
- 좋아요 갯수 (likeCount) — NOT NULL
- 리뷰 갯수 (reviewCount) — NOT NULL
- 별점 (rating) — NOT NULL
- 경로 (course) — NOT NULL
- 경로 이미지 url (courseImageUrl)
- createdAt — NOT NULL
- updatedAt — NOT NULL