qwer

Tables (5)

User (사용자)

  • Key — Primary key — NOT NULL
  • Field

comment (댓글)

  • comment_id (댓글의 id) — Long — Primary key — NOT NULL
  • post_id (게시글의 id) — Long — Foreign key → post.post_id — NOT NULL
  • Tag_id (태그 id2) — Long — Foreign key → post.Tag_id — NOT NULL
  • post_id (게시글의 id2) — Long — Foreign key → post.post_id — NOT NULL
  • Key_id (좋아요의 id) — Long — Foreign key → post.Key_id — NOT NULL
  • Key — Foreign key → post.Key — NOT NULL
  • content (내용) — string
  • password (비밀번호) — string
  • created_at (생성시간) — time
  • update_at (수정시간) — time

like (좋아요)

  • post_id (게시글의 id) — Long — Primary key — NOT NULL
  • Key_id (좋아요의 id) — Long — Primary key — NOT NULL
  • Key — Foreign key → User.Key — NOT NULL

post (게시글)

  • post_id (게시글의 id) — Long — Primary key — NOT NULL
  • Tag_id (태그 id) — Long — Primary key — NOT NULL
  • Tag_id (태그 id2) — Long — Foreign key → tag.Tag_id — NOT NULL
  • post_id (게시글의 id2) — Long — Foreign key → like.post_id — NOT NULL
  • Key_id (좋아요의 id) — Long — Foreign key → like.Key_id — NOT NULL
  • Key — Foreign key → like.Key — NOT NULL
  • content (내용) — string
  • like (좋아요) — int
  • view (조회수) — int
  • created_at (생성시간) — time
  • password (비밀번호) — string

tag (태그)

  • Tag_id (태그 id) — Long — Primary key — NOT NULL
  • name (태그의 이름) — string