first erd
Tables (3)
Article (article)
- Article ID (article_id) — INTEGER — Primary key — NOT NULL
- USER ID (user_id) — INTEGER — Foreign key → User.User ID — NOT NULL
- Title (title) — VARCHAR
- Content (content) — VARCHAR
- Created At (created_at) — TIMESTAMP
Comment (comment)
- Comment ID (comment_id) — INTEGER — Primary key — NOT NULL
- Article ID (article_id) — INTEGER — Foreign key → Article.Article ID — NOT NULL
- body — VARCHAR
- Created At (created_at) — TIMESTAMP
User (users)
- User ID (user_id) — INTEGER — Primary key — NOT NULL
- Email (email) — VARCHAR
- Password (password) — VARCHAR
- Created At (created_at) — TIMESTAMP