[Kde-finance-apps] Re: alkimia db doubt

[Alvaro Soliverez]

Hello Puneet,
you'll need an intermediate table to connect both tables.
Just to make sure, if you need another id for the payment, make the
table generate one. You can have an id column on the table, that
autogenerates an id.

Regards,
Alvaro

On Thu, Jul 21, 2011 at 4:02 AM, puneet goyal <puneetgoyal08 at gmail.com> wrote:
>  I have made some changes with committed revision 1242493 and 1242494.
> But there is a problem on how to connect the tables like the user and
> invoice table.
> There is an option if we have a field of suppose invoice id which will act
> as a foreign key and the table referenced can be the user table and for that
> user id can be used in that table.
> If we use this method then we will need another key(primary key) to identify
> a particular invoice.
> The ER diagram can be found on this link
> http://community.kde.org/Alkimia/Usecases/payment
> and the direct link is
> http://community.kde.org/File:ER_DIG_Payment_Detection.png
>
> Regards,
> Puneet
> --
> -----------------------------------------------------------------------
> Puneet Goyal
> Student of B. Tech. III Year (Software Engineering)
> Delhi Technological University, Delhi
> -----------------------------------------------------------------------
>