Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

> request for database design for email system

views
     
TSlittle piggy83
post May 14 2008, 11:28 AM, updated 14y ago

Getting Started
**
Junior Member
207 posts

Joined: May 2007
From: KL


heloo..maybe my topic is not related to the asp language. i just need some help or guidance on how the email system like hotmail or yahoo mail database stcuture design? may someone give me some ideas on how the email /messaging table design? it involve sender, feedback, delete from both users, reply ..etc...
dopodplaya
post May 14 2008, 11:40 AM

Look at all my stars!!
*******
Senior Member
2,280 posts

Joined: Jun 2006


QUOTE(little piggy83 @ May 14 2008, 11:28 AM)
heloo..maybe my topic is not related to the asp language. i just need some help or guidance on how the email system like hotmail or yahoo mail database stcuture design? may someone give me some ideas on how the email /messaging table design? it involve sender, feedback, delete from both users, reply ..etc...
*
you can start by writing the relationship diagram and some program flow and logics.
TSlittle piggy83
post May 14 2008, 11:41 AM

Getting Started
**
Junior Member
207 posts

Joined: May 2007
From: KL


i have start some..but it look like not logic..and i am confusing now. may u give me a hand? thank you
kmheing
post May 14 2008, 11:57 AM

Casual
***
Junior Member
351 posts

Joined: Aug 2007

i think do table with all the fields first..then only u start on ur relationship diagram..
TSlittle piggy83
post May 14 2008, 12:02 PM

Getting Started
**
Junior Member
207 posts

Joined: May 2007
From: KL


TBL_Email
---------------
EmailID
EmalSubject
EmailSentDate



tBL_EmailReply
------------------
EmailReplyID
EmailID
EmailFRom
EmailTo
EmailContent

what i have design it seem not good. and i duno hw the email flow going to work. plz guide on more detailed.thank you
dopodplaya
post May 14 2008, 12:12 PM

Look at all my stars!!
*******
Senior Member
2,280 posts

Joined: Jun 2006


QUOTE(little piggy83 @ May 14 2008, 12:02 PM)
TBL_Email
---------------
EmailID
EmalSubject
EmailSentDate
tBL_EmailReply
------------------
EmailReplyID
EmailID
EmailFRom
EmailTo
EmailContent

what i have design it seem not good. and i duno hw the email flow going to work. plz guide on more detailed.thank you
*
The table design looks good and we can normalized it later/
So, what are the processes involved - what you want to do, what you want to create from this database?
Just explain what you are required to do in this system? no need the technical terms yet
kmheing
post May 14 2008, 12:13 PM

Casual
***
Junior Member
351 posts

Joined: Aug 2007

basically its everything u can see in email lo..deleted mails, attachments, draft, etc..info that i gave u maybe cant be used..so dun rely so much on it..
alanyuppie
post May 14 2008, 12:16 PM

Look at all my stars!!
*******
Senior Member
2,707 posts

Joined: Jul 2006
From: here


QUOTE(little piggy83 @ May 14 2008, 01:02 PM)
TBL_Email
---------------
EmailID
EmalSubject
EmailSentDate
tBL_EmailReply
------------------
EmailReplyID
EmailID
EmailFRom
EmailTo
EmailContent

what i have design it seem not good. and i duno hw the email flow going to work. plz guide on more detailed.thank you
*
EmailStatus - (unread/read/read and replied)
EmailLocationFolder - (inbox/inbox/deleted folder/custom folder name)
EmailFormat - (column to store specialised directive/formatting the email fonts/colour) , for eg.

FONT=Times New Roman
FONTSIZE=12pt
FONTCOLOR=#000033







wKkaY
post May 14 2008, 12:19 PM

misutā supākoru
Group Icon
Admin
6,005 posts

Joined: Jan 2003
TBL_Email and TBL_EmailReply???

Can you explain your table design and the relations? As hard as I try, I really can't understand why you made it like that.


Added on May 14, 2008, 12:24 pmI suggest that you go through your mailbox, pick 10 random mails, and look at their message headers. It should give you a clue as to what you can enter into the database.

» Click to show Spoiler - click again to hide... «

silverhawk
post May 14 2008, 01:04 PM

I'm Positively Lustrous
Group Icon
Elite
4,220 posts

Joined: Jan 2003


You have to first ask yourself, how you want to design your e-mail system. Do you want to do it the folders way, like hotmail, or the label/tag system like gmail? This will affect your database design.

The actual e-mail messages themselves, can all be stored in one table. Any other tables would mostly be used for organising/sorting the e-mail messages or giving them some sort of relationship. Like how gmail provides a conversation like interface, instead of reading e-mails 1 by 1.
TSlittle piggy83
post May 14 2008, 01:17 PM

Getting Started
**
Junior Member
207 posts

Joined: May 2007
From: KL


i wna to do someting like the lowyat.net forum message part
silverhawk
post May 14 2008, 03:15 PM

I'm Positively Lustrous
Group Icon
Elite
4,220 posts

Joined: Jan 2003


Why don't you download the forum software and see their database design then?

 

Change to:
| Lo-Fi Version
0.0301sec    0.47    5 queries    GZIP Disabled
Time is now: 25th September 2021 - 11:09 AM