Hi, i was wondering if someone might be able to help me. I currently sell paintings using an auction format in hotel suites.

I wish to expand this and operate on line. I'm currently designing a database and need some help on the design.

Requirements:

Different levels of access for Admin Staff and public users.

Sellers and buyers will submit there own details and have a password.



So far i have...........

USERS
user_id
title
first_name
second_name
house_no
street
town
county
postcode
phone_no
date_reg
last_login
user_level
activated (When reg, an email sent for activation via link in email)
password

PAINTINGS
paintid
type
artist
year
description
reserve_price
condition
signiture
current bid
bid_history
no_of_bids

AUCTION DETAILS
paintid
userid
commision
price_Reached
net_Amount_for_Seller


I'm not sure if this will work, or if i have designed the database wrong.

I also want a tracking section that will show current highest bid, number of days left, history of all previous bids, number of bids to date and archive all this after the auction has ended. I've tried adding this to the above. Should i get rid of the AUCTION DETAILS and add this to PAINTING? What would you reccomend?

Any help or pointers would be excellent

Many thanks