Re: Inventory Stock Design
uhh.. are you talking about designing a MySQL table to do what you want? or designing an HTML table to do that?
give some more information if you could.
Re: Inventory Stock Design
Quote:
Originally Posted by kows
uhh.. are you talking about designing a MySQL table to do what you want? or designing an HTML table to do that?
give some more information if you could.
Thanks..i mean Mysql table. I dont know how to do it.:(..can u give me an idea..Thanks
Re: Inventory Stock Design
well, from what you told me i only understand that you need a table that references branches and inventory items.. i don't know what you mean by everything must have a "masterstock." but from your example, you need stock in and stock out? i don't understand. are they the amount of stock in and out? is it a boolean (either incoming or outgoing)? if you're asking for someone to design a table for you, you need to explain your ideas clearly.
soo.. taking a blind stab in the dark: assuming you want branch name, inventory name, stock in/out, and the date, you will need four fields, branch and inventory, both of them being either varchars or texts, date being an integer with a max length of 11 (length of unix timestamp), and stockmode as an enum with the values incoming or outgoing. i made the table for you:
Code:
CREATE TABLE `stock_inventory` (
`branch` TEXT NOT NULL ,
`inventory` TEXT NOT NULL ,
`mode` ENUM( 'incoming', 'outgoing' ) NOT NULL ,
`date` INT( 11 ) NOT NULL
) ENGINE = MYISAM ;
Re: Inventory Stock Design
Thanks a lot..i try it now. :)