I'm trying to design an application for a recruitment application. I have two types of users - a coordinator who works for an agency who logs in and posts jobs and searches for canidates. And a candidate who logs in and searches for jobs.
I'm not sure if it is best to have one general user table with fields
and then a table for coordinators
and then a table for candidates
professional license number
address line 2
And a table for agencies:
All candidates have a professional license number but coordinators do not. So if I put it into one table I would have lots of null values. But there will be massively more candidates than coordinators so it will be less than 1% fields with null values. Not sure whether it is a big issue to have null values?
Thanks in advance