Who are Vendors?

These guys supply me all of the cool hi tech keyboards which make my cash register sing.

And the Vendors Table is where all my vendors live!. :) .

This is where I keep all the important details about every one of my vendors.

Alright, so, every vendor I have, gets a row in this table,

The vendor ID (vend_id) field is a unique identifier for each vendor and is also the primary key field.

Vendors Table

There are 7 columns in this table.

That means for each vendor I store seven separate and relevant pieces of information.

As you can see, every field name is quite self explanatory, and that’s becoz I’m a field naming genius!