商品模型 · 優行到家后端程序

~~~[sql] CREATE TABLE `xi_goods` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `dealer_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商家ID', `stores_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '門店ID', `cate_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分類ID', `brands_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '品牌ID', `express_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '快遞ID', `template_id` int(11) unsigned DEFAULT NULL COMMENT '模板ID', `sn` varchar(32) NOT NULL DEFAULT '' COMMENT '商品唯一編碼', `name` varchar(64) NOT NULL DEFAULT '' COMMENT '名稱', `weight` float(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '重量（kg）', `volume` float(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '體積（m3）', `thumb` varchar(255) NOT NULL DEFAULT 'http://oss.dgyouduo.com/static/img/no-image.png' COMMENT '縮略圖', `banner` varchar(512) NOT NULL DEFAULT 'a:1:{i:0;s:53:"http://oss.dgyouduo.com/static/img/no-image-16x10.png";}' COMMENT '橫幅（輪播圖）', `summary` varchar(128) NOT NULL DEFAULT '' COMMENT '摘要', `content` text NOT NULL COMMENT '內容', `price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '普通價格', `market_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '市場價格', `inventory` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '庫存', `view_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '瀏覽數', `sale_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '銷售數', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_free_shipping` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否包郵', `is_hot` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否推薦', `is_new` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否新品', `is_real` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否實體商品', `is_sale` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否上架', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', `saled_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '上架時間', PRIMARY KEY (`id`), UNIQUE KEY `sn` (`sn`) ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='商品'; ~~~ ~~~[sql] CREATE TABLE `xi_goods_brands` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `dealer_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商家ID', `stores_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '門店ID', `cate_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分類ID', `name` varchar(16) NOT NULL DEFAULT '' COMMENT '名稱', `description` varchar(128) NOT NULL DEFAULT '' COMMENT '描述', `logo` varchar(255) NOT NULL DEFAULT 'http://oss.dgyouduo.com/static/img/no-image.png' COMMENT '商標', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`,`stores_id`,`cate_id`,`is_trash`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='商品品牌'; ~~~ ~~~[sql] CREATE TABLE `xi_goods_category` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `dealer_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商家ID', `stores_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '門店ID', `parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父ID', `parent_id_path` varchar(32) NOT NULL DEFAULT '' COMMENT '父ID路徑', `level` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '級別', `name` varchar(32) NOT NULL DEFAULT '' COMMENT '名稱', `thumb` varchar(255) NOT NULL DEFAULT 'http://oss.dgyouduo.com/static/img/no-image.png' COMMENT '縮略圖', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_show` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否顯示在列表', `is_hot` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否顯示在推薦', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`,`stores_id`,`parent_id`,`is_trash`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='商品分類'; ~~~ ~~~[sql] CREATE TABLE `xi_goods_evaluate` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `member_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '會員ID', `order_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '訂單ID', `goods_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品ID', `sku_key` varchar(32) DEFAULT NULL COMMENT '存放SKU庫存量項目ID進行拼接', `content` varchar(255) NOT NULL DEFAULT '' COMMENT '內容', `images` varchar(512) NOT NULL DEFAULT '/img/no-image.png' COMMENT '圖片', `grade` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '評分', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_anonymity` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否匿名', `is_audit` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否審核，0=>未審核，1=>審核通過，2=>審核駁回', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='商品評價'; ~~~ ~~~[sql] CREATE TABLE `xi_goods_parameter` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `dealer_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商家ID', `stores_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '門店ID', `cate_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分類ID', `name` varchar(32) NOT NULL DEFAULT '' COMMENT '名稱', `type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '屬性值類型（錄入方式），1=>單行文本，2=>多行文本，3=>單選，4=>多選', `default_values` varchar(255) NOT NULL DEFAULT '' COMMENT '可選屬性值（數組序列化）', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`,`stores_id`,`cate_id`,`is_trash`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='商品參數'; ~~~ ~~~[sql] CREATE TABLE `xi_goods_parameter_value` ( `param_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '參數ID', `goods_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品ID', `value` varchar(255) NOT NULL DEFAULT '' COMMENT '參數值', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', UNIQUE KEY `param_id` (`param_id`,`goods_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='商品參數值'; ~~~ ~~~[sql] CREATE TABLE `xi_goods_sku` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `dealer_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商家ID', `stores_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '門店ID', `cate_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分類ID', `name` varchar(32) NOT NULL DEFAULT '' COMMENT '名稱', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`,`stores_id`,`cate_id`,`is_trash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='商品庫存量單位'; ~~~ ~~~[sql] CREATE TABLE `xi_goods_sku_item` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `sku_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '庫存量項目ID', `name` varchar(16) NOT NULL DEFAULT '' COMMENT '名稱', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`,`sku_id`,`is_trash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='商品庫存量項目'; ~~~ ~~~[sql] CREATE TABLE `xi_goods_sku_value` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `dealer_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商家ID', `stores_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '門店ID', `goods_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品ID', `sku_key` varchar(32) NOT NULL DEFAULT '' COMMENT '存放SKU庫存量項目ID進行拼接', `sn` varchar(32) NOT NULL DEFAULT '' COMMENT '商品唯一編碼', `thumb` varchar(255) NOT NULL DEFAULT 'http://oss.dgyouduo.com/static/img/no-image.png' COMMENT '縮略圖', `price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '普通價格', `market_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '市場價格', `inventory` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '庫存', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`), UNIQUE KEY `sn` (`sn`), UNIQUE KEY `sku_key` (`sku_key`,`stores_id`,`goods_id`,`is_trash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='商品庫存量值'; ~~~