Book Image

ASP.NET 3.5 Social Networking

By : Andrew Siemer
Book Image

ASP.NET 3.5 Social Networking

By: Andrew Siemer

Overview of this book

Table of Contents (19 chapters)

Solution


Let's take a look at our solution.

Implementing the database

Let's take a look at what is needed in the database.

SystemObjects

The SystemObjects table is at the center of this chapter's list of features. Having said that, this table is the easiest part of this equation. It simply keeps track of all the tables in the system. Specifically, it keeps track of the table names and maintains an ID for each name.

Ratings

The Ratings table is responsible for holding all the end user ratings. As you can see each rating ties back to the SystemObjects table and also directly to the record within the specified table. In addition to that, we are also tracking the Option that was rated. The most important part of this table though is the Score field. The Score tracks the selected number of stars (in our case) that the end user has selected.

System object rating options

In addition to the ratings table we also have the SystemObjectRatingOptions table. This table tracks all the options that are...