I am just requesting a bit of advice on pros & cons re design. I am doing a DB with employee information table’s ( Name, DOB, Address, Qualifications etc.) I want to also include information for job applicants. Many of the details would be exactly the same as an applicant may well become an employee. I am unsure if it would be better to have an applicant table, with status’s say: Applicant, interviewed, job offered, rejected etc. then append all the details into an employee table if the applicant joins the company. Or just have one table including applicants and employees but then filter records via queries to only show employees or applicants depending on requirements. Re pros and cons, I am thinking in the terms of speed potentially having a table full of applicants who never got past interview stage ( I will obviously purge old details periodically for GDPR reasons).
Thanks for your comments