for a job application project, if jobseeker applies for a job what fields should necessary for an employer i am setting applications table for employes perspective to show applications to employer for a particular job. i am making table through code first approach,so accordingly
job id,emplyer id,jobseeker id,resume,applydate,status, this data i consider tobe necessary to hold in this table for that i use this code.
public class Application { [Key] public int AppId { get; set; } public DateTime ApplyDate { get; set; } public int EmpId { get; set; } public virtual Employer Employer { get; set; } public int JobId { get; set; } public virtual Jobs Job { get; set; } public int CanId { get; set; } public virtual Candidate Candidate { get; set; } public byte Status { get; set; } public ICollection<Candidate> Candidates { get; set; } }
is this approach OK or need some corrections.moreover how may i get list of applicants who applied for a specific job.will this code work for getting list of candidates