archive_delivery
归档发货单表
所属应用: archive
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| delivery_id | delivery_id | int(10) unsigned | Y | Y | |
| shop_id | 来源店铺 | varchar(32) | N | N | |
| idx_split | 订单的大致内容 | bigint(20) | Y | 0 | N |
| skuNum | 商品种类数 | mediumint(8) unsigned | Y | 0 | N |
| itemNum | 商品种类数 | mediumint(8) unsigned | Y | 0 | N |
| bnsContent | 具体订单内容 | text | Y | N | |
| delivery_bn | 配送流水号 | varchar(32) | Y | N | |
| member_id | 订货会员ID | int(10) unsigned | N | N | |
| is_protect | 是否保价 | enum('true','false') | Y | false | N |
| cost_protect | 保价费用 | decimal(20,3) | N | 0 | N |
| is_cod | 是否货到付款 | enum('true','false') | Y | false | N |
| delivery | 配送方式(货到付款、EMS...) | varchar(20) | N | N | |
| logi_id | 物流公司ID | mediumint(8) unsigned | N | N | |
| logi_name | 物流公司名称 | varchar(100) | N | N | |
| logi_no | 物流单号 | varchar(50) | N | N | |
| logi_number | 物流包裹总数 | mediumint(8) unsigned | Y | 1 | N |
| delivery_logi_number | 已发货物流包裹数 | mediumint(8) unsigned | Y | 0 | N |
| ship_name | 收货人姓名 | varchar(255) | N | N | |
| ship_area | 收货人地区 | varchar(255) | N | N | |
| ship_province | 省 | varchar(50) | N | N | |
| ship_city | 市 | varchar(50) | N | N | |
| ship_district | 区/县 | varchar(50) | N | N | |
| ship_addr | 收货人地址 | text | N | N | |
| ship_zip | 收货人邮编 | varchar(20) | N | N | |
| ship_tel | 收货人电话 | varchar(200) | N | N | |
| ship_mobile | 收货人手机 | varchar(200) | N | N | |
| ship_email | 收货人Email | varchar(150) | N | N | |
| create_time | 单据生成时间 | int(10) unsigned | N | N | |
| status | 状态 succ:已发货;failed:发货失败;cancel:已取消;progress:等待配货;timeout:超时;ready:等待配货;stop:暂停;back:打回; | enum('succ','failed','cancel','progress','timeout','ready','stop','back') | Y | ready | N |
| memo | 备注 | longtext | N | N | |
| branch_id | 仓库 | mediumint(8) unsigned | N | N | |
| last_modified | 最后更新时间 | int(10) unsigned | N | N | |
| delivery_time | 发货时间 | int(10) unsigned | N | N | |
| ship_time | 指定发货时间 | varchar(50) | N | N | |
| op_id | 操作员ID | mediumint(8) unsigned | Y | N | |
| op_name | 操作员名称 | varchar(30) | N | N | |
| org_id | 运营组织 | mediumint(8) unsigned | N | N | |
| shop_type | 店铺类型 | varchar(50) | N | N | |
| betc_id | 贸易公司ID | int(10) unsigned | N | 0 | N |
| cos_id | 组织架构ID | int(10) unsigned | N | 0 | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | delivery_id | Y | |
| ind_delivery_bn_shop | delivery_bn, shop_id | Y | |
| ind_status | status | N | |
| ind_delivery_time | delivery_time | N | |
| ind_create_time | create_time | N | |
| ind_logi_no | logi_no | N | |
| ind_ship_name | ship_name | N | |
| ind_ship_mobile | ship_mobile | N | |
| ind_ship_tel | ship_tel | N | |
| ind_betc_id | betc_id | N | |
| ind_cos_id | cos_id | N | |
| idx_c_shop_id | shop_id | N | |
| idx_c_member_id | member_id | N | |
| idx_c_logi_id | logi_id | N | |
| idx_c_branch_id | branch_id | N | |
| idx_c_op_id | op_id | N | |
| idx_c_org_id | org_id | N |