LocalHub

Tables (7)

BaseEntity

  • createdAt
  • updatedAt

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