Forums ~ Entity Relationship Diagram (ERD)

Forums Entity Relationship Diagram (ERD) v1.2

Entities

User

Attributes:

• user name (string)
• first name (string)
• last name (string)
• email (string)

Topic

Attributes:

• title (string)
• timestamp (datetime)

Post

Attributes:

• text (string)
• timestamp (datetime)

Forum

Attributes:

• title (string)
• category (string)

Relationships

• User and Topic

  • A user (1) makes many topics (N)

• User and Post

  • A user (1) makes many posts (N)
  • Many users (N) like many posts (M)

• Topic and Post

  • Many posts (N) are made in a topic (1)

• Topic and Forum

  • A forum (1) has many topics (N)