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 (생성시간)