pironeer_week4

Tables (4)

Comment (댓글)

  • id (댓글 키) — NOT NULL — Primary key — NOT NULL
  • user_id (유저 키) — NOT NULL — Foreign key → User.id — NOT NULL
  • post_id (게시글 키) — NOT NULL — Foreign key → Post.id — NOT NULL
  • content (내용) — NOT NULL

Like (좋아요)

  • id (좋아요 키) — NOT NULL — Primary key — NOT NULL
  • user_id (유저 키) — NOT NULL — Foreign key → User.id — NOT NULL
  • post_id (게시글 키) — NOT NULL — Foreign key → Post.id — NOT NULL

Post (게시글)

  • id (게시글 키) — NOT NULL — Primary key — NOT NULL
  • user_id (유저 키) — NOT NULL — Foreign key → User.id — NOT NULL
  • title (제목) — NOT NULL
  • content (내용) — NOT NULL
  • status (노출여부) — NOT NULL
  • createdAt (생성시간) — NOT NULL

User (유저)

  • id (유저 키) — NOT NULL — Primary key — NOT NULL
  • name (이름) — NOT NULL