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! 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? Link to comment https://forums.phpfreaks.com/topic/163151-calendar-database-schema/#findComment-860786 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.