likelion

Tables (7)

Comment (댓글)

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

Like (좋아요)

  • like_id (좋아요번호) — Primary key — NOT NULL
  • post_id (게시글번호) — Foreign key → Post.post_id — NOT NULL
  • user_id (유저번호) — Foreign key → User.user_id — NOT NULL

Post (게시글)

  • post_id (게시글번호) — Primary key — NOT NULL
  • title (제목)
  • content (본문)
  • created_at (생성날짜)
  • user_id (유저번호) — Foreign key → User.user_id — NOT NULL

Post-Tag (게시글-태그)

  • posttag_id (posttag번호) — Primary key — NOT NULL
  • tag_id (태그번호) — Foreign key → Tag.tag_id — NOT NULL
  • post_id (게시글번호) — Foreign key → Post.post_id — NOT NULL

Profile (프로필)

  • id (프로필번호) — Primary key — NOT NULL
  • Collegee (대학)
  • Major (전공)
  • user_id (유저번호) — Foreign key → User.user_id — NOT NULL

Tag (태그)

  • tag_id (태그번호) — Primary key — NOT NULL
  • content (내용)

User (유저)

  • user_id (유저번호) — Primary key — NOT NULL
  • username (이름)
  • password (비밀번호)
  • email (이메일)