Re: Latest DB schema

[sergey@total-knowledge.com]

It's not quite clear to me who Student is. Per docs,

http://www.total-knowledge.com/wiki/index.php/UU#Any_Student

Any Student
1. Takes free courses
2. Searches for UMOs

Does it mean that _any_ visitor is a Student by default?
I think a Student is an user who gets a course(paid or not paid) that has
a Teacher.
Gets = starts browsing a course(for free courses)
Buys a course(for paid courses)

> 1. There are many different "solution" types. Teacher-verified is only
> one of them.
>     (all others are actually verified automatically, immediately upon
> solution submission)
> http://www.total-knowledge.com/wiki/index.php/UU#Problem
> I just updated that page with some specifics on what each solution type
> is.
>
> 2. Teachers are tied to a course. This means we'll have to build fairly
> complex
> query to figure out who the problem solution for teacher-checked problems
> gets submitted to.
>
> 3. Remember - we store all solutions submitted to problems forever
> (regardless of their current access to given problem)
>
> Can you explain how you are addressing (or plan to address) all of above?
>
> Alexey Parshin wrote:
>> The problem is solved, if solution is presented and signed by some
>> teacher.
>> While placing the signature is trivial (another table with id and two
>> references, to solution and to teacher), we still have to think on how
>> to enforce the "teacher" role. Is it one of the ACLs for the problem?
>>
>> 2006/11/3, Ilya A. Volynets-Evenbakh <ilya@total-knowledge.com
>> <mailto:ilya@total-knowledge.com>>:
>>
>>     OK. This looks very good to me. Even better then what I had
>> originally
>>     in mind
>>     (Per-object notifications, that would be sent to all authors in
>>     case of
>>     referenced
>>     object change). Per-object per-user preferences are certainly
>> better!
>>
>>     Now, another thing that Sergey brought up, and which wasn't
>>     answered yet:
>>
>>     >> Also how do we know if a problem was "solved"/"not yet solved"
>>     by student?
>>
>>
>>
>> --
>> Alexey Parshin,
>> http://www.sptk.net
>
> --
> Ilya A. Volynets-Evenbakh
> Total Knowledge. CTO
> http://www.total-knowledge.com
>
>