id(主键), int(10), not null, primary key, autu_increment
// 15 个 @OneToOne
shop_id(店铺 id), int(10), not null
brand_id(品牌 id), int(10), not null
currency_id(货币 id), int(10), not null
thumbnail_image_id(图片 id), int(10), null
master_product_id(主商品 id), int(10), null
mpp_id(多属性商品 id), int(10), null,
prepare_price_id(准备特价 id), int(10), null
originla_price_id(原价 id), int(10) null
main_category_id(主类别 id), int(10), not null,
sub_category_id(子类别 id), int(10), null
product_group_id(零售商品组 id), int(10), null
wholesale_product_group_id(批发商品组 id), int(10), null
parker_product_id(parker 镜像 id), int(10), null
default_location_id(默认库位), int(10), null
backup_location_id(备用库位), int(10), null
// 8 个基本属性
status(状态), tinyint(3), not null
type(类型), tinyint(3), not null,
sku, varchar(255), not null,
barcode, varchar(255), null
name(名称), varchar(500), not null
name_aliase(别名), varchar(500), null
name_in_shipment(商品快递单名称), varchar(100), null
name_in_post_invoice(商品 POS 小票名称), varchar(100), null
// 9 个基本数值
default_cost(在库成本), decimal(12, 2), not null
pricing_cost(零售定价成本), decimal(12, 2), not null
wholesale_pricing_cost(批发定价成本), decimal(12, 2), not null
tax_rate(税率), decimal(12, 2), not null
default_cost_tax(在库成本税), decimal(12, 2), not null
bonus(奖金), decimal(12, 2), not null
rebate(回扣), decimal(12, 2), not null
lowest_price(最低售价), decimal(12, 2), not null
suggested_price(建议售价), decimal(12, 2), not null
// 24 个价格
price_l1, decimal(12, 2), not null
price_l2, decimal(12, 2), not null
price_l3, decimal(12, 2), not null
price_l4, decimal(12, 2), not null
price_l5, decimal(12, 2), not null
price_l6, decimal(12, 2), not null
price_l7, decimal(12, 2), not null
price_l8, decimal(12, 2), not null
price_l9, decimal(12, 2), not null
price_l10, decimal(12, 2), not null
price_l11, decimal(12, 2), not null
price_l12, decimal(12, 2), not null
export_price_l1, decimal(12, 2), not null
export_price_l2, decimal(12, 2), not null
export_price_l3, decimal(12, 2), not null
export_price_l4, decimal(12, 2), not null
export_price_l5, decimal(12, 2), not null
export_price_l6, decimal(12, 2), not null
export_price_l7, decimal(12, 2), not null
export_price_l8, decimal(12, 2), not null
export_price_l9, decimal(12, 2), not null
export_price_l10, decimal(12, 2), not null
export_price_l11, decimal(12, 2), not null
export_price_l12, decimal(12, 2), not null
// 17 个其他属性
weight(重量 g), int(10), not null
valid_date(保质期), bigint(20), null
short_description(短描述), text, null
full_description(全描述), mediumtext, null
allow_dropship(允许代发), tinyint(3), not null
allow_over_sale(超售数量), int(10), not null
close_over_sale(允许入库关超售) , bit(1), not null
carton(箱规), int(10), null,
virtual_stock(是否虚拟库存), bit(1), not null
spec(规格), varchar(50), null
unit(单位), varchar(50), null
auto_adjust_price(自动调整价格), bit(1), null
operate_color(操作颜色), tinyint(3), null
limited_qty(限购数量), int(10), null
creator_id(创建人 id), int(10), not null
create_time(创建时间), bigint(20), not null
last_time(最近修改), int(10), not null
// 3 个普通快递
zero_shipping_fee_qty(免运费数量), int(10), null
fixed_shipping_fee(固定运费), decimal(12, 2), null
shipping_fee_way(运费方式), tinyint(3), not null
// 5 个快运
can_ship_faster(是否支持快运), tinyint(3), not null
filling_name(海关备案名称), varchar(255), null
zero_shipping_fee_qty_fast(快运免运费数量), int(10), null
fixed_shipping_fee_fast(快运固定运费), decimal(12, 2), null
shipping_fee_way_fast(快运运费方式)，tinyint(3), null
// 5 个运营采购
market_status(市场状态), tinyint(3), not null
purchase_period(采购周期), int(10), not null
purchase_memo(采购备注), varchar(255), null
excess(库存超量值), int(10), null
auto_manager_slow_sale(自动管理低销), bit(1), not null
// 3 个换购
gift_sale(是否换购), tinyint(3), not null,
gift_threshold(换购条件), decimal(12, 2), null
gift_price(换购价格), decimal(12, 2), null
// 2 个澳洲
prefix(澳邮前缀), varchar(10), null
ewe_prefix(ewe 前缀), varchat(10), null
网友评论