advice on billing table

[harkly]

Am looking for the best way to set up my billing table.

 

This is what I have right now but I'm not quite sure if it is the most efficeint way to do it "normalized"

 

CREATE TABLE bill (invoice INT( NOT NULL PRIMARY KEY,
        billID VARCHAR(2) NOT NULL,
        userID VARCHAR(32) NOT NULL,
        dateBilled TIMESTAMP NOT NULL;

 

input::

INV00001 - 2 - user1 - 06/10/2010

 

My guidelines:

 

There will be set billIDs that goes with a certain amount of $. example 1 = $14  2 = $21

 

I also want to be able to keep track of what billID the user is choosing.

 

I will also have this table

 

 

CREATE TABLE billCode (billID VARCHAR(2) NOT NULL PRIMARY KEY,
amount INT(5) NOT NULL;