node crud test

Tables (4)

comments (Untitled3)

  • id (comment_id) — pk — Primary key — NOT NULL
  • id (user_id) — pk — Foreign key → users.id — NOT NULL
  • id (post_id) — pk — Foreign key → posts.id — NOT NULL
  • id (user_id2) — pk — Foreign key → posts.id — NOT NULL
  • 댓글 (content)

likes (Untitled4)

  • id (post_id) — pk — Foreign key → posts.id — NOT NULL
  • id (user_id) — pk — Foreign key → posts.id — NOT NULL
  • id (user_id2) — pk — Foreign key → users.id — NOT NULL

posts (Untitled2)

  • id (post_id) — pk — Primary key — NOT NULL
  • id (user_id) — pk — Foreign key → users.id — NOT NULL
  • 제목 (title)
  • 본문 (content)

users (Untitled)

  • id (user_id) — pk — Primary key — NOT NULL
  • 닉네임 (nickname)
  • 비밀번호 (password)
  • 비밀번호 확인 (confirm)