[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
Re: Latest DB schema
You should be able to. Last time we looked at it, it worked fine.
sergey@total-knowledge.com wrote:
> Can you please create .svg file? I can't open it with my Umbrello.
>
>
>> I have added most of the stored procedures to the database schema and
>> committed it to SVN. It needs some polishing that I'd do within next
>> couple
>> of days.
>> I need to know your opinion about the set of the procedures, procedure
>> names, parameter names, etc. In ideal case, the usage of the stored
>> procedure should be understood from its declaration.
>>
>> 2006/11/14, sergey@total-knowledge.com <sergey@total-knowledge.com>:
>>
>>> Got it. Thought I was missing something.
>>>
>>>
>>>> Schema isn't finished yet. At this point, I didn't define most of the
>>>> foreign key. The connections on the schema just show that the foreign
>>>>
>>> key
>>>
>>>> should be there.
>>>> And, at the moment, I have no idea if it's possible to indicate any
>>>> constraints besides foreign/primary keys in Umbrello. If I wouldn't
>>>>
>>> find
>>> a
>>>
>>>> way, the constraints would be added by a script file, after the
>>>>
>>> generating
>>>
>>>> of the database structure from Umbrello. The way Umbrello generates
>>>>
>>> the
>>>
>>>> database structure is pretty special - it generates a bunch of .sql
>>>>
>>> files
>>>
>>>> (one table per file). To get them together we would need a small C++
>>>> program
>>>> that would order these files so they could be ran properly. Otherwise
>>>>
>>> the
>>>
>>>> foreign key creation would be impossible. The other way is to cut-off
>>>>
>>> all
>>>
>>>> the foreign keys into a separate script, and run this script after all
>>>>
>>> the
>>>
>>>> tables are created.
>>>> And then, of course, come stored procedures :)
>>>>
>>>> 2006/11/14, sergey@total-knowledge.com <sergey@total-knowledge.com>:
>>>>
>>>>>> sergey@total-knowledge.com wrote:
>>>>>>
>>>>>>> For example, combination "pl_login + pl_password" in person_list
>>>>>>>
>>>>> should
>>>>>
>>>>>>> be
>>>>>>> unique for each user.
>>>>>>>
>>>>>> Ugh?? What does password have to do with uniqueness?
>>>>>>
>>>>>>
>>>>> Sorry, pl_login should be unique.
>>>>> Or in difficulty_level table dl_name column should be unique imho(and
>>>>> varchar type too). Authors shouldn't be allowed to create more than
>>>>>
>>> one
>>>
>>>>> difficulty level with the same name.
>>>>> How this kind of info presented in our schema?
>>>>>
>>>>>
>>>>>
>>>>>> --
>>>>>> Ilya A. Volynets-Evenbakh
>>>>>> Total Knowledge. CTO
>>>>>> http://www.total-knowledge.com
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>> --
>>>> Alexey Parshin,
>>>> http://www.sptk.net
>>>>
>>>>
>>>
>>>
>> --
>> Alexey Parshin,
>> http://www.sptk.net
>>
>>
>
>
>
--
Ilya A. Volynets-Evenbakh
Total Knowledge. CTO
http://www.total-knowledge.com