Re: Latest DB schema

["Alexey Parshin" <alexeyp@gmail.com>]

I have made some changes in the database. All of them are trying to define our approach to solutions.
Now solution structure includes an extra table, solution_signature.
The solution itself got a new field, ps_grade.

2006/11/4, Ilya A. Volynets-Evenbakh <ilya@total-knowledge.com>:

Alexey Parshin wrote:
> Forgot to mention.
>
> 1) The name problem_list means pl_ prefix that is already taken by
> person_list.
Make it uu_problems, or something - it's important not to tie the name
to topic, since logically they aren't strictly tied.
>
> 2) If we are planning to use problems with connections to something
> else -
> we need a description for this.
Tests I think are mentioned in the spec.
> Currently, I only defined topic to problem
> (many-to-many) connection.
There isn't anything else _now_, but there will be in v2. I.E.
homeworks, tests,
stand-alone problems, etc.
>
> 2006/11/3, Ilya A. Volynets-Evenbakh < ilya@total-knowledge.com>:
>>
>> Alexey Parshin wrote:
>> > I don't think we need versioning on studen't solution. The
>> > problem_solutions could be replaced with student_solutions if that
>> > clarifies the situation.
>> OK.
>> > We do need something like solution_template or correct_solution - to
>> > verify solutions automatically. We do need versioning on that one.
>> That should be part of problem_content, since it is versioned, and (for
>> things like template-based solutions) can
>> also be translated.
>>
>> BTW, I think we need to change problem table names from topic_problem*
>> to problem_list, etc., since
>> problems can be linked to other objects (tests, contests), or be
>> completely stand-alone.
>> At least it'll be possible in future.
>>
>> Another (purely cosmetic) thing, I just noticed, is that we have
>> _contents tables, while
>> it should be _content.
>>
>> >
>> > 2006/11/3, Ilya A. Volynets-Evenbakh <ilya@total-knowledge.com
>> > <mailto:ilya@total-knowledge.com>>:
>> >
>> >     Uh oh
>> >     1. Solution type is tied to the problem
>> >     2. Student's solutions to a problem are not versioned. It's not
>> >     content.
>> >     3. Word "Solution" refers to two different things:
>> >         - Correct solution, that problem author provides, and which is
>> >     carried
>> >           along with the problem itself
>> >         - Student's solution, which student submits for verification
>> >     against
>> >           "Correct solution"
>> >
>> >     We really need to find a different terminology, to disambiguate
>> >     "solutions"
>> >
>> >
>> >     Alexey Parshin wrote:
>> >     > The solutions are submitted to problem_solutions table.
>> >     >
>> >
>> >     --
>> >     Ilya A. Volynets-Evenbakh
>> >     Total Knowledge. CTO
>> >     http://www.total-knowledge.com <http://www.total-knowledge.com>
>> >
>> >
>> >
>> >
>> > --
>> > Alexey Parshin,
>> > http://www.sptk.net
>>
>> --
>> Ilya A. Volynets-Evenbakh
>> Total Knowledge. CTO
>> http://www.total-knowledge.com
>>
>>
>
>

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

-- 
Alexey Parshin,
http://www.sptk.net