What do these words mean?

[rikaG_510]

Hello,

I just started to learn about MySQL using the starter kit and free eCommerce MySQL Database. Now I am building my own database for my shopping cart, I have some questions to ask.

1. I can't figure out the meaning of some Column titles in some tables.

In a columns under "product" table, there are cells such as;
-ProductSKU (what does SKU stand for?)
-ProductLive (what does this mean?)
-ProductUnlimited (what does this mean?)

I'd like to customize product table so I can start inputing product info, but can't figure out what these are.

2. There are tables for "option group" and "options", what exactly are these for?
What I mean is, are these options for products (like product description)?

Could anyone give me any idea please?
Thank you in advance.

Rika :-)

[rikaG_510]

I just googled again for SKU and I found that it stands for "stock keeping unit", which makes sense a lot...

[Office Guy-172461]

SKU stands for Stock Keeping Unit. It is used to uniquely identify a model of a product (i.e. large blue widget has a different SKU than a Large green widget).

ProductLive indicates that the product will display on the site. This provides an easy way to temporarily take a product offline without deleting it.

Unlimited means there is unlimited inventory (i.e. downloadable product)

Options would be things like size and color.

[Neil Beadle]

Hey Rika,

Those are great questions, and for future versions of this database, we'll try to provide comments on any less specific tables or columns.

Don't worry too much about some columns not making sense or appearing unnecessary. This database is intended to cover a wide spectrum of websites, and if you end up with some columns or tables not being used because you have no use for them, that is fine. Who knows, they may come in handy later.

[rikaG_510]

Thank you both, now I feel much better!

>This database is intended to cover a wide spectrum of websites.
I thought so, but just couldn't leave them or go to the next step not knowing what these were for.
(I bet there are other folks who feels the same way ).

I wondered for a moment if this question would be too basic, but I guess there's nothing to lose by asking any question!

Rika ;-)