-
Database design for stock management software
hello
i am designing a stock maintanence software and need some help in design. This relates to consturction industry, where there will be about 03-04 godowns and 03-04 construction sites going on.
I need to maintain stock both at godown and construction site
currently my db has following table
material ordered -
divided in two tables
table one holds : order no (prim.key), supplier , date
table two holds : multiple items, quantity, price , order no
material received
table one holds : order no, supplier , date
table two holds : items, quantity, price, order no.
material issued to site (divided in two parts )
material utilised at site (divided in two parts )
material returned from site (divided in two parts )
material returned to original supplier (divided in two parts )
Is this way to separate each table a good way ?
awaiting help
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|