k-festival

Tables (12)

comment (댓글)

  • id (Key3) — Primary key — NOT NULL
  • memberId (Key) — Foreign key → member.id — NOT NULL
  • postId (Key2) — Foreign key → post.id — NOT NULL

comment like (댓글 좋아요)

  • id (Key2) — Primary key — NOT NULL
  • memberId (Key) — Foreign key → member.id — NOT NULL
  • commentId (Key22) — Foreign key → comment.postId — NOT NULL

festival (축제)

  • id (Key) — Long — Primary key — NOT NULL
  • festivalContentId (Key2) — Long — Foreign key → festival content.id — NOT NULL
  • title (Field) — String
  • imageUrl (Field2) — String
  • address (Field3) — String
  • contentId (Field4) — Long
  • startDate (Field5) — LocalDateTime
  • endDate (Field6) — LocalDateTime

festival content (축제 상세)

  • id (Key) — Long — Primary key — NOT NULL
  • contentId (Field) — Long
  • title (Field2) — String
  • address (Field3) — String
  • startDate (Field4) — LocalDateTime
  • endDate (Field5) — LocalDateTime
  • overview (Field6) — String
  • playtime (Field7) — String
  • mapx (Field8) — String
  • mapy (Field9) — String
  • firstImage (Field10) — String
  • firstImage2 (Field11) — String
  • areaCode (Field12) — String
  • addr1 (Field13) — String
  • tel (Field14) — String
  • dist (Field15) — String
  • infoText (Field16) — String

festival content translate (축제 상세 번역)

  • id (Key) — Long — Primary key — NOT NULL
  • festivalContentId (Key2) — Long — Foreign key → festival content.id — NOT NULL
  • contentId (Field) — Long
  • title (Field2) — String
  • address (Field3) — String
  • startDate (Field4) — LocalDateTime
  • endDate (Field5) — LocalDateTime
  • overview (Field6) — String
  • playtime (Field7) — String
  • mapx (Field8) — String
  • mapy (Field9) — String
  • firstImage (Field10) — String
  • firstImage2 (Field11) — String
  • areaCode (Field12) — String
  • addr1 (Field13) — String
  • tel (Field14) — String
  • dist (Field15) — String
  • infoText (Field16) — String
  • language (Field17)

festival like (축제 즐겨찾기)

  • id (Key2) — Primary key — NOT NULL
  • memberId (Key) — Foreign key → member.id — NOT NULL
  • contentId (Field)
  • title (Field2)
  • imageUrl (Field3)
  • address (Field4)
  • bookmarkedAt (Field5)

festival translate (축제 번역)

  • id (Key) — Primary key — NOT NULL
  • festivalId (Key2) — Long — Foreign key → festival.id — NOT NULL
  • title (Field)
  • language (Field2)
  • imageUrl (Field3)
  • address (Field4)
  • contentId (Field5)
  • startDate (Field6)
  • endDate (Field7)

member (사용자)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • profileImageUrl (Field2)
  • email (Field3)
  • password (Field4)
  • postCount (Field5)
  • role (Field6)
  • postsId (Field7)
  • festivalLikeId (Field8)

notification (알림 메일)

  • id (Key) — Primary key — NOT NULL
  • userId (Field)
  • festivalId (Field2)
  • executeAt (Field3)
  • executed (Field4) — boolean
  • type (Field5)

post (게시글)

  • id (Key) — Foreign key → member.id — NOT NULL
  • likes (Field)
  • title (Field2)
  • content (Field3)
  • thumbnailUrl (Field4)
  • imageId (Field5)
  • commentId (Field6)
  • memberId (Field7)

post image (게시글 사진)

  • id (Key2) — Primary key — NOT NULL
  • postId (Key) — Foreign key → post.id — NOT NULL
  • imageUrl (Field)
  • orderIndex (Field2)

post like (게시글 좋아요)

  • id (Key3) — Primary key — NOT NULL
  • memberId (Key) — Foreign key → member.id — NOT NULL
  • postId (Key2) — Foreign key → post.id — NOT NULL