Monday 13 June 2011

Fisharoo - Database Design - Questionable NULL attributes?

Relating to the example project, Fisharoo, associated with the fantastic book ASP.Net 3.5 Social Networking by Andrew Siemer, I am wondering why the architect has allowed for NULL entries in the following columns:

Email
Username
Password
CreateDate
LastUpdateDate

To me these fields are all imperative to the management of a User Account based website - especially a social network site.

So unless there is some other reason (EG to make working with StructureMap or other automation tools smoother), then i'll have to lean towards disagreeing with the architect on that one...

Until proven otherwise, i'll be setting these fields as NON NULLs...easier to change to NULL later on than Vice Versa...!

No comments:

Post a Comment