What do these words mean 2

I still don't know what many of the columns are for...

I really appreciate the database, but IF I can't figure out what a field is intended for, I probably won't use it. I'm sure there is an important purpose for each field, so I don't want to overlook or ignore anything, SO a description of some sort in the comments for each field would be so so so helpful.

As I read through the posts, I understand more and more, but I am still unclear on a few things:

UserVarificationCode ?
UserIP ?
OrderEmail ?
DetailName ?
DetailPrice ?
DetailSKU ?
DetailQuantity?
(actually, what is the purpose of the order details table?)

Thanks for your help - I am so close to having all this fall into place.

David

By the way, wouldn't a VENDORS table make this database absolutely perfect?!?

UserVarificationCode
This is the code that is sent to the user when verifying the email address.

UserIP
This records the users IP address so you can block abusers (i.e. Spammers)

OrderEmail
This the email address used when they place the order

DetailName
This is the name of the product ordered

DetailPrice
This is the price of the product ordered

DetailSKU
This is the SKU (Stock Keeping Unit) number of the product ordered
Stock-keeping_unit

DetailQuantity
This is the quantity of the product ordered

(actually, what is the purpose of the order details table?)

This is called Database normalization. The order is separated into two parts. The first part of the order contains information about the order itself, while the second part (Detail) has a record for each item ordered. This allows you to have unlimited numbers of items for each order without wasting space in the database.

See this article for more information:

Designing a Database
161/

Yes the vendors table is strangely absent but you can easily add it to the database following the example of the User table.