ffcommunity

Tables (10)

Comment (댓글)

  • comment_id (댓글ID) — string — Primary key — NOT NULL
  • post_id (게시글 ID) — string — Foreign key → Post.post_id — NOT NULL
  • member_id (멤버ID) — string — Foreign key → Post.member_id — NOT NULL
  • text (내용) — string
  • depth (댓글깊이) — int — depth 부모 댓글 1 자식 댓글 2
  • nickname (닉네임) — String
  • created_at (등록시간) — LocalDateTime

CommentReaction (댓글반응)

  • comment_id (댓글ID) — Long — Foreign key → Comment.comment_id — NOT NULL
  • reaction_id (리액션 ID) — Long — Foreign key → Reaction.reaction_id — NOT NULL

GuestComment (게스트 댓글)

  • comment_id (댓글ID) — string — Foreign key → Comment.comment_id — NOT NULL
  • ip_address (IP주소) — string
  • password (댓글비번) — string

GuestPost (게스트게시물)

  • post_id (게시글 ID) — Long — Foreign key → Post.post_id — NOT NULL
  • ip_address (IP주소) — String
  • password (게시물비번) — sting

Member (회원)

  • member_id (멤버ID) — Long — Primary key — NOT NULL
  • email (이메일) — String
  • password (비밀번호) — String
  • address (주소) — String

Post (게시글)

  • post_id (게시글 ID) — sting — Primary key — NOT NULL
  • member_id (멤버ID) — string — Foreign key → Profile.member_id — NOT NULL
  • nickname (닉네임) — String
  • category (게시글 카테고리) — String — 카테고리 (소통, 리뷰)
  • title (게시글 제목) — String
  • text (게시글 내용) — String — 5자 이상 500자 이하
  • latitude (위도) — double
  • longitude (경도) — double
  • created_at (등록시간) — LocalDateTime
  • modifide_at (수정시간) — LocalDateTime
  • images (이미지URL) — String

PostReaction (게시물반응)

  • post_id (게시글 ID) — Long — Foreign key → Post.post_id — NOT NULL
  • reaction_id (리액션 ID) — Long — Foreign key → Reaction.reaction_id — NOT NULL

Profile (회원 프로필)

  • member_id (멤버ID) — Long — Foreign key → Member.member_id — NOT NULL
  • nickname (닉네임) — String
  • profile_img (프로필사진) — String

Reaction (반응(좋아요))

  • reaction_id (리액션 ID) — Long — Primary key — NOT NULL
  • member_id (멤버ID) — Long — Foreign key → Member.member_id — NOT NULL
  • reaction_type (리액션타입) — String — 리액션타입 like (= 좋아요) dislike (= 싫어요) . . .
  • created_at (등록시간) — LocalDateTime — contentType {Post, Comment}

Reaction2 (반응)

  • reaction_id (리액션ID) — Long — Primary key — NOT NULL
  • member_id (멤버ID)
  • content_id (컨텐츠ID)
  • content_type (컨텐츠타입) — contentType POST, COMMENT
  • reaction_type (리액션타입) — reactionTyoe LIKE, DISLIKE , ...
  • created_at (생성시간)