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