first_erd
Tables (3)
Article (articles)
- Article_id (id) — INTEGER — Primary key — NOT NULL
- User_id (user_id) — INTEGER — Foreign key → User.User_id — NOT NULL
- Content (content) — VARCHAR
- Title (title) — VARCHAR
- Created_At (created_at) — TIMESTAMP
Comment (comments)
- Comment_id (id) — INTEGER — Primary key — NOT NULL
- Article_id (article_id) — INTEGER — Foreign key → Article.Article_id — NOT NULL
- User_id (user_id) — INTEGER — Foreign key → User.User_id — NOT NULL
- Body (Field) — VARCHAR
- Created_At (created_at) — TIMESTAMP
User (users)
- User_id (id) — INTEGER — Primary key — NOT NULL
- Email (email) — VARCHAR
- Password (password) — VARCHAR
- Created_at (created_at) — TIMESTAMP