plodos Posted March 11, 2008 Share Posted March 11, 2008 i want to design a database, it will work like that... 1) there will be a user registration page, after the registration, user will select the article type(for ex, engineering, database, mechanic) and upload file...after the upload, if user select the for example "mechanic", script will send message all the mechanic reviewers... 2) there will be review registaration page and after registration, if the reviewer select the mechanic, reviewer will see the mechanic papers, and reviewer will check the papers, maybe will write some comments about the paper, maybe reviewer will upload the same paper to show whats wrong on the paper..also user can write some comments, user and reviewer can talk about the paper... 3) users will upload the files inside of FTP,at first i think to store each file in the mysql but some times one paper size can be 1MB or 3MB, thats very big size to store in the databse, and very difficult to backup....and also database must store FTP link like http://aa.com/upload/user2.doc CREATE TABLE user( user_id title mr/ms firstname lastname college email ..... ) CREATE TABLE writer( writer_id title fname lastName department email ... reviewer_permisssion( if the reviewer select mechanic and software or only engineering, must not see the database papers ) ) CREATE TABLE upload( upload_id upload_link ) CREATE TABLE comments( ??// reviewer 1, reviewer 2 can write comments for user15 paper.. also user15 can write comments for paper ) user can write the comments and maybe writer can write the comments also maybe user will upload another file and will write some comments maybe wirter will upload another file and will write some comments thats very diffiulcult to make a relation between tables like upload and comments for me:S who can help me to design this database? Quote Link to comment Share on other sites More sharing options...
Stooney Posted March 11, 2008 Share Posted March 11, 2008 Rather than having both a writers and users table, have just a users table with a column specifying the user type. Do the users upload the files through the website? Or do you literally mean FTP? If you actually have them using ftp you should consider writing an upload script. Quote Link to comment Share on other sites More sharing options...
plodos Posted March 11, 2008 Author Share Posted March 11, 2008 user will upload the paper and databse will save the file path.., and reviewer can see the the related papers in the website part.. but comment and upload tables, i didnt make any relation, im new for dbase design... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.