（十二）采购与入库数据表

 采购表

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` tinyint(1) 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 = '入库商品表';