logisticsmanager_channel_extend
面单来源表
所属应用: logisticsmanager
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| id | id | mediumint(8) unsigned | Y | Y | |
| channel_id | 渠道主键 | int(10) unsigned | Y | N | |
| province | 省 | varchar(50) | N | N | |
| city | 市 | varchar(50) | N | N | |
| area | 地区 | varchar(50) | N | N | |
| street | 街道 | varchar(50) | N | N | |
| address_detail | 具体地址 | varchar(50) | N | N | |
| waybill_address_id | 地址ID | varchar(20) | N | N | |
| cancel_quantity | 取消数量 | int(10) unsigned | N | N | |
| allocated_quantity | 可用数量 | int(10) unsigned | N | N | |
| print_quantity | 打印数量 | int(10) unsigned | N | N | |
| seller_id | 用户ID | varchar(32) | N | N | |
| default_sender | default_sender | varchar(255) | N | N | |
| mobile | mobile | varchar(30) | N | N | |
| tel | tel | varchar(30) | N | N | |
| shop_name | shop_name | varchar(255) | N | N | |
| zip | zip | varchar(20) | N | N | |
| addon | addon | longtext | N | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | id | Y |
