Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

列名注释是否必填类型

id

系统ID


INT(10)

serial

包裹序列号

 必填

INT(4)

consignment_id

订单ID

 必填

BINGINT(16)

reference

产品类型

 可选

varchar(50)

delivery_reference跟踪号 必填 可选varchar(50)
weight重量(g)必填decimal(10,2)
length长度(mm)必填decimal(10,2)
width宽度(mm)必填decimal(10,2)
depth高度(mm)必填decimal(10,2)
description描述可选varchar(50)

...