Kenneth, May I request you to *please* send this feedback to the gnu-khata mailing list? 1, this mailing list is for gnu/linux users and at some point of time people might not be interested to get into this thread which is valuable for me and my team. 2, most of our developers are on the gnu=khata mailing list so they will bennifit out of your feedback.
happy hacking. Krishnakant.
On Wed, 2009-05-20 at 11:13 +0530, Kenneth Gonsalves wrote:
On Tuesday 19 May 2009 14:22:18 Krishnakant wrote:
Good observation and thanks for your feedback.
feedback no 2:
- you have 3 tables - organisation, vendor and customer. A lot of the address
information is the same. This may be abstracted out into a separate table.
- if city is made a foreign key to a city table, state and country
information is redundant
- "Product table which can maintain fields for all possible product types". It
is not possible to list all possible product types, and should not be hard coded anyway as you are just wasting database space. Since most of the fields here are text or integer, you should have a flexible template type table where these values can be named and entered. Most users will only require a few of these anyway.
there is lots more - when I have time ...
-- regards Kenneth Gonsalves Associate NRC-FOSS http://nrcfosshelpline.in/web/