Hi All:
Could you give me some real advice on this situation. I have loads of tutorials & books on this, but I'll still need some guidance from developers. Let me briefly explain the situation...
The purpose of the site is to sell audio clips/tracks, that have been produced by my studio. Each audio file is 30 seconds long, and is in .mp3 & .wav format. As I cannot afford a merchant account at this time, all payments will be made either through PayPal, by cheque or by money order...
Here is the idea I had when creating this table. Can you tell me if I am in the right direction or what you would do differently?
COLUMN
ID
DATE_INPUT
INVOICE/REFERENCE NUMBER
LINK TO .MP3
LINK TO .WAV
LINK TO PRICE
LINK TO PURCHASE OPTIONS
The purchase options link would extract the the price, invoice/reference #, and date input into the system to a checkout screen with an option for PayPal, cheque or money order.
What vital element(s) am I missing in the list above?
Is there any reason that I would want to use more than one table to
accomplish this? If so, what elements should be accounted for in each
table.
Since there is no actual invoicing system yet, do you suggest that I
randomly create an invoice # for each sample, or use the auto-incrementing
ID column to give each sample a reference # to order by?
I'm looking for the best options as this is a simple application, but one I do not have much experience.
Thanks, any and all help is appreciated.
M
