Database Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community Forums > Databases > Database Development
Reload this Page

How To Design Forum's Structure Databases?

Discuss How To Design Forum's Structure Databases? in the Database Development forum on Dev Articles.
How To Design Forum's Structure Databases? Database Development forum to discuss the topics of designing, maintaining, and normalizing databases. If you have to store and retrieve data of any kind, this forum is for you.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old March 12th, 2003, 10:10 AM
wareseeker wareseeker is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Dec 2002
Posts: 71 wareseeker User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 15 m 7 sec
Reputation Power: 6
Question How To Design Forum's Structure Databases?
Currently, I am working on a forum it is just a simple forum for members can post and reply messages and members can edit and delete their own messages, but my MySQL knowledge is still weak, and I don't how to design it to be appropriate such as how many tables I gonna have or what fields suppose to be included in each tables. I really need you guys help to construct this database. I am grateful to those who share the times and affords to help me in this issue. Thanks all in advance.
Reply With Quote
  #2  
Old March 18th, 2003, 12:29 PM
Mary Mary is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Mar 2003
Posts: 59 Mary User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 5 m 17 sec
Reputation Power: 0
Sorry! I cannot help you cause I am looking for the same thing as yours. Hope someone in this forum might help you.
Reply With Quote
  #3  
Old March 18th, 2003, 08:35 PM
Taelo Taelo is offline
5B's
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Oct 2002
Location: PC, FL
Posts: 364 Taelo User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 48 m 26 sec
Reputation Power: 6
start by breaking it down into sections,....

big things,....

categorys
forums
reply
post

then look at what would be needed in those sections.

lets start with categorys...
cat_id (auto int)
cat_name (varchar)
cat_order (int) for sorting the categorys

then move on to forums,... notice the very first part here.
forum_id (auto_int)
cat_id (int) relative key from category table.

see where this is going?
__________________
-- Jason
Reply With Quote
  #4  
Old April 5th, 2003, 01:33 AM
zigote zigote is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Aug 2002
Location: Atlanta GA
Posts: 73 zigote User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 55 m 11 sec
Reputation Power: 6
In creating tables how do you know what types to choose?

cat_name (varchar)
How can I tell that the cat_name needs to be varchar.
Reply With Quote
  #5  
Old April 5th, 2003, 02:10 AM
jpenn jpenn is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Oct 2002
Location: Washington, DC
Posts: 317 jpenn User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 m 3 sec
Reputation Power: 6
Read the documentation on the mysql site about the different column types...
__________________
~ Joe Penn

We work for free to help make this a valuable resource on the internet. Do you appreciate the help - did we provide help that will help you prosper and help that has contributed to sharpening your current skill set?

Show your appreciation and purchase something from our Amazon Wishlist's - it's simple and a great way to say thank you.


Reply With Quote
  #6  
Old April 5th, 2003, 06:35 AM
Ben Rowe
Guest
Dev Articles Newbie (0 - 499 posts)
  
Posts: n/a  
Time spent in forums:
Reputation Power:
whoa! thats a big job, even if its simple,

what you need to do is firstly read up on some articles on mysql and creating databases, and database structures. This will give you a bit more knowledge on the matter.

Once you have done that I would suggest writing out your design on paper, drawing how each table links to each other

Just off the top of my head, heres some tables you will need to get your forums started

members - containing the member info, etc
thread
posts
forums - contains data on the forum the threads are in, also contain a parent thread id, that way you can have a linking effect like at our forums, where theres the programing forums, then that breaks into php, asp, etc...

then if you want more advanced info, things like pm, etc
Reply With Quote
  #7  
Old April 17th, 2003, 06:40 AM
wareseeker wareseeker is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Dec 2002
Posts: 71 wareseeker User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 15 m 7 sec
Reputation Power: 6
Do we have any tut regarding to this? Please let me know if we had any. Thanks!
Reply With Quote
  #8  
Old April 17th, 2003, 08:38 AM
Taelo Taelo is offline
5B's
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Oct 2002
Location: PC, FL
Posts: 364 Taelo User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 48 m 26 sec
Reputation Power: 6
I have designed my own forums,......and let me just say that it is not easy,...lol,....it takes alot of time and patience and planning.
Reply With Quote
  #9  
Old April 17th, 2003, 09:32 AM
wareseeker wareseeker is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Dec 2002
Posts: 71 wareseeker User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 15 m 7 sec
Reputation Power: 6
Quote:
I have designed my own forums,......and let me just say that it is not easy,...lol,....it takes alot of time and patience and planning.

Could you please teach me how to do it? or just give me your planning in order I can have a foundation to start with. I really love to create one but not as complicated as vBulletin. But at least I can integrate it into other stuffs of my site. Thanks Taelo!
Reply With Quote
  #10  
Old April 17th, 2003, 09:53 AM
zigote zigote is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Aug 2002
Location: Atlanta GA
Posts: 73 zigote User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 55 m 11 sec
Reputation Power: 6
wareseeker,
I have found this, it may be what you are looking for...


one method of implementing a simple forum
http://www.easysoft.com/tech/php/tut_002/main.phtml
Reply With Quote
  #11  
Old April 22nd, 2003, 01:35 AM
avit avit is offline
Not Yet Perfect
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Nov 2002
Location: Squamish, BC
Posts: 111 avit User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 6
Send a message via ICQ to avit
Quote:
Originally posted by wareseeker
Do we have any tut regarding to this? Please let me know if we had any. Thanks!


The tutorial on the MySQL documentation (I think it's chapter 3) is a good place to start if you're not too familiar with SQL. also DevShed.com has some good MySQL tutorials.
Reply With Quote
  #12  
Old April 23rd, 2003, 08:53 AM
wareseeker wareseeker is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Dec 2002
Posts: 71 wareseeker User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 15 m 7 sec
Reputation Power: 6
Quote:
The tutorial on the MySQL documentation (I think it's chapter 3) is a good place to start if you're not too familiar with SQL. also DevShed.com has some good MySQL tutorials.

I don't see any tut which regards to my question. Please have a specific link in other to make someone going easy.
Reply With Quote
Reply

Viewing: Dev Articles Community Forums > Databases > Database Development > How To Design Forum's Structure Databases?

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

 Free IT White Papers!
 
Accelerating Trading Partner Performance
One in five. That's how many partner transactions have at least one error. That is an amazing statistic, particularly given the extraordinary leaps in innovation across the global supply chain during the past two decades. Download this white paper to learn more.
 
Competing on Analytics
This Tech Analysis is designed to help identify characteristics shared by analytics competitors, and includes information about 32 organizations that have made a commitment to quantitative, fact-based analysis.
 
Cost Effective Scaling with Virtualization and Coyote Point Systems
An overview of the industry trend toward virtualization, how server consolidation has increased the importance of application uptime and the steps being taken to integrate load balancing technology with virtualized servers.
 
Five Checkpoints to Implementing IP Telephony
Implementation planning for IP PBX software and IP telephony has become vital as businesses replace discontinued legacy PBX phone systems. This informative whitepaper outlines five &quot;checkpoints&quot; for any implementation plan that will help make IP communications a successful proposition.
 
Hosted Email Security: Staying Ahead of New Threats
In the last two years, email has become a fierce battleground between the nefarious forces of spam and malware, and the heroes of messaging protection. The spam volumes increased alarmingly every month, bringing clever new forms of phishing and virus propagation attacks.
 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway.