plat_order_address.md
2.36 KB
plat_order_address
平台订单地址表
- Rows (estimated): 0
- Data size: 16.0 KB
- Engine: InnoDB
- Collation: utf8mb3_general_ci
- Created: 2026-04-27 18:54:51
- Updated:
Columns
| # | Name | Type | Null | Key | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| 1 | iIncreaseId |
int |
NO | PRI | auto_increment | 主键(自增序列) | |
| 2 | tCreateTime |
datetime |
NO | 创建时间 | |||
| 3 | tModifyTime |
datetime |
NO | 退单时间 | |||
| 4 | sOrderId |
varchar(35) |
NO | MUL | 订单编号 | ||
| 5 | sOrderAddressId |
varchar(35) |
NO | UNI | 订单地址编号(P_ORA开头) | ||
| 6 | sAddressId |
varchar(35) |
NO | 地址编号 | |||
| 7 | sProvinceName |
varchar(20) |
NO | 省名称 | |||
| 8 | sCityName |
varchar(30) |
NO | 市名称 | |||
| 9 | sAreaName |
varchar(50) |
NO | 区名称 | |||
| 10 | sStreetName |
varchar(100) |
NO | 街道名称 | |||
| 11 | sAddress |
varchar(255) |
NO | 详细地址 | |||
| 12 | sRecvName |
varchar(20) |
NO | 收货人 | |||
| 13 | sMobile |
varchar(20) |
NO | 手机号 | |||
| 14 | iType |
tinyint |
NO | 0 | 类型(0:新地址,1:老地址) | ||
| 15 | iModifyType |
tinyint |
NO | 0 | 地址修改类型(0:erp,1:平台) | ||
| 16 | iLogisticsType |
tinyint |
NO | 0 | 物流类型(0:自定义,1:电子扫描单,2:无需物流) | ||
| 17 | sFreightTemplateId |
varchar(35) |
NO | 运费模板编号 | |||
| 18 | sFreightTemplateName |
varchar(50) |
NO | 运费模板名称 | |||
| 19 | sExpressName |
varchar(255) |
NO | 快递公司名称 | |||
| 20 | sExpressNo |
varchar(50) |
NO | 快递单号 | |||
| 21 | dWeight |
decimal(10,2) |
NO | 0.00 | 重量 | ||
| 22 | dQuantity |
int |
NO | 0 | 数量 | ||
| 23 | dMoney |
decimal(18,2) |
NO | 0.00 | 费用 | ||
| 24 | sRemark |
varchar(255) |
NO | 备注 |
Indexes
| Name | Unique | Type | Columns |
|---|---|---|---|
PLAT_ORDER_ADDRESS_IDX1 |
BTREE | sOrderId |
|
PLAT_ORDER_ADDRESS_UNQ1 |
✓ | BTREE | sOrderAddressId |
PRIMARY |
✓ | BTREE | iIncreaseId |
Narrative
No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.