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