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: 382

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:

  1. Should I use one users table with all users data in it or more tables?
  2. 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

Related posts about sql-server

Related posts about database