[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
Re: UU database: problem tables
Actually,
I expected that single problem may be offered to many students, and every student may have personal solution with personal access and personal status.
Also, I suspect that status may be a part of many other ACL entries. In any given case, what entities need ACL but still not covered with ACL yet?
2006/9/26, Ilya A. Volynets-Evenbakh <ilya@total-knowledge.com>:
Looking at latest database diagram.
Wouldn't it make sense to combine topic_problems and problem_solutions
tables?
One problem - one solution after all...
Another thing (which sort of derives from this): there is no real
person_solution_ACL.
It's just person_problem_solutions in this case, and it contains info on
how the person
solved the problem, not on their access to it (there still will be
person_problem_acl, that
shows access of given person to given problem).
--
Ilya A. Volynets-Evenbakh
Total Knowledge. CTO
http://www.total-knowledge.com
--
Alexey Parshin,
http://www.sptk.net