Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
millzee
Starting Member
2 Posts |
 Posted - 2009-05-22 : 09:40:57
|
| Hi everyone, I really need some advice from an expert..i've written a web application that saves user inputted text from a textarea to a textfile in a members area where its shared by members of the team. What i want to do is try migrate the solution to a simple database.Currently, the text file is saved into a folder shared by a team of users. and becuase each team have their own folder, we dont get into a situation where duplicate files are ever created.to migrate this into a database seemed quite simple, however as i get more into coding the switch its becoming more aparent that the db model i've created wont do the job properly.So far, i've created a new db and with a single table called board that contains 4 columnsTID = text file ID (PK/auto incriment)UID = user id numberfilename = filename text = text from text areamy dilema is this, because multiple users will be saving data into the database, having just the filename unique wont work because someone else may potentially use the same filename for their data. I need some sort of unique association between the UID, filename and text so when a query is executed, the right data is pulled into the users textarea were they can update if needed.Looking at what i've done so far, do you think i should be moving columns into their own seperate tables?i'd be really grateful of an experts advice on this before i spend anymore time on it...regardsMillzee |
|
|
millzee
Starting Member
2 Posts |
Posted - 2009-05-22 : 10:07:49
|
| I think i managed to sort it. i'll append the uid in front of the filename being inserted. that way each uid, filename and text are unique...i hope.cheersmillzee |
 |
|
|
|
|
|
Newbie Question - Database Design