促銷模型 · 優行到家后端程序

~~~[sql] CREATE TABLE `xi_promotion_coupon` ( `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', `name` varchar(32) NOT NULL DEFAULT '' COMMENT '名稱', `money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '金額', `number` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '數量', `conditions` varchar(255) NOT NULL DEFAULT '' 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) NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) NOT NULL DEFAULT '1451577600' COMMENT '更新時間', `start_at` int(11) NOT NULL DEFAULT '1451577600' COMMENT '開始時間', `end_at` int(11) NOT NULL DEFAULT '1451577600' COMMENT '結束時間', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='促銷優惠券'; ~~~ ~~~[sql] CREATE TABLE `xi_promotion_coupon_record` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `coupon_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '優惠券ID', `member_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '會員ID', `order_id` int(11) unsigned DEFAULT NULL COMMENT '訂單ID', `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 `conpon_id` (`coupon_id`,`member_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='促銷優惠券記錄'; ~~~ ~~~[sql] CREATE TABLE `xi_promotion_goods_seckill` ( `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', `price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '價格', `inventory` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '庫存', `max_buy_number` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '最大購買數量', `is_trash` tinyint(11) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(11) 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 '更新時間', `start_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '開始時間', `end_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '結束時間', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='促銷商品秒殺'; ~~~ ~~~[sql] CREATE TABLE `xi_promotion_order_full_subtract` ( `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', `value` varchar(255) NOT NULL DEFAULT '' 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 `stores_id` (`stores_id`,`is_trash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='促銷訂單滿減'; ~~~ ~~~[sql] CREATE TABLE `xi_promotion_redpacket` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `admin_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '管理員ID', `name` varchar(32) NOT NULL DEFAULT '' COMMENT '名稱', `money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '金額', `number` int(11) unsigned NOT NULL DEFAULT '1' 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='促銷紅包'; ~~~ ~~~[sql] CREATE TABLE `xi_promotion_redpacket_record` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `redpacket_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '紅包ID', `member_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '會員ID', `order_id` int(11) unsigned DEFAULT NULL COMMENT '訂單ID', `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 `redpacket_id` (`redpacket_id`,`member_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='促銷紅包記錄'; ~~~