views:

73

answers:

1

Times

Refers to the start + stop date

For each user assigned to a timeslice, create a reference record here of UserId + Time. What does the bolded mean? I know this is a noob question, sorry.

+2  A: 

Assuming you are talking about how to create a db schema for this:

ScheduleTimes 
===============
ScheduleTimesID  <-- PK
StartDate
StopDate

ScheduleUsers
===============
ScheduleUsersID  <-- PK
UserID           <-- FK to Users table
ScheduleTimesID  <-- FK to ScheduleTimes table

Users
=======
UserID           <-- PK
Username
...
RedFilter