I want to build a wikipedia type information system, http://en.wikipedia.org/wiki/Main_Page Like this but with a much more limited information set.
Im not sure how I should build the tables around the data for:
The Main Content - Are these Subdivided portions linked through foreign keys?
Images - Movie Files etc - Should I build a separate table for these types of items (varchar link to file), or can I store the information as blob or something directly into the record
Field Data type Description
TopicID Int PK Primary Identifier
Parent_TopicID Int FK Link to Parent Category
Topic Varchar(120) Name of Topic
would appreciate any thoughts on the matter, and Im using SQL server 2005 for any data types.