SBContact
Back to learning log

Learning log

What primary keys and foreign keys taught me about app data

Learning relational database design helped me understand how real apps connect users, projects, events, uploads, and permissions without everything becoming messy.

SQL / Database fundamentals
  • SQL
  • database fundamentals
  • Postgres

What I was learning

I was learning how primary keys identify records and foreign keys connect related records across tables.

Why it matters

Real apps need clear relationships between users, projects, events, uploads, and permissions. Without those relationships, data gets messy quickly.

Where I applied it

This connects directly to projects that need accounts, event records, uploaded files, and structured project data.

What clicked

A table is easier to reason about when identity and relationships are explicit instead of hidden in loose fields or duplicated data.

What I still need to improve

I still need to keep practicing joins, constraints, migrations, and row-level security patterns.