Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 3 of 3
  1. #1
    Junior Member
    Join Date
    May 2005
    Posts
    3
    Member #
    9941
    Hi! I'm trying to build an archive of documents and need some help with the table structure to make the archive searchable.

    An example of my doc's are:

    Main category: Holiday, Lifecycle, History
    Sub Category: New Year, Birth, Independence Day

    Some files may be a main category i.e. a general doc on holiday, others could belong to more than one sub category i.e. a main category Calendar would have New Year and Independence Day as well. I also don't know if I could get them all under a main and sub and may need a third level.

    I would like to the user to find the file by 1) search box, 2) keyword index, 3) click on main category which will bring to sub, and so on. 4) search through drop down menu. (Did I miss any?)

    Am I building this properly with main and sub cats, or is there some other method? And how do I structure the table for sub and sub sub cat? What do I do with a file that doesn't really belong anywhre, make a misc.?

    This is what I'm working with:

    File
    FileID
    FileName
    FilePages
    FileDate
    FileAuthor
    FileDescription
    Classification essay, article, joke, quote, etc.
    Types (Are any of these RETRIEVABLE by SYSTEM CALL?)
    FileID
    FileType - doc, URL
    FileIcon
    FileSize
    Topic/Category
    FileID
    FileCategory
    Keyword
    FileID
    FileKeyword

    I'd appreciate any help. Thank You

  2.  

  3. #2
    Junior Member w84me's Avatar
    Join Date
    Jun 2005
    Location
    Greece
    Posts
    2
    Member #
    10368

  4. #3
    Junior Member
    Join Date
    May 2005
    Posts
    3
    Member #
    9941
    Thanks


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 09:02 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com