plat_order_detail.md 1.31 KB

Edit Raw Blame History



plat_order_detail


平台订单详情


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
sOrderDetailId
varchar(35)
NO
UNI


订单详情编号(P_ODD开头)


6
sOfferId
varchar(35)
NO
MUL


报价编号


7
sLargeNumber
varchar(255)
NO


大版号


8
tLargeTime
datetime
YES


落大版的时间


Indexes


Name
Unique
Type
Columns


PLAT_ORDER_DETAIL_IDX1

BTREE
sOfferId


PLAT_ORDER_DETAIL_UNQ1
✓
BTREE
sOrderDetailId


PLAT_ORDER_DETAIL_UNQ2
✓
BTREE

sOrderId, sOfferId


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.