LocalHub
Tables (7)
Board
- boardId — BIGINT — Primary key — NOT NULL
- name — VARCHAR — NOT NULL
- category — VARCHAR — NOT NULL
- description — VARCHAR
Post_Tags
- postId — BIGINT — Foreign key → post.postId — NOT NULL
- tagId — BIGINT — Foreign key → Tag.tagId — NOT NULL
Tag
- tagId — BIGINT — Primary key — NOT NULL
- name — VARCHAR — NOT NULL
comment
- commentId — BIGINT — Primary key — NOT NULL
- postId — BIGINT — Foreign key → post.postId — NOT NULL
- parentId — BIGINT — Foreign key → comment.commentId — NOT NULL
- author — VARCHAR — NOT NULL — UUID
- content — TEXT — NOT NULL
- password — VARCHAR — NOT NULL
media
- mediaId — BIGINT — Primary key — NOT NULL
- postId — BIGINT — Foreign key → post.postId — NOT NULL
- imageUrl — VARCHAR — NOT NULL
- sequence — INTEGER — NOT NULL
post
- postId — BIGINT — Primary key — NOT NULL
- boardId — BIGINT — Foreign key → Board.boardId — NOT NULL
- title — VARCHAR — NOT NULL
- author — VARCHAR — NOT NULL — UUID
- content — TEXT — NOT NULL
- password — VARCHAR — NOT NULL
- viewCount — INTEGER — NOT NULL
- likeCount — INTEGER — NOT NULL