3g-Netease-Mailbox-Database Design

USEMASTER -- ylb: 3G Netease mailbox -- url: -- devloper: ylb, tech -- author: YuanBo -- date: 11: 112012-07-05 -- (master .. sysdatabases) dropdatabase_415163email_3g163emailgouse_3g163email -- ylb: 1.1 email account table -- MailUsers (mailUserpwd

Use master -- ylb: 3G Netease mailbox -- url: -- devloper: ylb, tech -- author: YuanBo -- date: -- (master .. sysdatabases) drop database _ %163email _ %163email go use _ %163email -- ylb: 1.1 email account table -- MailUsers (mailUser pwd

Use master -- ylb: 3G Netease mailbox -- url: -- devloper: ylb, tech -- author: YuanBo -- date: -- (master .. sysdatabases) drop database _ %163email _ %163emailgouse _ %163email -- ylb: 1.1 email account table -- MailUsers (mailUser pwd mobileNum varchar (100) -- mobile phone number) -- ylb: 2, EMail -- EMail (eMailId (content varchar (5000), -- body sendDate sendMail toMail att varchar (200), -- attachment address flagRead flagState int, -- mail status 0: sent; 1: Save mailUser varchar (100) -- account name [FK]) -- ylb: 3, Contact Group -- ContactGroup (contactGroupId (), -- number [PK] contactGroupName mailUser) go/* insert into ContactGroup (contactGroupName, mailUser) values ('friend ', '') insert into ContactGroup (contactGroupName, mailUser) values ('colleague ','') insert into ContactGroup (contactGroupName, mailUser) values ('relatives', '') insert into ContactGroup (contactGroupName, mailUser) values ('netizen ','') insert into ContactGroup (contactGroupName, mailUser) values ('regular contacts ', '') insert into ContactGroup (contactGroupName, mailUser) values ('', '') select @ identityinsert into ContactGroup (contactGroupName, mailUser) values ('friends', 'rain @ 163.com ') -- insert into ContactGroup (contactGroupName, mailUser) ({'relaties', 'rain @ 163.com'}, {'colleagues ', 'rain @ 163.com '}) -- a similar form of contactGroupId, contactGroupName contactGroupId -- ylb: 3.2, Contact -- Contact (contactId (, 1 ), -- No. [PK] name emailPref varchar (100), -- email telCell varchar (100), -- phone | mobile phone number contactGroupIds varchar (100 ), -- Contact Group number [FK] mailUser) -- ylb: 3.3, contact and group relationship -- ContactGroupContact (contactId, -- contact (UserMails) number [FK] contactGroupId, -- Contact Group number (ContactGroup) [FK] mailUser) -- ylb: 4, email attachment -- Attachments (attachmentId (200), -- number [PK] attachmentUrl ), -- file name filesize varchar (100), -- file size emailId int, -- mail number [FK-Email] tempId varchar (200 ), -- temporary save ID [when the mailbox is not saved] mailUser) MailUsers -- ylb: 5, file center -- (fileId (baseId fileType int, -- file type 1: folder; 2: Non-Folder fileUrl varchar (100), -- (non-file) file storage location fileSize int, -- file size mailUser) GO

, Hong Kong server, server space, virtual host