sql - Storing Schedule Information -
i need create table hold schedule meetings. meeting can scheduled be: daily 'ever x days'. x can between 1 , 6. ending after x sessions. 'sessions' number of repeats. weekly days during week can occur. mon, tue, etc. can select more 1 day per week. date on ends. monthly use can select day of month can occur (1st, 2nd etc) or can select lookup of '1st, 2nd, 3rd, 4th or last' , day 'mon, tues', saying, example "the 2nd friday" of month. how can store these scenarios in single table? i thinking: create table schedule ( id int not null identity(1,1) primary key, startdate datetime not null, endtime time null, repeattypeid int not null, // daily, weekly, monthly, none // daily everydaycount int null, // handle 'every 3 days', repeatcount int null, // how many occurances. can shared different repeattypes // weekly ismonday bit, istuesday bit, etc // field per day selection. there better way?