[Kde-finance-apps] alkimia db doubt

puneet goyal puneetgoyal08 at gmail.com
Thu Jul 21 09:02:19 CEST 2011


 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
-----------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.kde.org/pipermail/kde-finance-apps/attachments/20110721/54c81648/attachment.htm 


More information about the Kde-finance-apps mailing list