likelion_hw1_socialmedia

Tables (6)

Comment

  • commentID (commnetID) — INT — Primary key — NOT NULL
  • PostID (postid) — INT — Foreign key → Post.PostID — NOT NULL
  • UserID (user_id) — INT — Foreign key → Post.UserID — NOT NULL
  • content — Text

CommentLike

  • userCommentLikeID — INT — Primary key — NOT NULL
  • commentID (commnetID) — INT — Foreign key → Comment.commentID — NOT NULL
  • PostID (postid) — INT — Foreign key → Comment.PostID — NOT NULL
  • UserID (user_id) — INT — Foreign key → User.UserID — NOT NULL

Image

  • ImageID (imageID) — INT — Primary key — NOT NULL
  • PostID (postid) — INT — Foreign key → Post.PostID — NOT NULL
  • filename — VARCHAR(20)

Post

  • PostID (postid) — INT — Primary key — NOT NULL
  • UserID (user_id) — INT — Foreign key → User.UserID — NOT NULL
  • Content (content) — Text
  • PostDate (postDate) — TimeStamp

PostLike

  • postLikeID — INT — Primary key — NOT NULL
  • UserID (user_id) — INT — Foreign key → User.UserID — NOT NULL
  • PostID (postid) — INT — Foreign key → Post.PostID — NOT NULL

User

  • UserID (user_id) — INT — Primary key — NOT NULL
  • Firstname (firstname) — VARCHAR(20)
  • Lastname (lastname) — VARCHAR(20)
  • Email (email) — VARCHAR(30)
  • Password (password) — VARCHAR(20)
  • Gender (gender) — VARCHAR(5)
  • PhoneNumber (phonenumber) — VARCHAR(10)
  • ProfileImage (profileimage) — VARCHAR(20)
  • RegisterDate (registerDate) — TimeStamp