title: Designing Database for File Structure
body: <p>We are using file system to store files within the application. Now we change this to use SQL2K5 for storing as BLOB instead as per requirement.</p>
  
  <p>Now, we need advice regarding the design for table. Obviously, it must have a folder, files within files, size, last date modified, etc., similar to file system.</p>
  
  <p>I start with:</p>
  
  <blockquote>
    <p>FileID, ParentFileID, FileName, Size, LastDateModified, DateCreated, LastModifiedBy, ModifiedBy</p>
  </blockquote>
  
  <p>How can this be modified to handle folders as well?</p>