CRUD

Tables (4)

Comment (댓글)

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

Like (좋아요)

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

Post (게시글)

  • id (게시글키) — NOT NULL — Primary key — NOT NULL
  • 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
  • Field