Help on DB Design

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bootzwiz
    New Member
    • Jan 2007
    • 14

    #1

    Help on DB Design

    Hi,
    I have a form where users can choose number of file uploads ( drop down ) and upload images. I need to store the path of images in database.I want to know what is the best way to store multiple file upload paths. As per my knowledge it possible to store paths in one field with delimiter. Is there any other good way to store the paths.

    Raj
  • hariharanmca
    Top Contributor
    • Dec 2006
    • 1977

    #2
    Originally posted by bootzwiz
    Hi,
    I have a form where users can choose number of file uploads ( drop down ) and upload images. I need to store the path of images in database.I want to know what is the best way to store multiple file upload paths. As per my knowledge it possible to store paths in one field with delimiter. Is there any other good way to store the paths.

    Raj
    Generate FileId in the database and GroupId and FilePath

    FileId FileGroupID FilePath
    -----------------------------------------------------------------------------------------------------------


    Like this

    Comment

    • hoomaniraji
      New Member
      • Jul 2007
      • 10

      #3
      Originally posted by bootzwiz
      Hi,
      I have a form where users can choose number of file uploads ( drop down ) and upload images. I need to store the path of images in database.I want to know what is the best way to store multiple file upload paths. As per my knowledge it possible to store paths in one field with delimiter. Is there any other good way to store the paths.

      Raj
      i offer to have the following entity/table for your application :

      1-an entity named "Session " with these fields (SessionID,Sess ionName,Session Date ) with SessionID for primary key.

      2-an entity named SessionFiles with these fields(SessionI D,FilenameWithP ath,uploadStatu s) with "SessionID,File nameWithPath" for primary key.

      3-make relation for these two table with SessionID field.

      4-each form shows one session in your application for uploading the related SessionFiles.

      5-Enjoy it.

      Comment

      Working...