Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
muek
Starting Member
16 Posts |
 Posted - 2009-07-28 : 10:42:24
|
| Hi,I'm not sure if this is the correct place for my question, but here it goes:I have 2 tables:Request - tableidnamerequestBy - FK userIDapproveBy - FK userIDUser - tableidnameWhat you think about this modelling? |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-07-28 : 11:36:44
|
| The referential integrity seems fine. The object names go against what I consider best practices. You should be able to look at a column name and know what it is. So [id] should be [UserID] and [RequestID], [name] should be [RequestName] and [UserName], etc. [requestBy] should be [RequestByUserID] so it is obvious that the value is a UserID. Also, don't use key words for object names like [User].Be One with the OptimizerTG |
 |
|
|
|
|
|
DB modeling