The User Tables Revisited
To better understand how the user administrative features for MyGolfGear.Net were implemented, we need to revisit the user-related portion of the data model. For this discussion, we'll focus on the User and UserType tables.
The User table holds basic username, password, and contact information. Specifically, it holds first and last names, e-mail addresses, and user passwords. Table 18.1 shows the specifics for this table.
| Name | Data Type | Size | Allow Nulls |
|---|---|---|---|
| UserID | int | 4 | No |
| UserTypeID | int | 4 | No |
| FirstName | varchar | 50 | Yes |
| LastName | varchar | 50 | Yes |
| EmailAddress | varchar | 50 | No |
| Password | varchar | 50 | No |
Caution
It is not a good idea to store passwords or other sensitive data as a varchar in a SQL Server table ...
Get Building e-Commerce Sites with the .NET Framework now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
