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