Re: DB structure: Dialog of Texts (DoT)

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

Here is the latest DB schema as I understood it..

The changes added:

1) Added a table text_text_reference to allow to define text to text relation. It also has a reference to texts_relation as described by Anatoly.
2) Added a table topic_group to allow a topic to be a subtopic to another topic
3) Added a difficulty_level table to define a level of difficulty for an explanation, problem, etc..
4) Added a blue background color for the tables defining system dictionaries that never supposed to be changed by user.

See the attached SVG file (can be viewed by different graphical viewers including Web browsers).

2006/10/18, Anatoly Volynets <av@total-knowledge.com >:

I need to look it over.

Ilya A. Volynets-Evenbakh wrote:
> Alexey Parshin wrote:
>
>> Any object that is potentially changeble should have an ACL entry.
>>
> Correct. It's just I think DoT is single object, including texts it
> contains, and Texts
> that are part of it are not separately shareable. However, I'm not 100%
> sure about it.
> Apparently we talked about what DoT really is, but never wrote it down.
>
>> Someone may want to edit a text.. Adding, deleting texts with DoT may
>> be assumed as 'edit' permission on DoT.
>>
>> Cross-reference would be added. I just need to understand, is it like
>> 'Also take a look at the following texts: {list of texts here}' ..
>>
> OK. I updated
> http://www.total-knowledge.com/wiki/index.php/UU#Dialogue_of_Texts
> with bit more info. Now, we need to review it and figure out if it's
> really something we
> want to do, and that we want it in UUv1time frame.
>
>
>> 2006/10/18, Ilya A. Volynets-Evenbakh <ilya@total-knowledge.com
>> <mailto:ilya@total-knowledge.com >>:
>>
>>     What I mean is that single text within DoT may not actually be
>>     separable.
>>     I.E. one cannot reference separate text, and thus there is no need
>>     to have
>>     separate ACL. Access to whole dialog object applies to separate
>>     pieces
>>     of it as well.
>>
>>     Also, important part of DoT functionality is cross-referencing between
>>     texts.
>>     How is this reflected in our database schema? (Take a look at
>>     Model-layer
>>     to see sketch of what is intended).
>>
>>     Alexey Parshin wrote:
>>     > IMHO, dialog of text logically should be connected to a topic. We do
>>     > need an ACL for the texts, controlling editing, deleting, and MB
>>     even
>>     > referencing (for the commercial server).
>>     >
>>     > 2006/10/18, Ilya A. Volynets-Evenbakh < ilya@total-knowledge.com
>>     <mailto: ilya@total-knowledge.com>
>>     > <mailto:ilya@total-knowledge.com
>>     <mailto:ilya@total-knowledge.com >>>:
>>     >
>>     >     - Is dialog_of_texts really course-level thing?
>>     >     Actually this is more of a question to Anatoly. Spec says
>>     >     it's course-level object, but I suspect what is meant is that
>>     >     DoT is at the same level as course ( i.e. completely
>>     independent)
>>     >     I guess it could be referenced from courses/topics/etc. in same
>>     >     way as any other media object.... I think this needs more
>>     detailing
>>     >     in specification.
>>     >
>>     >     - I'm not sure we really need separate ACL for texts_in_dialog
>>     >     Again - needs clarification in spec - i.e. can texts be included
>>     >     in different dialogs without being modified. Is
>>     cross-referencing
>>     >     between texts in a dialog actually separate from texts
>>     themselves
>>     >     (logically it can be, but does our data structure reflect
>>     that at
>>     >     all?)
>>     >
>>     >     --
>>     >     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
>>
>>
>>
>>
>> --
>> Alexey Parshin,
>> http://www.sptk.net
>>
>
>

--

Anatoly Volynets, Co-Founder
total-knowledge.com
culturedialogue.org

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

Attachment: UU database structure.svg
Description: image/svg