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
Information varchar(unlimited????)
would appreciate any thoughts on the matter, and Im using SQL server 2005 for any data types.