Scrap Management system Table Design

Riddhi Valecha12y ago

Hi..

Can you please explain the system flow ...

From what I have understood, I can suggest that make a table as below -

ID	ProductID	IsDamaged
1	P1	true
2	P2	false
3	P3	true
4	P4	false

ID- int, PK,
ProductID - varchar, not null
IsDamaged - bit and not null,

If the product is damaged, then the column will have "true", else "false".

Hope this helps..

0

Dnyaneshwar Babar13y ago

Hi, I have seen that website this is good one but my stuff is not there.... if you have another answer then please send me Thank's in Advance

0

Jaganathan Bantheswaran13y ago

Hi,

Lot of DB models available here.

0

Dnyaneshwar Babar13y ago

Hi,Jaganathan I am developing Inventory Management System in that software i want to maintain stock and scrap of products means,there would be damaged products .those are damaged products i will store in scrap table . so how can i do that process or how can i design table for that.........next process is i want to sale scrap goods and add that amount into account table... Thank's in advance

0

Jaganathan Bantheswaran13y ago

Hi,

Question is not clear, Explain in detail.

0