Hello!

Im quite stuck on how to get this to work. I want so my "customers" could see their renting history and I would also like to somehow keep track of the quantity of DVDs and VHS of each movie. I mean, I would like to have maybe 5DVDs and 2VHS of the movie The Town and maybe 2DVDs and 0VHS of the movie Blood Diamond.

This is what I have now:

users
{
id
username
name
adress
city
email
password
suspended
}

films
{
id
name
about
new_date
}

rents
{
userid
filmis

rent_date
due_date
}

category
{
filmid
category
}

images
{
id
image (blob)
}

Any help/input/opinions is greatly welcomed. Thanks!