Database with users design
Posted
by
1110
on Stack Overflow
See other posts from Stack Overflow
or by 1110
Published on 2010-12-25T22:03:04Z
Indexed on
2010/12/26
11:53 UTC
Read the original article
Hit count: 405
I am in database design development phase. Application will work with large number of users (LARGE :))
I designed 80% of database but I have one Users table which is connected to everything else:
Users {UserId, FirstName, LastName, Username, Password, PasswordQuestion, PasswordAnswer, Gender, RoleId, LastLoginDate etc etc}
I saw asp.net membership database structure where Users and Membership are two tables. My questions are:
- Should I use one users table with all users data in it or more tables?
- If answer is 'more tables', what tables to use? Any advice on how to structure relation between those tables?
This is sample relation that I have, and trying to improve. I don't understand why user and userChild are separated tables?
© Stack Overflow or respective owner