Tilted Forum Project Discussion Community - View Single Post - Best way to set up this Mysql? (primary key?)

Realizm · 02-27-2004, 05:34 PM

Me and a friend are technicians and I'm wanting to set up a database that contains info on the items we work on.

Products that are the exact same (model number, type) are grouped by "Item Number" which we have created over time.

The database would include spaces for the item number, model number, etc. We work with several different objects though and there are thousands of differen t products so many many item numbers.

I have been reading a little about how a "primary key" in mysql is like something unique.. like a way of tracking, I guess?

would it be good for me to set up a primary key as our item number?

02-27-2004, 05:34 PM	#1 (permalink)
Realizm Insane Location: A fuzzy cloud.	Best way to set up this Mysql? (primary key?) Me and a friend are technicians and I'm wanting to set up a database that contains info on the items we work on. Products that are the exact same (model number, type) are grouped by "Item Number" which we have created over time. The database would include spaces for the item number, model number, etc. We work with several different objects though and there are thousands of differen t products so many many item numbers. I have been reading a little about how a "primary key" in mysql is like something unique.. like a way of tracking, I guess? would it be good for me to set up a primary key as our item number?