Welcome to the Treehouse Community
The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.
Oisin M5,463 Points
Real Web Applications: Database for each user?
Many websites keep information about each individual user.
Eg: Treehouse has a record of all videos each user has watched.
Question: Having a table for each user doesn't seem ideal, so how is this information stored?
Is information like this stored in one big table where each row has a user id has a list of videos watched, or is there some other way?
Sue Dough35,800 Points
You should have a users table and each user is a row. You can then use the user id from that table for other tables as a reference.