[Anarchdb-devel] Re: database layout questions?

[Meshee]

2006/3/13, Meshee <address@hidden>:
> Heya there, i did lies to you earlier... i did dive in the code base.
>
> Here is the result of my work:
> a sql database schema of the core tables.
>
> As i did build the DB schema it raises some questions, if you guys
> could help me  answering theme it would be much appreciate:
>
> * *cards_names* -- table i do not understand what this table stand
> for. It looks like an attempt to have ALL cards in the same tables but
> i do not see the point. As a result it just add a level of indirection
> in the DB schema. The card_table field is the most mysterious.
>
> * *cards_XX_ignored* -- once again i do not see the purpose of thoses
> tables... missmatching cards during DB update?
>
> * *cards_types* -- according to the <FK> this tables contains card
> type (Action, Action Modifier etc) AND Vampire Clans O_O. Even if it
> looks non problematic at first, merging concept in the same table if
> prone to troubles on the long run. I wonder if something escape me?
>
> * *disciplines* -- this table looks to not be related to anything
> else, what does it stand for?
>
> * *rarity_types* -- i just wonder how anarchdb handles multiple rarity
> for a same card (Immortal Grapple)
>
> * *url* -- what does this fielsd use to contains? my guess is
> monger.vekn.org card url. If i guess right monger allow a search per
> name so may be it can be remove.
>
> * *cards_crypt* -- i see many fields with similar purpose:
> disciplines, inferior, superior, wha
>

hum humm bad click... well i go on here

why do we has thoses fields AND one field per disciplines?

Last question:
* library_selection/crypt_selection what do they stand for? no <PK>
<FK> i wonder if they are used at all
>
>

bbfn