user_profile table
id
first_name
last_name
email
cellnum
username
pw
last_login
project table
id
title
date
author
file_size
last_modified
num_pics
num_users

 


picture table
id
title
date
author
file_size
last_modified
original_img
modified_img
tags
desc
audio
 
 

sub-folder table
id
title
date
last_modified
file_size
num_pics

 

 

The following are other many-to-many tables I will use:

  • user X project
  • project X picture
  • user X picture
  • subfolder X project