CRM Email System Analysis

Insert into [crm_email] ([createdate], [sendertypeid], [sendername], [receivertypeid], [receivername], [receiveremail], [objecttype], [title], [content], [type], [uploadfiletypeid]) values (getdate (), '000000', 'postmaster ', '000000', 'postmaster ','', 'send', 'email name', 'email body', 0, '2, 1 ')
Go
Insert into [crm_email] ([createdate], [sendertypeid], [sendername], [receivertypeid], [receivername], [receiveremail], [objecttype], [title], [content], [type], [uploadfiletypeid]) values (getdate (), '000000', 'postmaster ', '000000', 'postmaster ','', 'receive ', 'email name', 'email body', 0, '2, 1 ')
Go
Exec spcrm_msgsendbatch 'normal', '000000', '000000', 'email notification: [administrator] sent you an email at 12:47:30, September 5, 0000000000.
Email name: email name
[Surl = ../message/viewemailfile. asp? Emailtypeid = 241 & emailtype = self] Click to view [/Surl] ', 'system', '11 5 2007 12: 47: 30: 000pm', 'email ',''
Go
Update [crm_uploadfile] Set [coobject] = 'e-mail 'Where [creatortypeid] = '000000' and [coobjecttypeid] = 'e-mail' and [coobject] = 'emailtemp'
Go
Delete [crm_uploadfile] Where [creatortypeid] = '000000' and ([coobject] = 'emailtemp ')
Go

-- The Bank's approach is to change the space efficiency. It splits the sender's group into one individual, but it cannot tell whether an email is sent once,
-- It is right to change the design and change the efficiency by space. (You can also use like to determine whether a person exists, but it is not as efficient as a person, select efficiency for a large number of users)
-- The inbox only needs to keep one piece of data (for any row, it seems that there is no need to split it all), and the sender should split it all