StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
18807365
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-09-14T23:23:15.027
FavoriteCount
0
LastActivityDate
2013-09-14T23:28:29.220
LastEditDate
2013-09-14T23:28:29.220
LastEditorUserId
1875438
OwnerUserId
1875438
ParentId
18806506
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
I think there is no 'best' answer to your question. I give you some schema but there could be more answers which would be good as well. <pre><code>shedule_map schedule activity ------------------------------------------------ id id id user_id schedule_id schedule_id default_schedule_id user_id date startOfWeek start_hour end_hour activity_description </code></pre> 'Schedule' table every week will gain one entry per user. If user choose default schedule for current week in 'schedule' table schedule_id will be obtained from schedule_map. Elswhere schedule_id = MAX(schedule_id) + 1 and new activities for this new schedule will be created. Lets get today's activities from that schema for user_id = 10: <pre><code>SELECT act.start_hour, act.end_hour, act.activity_descripton FROM activity act INNER JOIN schedule s USING (schedule_id) WHERE s.startOfWeek = ( SELECT MAX(startOfWeek) FROM schedule WHERE startOfWeek < NOW() ) AND s.user_id = 10 ORDER BY act.start_hour </code></pre> I use mostly ORMs and there are problems with subqueries so startOfWeek adequate to current date you can obtain from other query. I don't think one additional entry per user per week can be a problem. But if you think it is then you can add to 'schedule_map' table column 'custom_schedule_id' setting it to NULL if user choose default schedule. But then you would have to determine firstly if user use custom schedule or not or more complicated query will be needed. On example <pre><code>SELECT act.start_hour, act.end_hour, act.activity_descripton FROM activity act INNER JOIN schedule s ON act.schedule_id = s.schedule_id INNER JOIN schedule_map sm ON sm.user_id = s.user_id AND sm.custom_schedule_id = s.schedule_id WHERE s.user_id = 10 ORDER BY act.start_hour UNION ALL SELECT act.start_hour, act.end_hour, act.activity_descripton FROM activity act INNER JOIN schedule s ON act.schedule_id = s.schedule_id INNER JOIN schedule_map sm ON sm.user_id = s.user_id AND sm.default_schedule_id = s.schedule_id AND sm.custom_schedule_id IS NULL WHERE s.user_id = 10 ORDER BY act.start_hour </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POBest MySQL setup for a weekly default schedule with alternate schedules in case of
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USuser1875438
UserOwnerUserId
1. USuser1875438
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.