TheFilmGod Posted June 21, 2009 Share Posted June 21, 2009 I'm designing a school website for a school. I'm currently working on the calendar feature. However, I've hit a blockade. Recurring events are not a problem for me. Any repeating events will get a new record. I'm going for speed not for space. Here's the problem - there will be many different events - school, grade, club, and homework... School events will apply to everyone, but grade, club, and homework, will apply to only a certain number of students. How do I design a database schema to make it easy for JUNIOR IN CALCULUS BC to find all school events, grade events, and homework that apply to him? Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/163151-calendar-database-schema/ Share on other sites More sharing options...
irvieto Posted June 21, 2009 Share Posted June 21, 2009 Hi. So.. let me guess what you have.. a calendar table (id, start_date, end_date, id_type_of_item, title, etc..) and a students table. I think the "id_type_of_item" (1-Grade, 2-club, 3-homework,4- God knows what else...) will solve this issue. Now, how is the relationship between students and the items? Is there only grade per student or multiple? Quote Link to comment https://forums.phpfreaks.com/topic/163151-calendar-database-schema/#findComment-860786 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.