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