likelion_blog

Tables (4)

Comment (댓글)

  • comment_id (댓글 번호) — Primary key — NOT NULL
  • content (내용)
  • created_at (작성일자)
  • user_id (유저 번호) — Foreign key → User.user_id — NOT NULL
  • post_id (게시글 번호) — Foreign key → Post.post_id — NOT NULL

Post (게시글)

  • post_id (게시글 번호) — Primary key — NOT NULL
  • title (제목)
  • content (내용)
  • created_at (게시일자)
  • user_id (유저 번호) — Foreign key → User.user_id — NOT NULL

User (사용자)

  • user_id (유저 번호) — Primary key — NOT NULL
  • username (이름)
  • password (비밀번호)
  • email (이메일)
  • signed_up_at (회원가입 일자)

UserProfile (유저 정보)

  • userprofile_id (유저정보 번호) — Primary key — NOT NULL
  • major (Field)
  • age (Field2)
  • user_id (유저 번호) — Foreign key → User.user_id — NOT NULL