llikelion_session_3

Tables (4)

Comment

  • comment_id — Integer — Primary key — NOT NULL
  • content (댓글 내용) — String
  • created_date (작성 일자) — DateField
  • modified_date (수정 일자) — DateField
  • post_id — Integer — Foreign key → Post.post_id — NOT NULL
  • user_id — Integer — Foreign key → User.user_id — NOT NULL

Like

  • post_id — Integer — Foreign key → Post.post_id — NOT NULL
  • user_id — Integer — Foreign key → User.user_id — NOT NULL

Post

  • post_id — Integer — Primary key — NOT NULL
  • title (게시글 제목) — String
  • content (게시글 내용) — String
  • created_date (작성 일자) — DateField
  • modified_date (수정 일자) — DateFIeld
  • user_id — Integer — Foreign key → User.user_id — NOT NULL

User

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