Scrap Management system Table Design

Question

Hi In my software scrap management is a process . I unknown about this process please guide me for it's process and Table Design . Thank's in advance

Riddhi Valecha · Answer

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..

Dnyaneshwar Babar · Answer

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

Jaganathan Bantheswaran · Answer

Hi Lot of DB models available here .

Dnyaneshwar Babar · Answer

HiJaganathan I am developing Inventory Management System in that software i want to maintain stock and scrap of products meansthere 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

Jaganathan Bantheswaran · Answer

Hi Question is not clear Explain in detail.