Mail server database structure...

anuj_web

New Member
Messages
145
Reaction score
0
Points
0
Hi...


I need the basic database structure used in email servers to handle emails, if available ... please post the link.....



thnks
 

freecrm

New Member
Messages
629
Reaction score
0
Points
0
Sorry - probably being thick here - can you clarify?

Do you mean a basic db to store information, including e-mail addresses.

Or headers?

Are you using php to handle e-mails? - If not, I can't help!
 

sunils

New Member
Messages
2,266
Reaction score
0
Points
0
senders id, receivers id, message, subject, ipaddress from which the sender has sent it, the timestamp when the mail was sent, when it reached the server and when it was forwarded to the client. I thinks this is the basic structure/ data collected.. There are more than this..
 

anuj_web

New Member
Messages
145
Reaction score
0
Points
0
thnks for replying.....

actually what i want is the designs of all the tables involved in the database of an email server.....

Otherwise i would like to know how an email is related to attachments...the table design again would help....

How more than one attachment is indexed in a table and how are they stored on the servers....

thanks
 
Last edited:

anuj_web

New Member
Messages
145
Reaction score
0
Points
0
thnx bro for replying....

but i could find the structure newere on those pages :|



thanks again
 
Last edited:

anuj_web

New Member
Messages
145
Reaction score
0
Points
0
i am actually in doubt about the contacts table...consider this 2 field table
(ID,Contact)

(User1,User2)
(User2,User1)

See....there is unnecessary repetition....i cant figure out another structure...so that this does not happen..

please help...
 

anuj_web

New Member
Messages
145
Reaction score
0
Points
0
stuck again....sorry for bumping...

i am actually in doubt about the contacts table...consider this 2 field table
(ID,Contact)

(User1,User2)
(User2,User1)

See....there is unnecessary repetition....i cant figure out another structure...so that this does not happen..

please help...
 

jassie3

New Member
Messages
1
Reaction score
0
Points
0
please help !

HI all, I'm very new to mysql . does anyone here can tell me what am I missing because I got the error message - Los emails no coinciden
Thanks in advandce.
 
Top