Solved

Table design idea for Calendar

Posted on 2011-09-22
2
251 Views
Last Modified: 2012-05-12

I need to design a table for a calendar. I'll be using Telerik's calendar control. User opens the calendar in week or month view. They
click on , for example, Thursday 1 PM March 2012 and Tuesday 2 PM October 1st, etc.  I need to save calendar choices in the database for each user. Multiple choices (dates) for each user.

How can I design this table? Do I need more than one table? One for each month, one for each day, one for each hour? and one for each month?
(I need to read the data back as well and populate the calendar control with this data...for example, mark the calendar red or something.)
0
Comment
Question by:Camillia
2 Comments
 
LVL 21

Accepted Solution

by:
JestersGrind earned 500 total points
ID: 36581412
It sounds like you are trying to associate a date/time with a user.  Assuming that you already have a Users table, I would add a Schedule table with a ScheduleID as it's primary key.  ScheduleID could be an identity column.  Then a UserID column with a foreign key reference to your Users table.  Then a ScheduleDate datetime column to hold the date/time of the scheduled date.  Maybe a few other columns depending on what other characteristics you need to capture like comments, color if you allow the user to select this, etc...

Greg



0
 
LVL 7

Author Comment

by:Camillia
ID: 36581460
ah, yes, i dont need to separate day, time, month, etc tables. Thanks. I will try that.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question