Doubt from BeerHouse starter kit project-AddedBy

I am going through the starter kit -"BeerHouse" (http://www.asp.net/Downloads/starter-kits/the-beer-house/).
It is an excellent work. But, I have a doubt;-
Why do we need to enter the AddedBy (user's login name) in all the tables in the database?
Can we not enter the user's login name in one table (we may have to add a new table - eg: Register_Table(Reg_id, AddedDate, AddedBy)
and use the Reg_id in all the other tables as the foreign key of Register_Table instead of AddedBy.
Suppose, the user wants an option to change the username in the future this approach will reduce the hastle
to update the username in all the tables. Am I thinking in the right track? Can anyone correct me if I am wrong?

Thanks,

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Bechir Bejaoui18y ago
Your analyse seems to be very logic, I'm totaly agree with you but we have to assume that uder certain conditions unknown an ignored by us as externals to the application development somethings or procedures those seems to be illogic to us are adopted.