MySQL Forums
Forum List  »  Newbie

Design of table for .doc archive
Posted by: anymisc
Date: June 17, 2005 02:50AM

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

Options: ReplyQuote


Subject
Written By
Posted
Design of table for .doc archive
June 17, 2005 02:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.