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 |
