---
# System prepended metadata

title: Untitled

---

## Discussion - How would we model our Twitter domain using database tables? What columns would each table have?

users
id PRIMARY KEY INTEGER
name TEXT
profile_url TEXT

likes
id PRIMARY KEY INTEGER
user_id  FOREIGN KEY INTEGER
tweet_id FOREIGN KEY INTEGER

tweets
id PRIMARY KEY INTEGER
message TEXT