RE:ALTHON

Tables (6)

User

  • id — Primary key — NOT NULL
  • Field (email)
  • Field (hashedPassword)

article (Article)

  • id — Primary key — NOT NULL
  • id (topicId) — Foreign key → topic.id — NOT NULL
  • title
  • content
  • pressName
  • createdAt
  • Field (view)
  • Field (thumbnailUrl)

comments (Comments)

  • id — Primary key — NOT NULL
  • userId — Foreign key → User.id — NOT NULL
  • articleId — Foreign key → article.id — NOT NULL
  • content

like (Like)

  • id — Primary key — NOT NULL
  • id (userId) — Foreign key → User.id — NOT NULL
  • id (articleId) — Foreign key → article.id — NOT NULL

topic (Topic)

  • id — Primary key — NOT NULL
  • positive
  • negative
  • title

user-topic (UserTopic)

  • Key (id) — Primary key — NOT NULL
  • topicId — Foreign key → topic.id — NOT NULL
  • userId — Foreign key → User.id — NOT NULL