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