PHP Developers Network
http://forums.devnetwork.net/

work with an inventory, with some items having serial number
http://forums.devnetwork.net/viewtopic.php?f=2&t=147853
Page 1 of 1

Author:  Vegan [ Tue Jun 26, 2018 10:50 pm ]
Post subject:  work with an inventory, with some items having serial number

I was wondering how to use MySQL to handle an inventory system, easy enough when there is a simple count of the UPC for each item

I was wondering with electronics how to handle series numbers

clearly serial numbers are not useful as an index, while UPC is slightly more suitable

ideas?

Author:  Christopher [ Wed Jun 27, 2018 12:50 pm ]
Post subject:  Re: work with an inventory, with some items having serial nu

I would in general recommend an autoincrement INT for indexes. The product, serial, series, etc. numbers would be separate fields that can be indexed if they are to be searched in WHERE statements.

Author:  Vegan [ Wed Jun 27, 2018 3:17 pm ]
Post subject:  Re: work with an inventory, with some items having serial nu

That is more or less what I was figuring, more rows for those items with serial numbers.

products like iphone cables do not have a serial number, unlike the iphone itself

upc codes are abundant but imperfect

I was pondering 2 tables, one for the products and a bool then for those who have serial numbers,pull the data from another table which would simplify things a tad

Author:  Christopher [ Thu Jun 28, 2018 11:17 pm ]
Post subject:  Re: work with an inventory, with some items having serial nu


Page 1 of 1 All times are UTC - 5 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/