sys_msg_template.md 1.85 KB

Edit Raw Blame History



sys_msg_template


消息模板


Engine: InnoDB

Collation: utf8mb3_general_ci


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
iIncrement
int
NO
PRI

auto_increment
自增列


2
sId
varchar(50)
YES
MUL


唯一ID


3
sBrandsId
varchar(50)
YES


加工商ID


4
sSubsidiaryId
varchar(50)
YES


子公司ID


5
tCreateDate
datetime
NO

CURRENT_TIMESTAMP
DEFAULT_GENERATED
制单日期


6
iOrder
int
NO

0

排序号


7
sMakePerson
varchar(50)
YES


制单人


8
sTemplateCode
varchar(50)
YES


模板代码


9
sTemplateName
varchar(50)
YES


模板名称


10
bSendEmail
bit(1)
NO

b'0'

发送邮件


11
bSendWechat
bit(1)
NO

b'0'

发送微信


12
bSendDingTaik
bit(1)
NO

b'0'

发送钉钉


13
bSendPhone
bit(1)
NO

b'0'

发送短信


14
bInvalid
bit(1)
NO

b'0'

是否作废


15
sTitle
varchar(50)
NO


消息标题


16
sAbstract
varchar(500)
NO


消息摘要


17
sTemplateMemo
longtext
YES


消息模板


18
sTemplateFile
longtext
YES


附件模板


19
sBillNo
varchar(50)
NO


消息模板单据号


20
sFormId
varchar(50)
NO


窗体ID


Indexes


Name
Unique
Type
Columns


IndexU_1
✓
BTREE

sId, sBrandsId, sSubsidiaryId


PRIMARY
✓
BTREE
iIncrement


Narrative

No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.