LikeLion_Site

Tables (3)

Comment

  • comment_id — Integer — Primary key — NOT NULL
  • Image (프로필 사진) — Image
  • created_at (작성일자) — DataTime
  • content (내용) — Text
  • like_count (좋아요 수) — Integer
  • post_id — Integer — Foreign key → Post.post_id — NOT NULL

Post

  • post_id — Integer — Primary key — NOT NULL
  • title (제목) — String
  • created_at (작성일자) — DataTime
  • content (내용) — Text
  • like_count (좋아요 수) — Integer
  • user_id — Integer — Foreign key → User.user_id — NOT NULL

User

  • user_id — Integer — Primary key — NOT NULL
  • email (이메일) — String
  • password (비밀번호) — String
  • username (닉네임) — String