With our status stream now supporting simple-text updates from the profile owner, and public messages from other users, it is time for us to integrate other types of media into these statuses.
In this chapter, you will learn how to integrate other types of media in profile posts, including:
The core information to our current statuses is held within the statuses table. We will keep this the same. However, depending on the type of status update, we may call upon other database tables to extend the information available to us.
Since different status types will use different status tables, we should use a left join to connect the tables, so we can keep just a single query to look up the statuses. It also ...