Let's say we are going to make email address as the username and we are using this structure currently.
Code: Select all
UserAccounts_tbl
=================
UserName
Password
PrivelegeId
FirstName
LastName
Age
Gender
Email
Phone
Street
City
State
Country
PostCode
JoinDate
I am going to have another table called Orders which has to reference a member for every entry in it.
In such a case, if I put the username in the Orders table, its unnecessarily going to occupy so much space when the usernames are longer.
so in such a case, do you think having an MemberId in the same Members_tbl would be beneficial.
The proposed structure would be
Code: Select all
UserAccounts_tbl
=================
MemberId //newly added field
UserName
Password
PrivelegeId
FirstName
LastName
Age
Gender
Email
Phone
Street
City
State
Country
PostCode
JoinDate