I would like to make a model agency based using Codeigniter.
I would like to allow users to sign up as model, photographer, agency, or make-up artist.
How do I make the registration database?
Do I separate the models, photographers, agencies, and artists in different tables, and at the registration form only ask for basic info like name, password, email and date of birth?
You should use entity sub-typing with a parent type of "USER", which will contain your basic information, and with sub-types of "MODEL", "AGENCY", "PHOTOGRAPHER", "MAKEUP_ARTIST". This will allow you to have a better user experience for the inevitable case where there is overlap. I'm sure there are photographers who have agencies and agencies that do make-up etc. It would be much better for these types of users to have a single user ID and password despite having different types of profiles.