[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
Classes and groups
- To: uu@total-knowledge.com
- Subject: Classes and groups
- From: "Alexey Parshin" <alexeyp@gmail.com>
- Date: Sat, 5 Jul 2008 13:53:43 +1000
- Delivered-to: mailing list uu@total-knowledge.com
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=+eS5hb76k3wjDjHkAfNWvuCWNbWGRFm6cjAgOncvOA4=; b=wGJUcAsXeGO0QO7XyL3226iD0G+S7Tm+1ChAr+aR6s9DXnl01/PlMXKSM9NlqKM0ET 1ENj67r0+Br/w5X17JVhlv+MaSYchrT77+GW7ADaVhFAEW44oFEIRcnq+wqRRl5nnh6i u5fAb8tN5hKXNGxBePEVjsteJH0kDBo/65QUk=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=td9c+F0aTJHLzwfSpdhELFXm76tFIeowsxLuDCx1HNNPJ1s+eaPtci5FnRk3UoVzRi AUrsMIrETGLX6VI/ntld9U4WCtoKmBWMvqAKTzBXaePbZ486hCsMr711pLQkf73ipnoR iFJSdIHfyQJg2e8LeOXNUgzXVK/dnD0rxrLDE=
- Mailing-list: contact uu-help@total-knowledge.com; run by ezmlm
Here is my attempt to summarize the course-class-group relations. After a discussion, I intend to write it into Wiki to prevent future questions on that matter.
1) Course is stored in study_course table, with mandatory connection to TLT.
2) Class is stored in course_class table, with optional connection to course (many to many r/ship) through course_to_class table.
3) Class contains a set of groups with different group types of { ADMINS, TEACHERS, STUDENTS, etc }
4) There is no direct subscription to Course (please confirm). There is subscription to a certain group of the class.
Now, the uncertain part:
5) A group is subscribed to a set of versions of the course TLT and all the included (at the subscription moment) UMOs.
6) The list of the subscribed courses for a person can be determined as a list of the TLTs (connected to study_course), for all the groups (connected to classes) where a person is a member.
7) For a group, class reference is optional (currently doesn't exist).
8) Subscribing one to a class means including one into the group 'STUDENTS' of the class.
9) The group type should be unique within the class (please confirm), so we can't have mor than one group of, say, students per class.
Any inforcements of described relations with foreign keys are expected to increase the performance.
After we discuss that, I'd need to understand what part of Wiki it belongs.
--
Alexey Parshin,
http://www.sptk.net