Re: Database schema [was: UU tools]

["Ilya A. Volynets-Evenbakh" <ilya@total-knowledge.com>]

That's correct - and that is exactly the answer I gave to your original
question.
To rephrase:
- There are ways to connect users to objects other then through ACL
- ACL connection doesn't have to be present for other types of connections
  to exist.
- Yes, ACL lists can change as a result of user's actions

This applies to any type of object, not just problem. Problem is just
easiest
example to demonstrate on.

Alexey Parshin wrote:
> This is a different issue. I'd split it in two:
>
> 1) We need a problem_completion or similar table that shows  problems
> of the student with their state.
> 2) Completing a problem switches it into read-only mode. I'm not 100%
> sure that this is unconditional, but it makes sense.
>
> I can think of ether a trigger to achieve 2) upon problem completion,
> or a procedure "problem completed()" that does it for us. Actually, it
> may be a proc in both cases, and trigger may just call it..
>
> 2006/9/23, Ilya A. Volynets-Evenbakh <ilya@total-knowledge.com
> <mailto:ilya@total-knowledge.com>>:
>
>     There is another way - every time someone "passes" an object
>     (meaning of
>     "pass" depends
>     on object type), there is a trail record left. I.E. if student
>     solves a
>     problem - there is a record
>     in some table (user_problem_solutions?) that indicates when he solved
>     it, what his answer was,
>     what his score was, etc.
>
>     If someone passes a course, he also leaves such a trail. He just loses
>     access permissions once
>     he is done, and is not signed up any more.
>
>     Alexey Parshin wrote:
>     > Does it mean - we can always connect course and student through
>     an ACL
>     > _only_? I.e. course_list_acl is the only connection between
>     course and
>     > student? :
>     >
>     > Something like:
>     >
>     > SELECT *
>     > FROM person_list, course_list, course_list_acl
>     > WHERE
>     >    pl_id = cla_person
>     >    AND
>     >    cl_id = cla_course
>     >
>     > (assuming that cla_* are the fields from course_list_acl)
>     >
>
>     --
>     Ilya A. Volynets-Evenbakh
>     Total Knowledge. CTO
>     http://www.total-knowledge.com
>
>
>
>
> -- 
> Alexey Parshin,
> http://www.sptk.net 

-- 
Ilya A. Volynets-Evenbakh
Total Knowledge. CTO
http://www.total-knowledge.com