### 數據庫設計
1. 平臺有5個字段設置。（1個選擇分銷模式、4個分銷比例設置）
2. 平臺分類中新增三個字段，作為分傭比例設置。
3. 商家有3個字段 （3個分銷比例）
CREATE TABLE `yf_fenxiao_cat` (
`id` INT (10) NOT NULL AUTO_INCREMENT,
`cat_id` INT (10) NOT NULL COMMENT '分類id',
`shop_id` INT (10) NOT NULL DEFAULT 0 COMMENT '店鋪id 為零代表平臺',
`user_id` INT (10) NOT NULL DEFAULT 0 COMMENT '當前操作用戶id 為零代表平臺',
`level` TINYINT (1) NOT NULL COMMENT '分銷級別',
`value` DECIMAL (4, 2) unsigned NOT NULL COMMENT '分銷比例',
`create` datetime NOT NULL COMMENT '創建時間',
`update` datetime NOT NULL COMMENT '更新時間',
PRIMARY KEY (`id`)
) ENGINE = INNODB DEFAULT CHARSET = utf8 ROW_FORMAT = COMPACT COMMENT = '分銷分類表';
CREATE TABLE `yf_fenxiao_goods` (
`id` INT (10) NOT NULL AUTO_INCREMENT,
`shop_id` INT (10) NOT NULL COMMENT '店鋪id（冗余）',
`goods_id` INT (10) NOT NULL COMMENT '商品id',
`version` INT (10) NOT NULL DEFAULT 1 COMMENT '版本號',
`level` TINYINT (1) NOT NULL COMMENT '分銷級別',
`value` DECIMAL (4, 2) unsigned NOT NULL COMMENT '分銷比例',
PRIMARY KEY (`id`)
) ENGINE = INNODB DEFAULT CHARSET = utf8 ROW_FORMAT = COMPACT COMMENT = '分銷商品表';
CREATE TABLE `yf_fenxiao_order_goods` (
`id` INT (10) NOT NULL AUTO_INCREMENT COMMENT '訂單商品表id',
`order_goods_id` INT (10) NOT NULL COMMENT '訂單商品表id',
`order_id` varchar(50) NOT NULL COMMENT '訂單id',
`shop_id` INT (10) NOT NULL COMMENT '店鋪id（冗余）',
`goods_id` INT (10) NOT NULL COMMENT '商品id（冗余）',
`num` INT (10) NOT NULL COMMENT '數量',
`price` DECIMAL(10,2) NOT NULL COMMENT '實付金額總的（冗余）',
`version` INT (10) NOT NULL COMMENT '關聯分銷商品表版本號',
`user_id` INT (10) NOT NULL COMMENT '用戶id',
PRIMARY KEY (`id`)
) ENGINE = INNODB DEFAULT CHARSET = utf8 ROW_FORMAT = COMPACT COMMENT = '分銷訂單商品表';
CREATE TABLE `yf_fenxiao_user` (
`user_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用戶id',
`parent_id` varchar(50) NOT NULL COMMENT '上級用戶id',
`create` datetime NOT NULL COMMENT '創建時間',
PRIMARY KEY (`user_id`)
) ENGINE = INNODB DEFAULT CHARSET = utf8 ROW_FORMAT = COMPACT COMMENT = '分銷會員關系表';
CREATE TABLE `yf_fenxiao_commission` (
`id` INT (10) NOT NULL AUTO_INCREMENT,
`order_goods_id` INT (10) NOT NULL COMMENT '訂單商品表id 注意此id為fenxiao_order_goods主鍵',
`price` DECIMAL(10,2) NOT NULL COMMENT '傭金',
`user_id` INT (10) NOT NULL COMMENT '用戶id',
`create` datetime NOT NULL COMMENT '創建時間',
`end` datetime NOT NULL COMMENT '結束時間（用戶確認收貨）',
`status` TINYINT (1) NOT NULL DEFAULT 0 COMMENT '是否結算',
PRIMARY KEY (`id`)
) ENGINE = INNODB DEFAULT CHARSET = utf8 ROW_FORMAT = COMPACT COMMENT = '分銷傭金流水表';
