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