Hi Everyone,
I'm new to .net. Please forgive the Newb question here.
I'm designing a website that has users who login. There are three rolls: Customers, Business Admins, SuperUserAdmin.
Business Admins have a 1 to many relationship with many Customers. SuperUserAdmins can login and do anything... typically, just me or a developer.
Would this be the correct table design?:
Rolls_
RollId
RollName
...
Membership_
ApplicationId
UserId
Password
...
Businesses_
UserId
BusId <-- Primary Key
...
Customers_
UserId
BusId <-- Foreign Key
...
...
Go to the complete details ...