Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2005-02-17 : 20:51:10
|
| I have a pretty mailbox system that I would like to upgrade. Is there a standard mailbox design out there? I would think it is something that is designed quite often and pretty standard.The problems I am having with the design below are as follows:the outboxwhen you look at what you have sent messages disappear as people delete from their inbox.folder optionsnice feature to categorize, all users would automatically have 'myinbox' as standard folder with option to add more foldersMy design is as shown below. I use the "checked" column to show whether the message has been read by marking it with either a 0 or 1 value. Any suggestions on how to upgrade this? Thanks once again,mike123CREATE TABLE [dbo].[tblMessage] ( [MessageID] [int] IDENTITY (1, 1) NOT NULL , [MessageFrom] [int] NOT NULL , [MessageTo] [int] NOT NULL , [Message] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [prevMessage] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Subject] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [date] [smalldatetime] NULL , [Checked] [tinyint] NULL ) ON [PRIMARY]GO |
|
|
|
|
|
mailbox design