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