Skip to content

archive_order_receiver

归档订单收货人信息表

所属应用: archive

表结构

ColumnNameCommentTypeNot nullDefaultAutoincrement
order_id订单号int(10) unsignedY0N
encrypt_source_data加密数据textNN
platform_country_id平台国家IDvarchar(30)NN
platform_province_id平台省IDvarchar(30)NN
platform_city_id平台市IDvarchar(30)NN
platform_district_id平台地区IDvarchar(30)NN
platform_town_id平台镇IDvarchar(30)NN
ship_provincevarchar(30)NN
ship_cityvarchar(30)NN
ship_districtvarchar(30)NN
ship_town乡镇varchar(30)NN
ship_villagevarchar(50)NN
archive_time归档时间int(10) unsignedNN

索引

Key nameColumn namesUniqueComment
primaryorder_idY
ind_order_idorder_idN
ind_archive_timearchive_timeN