board
Tables (3)
comment (댓글)
- commentId (comment_id) — bigint — Primary key — NOT NULL — AUTO_INCREMENT
- commentContent (content) — varchar(255) — NOT NULL
- parentId (parent_id) — bigint — Foreign key → comment.commentId — FK(self)
- postId (post_id) — bigint — Foreign key → post.postId — NOT NULL — FK(post)
- authorId (author_id) — bigint — Foreign key → user.userId — NOT NULL — FK(user)
post (게시글)
- postId (post_id) — bigint — Primary key — NOT NULL — AUTO_INCREMENT
- postTitle (title) — varchar(50) — NOT NULL
- postContent (content) — text — NOT NULL
- category — varchar(10) — NOT NULL
- bookmarked — boolean — NOT NULL
- authorId (author_id) — bigint — Foreign key → user.userId — NOT NULL — FK(user)
user (사용자)
- userId (user_id) — bigint — Primary key — NOT NULL — AUTO_INCREMENT
- userName (name) — varchar(10) — NOT NULL
- password — varchar(15) — NOT NULL