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