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