K'Tyn Fowler

Generate an ERD with three tables

I have chosen three tables. Users, Articles, and Comments.

  • October 6, 2016 at 1:00 AM
  • Visible to public
I have chosen three tables. Users, Articles, and Comments. Users has a one to many relationship with articles and comments so both the Articles and Comments table use the userID as a foreign key. Articles has a one to many relationship with comments so the Comments table uses the articleID as a foreign key. Comments are nested in the style of an adjacency table so the Comments table references its own commentID using the parentID column.

erd link: