Design of table for .doc archive

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

sorry about that.

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[/indent]
Topic/Category
FileID
FileCategory

Keyword
FileID
FileKeyword

This seems like less of a technical problem and instead more of a logistical one. When it comes to complicated library systems it's not always clear where items must go. As long as there is a continous logic throughout the system, I would think things would be ok. At the end of the day it's your users that will be using the system, so why not ask them for feedback on where items should go.

I don't have much experience from the technical side of this, but I'm sure someone can give you some hints!

Thanks. Well I'm hoping someone here could help me with the logistics then. It's a major hurdle for me that I have to pass.

Thank you.