DB foundation_inventory

warehouse

column name	definition
warehouse_id	BIGINT UNSIGNED NOT NULL
user_id	BIGINT UNSIGNED NOT NULL COMMENT '所属用户ID'
store_id	BIGINT UNSIGNED NOT NULL COMMENT '所属店铺ID'
type	TINYINT UNSIGNED NOT NULL COMMENT '仓库类型 . \n\n比如 virtual . 没有实际仓库，对于绝大部分店铺，是没有实体仓库的\n比如 solid . 实体仓库 . 没错 ,　就是这个单词 , 从美剧中学的 . '
name	VARCHAR (45) NOT NULL COMMENT '仓库名称'
create_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
create_user_id	BIGINT UNSIGNED NOT NULL
last_modify_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
last_modify_user_id	BIGINT UNSIGNED NOT NULL
is_deleted	BIGINT UNSIGNED NOT NULL DEFAULT 0

sku

column name	definition
sku_id	BIGINT UNSIGNED NOT NULL
item_id	BIGINT UNSIGNED NOT NULL COMMENT '商品ID'
item_variation_id	BIGINT UNSIGNED NOT NULL COMMENT '商品规格ID'
warehouse_id	BIGINT UNSIGNED NOT NULL COMMENT '仓库ID'
name	VARCHAR (45) NOT NULL COMMENT 'sku名称，方便管理。'
create_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
create_user_id	BIGINT UNSIGNED NOT NULL
last_modify_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
last_modify_user_id	BIGINT UNSIGNED NOT NULL
is_deleted	BIGINT UNSIGNED NOT NULL DEFAULT 0

sku_quantity

column name	definition
sku_id	BIGINT UNSIGNED NOT NULL
total_quantity	INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '库存总数'
create_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
create_user_id	BIGINT UNSIGNED NOT NULL
last_modify_time	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
last_modify_user_id	BIGINT UNSIGNED NOT NULL
is_deleted	BIGINT UNSIGNED NOT NULL DEFAULT 0