新零售mysql设计（采购表 入库信息表 入库商品表）

CREATE table t_purchase(
id int unsigned PRIMARY KEY AUTO_INCREMENT COMMENT "主键",
    sku_id int unsigned not null COMMENT "商品id",
    num int unsigned not null COMMENT "数量",
    warehouse_id int unsigned not null COMMENT "仓库id",
    in_price  decimal(10,2)  unsigned not null COMMENT "采购价格",
    out_price decimal(10,2) unsigned COMMENT "建议零售价",
    buyer_id int unsigned not null COMMENT "采购员id",
    `status` tinyint unsigned not null COMMENT "状态:1未完成,2已完成",
    create_time timestamp not null default now() COMMENT "添加时间",
    INDEX idx_sku_id(sku_id),
    INDEX idx_warehouse_id(warehouse_id),
    INDEX idx_buyer_id(buyer_id),
    INDEX idx_status(`status`),
    INDEX idx_create_time(create_time)
) COMMENT="采购表";

CREATE TABLE t_productin(
id int unsigned PRIMARY KEY AUTO_INCREMENT COMMENT "主键",
    storekeeper_id int unsigned not null COMMENT "保管员id",
    amount decimal(15,2) unsigned not null COMMENT "总金额",
    supplier_id  int unsigned not null COMMENT "供应商id",
    payment decimal(15,2) unsigned not null COMMENT "实付金额",
    payment_type tinyint unsigned not null COMMENT "支付方式",
    invoice boolean not null COMMENT "是否开票",
    remark varchar(200) COMMENT "备注",
    create_time timestamp not null default now() COMMENT "添加时间",
    INDEX idx_storekeeper_id(storekeeper_id),
    INDEX idx_supplier_id(supplier_id),
    INDEX idx_payment_type(payment_type),
    INDEX idx_create_time(create_time) 
) COMMENT="入库信息表";

CREATE TABLE t_productin_purchase(
productin_id  int unsigned not null COMMENT "入库id",
    purchase_id int unsigned not null COMMENT "采购id",
    PRIMARY KEY(productin_id,purchase_id)
) COMMENT="入库商品表";