Skip to content

ome_order_objects_extend

订单Objects扩展表

所属应用: ome

表结构

ColumnNameCommentTypeNot nullDefaultAutoincrement
obj_id订单obj_idint(10) unsignedY0N
order_idorder_idint(10) unsignedY0N
store_dly_type门店发货模式tinyint(1)N0N
store_bn门店编码varchar(20)NN
customization商品定制信息,格式:jsonlongtextNN
at_time创建时间TIMESTAMPNCURRENT_TIMESTAMPN
up_time更新时间TIMESTAMPNCURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMPN

索引

Key nameColumn namesUniqueComment
primaryobj_idY
ind_at_timeat_timeN
ind_up_timeup_timeN
idx_c_order_idorder_idN