first erd

Tables (3)

Article (Untitled2)

  • Article ID (article_id) — INTEGER — Primary key — NOT NULL
  • user Id (user_id) — INTEGER — Foreign key → User.User ID — NOT NULL
  • Tittle (tittle) — VARCHAR
  • Content (content) — VARCHAR
  • Update At (updated_at) — TIMESTAMP
  • Created At (create_at) — TIMESTAMP

Comment (Untitled3)

  • Comment ID (commend_id) — INTEGER — Primary key — NOT NULL
  • Article ID (article_id) — INTEGER — Foreign key → Article.Article ID — NOT NULL
  • Body (body) — VARCHAR
  • Created At (create_at) — TIMESTAMP

User (Untitled)

  • User ID (user_id) — INTEGER — Primary key — NOT NULL
  • Email (email) — VARCHAR
  • Password (password) — VARCHAR
  • Created At (create_at) — TIMESTAMP