Applicant availability model

View previous topic View next topic Go down

Applicant availability model

Post  satishjayan on Thu Dec 20, 2012 1:59 pm

During application process each applicant needs to provide availability information and below is the matrix that we present -
Mon Tue Wed Thu Fri Sat Sunday

Early Morning x

Mid day x x

Afternoon x

Evening

Overnight x x

I'm designing the table as below. Please let me know if there is a better way to do this.


ApplicantID
ShiftID - (There will be a look up table for all Shifts in a day Early morning -1, Midway -2 etc.;)
Mon
Tue
Wed
Thu
Fri
Sat
Sun

satishjayan

Posts : 4
Join date : 2012-12-18

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum