If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Wiki Pedia Table Setup

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-13-07, 21:50
Nate1 Nate1 is offline
Registered User
 
Join Date: Aug 2007
Location: Auckland New Zealand
Posts: 113
Wiki Pedia Table Setup

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.
Reply With Quote
  #2 (permalink)  
Old 12-17-07, 00:57
jezemine jezemine is offline
another indirection layer
 
Join Date: May 2004
Location: Seattle
Posts: 1,312
why do this at all? there are so many free wiki packages out there already. why not just use one of them?
__________________
elsasoft.org
Reply With Quote
  #3 (permalink)  
Old 12-17-07, 01:54
sco08y sco08y is offline
Registered User
 
Join Date: Oct 2002
Location: Baghdad, Iraq
Posts: 697
Quote:
Originally Posted by jezemine
why not just use one of them?
Another way of putting this: what do you need that the existing packages don't offer?
Reply With Quote
  #4 (permalink)  
Old 12-17-07, 03:56
Nate1 Nate1 is offline
Registered User
 
Join Date: Aug 2007
Location: Auckland New Zealand
Posts: 113
Whats a Good example?, I already have an extensive CMS that I want to add another facet of information too,

I cant' afford a commercial option and don't want the typically external links that come with the free editions of software.
Im not sure what features are offered by existing systems?
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On