logisticsmanager_express_template

面单模板表

所属应用: logisticsmanager

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
template_id	ID	int(10) unsigned	Y		Y
out_template_id	外部模板ID	varchar(128)	N	0	N
template_name	模板名称	varchar(100)	Y		N
template_type	面单类型 normal:普通面单;electron:电子面单;cainiao:菜鸟面单;cainiao_standard:菜鸟面单;cainiao_user:菜鸟面单;pdd_standard:拼多多面单;pdd_user:拼多多面单;delivery:发货面单;stock:备货面单;jd_standard:京东面单;jd_user:京东面单;douyin_standard:抖音面单;douyin_user:抖音面单;kuaishou_standard:快手面单;kuaishou_user:快手面单;wphvip_standard:唯品会vip面单;wphvip_user:唯品会vip面单;dewu_ppzf:得物面单;dewu_ppzf_zy:得物自研面单;sf:顺丰面单;xhs_standard:小红书面单;xhs_user:小红书面单;wxshipin_standard:微信视频号面单;wxshipin_user:微信视频号面单;meituan4bulkpurchasing_user:美团电商面单;youzan_standard:有赞面单;yilianyun:易联云;	enum('normal','electron','cainiao','cainiao_standard','cainiao_user','pdd_standard','pdd_user','delivery','stock','jd_standard','jd_user','douyin_standard','douyin_user','kuaishou_standard','kuaishou_user','wphvip_standard','wphvip_user','dewu_ppzf','dewu_ppzf_zy','sf','xhs_standard','xhs_user','wxshipin_standard','wxshipin_user','meituan4bulkpurchasing_user','youzan_standard','yilianyun')	Y	normal	N
page_type	纸张类型	tinyint(3) unsigned	Y	1	N
control_type	控件类型	varchar(32)	Y	shopexplugin	N
status	是否启用	enum('true','false')	N	true	N
template_width	宽度	float	Y	100	N
template_height	高度	float	Y	100	N
file_id	背景文件ID	mediumint(8) unsigned	Y	0	N
is_logo	打印LOGO	enum('true','false')	N	true	N
template_select	template_select	longtext	N		N
template_data	template_data	longtext	N		N
is_default	默认	enum('true','false')	Y	false	N
aloneBtn	独立按钮	enum('true','false')	Y	false	N
btnName	独立按钮名称	varchar(20)	N		N
source	模板来源	varchar(32)	N	local	N
cp_code	cp_code	varchar(32)	N		N

索引

Key name	Column names	Unique	Comment
primary	template_id	Y
ind_out_template_id	out_template_id	N