NewsFeed
Tables (4)
Comment (comment)
- Key (comment_id) — Long — Primary key — NOT NULL
- Key (user_id) — Long — Foreign key → User.Key — NOT NULL
- Key (post_id) — Long — Foreign key → Post.Key — NOT NULL
- Field (contents) — String
- Field (created_at) — Date
- Field (modified_at) — Date
Post (post)
- Key (post_id) — Long — Primary key — NOT NULL
- Key (user_id) — Long — Foreign key → User.Key — NOT NULL
- Field (title) — String
- Field (contents) — String
- Field (like_count) — Long
- Field (view_count) — Long
- Field (category) — String
- Field (created_at) — Date
- Field (modified_at) — Date
PostLike (postlike)
- Key (postlike_id) — Long — Primary key — NOT NULL
- Key (user_id) — Long — Foreign key → User.Key — NOT NULL
- Key (post_id) — Long — Foreign key → Post.Key — NOT NULL
User (user)
- Key (user_id) — Long — Primary key — NOT NULL
- Field (username) — String
- Field (password) — String
- Field (email) — String
- Field (mbti) — String
- Field (profileDescription) — String