blog

Tables (4)

Comment (Untitled2)

  • 댓글id (comment_id) — int — Primary key — NOT NULL
  • 게시글id (post_id) — int — Foreign key → Post.게시글id — NOT NULL
  • 작성자 (writer) — varchar[10]
  • 내용 (content) — text

Hashtag (Untitled3)

  • 해시태그id (tag_id) — int — Primary key — NOT NULL
  • 내용 (content) — varchar[20]
  • 게시글id (post_id) — int

HashtagPosts (Untitled4)

  • 게시글id (post_id) — int — Foreign key → Post.게시글id — NOT NULL
  • 해시태그id (tag_id) — int — Foreign key → Hashtag.해시태그id — NOT NULL

Post (Untitled)

  • 게시글id (post_id) — int — Primary key — NOT NULL
  • 제목 (title) — varchar[20]
  • 내용 (content) — text
  • 작성자 (writer) — varchar[10]
  • 카테고리 (category) — varchar[20]