sideProject_1

Tables (3)

Comment (댓글)

  • id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → Post.id — NOT NULL
  • user_id (Field2)
  • content (Field3)
  • created_at (Field4)
  • updated_at (Field5)

Post (게시물)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • title (Field2)
  • content (Field3)
  • like_count (Field4)
  • comment_count (Field5)
  • created_at (Field6)
  • updated_at (Field7)

User (사용자)

  • id (Key) — Primary key — NOT NULL
  • email (Field)
  • password (Field2)
  • username (Field3)
  • created_at (Field4)
  • updated_at (Field5)