can someone explain this to me
Times
Refers to the start + stop date
For each user assigned to a timeslice, create a reference record here o开发者_JAVA技巧f UserId + Time. What does the bolded mean? I know this is a noob question, sorry.
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
...
精彩评论