Menu

#6 No use of tbl_Members.memberID

open
nobody
None
5
2003-10-23
2003-10-23
Sangeun Ju
No

Primary key for tbl_Members is not MemberID but
OriginalID. All MemberID columns of other tables refer
tbl_Member.OriginalID instead of tbl_member.memberID.
Not only the memberID column doesn't have any use,
but also it can cause error when we access tbl_member
table.
I recommend to remove tbl_Members.memberID column
at least.

Discussion


Log in to post a comment.

MongoDB Logo MongoDB