ok, here's the thing: If I were to create a fileserver website like Microsofts SkyDrive then how should I structure the database? There are incredibly little information about database structure on the internet (web security too) and I've searched a whole lot. Should I create a table for every user containing the files or should I have one single large table with thousands of records of files in which I have a column with the name of the user the file is belonging to?
gunnarflax
0
Junior Poster
Recommended Answers
Jump to Postwhat about creating two tables
1..containing the user information
2..containing the users files information.
and linking both
All 2 Replies
debasisdas
580
Posting Genius
Featured Poster
what about creating two tables
1..containing the user information
2..containing the users files information.
and linking both
gunnarflax
0
Junior Poster
Yeah that is how I have it at the moment but since I haven't found any good tutorials on database structure I'm always uncertain how to design my databases. So you think that the way I'm doing it now would be the best way?
Do you know any good database resources?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.