Hi, is it possible to create a table from other tables with the following conditions?
Note! My goal is to create that table 'Hours' with a say 362 records and after that to update those records with UPDATE sql commands. That is, I don't want to INSERT in that table any more records, but just UPDATE it's existing records only with new or modified informations. The conditions are as follows. The resulting table called Hours should look like this: Columns are: id,date,D,lb,g,c,lp,ld,re where D is a Day name in Week, lb is the number of the Lesson Block hour, g is the grade of a school class, c is the name of the school class, lp is LessonPlan, ld is LessonDiary, re is Reminder. Example records would be like this: 1,2017-9-1,F,1-2,5,b,,, 2,2017-9-1,F,1-2,7,c,,, 3,2017-9-4,M,1-2,7,b,,, 4,2017-9-4,M,1-2,5,a,,, 5,2017-9-5,Tu,1-2,8,c,,, 6,2017-9-5,Tu,1-2,8,b,,, 7,2017-9-6,W,1-2,8,a,,, 8,2017-9-6,W,1-2,7,a,,, 9,2017-9-7,Th,1-2,6,a,,, 10,2017-9-7,Th,1-2,5,c,,, 11,2017-9-8,F,3-4,5,b,,, 12,2017-9-8,F,3-4,7,c,,, where the last three columns have NULL values so far, because later I want to fill those with informations by using UPDATE sql command. So in Hours table one or more records could have the same date, Day name in Week, Lesson Block number, but could have also same grade, and same class name. Only id is UNIQUE in these records. For start I will be happy to get the Hours table with proper date and Day name in Week values out there. Which date is proper in the Hours table should be determined by another table in the database. Let this table be called the 'Semesters'. However, a date value in Hours table should not be a Sunday date in the Year. The Semesters table should have the following columns: id,numberOfSemester, StartDay,EndDay In a record of Hours table a date should have the Day name in the Week which it has in the Calendar, but this behavior can be changed by another two tables in the database; let these be called the 'TeachingSaturdays' and 'Timetable Exceptions'. The TeachingSaturdays table should have the following columns: id,date,D where the value for date column is definitely a Saturday day date, and D could be one of these: M, Tu, W, Th, F. The TimetableExceptions table should have the following columns: id,date,D where the value for D column could be one of these: M, Tu, W, Th, F. Well, I hope I have clearly defined the problem. Can this Hours table be created with these constraints? -- Best, Pali _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
