community
Tables (4)
Comment
- Comment ID (comment_id) — int — Primary key — NOT NULL
- Contents (contents) — varchar(200) — NOT NULL
- Created date (created_at) — datetime — NOT NULL
- Writer ID (user_id) — int — Foreign key → User.User ID — NOT NULL
- Post ID (post_id) — int — Foreign key → Post.Post ID — NOT NULL
- Is Deleted (is_deleted) — bool
Like (Post_Like)
- Liker ID (user_id) — int — Foreign key → User.User ID — NOT NULL
- Post ID (post_id) — int — Foreign key → Post.Post ID — NOT NULL
Post
- Post ID (post_id) — int — Primary key — NOT NULL
- Title (title) — varchar(50) — NOT NULL
- Contents (contents) — varchar(1500) — NOT NULL
- Created Date (created_at) — datetime — NOT NULL
- Likes Count (likes_count) — int — NOT NULL
- Views Count (views_count) — int — NOT NULL
- Comments Count (comments_count) — int — NOT NULL
- Image URL (image_url) — varchar
- Writer ID (user_id) — int — Foreign key → User.User ID — NOT NULL
- Is Deleted (is_deleted) — bool
User
- User ID (user_id) — int — Primary key — NOT NULL
- Email (email) — varchar — NOT NULL
- Password (password) — varchar(20) — NOT NULL
- Nickname (nickname) — varchar(10) — NOT NULL
- Profile Image URL (profile_image_url) — varchar
- Refresh Token (refresh_token) — varchar
- Is Deleted (is_deleted) — bool