flutter-blog

Tables (7)

bookmark (북마크)

  • 북마크ID (bookmarkId) — NOT NULL — Primary key — NOT NULL
  • 글ID (postId) — NOT NULL — Foreign key → post.글ID — NOT NULL
  • 유저ID (userId) — NOT NULL — Foreign key → user.유저ID — NOT NULL

comment (댓글)

  • 댓글ID (commentId) — NOT NULL — Primary key — NOT NULL
  • 글ID (postId) — NOT NULL — Foreign key → post.글ID — NOT NULL
  • 유저ID (userId) — NOT NULL — Foreign key → user.유저ID — NOT NULL
  • 내용 (content) — NOT NULL
  • 댓글ID (parentCommentId) — NOT NULL — Foreign key → comment.댓글ID — NOT NULL

comment_favorite (댓글_좋아요)

  • 좋아요ID (favoriteId) — NOT NULL — Primary key — NOT NULL
  • 댓글ID (commentId) — NOT NULL — Foreign key → comment.댓글ID — NOT NULL
  • 유저ID (userId) — NOT NULL — Foreign key → user.유저ID — NOT NULL

post (글)

  • 글ID (postId) — NOT NULL — Primary key — NOT NULL
  • 유저ID (userId) — NOT NULL — Foreign key → user.유저ID — NOT NULL
  • 제목 (title) — NOT NULL
  • 서브제목 (subTItle) — NULL
  • 내용 (content) — NOT NULL

post_favorite (글_좋아요)

  • 좋아요ID (favoriteId) — NOT NULL — Primary key — NOT NULL
  • 글ID (postId) — NOT NULL — Foreign key → post.글ID — NOT NULL
  • 유저ID (userId) — NOT NULL — Foreign key → user.유저ID — NOT NULL

tag (태그)

  • 태그ID (tagId) — NOT NULL — Primary key — NOT NULL
  • 글ID (postId) — NOT NULL — Foreign key → post.글ID — NOT NULL
  • 내용 (cotent) — NOT NULL

user (사용자)

  • 유저ID (userId) — NOT NULL — Primary key — NOT NULL
  • 이름 (userName) — NOT NULL
  • 비밀번호 (password) — NOT NULL
  • 썸네일 (thumbnail) — NULL
  • 역할 (role) — NOT NULL