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