ENTEmail表
Name | code | type | isNull |
主键 | ENTEmailId | int | NOT NULL |
收件人 | ToEmailAddress | varchar(max) | NOT NULL |
抄送人列表 | CCEmailAddress | varchar(max) | NULL |
暗抄送人列表 | BCCEmailAddress | varchar(max) | NULL |
发件人 | FromEmailAddress | varchar(255) | NOT NULL |
邮件主题 | Subject | varchar(max) | NOT NULL |
邮件内容 | Body | varchar(max) | NOT NULL |
发送状态 | EmailStatusFlag | tinyint | NOT NULL |
ENTNotification表(用户可以选择接收的通知列表)
Name | code | type | isNull |
主键 | ENTNotificationId | int | NOT NULL |
说明 | Description | varchar(255) | NOT NULL |
邮件发送账号 | FromEmailAddress | varchar(255) | NOT NULL |
邮件主题 | Subject | varchar(max) | NOT NULL |
通知模板 | Body | varchar(max) | NOT NULL |
模板数据:
INSERT [dbo].[ENTNotification] ([ENTNotificationId], [Description], [FromEmailAddress], [Subject], [Body]) VALUES (1, N'I became the owner of an item.', N'vince.varallo@PoweredByV2.com', N'You become the owner of the following item: <WFITEMID>', N'Please review the following item.<br>
<br>
Item Id: <WFITEMID><br>
State: <WFSTATE><br>
Owner: <WFOWNER><br>
Submit Date: <WFSUBMITDATE><br>
<br>
<LINK>')
ENTNotificationENTUserAccount(注册接收特定通知的用户)
Name | code | type | isNull |
主键 | ENTNotificationENTUserAccountId | int | NOT NULL |
通知ID | ENTNotificationId | int | NOT NULL |
用户ID | ENTUserAccountId | int | NOT NULL |
ENTNotificationENTWFState(用户订阅请求到达某个指定状态的通知)
Name | code | type | isNull |
主键 | ENTNotificationENTWFStateId | int | NOT NULL |
用户ID | ENTNotificationENTUserAccountId | int | NOT NULL |
状态ID | ENTWFStateId | int | NOT NULL |