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
  • Comment (comment) — VARCHAR

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(255)
  • CreatedAt (created_at) — TIMESTAMP

User (users)

  • User_Id (user_id) — Integer — Primary key — NOT NULL
  • Email (email) — VARCHAR
  • Password (password) — VARCHAR
  • CreatedAt (created_at) — TIMESTAMP