Home Projects Jobs Clientele Contact


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Latest DB schema

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,

Authoright © Total Knowledge: 2001-2008