Web-Application Design: users, account. database strucure and architecture

Question

Hy,

In my application there will be: profiles: they are just users that make a profile and can do a lot of stuff... businesses: they can make new ads and do all this stuff

both can login and a profile can be a business to and here is the problem! I was thinking in doing an accunt table, that stores the email and password and the types of account.. but is not so solid this approach

You have a better idea? thanks

Answer 1

Some websites have a User table and a Role table and a UserRole table. The content shown to each visitor is then based on which roles the user belongs to. But there are several other ways to do this.