first erd
Tables (3)
Article (article)
- ArticleID (article_id) — BIGINT — Primary key — NOT NULL
- UserID (user_id) — BIGINT — Foreign key → User.UserID — NOT NULL
- Content (content) — varchar
- title — varchar
- Created At (created_at) — timestamp
- Updated At (updated_at) — timestamp
Comment (comment)
- Comment ID (comment_id) — BIGINT — Primary key — NOT NULL
- ArticleID (article_id) — BIGINT — Foreign key → Article.ArticleID — NOT NULL
- UserID (user_id) — BIGINT — Foreign key → Article.UserID — NOT NULL
- Body (body) — varchar
- Created At (created_at) — timestamp
User (users)
- UserID (user_id) — BIGINT — Primary key — NOT NULL
- Email (email) — VARCHAR
- Password (password) — VARCHAR
- Created At (created_at) — timestamp