Why there is no “code”

This project focuses on database modelling and schema design. There is no application-layer code (e.g., Java/Python). The main deliverables are ER diagrams and the final MySQL schema script.

The assignment explicitly requires a conceptual ER model (hand-drawn) and a MySQL Workbench physical model.

Downloads

Download Schema (SQL) Download ER Models (PDF) Download Spec (PDF)

Tip: If you want, you can open the SQL file in a text editor to view tables, primary keys, foreign keys, and constraints.

What the schema covers (high-level)

• Hubs, Posts, external URLs and post-to-post linking
• Users and bi-directional user connections
• Comments and “tagging up to 10 users” relationships
• Moderator assignments (time-bounded) and Reports (posts/comments)
• Optional AI agent tracking for post reports

These requirements come directly from the assignment business rules.