Home Projects Jobs Clientele Contact


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

Re: Latest DB schema

Keys should be generated after creating tables (I think it could
be true for primary keys as well). It's just lot simpler to automate
whole thing this way.

Alexey Parshin wrote:
> 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
> <mailto:sergey@total-knowledge.com> < sergey@total-knowledge.com
> <mailto:sergey@total-knowledge.com>>:
>     > sergey@total-knowledge.com <mailto: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 

Ilya A. Volynets-Evenbakh
Total Knowledge. CTO

Authoright © Total Knowledge: 2001-2008