/*
 Navicat Premium Data Transfer

 Source Server         : 本地連接
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:3306
 Source Schema         : 本地复制存放

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 28/10/2024 16:28:57
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for activity_log
-- ----------------------------
DROP TABLE IF EXISTS `activity_log`;
CREATE TABLE `activity_log`  (
  `activity_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '員工操作日誌id',
  `admin_id` int(11) NULL DEFAULT NULL COMMENT '管理员id',
  `admin_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理员名称',
  `activity_type` int(2) NOT NULL DEFAULT 1 COMMENT '操作类型： 1：用户积分  2：用户钱包3:庫存4：位置',
  `activity_mode` int(2) NOT NULL DEFAULT 1 COMMENT '操作方式： 1：新增  2：减少',
  `activity_number` int(2) NOT NULL DEFAULT 0 COMMENT '操作数量',
  `activity_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '員工操作日誌修改信息',
  `activity_status` int(2) NOT NULL DEFAULT 1 COMMENT '1 可用 2禁用  -1删除',
  `created_at` datetime NULL DEFAULT NULL COMMENT '創建時間',
  `updated_at` datetime NULL DEFAULT NULL COMMENT '修改時間',
  PRIMARY KEY (`activity_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '員工操作日誌記錄' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of activity_log
-- ----------------------------

-- ----------------------------
-- Table structure for address_area
-- ----------------------------
DROP TABLE IF EXISTS `address_area`;
CREATE TABLE `address_area`  (
  `area_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '区域选择id',
  `en_area_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域名称-英文',
  `area_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域名称',
  `area_parent` int(11) NOT NULL DEFAULT 0 COMMENT '區域父級',
  `area_status` int(2) NULL DEFAULT 1 COMMENT '1 可用 0禁用  -1删除',
  `created_at` datetime NULL DEFAULT NULL COMMENT '用户创建时间',
  `updated_at` datetime NULL DEFAULT NULL COMMENT '用户更新时间',
  PRIMARY KEY (`area_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '区域选择' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of address_area
-- ----------------------------
INSERT INTO `address_area` VALUES (1, 'Central and West District', '中西區', 19, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (2, 'Eastern District', '東區', 19, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (3, 'Southern District', '南區', 19, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (4, 'Wan Chai District', '灣仔區', 19, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (5, 'Kowloon City District', '九龍城區', 20, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (6, 'Kwun Tong District', '觀塘區', 20, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (7, 'Sham Shui Po District', '深水涉區', 20, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (8, 'Wong Tai Sin District', '黃大仙區', 20, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (9, 'Yau Tsim Mong District', '油尖旺區', 20, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (10, 'Island District', '離島區', 21, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (11, 'Kwai Tsing District', '葵青區', 21, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (12, 'North District', '北區', 21, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (13, 'Sai Kung District', '西貢區', 21, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (14, 'Sha Tin District', '沙田區', 21, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (15, 'Tai Po District', '大浦區', 21, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (16, 'Tsuen Wan District', '荃灣區', 21, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (17, 'Tuen Mun District', '屯門區', 21, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (18, 'Yuen Long District', '元朗區', 21, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (19, 'Hong Kong Island', '香港島', 0, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (20, 'Kowloon Peninsula', '九龍半島', 0, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');
INSERT INTO `address_area` VALUES (21, 'New Territories', '新界', 0, 1, '2024-07-23 16:17:31', '2024-07-23 16:17:31');

-- ----------------------------
-- Table structure for admin_log
-- ----------------------------
DROP TABLE IF EXISTS `admin_log`;
CREATE TABLE `admin_log`  (
  `login_id` int(11) NOT NULL AUTO_INCREMENT,
  `login_admin_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登錄管理員id',
  `login_admin_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登錄管理員姓名',
  `login_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录IP',
  `login_nation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登錄國家',
  `login_region` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地區',
  `login_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '城市',
  `login_lng` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登錄經度',
  `login_lat` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登錄緯度',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`login_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理員登陆日志' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of admin_log
-- ----------------------------

-- ----------------------------
-- Table structure for admin_role
-- ----------------------------
DROP TABLE IF EXISTS `admin_role`;
CREATE TABLE `admin_role`  (
  `admin_role_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) NULL DEFAULT NULL COMMENT '管理员id',
  `role_id` int(11) NULL DEFAULT NULL COMMENT '角色id',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`admin_role_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员角色表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of admin_role
-- ----------------------------
INSERT INTO `admin_role` VALUES (1, 1, 1, '2024-09-09 10:10:53', '2024-09-09 10:10:55');

-- ----------------------------
-- Table structure for admins
-- ----------------------------
DROP TABLE IF EXISTS `admins`;
CREATE TABLE `admins`  (
  `admin_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '頭像',
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
  `token` varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'TOKEN',
  `status` int(11) NULL DEFAULT 1 COMMENT '状态(0禁用，1可用，-1删除)',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`admin_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员表\r\n' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of admins
-- ----------------------------
INSERT INTO `admins` VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', NULL, NULL, NULL, NULL, 1, '2024-09-09 10:09:59', '2024-09-09 10:10:02');

-- ----------------------------
-- Table structure for app_versions
-- ----------------------------
DROP TABLE IF EXISTS `app_versions`;
CREATE TABLE `app_versions`  (
  `versions_id` int(11) NOT NULL AUTO_INCREMENT,
  `versions_number` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `versions_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `versions_status` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '1：正常  2：禁用  -1：删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`versions_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of app_versions
-- ----------------------------
INSERT INTO `app_versions` VALUES (1, '1.01', 'http://www.xxx.com', '1', '2022-09-15 15:20:44', '2024-06-13 13:57:02');

-- ----------------------------
-- Table structure for banner
-- ----------------------------
DROP TABLE IF EXISTS `banner`;
CREATE TABLE `banner`  (
  `banner_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'bannerID',
  `banner_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'banner標題',
  `en_banner_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `banner_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片路径',
  `banner_status` int(11) NOT NULL DEFAULT 1 COMMENT '状态(1可用，0禁用，-1删除)',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`banner_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'banner图' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of banner
-- ----------------------------

-- ----------------------------
-- Table structure for clause
-- ----------------------------
DROP TABLE IF EXISTS `clause`;
CREATE TABLE `clause`  (
  `clause_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用戶隱私協議id',
  `clause_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',
  `en_clause_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容（英）',
  `clause_status` int(2) NOT NULL DEFAULT 1 COMMENT '1 可用 0禁用  -1删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`clause_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶隱私表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of clause
-- ----------------------------
INSERT INTO `clause` VALUES (1, '<p>本軟件尊重並保護所有使用服務用戶的個人隱私權。為了給您提供更準確、更有個性化的服務，本軟件會按照本隱私權政策的規定使用和披露您的個人資訊。但本軟件將以高度的勤勉、審慎義務對待這些資訊。除本隱私權政策另有規定外，在未征得您事先許可的情况下，本軟件不會將這些資訊對外披露或向協力廠商提供。本軟件會不時更新本隱私權政策。您在同意本軟件服務使用協定之時，即視為您已經同意本隱私權政策全部內容。本隱私權政策屬於本軟件服務使用協定不可分割的一部分。</p>\n<p>&nbsp;</p>\n<p>1.適用範圍</p>\n<p>&nbsp;</p>\n<p>a）在您使用本軟件網路服務，本軟件自動接收並記錄的您的手機上的資訊，包括但不限於您的健康數據、使用的語言、訪問日期和時間、軟硬體特徵資訊及您需求的網頁記錄等數據；</p>\n<p>&nbsp;</p>\n<p>2.資訊的使用</p>\n<p>&nbsp;</p>\n<p>a）在獲得您的數據之後，本軟件會將其上傳至服務器，以生成您的排行榜數據，以便您能够更好地使用服務。</p>\n<p>&nbsp;</p>\n<p>3.資訊披露</p>\n<p>&nbsp;</p>\n<p>a）本軟件不會將您的資訊披露給不受信任的協力廠商。</p>\n<p>&nbsp;</p>\n<p>b）根據法律的有關規定，或者行政或司法機構的要求，向協力廠商或者行政、司法機構披露；</p>\n<p>&nbsp;</p>\n<p>c）如您出現違反香港有關法律、法規或者相關規則的情况，需要向協力廠商披露；</p>\n<p>&nbsp;</p>\n<p>4.資訊存儲和交換</p>\n<p>&nbsp;</p>\n<p>本軟件收集的有關您的資訊和資料將保存在本軟件及（或）其關聯公司的服務器上，這些資訊和資料可能傳送至您所在國家、地區或本軟件收集資訊和資料所在地的境外並在境外被訪問、存儲和展示。</p>\n<p>&nbsp;</p>\n<p>5.資訊安全</p>\n<p>&nbsp;</p>\n<p>a）在使用本軟件網路服務進行網上交易時，您不可避免的要向交易對方或潜在的交易對方披露自己的個人資訊，如聯絡方式或者郵政地址。請您妥善保護自己的個人資訊，僅在必要的情形下向他人提供。如您發現自己的個人資訊洩密，請您立即聯絡本軟件客服，以便本軟件採取相應措施。</p>', '<p>本軟件尊重並保護所有使用服務用戶的個人隱私權。為了給您提供更準確、更有個性化的服務，本軟件會按照本隱私權政策的規定使用和披露您的個人資訊。但本軟件將以高度的勤勉、審慎義務對待這些資訊。除本隱私權政策另有規定外，在未征得您事先許可的情况下，本軟件不會將這些資訊對外披露或向協力廠商提供。本軟件會不時更新本隱私權政策。您在同意本軟件服務使用協定之時，即視為您已經同意本隱私權政策全部內容。本隱私權政策屬於本軟件服務使用協定不可分割的一部分。</p>\n<p>&nbsp;</p>\n<p>1.適用範圍</p>\n<p>&nbsp;</p>\n<p>a）在您使用本軟件網路服務，本軟件自動接收並記錄的您的手機上的資訊，包括但不限於您的健康數據、使用的語言、訪問日期和時間、軟硬體特徵資訊及您需求的網頁記錄等數據；</p>\n<p>&nbsp;</p>\n<p>2.資訊的使用</p>\n<p>&nbsp;</p>\n<p>a）在獲得您的數據之後，本軟件會將其上傳至服務器，以生成您的排行榜數據，以便您能够更好地使用服務。</p>\n<p>&nbsp;</p>\n<p>3.資訊披露</p>\n<p>&nbsp;</p>\n<p>a）本軟件不會將您的資訊披露給不受信任的協力廠商。</p>\n<p>&nbsp;</p>\n<p>b）根據法律的有關規定，或者行政或司法機構的要求，向協力廠商或者行政、司法機構披露；</p>\n<p>&nbsp;</p>\n<p>c）如您出現違反香港有關法律、法規或者相關規則的情况，需要向協力廠商披露；</p>\n<p>&nbsp;</p>\n<p>4.資訊存儲和交換</p>\n<p>&nbsp;</p>\n<p>本軟件收集的有關您的資訊和資料將保存在本軟件及（或）其關聯公司的服務器上，這些資訊和資料可能傳送至您所在國家、地區或本軟件收集資訊和資料所在地的境外並在境外被訪問、存儲和展示。</p>\n<p>&nbsp;</p>\n<p>5.資訊安全</p>\n<p>&nbsp;</p>\n<p>a）在使用本軟件網路服務進行網上交易時，您不可避免的要向交易對方或潜在的交易對方披露自己的個人資訊，如聯絡方式或者郵政地址。請您妥善保護自己的個人資訊，僅在必要的情形下向他人提供。如您發現自己的個人資訊洩密，請您立即聯絡本軟件客服，以便本軟件採取相應措施。</p>', 1, '2024-05-16 14:07:25', '2024-05-16 14:07:25');

-- ----------------------------
-- Table structure for coupon
-- ----------------------------
DROP TABLE IF EXISTS `coupon`;
CREATE TABLE `coupon`  (
  `coupon_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) NULL DEFAULT NULL COMMENT '管理员id',
  `coupon_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
  `en_coupon_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '优惠券名称（英）',
  `coupon_type` int(11) NULL DEFAULT NULL COMMENT '1：現金券 2：現金券 3：折扣券 4：折扣券',
  `lowest` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '使用优惠券最低价',
  `discount` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '折扣',
  `coupon_stock` int(11) NOT NULL DEFAULT 0 COMMENT '优惠券庫存',
  `conversion_price` int(11) NULL DEFAULT NULL COMMENT '兑换价格',
  `expiration_time` datetime NULL DEFAULT NULL COMMENT '到期时间',
  `instructions` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '使用说明',
  `en_instructions` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '使用说明（英）',
  `coupon_status` int(11) NOT NULL DEFAULT 1 COMMENT '1：正常0：禁用-1：删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`coupon_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '优惠券表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of coupon
-- ----------------------------
INSERT INTO `coupon` VALUES (1, 1, '立減優惠券 $20', 'Discount coupon $20', 1, 10.00, '20', 92, 20, '2024-08-31 00:00:00', '使用此優惠券可立即優惠 $20', 'Use this coupon to immediately discount $20', 1, '2024-07-04 17:16:48', '2024-07-25 17:14:29');
INSERT INTO `coupon` VALUES (2, 1, '滿減優惠券 $20', 'Full discount coupon $20', 2, 200.00, '20', 96, 20, '2024-08-31 00:00:00', '金額滿$200可享受優惠$20', 'A discount of $20 is available for amounts over $200', 1, '2024-07-04 17:23:48', '2024-07-25 16:39:25');
INSERT INTO `coupon` VALUES (3, 1, '立折優惠券 9折', '10% off vertical discount coupon', 3, 0.00, '0.9', 98, 20, '2024-08-31 00:00:00', '使用此優惠券可立即享受9折優惠', 'Use this coupon to immediately enjoy a 10% discount', 1, '2024-07-04 17:26:05', '2024-07-15 16:41:04');
INSERT INTO `coupon` VALUES (4, 1, '滿折優惠券 9折', '10% off full discount coupon', 4, 200.00, '0.9', 94, 20, '2024-08-31 00:00:00', '金額滿200可享受9折優惠', 'Up to 200 yuan can enjoy a 10% discount', 1, '2024-07-04 17:30:34', '2024-08-21 14:43:53');

-- ----------------------------
-- Table structure for file
-- ----------------------------
DROP TABLE IF EXISTS `file`;
CREATE TABLE `file`  (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `file_sort_id` int(11) NULL DEFAULT NULL COMMENT '文件分类id',
  `file_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件地址',
  PRIMARY KEY (`file_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文件地址表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of file
-- ----------------------------

-- ----------------------------
-- Table structure for file_sort
-- ----------------------------
DROP TABLE IF EXISTS `file_sort`;
CREATE TABLE `file_sort`  (
  `file_sort_id` int(11) NOT NULL AUTO_INCREMENT,
  `file_sort_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件分类名',
  `en_file_sort_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件分类名（英）',
  PRIMARY KEY (`file_sort_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文件分类表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of file_sort
-- ----------------------------
INSERT INTO `file_sort` VALUES (1, 'Logo（請勿刪除）', 'Logo（請勿刪除）');
INSERT INTO `file_sort` VALUES (2, '產品圖片', 'product picture');
INSERT INTO `file_sort` VALUES (3, '產品分類圖片', 'Product category Pictures');

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu`  (
  `menu_id` int(11) NOT NULL AUTO_INCREMENT,
  `menu_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '菜单名',
  `en_menu_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜單名（英）',
  `parent` int(11) NULL DEFAULT 0 COMMENT '父级',
  `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标',
  `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路径',
  `redirect` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `status` int(11) NULL DEFAULT 1 COMMENT '状态(2禁用，1可用，-1删除)',
  `created_at` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 52 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '路由表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of menu
-- ----------------------------
INSERT INTO `menu` VALUES (1, '權限管理', NULL, 0, 'el-icon-lock', '/authority', 'Layout', 1, '2024-08-01 09:16:51', '2024-08-01 09:16:51');
INSERT INTO `menu` VALUES (2, '管理員管理', NULL, 1, NULL, '/administrator', 'authority/administrator', 1, '2024-07-15 16:31:47', NULL);
INSERT INTO `menu` VALUES (3, '角色管理', NULL, 1, NULL, '/role', 'authority/role', 1, '2024-07-15 16:31:58', NULL);
INSERT INTO `menu` VALUES (4, '規格分類管理', NULL, 0, 'el-icon-copy-document', '/specs', 'Layout', 1, '2024-08-01 09:16:57', '2024-08-01 09:16:57');
INSERT INTO `menu` VALUES (5, '規格分類管理', NULL, 4, NULL, '/specs-cate', 'specs/specs-cate', 1, '2024-07-15 16:32:13', NULL);
INSERT INTO `menu` VALUES (6, '產品管理', NULL, 0, 'el-icon-goods', '/product', 'Layout', 1, '2024-08-01 09:17:03', '2024-08-01 09:17:03');
INSERT INTO `menu` VALUES (7, '產品列表', NULL, 6, NULL, '/product-list', 'product/product-list', 1, '2024-07-16 10:50:18', '2024-07-16 10:50:18');
INSERT INTO `menu` VALUES (8, '產品分類管理', NULL, 6, NULL, '/classification', 'product/product-list', 1, '2024-07-16 10:50:20', '2024-07-16 10:50:20');
INSERT INTO `menu` VALUES (9, '用戶管理', NULL, 0, 'el-icon-user', '/user', 'Layout', 1, '2024-08-01 09:17:07', '2024-08-01 09:17:07');
INSERT INTO `menu` VALUES (10, '用戶管理', NULL, 9, NULL, '/user-list', 'user/user-list', 1, '2024-07-15 16:32:51', NULL);
INSERT INTO `menu` VALUES (11, '優惠券管理', NULL, 0, 'el-icon-s-ticket', '/coupon', 'Layout', 1, '2024-08-01 09:17:16', '2024-08-01 09:17:16');
INSERT INTO `menu` VALUES (12, '優惠券管理', NULL, 11, NULL, '/coupon-list', 'coupon/coupon-list', 1, '2024-07-15 16:33:06', NULL);
INSERT INTO `menu` VALUES (13, '產品庫銷記錄', NULL, 0, 'el-icon-tickets', '/inventory-records', 'Layout', 1, '2024-08-01 09:17:24', '2024-08-01 09:17:24');
INSERT INTO `menu` VALUES (14, '損耗記錄', NULL, 13, NULL, '/loss', 'inventory-records/loss', 1, '2024-07-15 16:33:18', NULL);
INSERT INTO `menu` VALUES (15, '采購記錄', NULL, 13, NULL, '/purchase', 'inventory-records/purchase', 1, '2024-07-15 16:33:26', NULL);
INSERT INTO `menu` VALUES (16, '預約排號管理', NULL, 0, 'el-icon-time', '/Appointment-queue', 'Layout', 1, '2024-08-01 09:17:30', '2024-08-01 09:17:30');
INSERT INTO `menu` VALUES (17, '排號項目管理', NULL, 16, NULL, '/number-project', 'Appointment-queue/number-project', 1, '2024-07-15 16:33:44', NULL);
INSERT INTO `menu` VALUES (18, '用戶排號管理', NULL, 16, NULL, '/user-numbering', 'Appointment-queue/user-numbering', 1, '2024-07-15 16:33:52', NULL);
INSERT INTO `menu` VALUES (19, '訂單管理', NULL, 0, 'el-icon-s-order', '/order', 'Layout', 1, '2024-08-01 09:17:35', '2024-08-01 09:17:35');
INSERT INTO `menu` VALUES (20, '訂單列表', NULL, 19, NULL, '/order-list', 'order/order-list', 1, '2024-07-15 16:34:12', NULL);
INSERT INTO `menu` VALUES (21, '線下訂單', NULL, 19, NULL, '/offline-orders', 'order/offline-orders', 1, '2024-07-15 16:34:20', NULL);
INSERT INTO `menu` VALUES (22, '日曆訂單', NULL, 19, NULL, '/calendar-orders', 'order/calendar-orders', 1, '2024-07-15 16:34:32', NULL);
INSERT INTO `menu` VALUES (23, '評論管理', NULL, 0, 'el-icon-s-comment', '/comment', 'Layout', 1, '2024-08-01 09:17:36', '2024-08-01 09:17:36');
INSERT INTO `menu` VALUES (24, '評論管理', NULL, 23, NULL, '/comment-list', 'comment/comment-list', 1, '2024-07-15 16:34:48', NULL);
INSERT INTO `menu` VALUES (25, '咨詢管理', NULL, 0, 'el-icon-film', '/news', 'Layout', 1, '2024-08-01 09:17:53', '2024-08-01 09:17:53');
INSERT INTO `menu` VALUES (26, '咨詢管理', NULL, 25, NULL, '/news-list', 'news/news-list', 1, '2024-07-15 16:35:02', NULL);
INSERT INTO `menu` VALUES (27, '百度AI', NULL, 0, 'el-icon-question', '/baidu', 'Layout', 1, '2024-08-01 09:18:05', '2024-08-01 09:18:05');
INSERT INTO `menu` VALUES (28, '百度AI', NULL, 27, NULL, '/baidu-ai', 'baidu/baidu-ai', 1, '2024-07-15 16:35:16', NULL);
INSERT INTO `menu` VALUES (29, '店鋪管理', NULL, 0, 'el-icon-s-shop', '/shop', 'Layout', 1, '2024-08-01 09:18:12', '2024-08-01 09:18:12');
INSERT INTO `menu` VALUES (30, '店鋪管理', NULL, 29, NULL, '/store-settings', 'shop/store-settings', 1, '2024-07-15 16:35:30', NULL);
INSERT INTO `menu` VALUES (31, '客服管理', NULL, 29, NULL, '/service-settings', 'shop/service-settings', 1, '2024-07-15 16:35:40', NULL);
INSERT INTO `menu` VALUES (32, 'PayPal管理', NULL, 29, NULL, '/paypal-settings', 'shop/paypal-settings', 1, '2024-07-15 16:35:48', NULL);
INSERT INTO `menu` VALUES (33, '等級管理', NULL, 29, NULL, '/member-list', 'shop/member-list', 1, '2024-07-15 16:35:57', NULL);
INSERT INTO `menu` VALUES (34, '常見問題管理', NULL, 29, NULL, '/faq-list', 'shop/faq-list', 1, '2024-07-15 16:36:05', NULL);
INSERT INTO `menu` VALUES (35, '推送管理', NULL, 0, 'el-icon-s-promotion', '/system', 'Layout', 1, '2024-08-01 09:18:19', '2024-08-01 09:18:19');
INSERT INTO `menu` VALUES (36, '推送配置', NULL, 35, NULL, '/push-settings', 'system/push-settings', 1, '2024-07-15 16:36:21', NULL);
INSERT INTO `menu` VALUES (37, '系統推送', NULL, 35, NULL, '/system-push', 'system/system-push', 1, '2024-07-15 16:36:30', NULL);
INSERT INTO `menu` VALUES (38, '協議管理', NULL, 0, 'el-icon-tickets', '/agreement', 'Layout', 1, '2024-08-01 09:18:23', '2024-08-01 09:18:23');
INSERT INTO `menu` VALUES (39, '用戶協議管理', NULL, 38, NULL, '/user-agreement', 'agreement/user-agreement', 1, '2024-07-15 16:36:45', NULL);
INSERT INTO `menu` VALUES (40, '隱私協議管理', NULL, 38, NULL, '/privacy-agreement', 'agreement/privacy-agreement', -1, '2024-08-21 14:20:58', '2024-08-21 14:20:58');
INSERT INTO `menu` VALUES (41, 'Banner管理', NULL, 0, 'el-icon-s-flag', '/banner', 'Layout', 1, '2024-08-01 09:18:33', '2024-08-01 09:18:33');
INSERT INTO `menu` VALUES (42, 'Banner管理', NULL, 41, NULL, '/banner-list', 'banner/banner-list', 1, '2024-07-15 16:37:12', NULL);
INSERT INTO `menu` VALUES (43, '留言管理', NULL, 0, 'el-icon-chat-dot-round', '/message', 'Layout', 1, '2024-08-01 09:18:38', '2024-08-01 09:18:38');
INSERT INTO `menu` VALUES (44, '留言管理', NULL, 43, NULL, '/message-list', 'message/message-list', 1, '2024-07-15 16:37:25', NULL);
INSERT INTO `menu` VALUES (45, '分析系統', NULL, 0, 'el-icon-data-analysis', '/analysis', 'Layout', 1, '2024-08-01 09:18:40', '2024-08-01 09:18:40');
INSERT INTO `menu` VALUES (46, '用戶消費分析', NULL, 45, NULL, '/user-consumption', 'analysis/user-consumption', 1, '2024-07-15 16:37:41', NULL);
INSERT INTO `menu` VALUES (47, '訂單分析', NULL, 45, NULL, '/order-analysis', 'analysis/order-analysis', 1, '2024-07-15 16:37:52', NULL);
INSERT INTO `menu` VALUES (48, '銷售方向分析', NULL, 45, NULL, '/sales-direction', 'analysis/sales-direction', 1, '2024-07-15 16:38:01', NULL);
INSERT INTO `menu` VALUES (49, '日志管理', NULL, 0, 'el-icon-document', '/log', 'Layout', 1, '2024-08-01 09:18:55', '2024-08-01 09:18:55');
INSERT INTO `menu` VALUES (50, '操作日誌', NULL, 49, NULL, '/operation-log', 'log/operation-log', 1, '2024-07-15 16:38:13', NULL);
INSERT INTO `menu` VALUES (51, '登錄日誌', NULL, 49, NULL, '/login-log', 'log/login-log', 1, '2024-07-15 16:38:18', NULL);

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of migrations
-- ----------------------------

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news`  (
  `news_id` int(11) NOT NULL AUTO_INCREMENT,
  `news_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最新資訊標題',
  `en_news_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最新資訊標題(英文)',
  `news_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '新聞資訊圖片',
  `news_text` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '最新資訊內容',
  `en_news_text` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '最新資訊內容(英文)',
  `reading_num` int(11) NOT NULL DEFAULT 0 COMMENT '閱讀數量',
  `news_status` int(2) NULL DEFAULT 1 COMMENT '状态(0禁用，1可用，-1删除)',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`news_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '產品資訊表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of news
-- ----------------------------

-- ----------------------------
-- Table structure for oauth_access_tokens
-- ----------------------------
DROP TABLE IF EXISTS `oauth_access_tokens`;
CREATE TABLE `oauth_access_tokens`  (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) NULL DEFAULT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `oauth_access_tokens_user_id_index`(`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Laravel_Token註冊表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of oauth_access_tokens
-- ----------------------------
INSERT INTO `oauth_access_tokens` VALUES ('a686d014512173336d3a6ecaacbf5a625869c3a2d3f86dab1612afe4918894d50390403446d9b971', 100001, 3, '100001', '[]', 0, '2024-08-28 11:13:26', '2024-08-28 11:13:26', '2025-08-28 11:13:26');

-- ----------------------------
-- Table structure for oauth_clients
-- ----------------------------
DROP TABLE IF EXISTS `oauth_clients`;
CREATE TABLE `oauth_clients`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `redirect` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `provider` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `oauth_clients_user_id_index`(`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Laravel密鑰記錄表1' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of oauth_clients
-- ----------------------------
INSERT INTO `oauth_clients` VALUES (1, NULL, 'MobFever Personal Access Client', 'ECgF5VMwp30kXsResfnsJo7FqWo55WNxluh4Ypge', 'http://localhost', NULL, 1, 0, 0, '2024-08-28 10:13:47', '2024-08-28 10:13:47');
INSERT INTO `oauth_clients` VALUES (2, NULL, 'MobFever Password Grant Client', 'P2GSVhNEY8ut3RjfT78lcmnRCziTolCUSbFUwbrF', 'http://localhost', 'users', 0, 1, 0, '2024-08-28 10:13:47', '2024-08-28 10:13:47');
INSERT INTO `oauth_clients` VALUES (3, NULL, 'MobFever Personal Access Client', 'onC3pK5Ql9eQb7Dj64ge7O8eeScQHbeh1dwkBCLf', 'http://localhost', NULL, 1, 0, 0, '2024-08-28 10:38:25', '2024-08-28 10:38:25');
INSERT INTO `oauth_clients` VALUES (4, NULL, 'MobFever Password Grant Client', 'YDp2X9C9CMC0YgoWjTsGrYwecaIFOCMX1O9mWnC1', 'http://localhost', 'users', 0, 1, 0, '2024-08-28 10:38:25', '2024-08-28 10:38:25');
INSERT INTO `oauth_clients` VALUES (5, NULL, 'rande Personal Access Client', 'z7i1EF1LS2bL0UAxLoy5udMkBPjFB0PoM1eSri3S', 'http://localhost', NULL, 1, 0, 0, '2024-09-09 10:11:08', '2024-09-09 10:11:08');
INSERT INTO `oauth_clients` VALUES (6, NULL, 'rande Password Grant Client', 'DC2ehjlYj6QPLkCIaLcfino8rgxyQm4BRDi3Jrl2', 'http://localhost', 'users', 0, 1, 0, '2024-09-09 10:11:08', '2024-09-09 10:11:08');

-- ----------------------------
-- Table structure for oauth_personal_access_clients
-- ----------------------------
DROP TABLE IF EXISTS `oauth_personal_access_clients`;
CREATE TABLE `oauth_personal_access_clients`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `client_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `oauth_personal_access_clients_client_id_index`(`client_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Laravel密鑰記錄表2' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of oauth_personal_access_clients
-- ----------------------------
INSERT INTO `oauth_personal_access_clients` VALUES (1, 1, '2024-08-28 10:13:47', '2024-08-28 10:13:47');
INSERT INTO `oauth_personal_access_clients` VALUES (2, 3, '2024-08-28 10:38:25', '2024-08-28 10:38:25');
INSERT INTO `oauth_personal_access_clients` VALUES (3, 5, '2024-09-09 10:11:08', '2024-09-09 10:11:08');

-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order`  (
  `order_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '訂單ID',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用戶id',
  `coupon_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '優惠券id',
  `order_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '訂單號',
  `original_cost` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '訂單原价=订单实际支付金额+订单优惠金额',
  `order_money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '订单实际支付金额',
  `coupon_money` decimal(10, 2) NOT NULL COMMENT '订单优惠金额',
  `freight_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '订单运费',
  `booking_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '预约到店金额',
  `delivery_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收货地址-地址',
  `delivery_area` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收货地址-区域',
  `delivery_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收货地址-姓名',
  `delivery_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收货地址-电话',
  `delivery_mail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收货地址-邮件',
  `payment_type` int(2) NOT NULL DEFAULT 1 COMMENT '支付类型：1：立即支付，2：預約到店查看',
  `payment_mode` int(2) NOT NULL DEFAULT 1 COMMENT '支付方式 1：paypal  2：Stripe，3：錢包 ，4：其他支付（上傳支付圖片）5：線下支付',
  `order_type` int(2) NOT NULL DEFAULT 1 COMMENT '訂單類型：1：線上訂單，2：線下訂單',
  `indent_type` int(2) NOT NULL DEFAULT 1 COMMENT '訂單類型  1產品訂單  2預約訂單',
  `receiving_type` int(2) NOT NULL DEFAULT 1 COMMENT '取货方式：1：商家发货，2：自取',
  `payment_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '訂單支付圖片（其他支付）',
  `order_time` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '訂單预约时间',
  `order_num` int(11) NOT NULL DEFAULT 1 COMMENT '訂單预约人数',
  `refund_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '訂單退款id',
  `payment_status` int(2) NOT NULL DEFAULT 1 COMMENT '支付状态：1：待支付  2：待核验（其他支付的）   3：已支付  4：已取消  5：已完成',
  `return_status` int(2) NOT NULL DEFAULT 0 COMMENT '退款状态：0：不可退款  1：可退款  2：退款中  3：已退款',
  `push_state` int(2) NOT NULL DEFAULT 1 COMMENT '推送状态：1：未推送 2：已推送',
  `mail_state` int(2) NOT NULL DEFAULT 1 COMMENT '郵件發送狀態 ： 1：未發送  2：已發送',
  `order_status` int(2) NOT NULL DEFAULT 1 COMMENT '状态(1可用，0禁用,-1删除)',
  `payment_at` datetime NULL DEFAULT NULL COMMENT '支付成功時間',
  `order_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '訂單备注',
  `created_at` datetime NULL DEFAULT NULL COMMENT '訂單創建時間',
  `updated_at` datetime NULL DEFAULT NULL COMMENT '訂單更新時間',
  `order_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单二维码',
  PRIMARY KEY (`order_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '訂單表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of order
-- ----------------------------

-- ----------------------------
-- Table structure for order_comment
-- ----------------------------
DROP TABLE IF EXISTS `order_comment`;
CREATE TABLE `order_comment`  (
  `comment_id` int(12) NOT NULL AUTO_INCREMENT COMMENT '評論id',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用戶id',
  `product_id` int(11) NULL DEFAULT NULL COMMENT '商品id',
  `details_id` int(11) NULL DEFAULT NULL COMMENT '訂單詳情id',
  `comment_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '評論圖片',
  `comment_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '評論內容',
  `comment_score` int(11) NULL DEFAULT NULL COMMENT '評分',
  `comment_status` int(11) NOT NULL DEFAULT 1 COMMENT '状态(1可用，0禁用，-1删除)',
  `created_at` datetime NULL DEFAULT NULL COMMENT '創建時間',
  `updated_at` datetime NULL DEFAULT NULL COMMENT '修改時間',
  PRIMARY KEY (`comment_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '訂單評論表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of order_comment
-- ----------------------------

-- ----------------------------
-- Table structure for order_details
-- ----------------------------
DROP TABLE IF EXISTS `order_details`;
CREATE TABLE `order_details`  (
  `details_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '訂單詳情id',
  `order_id` int(11) NULL DEFAULT NULL COMMENT '訂單id',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用戶id',
  `product_id` int(11) NULL DEFAULT NULL COMMENT '商品id',
  `product_relation_id` int(11) NULL DEFAULT NULL COMMENT '產品規格組合ID',
  `product_specs` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '產品規格',
  `product_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品名',
  `product_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品展示图',
  `product_number` int(11) NULL DEFAULT NULL COMMENT '购买数量',
  `product_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '單價金额',
  `product_money` decimal(10, 2) NULL DEFAULT NULL COMMENT '商品總價',
  `product_type` int(2) NULL DEFAULT NULL COMMENT '商品种类1：產品 2：預約',
  `details_status` int(2) NOT NULL DEFAULT 1 COMMENT '状态(1可用，2禁用,-1删除)',
  `logistics_status` int(2) NOT NULL DEFAULT 0 COMMENT '物流狀態 0：待發貨   1：發貨中   2：已收貨  3:已評論',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  `details_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '訂單詳情備註',
  PRIMARY KEY (`details_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '訂單詳情表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of order_details
-- ----------------------------

-- ----------------------------
-- Table structure for order_logistics
-- ----------------------------
DROP TABLE IF EXISTS `order_logistics`;
CREATE TABLE `order_logistics`  (
  `logistics_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '訂單物流id',
  `details_id` int(11) NULL DEFAULT NULL COMMENT '訂單詳情id',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用戶id',
  `logistics_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '物流單號',
  `logistics_status` int(2) NOT NULL DEFAULT 0 COMMENT '物流狀態 0：待發貨   1：發貨中   2：已收貨  ',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`logistics_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '訂單物流' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of order_logistics
-- ----------------------------

-- ----------------------------
-- Table structure for order_snapshot
-- ----------------------------
DROP TABLE IF EXISTS `order_snapshot`;
CREATE TABLE `order_snapshot`  (
  `snapshot_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '訂單快照ID',
  `details_id` int(11) NOT NULL COMMENT '訂單詳情ID',
  `coupon_snapshot` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '優惠券快照',
  `user_snapshot` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '用戶快照',
  `product_snapshot` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '產品快照',
  `snapshot_status` int(11) NOT NULL DEFAULT 1 COMMENT '1：正常0：禁用-1：删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`snapshot_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '訂單快照表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of order_snapshot
-- ----------------------------

-- ----------------------------
-- Table structure for power
-- ----------------------------
DROP TABLE IF EXISTS `power`;
CREATE TABLE `power`  (
  `power_id` int(11) NOT NULL AUTO_INCREMENT,
  `power_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限名',
  `en_power_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '權限名（英）',
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限标识',
  PRIMARY KEY (`power_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of power
-- ----------------------------
INSERT INTO `power` VALUES (1, '查看', 'query', 'view');
INSERT INTO `power` VALUES (2, '新增', 'newly added', 'add');
INSERT INTO `power` VALUES (3, '編輯', 'modify', 'edit');
INSERT INTO `power` VALUES (4, '刪除', 'Delete', 'del');
INSERT INTO `power` VALUES (5, '規格', NULL, 'spec');
INSERT INTO `power` VALUES (6, '修改密碼', NULL, 'password');
INSERT INTO `power` VALUES (7, '發送郵件', NULL, 'send');
INSERT INTO `power` VALUES (8, '修改狀態', NULL, 'status');
INSERT INTO `power` VALUES (9, '下載發票/收據', NULL, 'download');
INSERT INTO `power` VALUES (10, '確認支付', NULL, 'pay');
INSERT INTO `power` VALUES (11, '添加物流單號', NULL, 'logistics');
INSERT INTO `power` VALUES (12, '修改預約時間', NULL, 'appotime');
INSERT INTO `power` VALUES (13, '確認收貨', NULL, 'complete');
INSERT INTO `power` VALUES (14, '添加線下訂單', NULL, 'addo');
INSERT INTO `power` VALUES (15, '預約線下訂單', NULL, 'appo');
INSERT INTO `power` VALUES (16, '進/出倉', NULL, 'oew');

-- ----------------------------
-- Table structure for power_menu
-- ----------------------------
DROP TABLE IF EXISTS `power_menu`;
CREATE TABLE `power_menu`  (
  `power_menu_id` int(11) NOT NULL AUTO_INCREMENT,
  `power_id` int(11) NULL DEFAULT NULL COMMENT '权限id',
  `role_id` int(11) NULL DEFAULT NULL COMMENT '角色id',
  `menu_id` int(11) NULL DEFAULT NULL COMMENT '路由id',
  `status` int(11) NULL DEFAULT 0 COMMENT '0:禁用1:正常',
  `created_at` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`power_menu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 75 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '路由权限表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of power_menu
-- ----------------------------
INSERT INTO `power_menu` VALUES (1, 2, 1, 2, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (2, 3, 1, 2, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (3, 4, 1, 2, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (4, 2, 1, 3, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (5, 3, 1, 3, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (6, 4, 1, 3, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (7, 2, 1, 5, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (8, 3, 1, 5, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (9, 4, 1, 5, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (10, 1, 1, 7, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (11, 2, 1, 7, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (12, 3, 1, 7, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (13, 4, 1, 7, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (14, 5, 1, 7, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (15, 2, 1, 8, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (16, 3, 1, 8, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (17, 4, 1, 8, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (18, 2, 1, 10, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (19, 3, 1, 10, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (20, 4, 1, 10, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (21, 6, 1, 10, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (22, 2, 1, 12, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (23, 3, 1, 12, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (24, 4, 1, 12, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (25, 2, 1, 14, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (26, 3, 1, 14, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (27, 4, 1, 14, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (28, 2, 1, 15, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (29, 3, 1, 15, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (30, 4, 1, 15, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (31, 7, 1, 15, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (32, 16, 1, 15, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (33, 2, 1, 17, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (34, 3, 1, 17, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (35, 4, 1, 17, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (36, 4, 1, 18, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (37, 8, 1, 18, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (38, 1, 1, 20, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (39, 4, 1, 20, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (40, 9, 1, 20, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (41, 10, 1, 20, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (42, 11, 1, 20, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (43, 12, 1, 20, 1, '2024-09-09 10:30:13', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (44, 13, 1, 20, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (45, 14, 1, 21, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (46, 15, 1, 21, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (47, 4, 1, 24, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (48, 2, 1, 26, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (49, 3, 1, 26, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (50, 4, 1, 26, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (51, 3, 1, 30, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (52, 2, 1, 31, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (53, 3, 1, 31, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (54, 4, 1, 31, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (55, 2, 1, 32, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (56, 3, 1, 32, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (57, 4, 1, 32, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (58, 3, 1, 33, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (59, 2, 1, 34, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (60, 3, 1, 34, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (61, 4, 1, 34, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (62, 3, 1, 36, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (63, 2, 1, 37, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (64, 4, 1, 37, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (65, 3, 1, 39, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (66, 3, 1, 40, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (67, 2, 1, 42, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (68, 3, 1, 42, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (69, 4, 1, 42, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (70, 4, 1, 44, 1, '2024-09-09 10:30:21', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (71, 4, 1, 50, 1, '2024-09-09 10:30:21', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (72, 2, 1, 52, 1, '2024-10-28 16:13:59', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (73, 3, 1, 52, 1, '2024-10-28 16:15:11', '2024-10-28 16:14:03');
INSERT INTO `power_menu` VALUES (74, 4, 1, 52, 1, '2024-10-28 16:15:13', '2024-10-28 16:14:03');

-- ----------------------------
-- Table structure for privacy
-- ----------------------------
DROP TABLE IF EXISTS `privacy`;
CREATE TABLE `privacy`  (
  `privacy_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '隱私協議id',
  `privacy_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',
  `en_privacy_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `privacy_status` int(2) NOT NULL DEFAULT 1 COMMENT '1 可用 2禁用  -1删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`privacy_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '隱私协议表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of privacy
-- ----------------------------

-- ----------------------------
-- Table structure for product
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product`  (
  `product_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '產品id',
  `product_sort_id` int(11) NULL DEFAULT NULL COMMENT 'APP类别ID',
  `product_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品名稱',
  `en_product_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '產品名稱（英）',
  `product_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品展示图',
  `is_priority` int(2) NULL DEFAULT 0 COMMENT '是否推荐 1：是 0：否',
  `is_specs` int(2) NULL DEFAULT 0 COMMENT '是否有规格 1：是  0：否',
  `is_album` int(2) NULL DEFAULT 0 COMMENT '是否有相冊 1：是 0：否',
  `is_integral` int(2) NULL DEFAULT 0 COMMENT '可否获得积分 1：是  0：否',
  `is_tag` int(2) NULL DEFAULT NULL COMMENT '是否有標籤  1：是 0：否',
  `integral_num` int(2) NULL DEFAULT 0 COMMENT '反馈积分',
  `product_type` int(2) NULL DEFAULT 1 COMMENT '商品种类1：產品 2：服務',
  `product_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '產品價格',
  `product_cost` int(11) NOT NULL DEFAULT 0 COMMENT '產品成本',
  `product_stock` int(11) NULL DEFAULT 0 COMMENT '產品庫存',
  `browse_number` int(11) NULL DEFAULT 0 COMMENT '商品瀏覽量',
  `product_describe` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '商品描述',
  `en_product_describe` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '產品描述（英）',
  `product_barcode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '产品条码',
  `product_location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '產品位置',
  `product_synopsis` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '產品簡介',
  `en_product_synopsis` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '產品簡介（英）',
  `product_hand` int(2) NOT NULL DEFAULT 0 COMMENT '產品人手',
  `product_status` int(11) NULL DEFAULT 1 COMMENT '1：正常  0：禁用  -1：删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`product_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '產品表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of product
-- ----------------------------
INSERT INTO `product` VALUES (1, 1, '海報製作', 'poster production', 'https://brain-storm.oss-cn-hongkong.aliyuncs.com/2024-08-28/1724815607813676.png', 1, 1, 1, 1, 0, 10, 2, 100.00, 10, 0, 0, '<p>海報製作</p>', '<p>poster production</p>', 'AC000012', 'A001', '海報製作', 'poster production', 1, 1, '2024-08-28 11:30:30', '2024-08-28 11:31:46');

-- ----------------------------
-- Table structure for product_album
-- ----------------------------
DROP TABLE IF EXISTS `product_album`;
CREATE TABLE `product_album`  (
  `product_album_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '產品相冊id',
  `product_id` int(11) NULL DEFAULT NULL COMMENT '產品id',
  `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '圖片地址',
  PRIMARY KEY (`product_album_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '產品相冊表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of product_album
-- ----------------------------
INSERT INTO `product_album` VALUES (1, 1, 'https://brain-storm.oss-cn-hongkong.aliyuncs.com/2024-08-28/1724815607813676.png');

-- ----------------------------
-- Table structure for product_relation
-- ----------------------------
DROP TABLE IF EXISTS `product_relation`;
CREATE TABLE `product_relation`  (
  `product_relation_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NULL DEFAULT NULL COMMENT '產品id',
  `product_specs_value_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '產品規格值id組合',
  `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '價格',
  `cost` decimal(10, 2) NULL DEFAULT NULL COMMENT '成本',
  `stock` int(11) NULL DEFAULT NULL COMMENT '庫存',
  PRIMARY KEY (`product_relation_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '產品規格組合表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of product_relation
-- ----------------------------
INSERT INTO `product_relation` VALUES (1, 1, '1-4', 100.00, 10.00, 0);
INSERT INTO `product_relation` VALUES (2, 1, '1-5', 200.00, 10.00, 0);
INSERT INTO `product_relation` VALUES (3, 1, '1-6', 300.00, 10.00, 0);
INSERT INTO `product_relation` VALUES (4, 1, '2-4', 400.00, 20.00, 0);
INSERT INTO `product_relation` VALUES (5, 1, '2-5', 500.00, 20.00, 0);
INSERT INTO `product_relation` VALUES (6, 1, '2-6', 600.00, 20.00, 0);
INSERT INTO `product_relation` VALUES (7, 1, '3-4', 700.00, 20.00, 0);
INSERT INTO `product_relation` VALUES (8, 1, '3-5', 800.00, 20.00, 0);
INSERT INTO `product_relation` VALUES (9, 1, '3-6', 900.00, 20.00, 0);

-- ----------------------------
-- Table structure for product_sort
-- ----------------------------
DROP TABLE IF EXISTS `product_sort`;
CREATE TABLE `product_sort`  (
  `product_sort_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_sort_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '產品分類名',
  `en_product_sort_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '產品分類名（英）',
  `product_sort_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分類圖片',
  `status` int(11) NULL DEFAULT 1,
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`product_sort_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '產品分類表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of product_sort
-- ----------------------------
INSERT INTO `product_sort` VALUES (1, '服務', 'serve', 'https://brain-storm.oss-cn-hongkong.aliyuncs.com/2024-08-28/1724815691129087.jpg', 1, '2024-08-28 11:28:39', NULL);

-- ----------------------------
-- Table structure for product_specs_key
-- ----------------------------
DROP TABLE IF EXISTS `product_specs_key`;
CREATE TABLE `product_specs_key`  (
  `product_specs_key_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NULL DEFAULT NULL COMMENT '產品id',
  `product_specs_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '產品規格名',
  `en_product_specs_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '產品規格名（英）',
  PRIMARY KEY (`product_specs_key_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '產品規格名表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of product_specs_key
-- ----------------------------
INSERT INTO `product_specs_key` VALUES (1, 1, '大小', 'size');
INSERT INTO `product_specs_key` VALUES (2, 1, '材質', 'texture');

-- ----------------------------
-- Table structure for product_specs_value
-- ----------------------------
DROP TABLE IF EXISTS `product_specs_value`;
CREATE TABLE `product_specs_value`  (
  `product_specs_value_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_specs_key_id` int(11) NULL DEFAULT NULL COMMENT '產品規格名id',
  `product_specs_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '產品規格值名',
  `en_product_specs_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '產品規格值名（英）',
  PRIMARY KEY (`product_specs_value_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '產品規格值表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of product_specs_value
-- ----------------------------
INSERT INTO `product_specs_value` VALUES (1, 1, '3*3米', '3*3M');
INSERT INTO `product_specs_value` VALUES (2, 1, '5*5米', '5*5M');
INSERT INTO `product_specs_value` VALUES (3, 1, '10*10米', '10*10M');
INSERT INTO `product_specs_value` VALUES (4, 2, 'PP紙', 'PP Paper');
INSERT INTO `product_specs_value` VALUES (5, 2, '無紡布', 'nonwovens');
INSERT INTO `product_specs_value` VALUES (6, 2, '絹絲佈', 'Spun silk cloth');

-- ----------------------------
-- Table structure for product_tag
-- ----------------------------
DROP TABLE IF EXISTS `product_tag`;
CREATE TABLE `product_tag`  (
  `product_tag_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NULL DEFAULT NULL,
  `product_tag_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `en_product_tag_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`product_tag_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '產品標籤表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of product_tag
-- ----------------------------

-- ----------------------------
-- Table structure for purchase_record
-- ----------------------------
DROP TABLE IF EXISTS `purchase_record`;
CREATE TABLE `purchase_record`  (
  `purchase_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '採購記錄id',
  `admin_id` int(11) NULL DEFAULT NULL COMMENT '管理員id',
  `product_id` int(11) NULL DEFAULT NULL COMMENT '產品id',
  `product_relation_id` int(11) NULL DEFAULT NULL COMMENT '產品規格組合id',
  `product_specs` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '產品規格',
  `purchase_supplier` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '採購供應商',
  `purchase_contact` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '採購聯繫方式',
  `purchase_cost` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '採購成本',
  `purchase_number` int(11) NULL DEFAULT NULL COMMENT '採購數量',
  `purchase_remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '採購備註',
  `purchase_send` int(2) NOT NULL DEFAULT 0 COMMENT '郵箱發送 0否  1是',
  `purchase_status` int(2) NOT NULL DEFAULT 1 COMMENT '1：正常  2：禁用  -1：删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  `purchase_state` int(2) NOT NULL DEFAULT 0 COMMENT '产品状态 0：等待進倉1：進倉、2：退倉、3：轉倉  ',
  PRIMARY KEY (`purchase_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '採購記錄' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of purchase_record
-- ----------------------------

-- ----------------------------
-- Table structure for push
-- ----------------------------
DROP TABLE IF EXISTS `push`;
CREATE TABLE `push`  (
  `push_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) NULL DEFAULT NULL COMMENT '管理员id',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `push_type` int(11) NULL DEFAULT 1 COMMENT '1：单用户2：多用户',
  `push_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '推送标题',
  `push_content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '推送内容',
  `push_platform` int(11) NULL DEFAULT 0 COMMENT '0：全部1：ios2：安卓',
  `push_status` int(11) NULL DEFAULT 1 COMMENT '1：正常-1：删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`push_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '推送信息表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of push
-- ----------------------------

-- ----------------------------
-- Table structure for reservation_project
-- ----------------------------
DROP TABLE IF EXISTS `reservation_project`;
CREATE TABLE `reservation_project`  (
  `reservation_project_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '预约项目id',
  `reservation_project_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '预约项目名',
  `en_reservation_project_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '预约项目名（英）',
  `reservation_project_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '預約項目圖片',
  `reservation_project_describe` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `en_reservation_project_describe` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述（英）',
  `reservation_project_stock` int(11) NULL DEFAULT NULL COMMENT '每日票数',
  `reservation_project_badge` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目标识',
  `reservation_project_time` int(3) NULL DEFAULT NULL COMMENT '项目时长(分钟)',
  `reservation_project_status` int(11) NOT NULL DEFAULT 1 COMMENT '1：正常0：禁用-1：删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`reservation_project_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '预约项目表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of reservation_project
-- ----------------------------

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role`  (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名',
  `en_role_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名（英）',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES (1, '超級管理員', 'Super administrator');

-- ----------------------------
-- Table structure for role_menu
-- ----------------------------
DROP TABLE IF EXISTS `role_menu`;
CREATE TABLE `role_menu`  (
  `role_menu_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NULL DEFAULT NULL COMMENT '角色id',
  `menu_id` int(11) NULL DEFAULT NULL COMMENT '路由id',
  `status` int(11) NULL DEFAULT 0 COMMENT '0:禁用1:正常',
  `created_at` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`role_menu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 53 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色路由表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of role_menu
-- ----------------------------
INSERT INTO `role_menu` VALUES (1, 1, 1, 1, '2024-09-09 10:33:16', '2024-09-09 10:33:16');
INSERT INTO `role_menu` VALUES (2, 1, 2, 1, '2024-09-09 10:33:16', '2024-09-09 10:33:16');
INSERT INTO `role_menu` VALUES (3, 1, 3, 1, '2024-09-09 10:33:16', '2024-09-09 10:33:16');
INSERT INTO `role_menu` VALUES (4, 1, 4, 1, '2024-09-09 10:33:16', '2024-09-09 10:33:16');
INSERT INTO `role_menu` VALUES (5, 1, 5, 1, '2024-09-09 10:33:17', '2024-09-09 10:33:17');
INSERT INTO `role_menu` VALUES (6, 1, 6, 1, '2024-09-09 10:33:17', '2024-09-09 10:33:17');
INSERT INTO `role_menu` VALUES (7, 1, 7, 1, '2024-09-09 10:33:17', '2024-09-09 10:33:17');
INSERT INTO `role_menu` VALUES (8, 1, 8, 1, '2024-09-09 10:33:17', '2024-09-09 10:33:17');
INSERT INTO `role_menu` VALUES (9, 1, 9, 1, '2024-09-09 10:33:17', '2024-09-09 10:33:17');
INSERT INTO `role_menu` VALUES (10, 1, 10, 1, '2024-09-09 10:33:17', '2024-09-09 10:33:17');
INSERT INTO `role_menu` VALUES (11, 1, 11, 1, '2024-09-09 10:33:17', '2024-09-09 10:33:17');
INSERT INTO `role_menu` VALUES (12, 1, 12, 1, '2024-09-09 10:33:17', '2024-09-09 10:33:17');
INSERT INTO `role_menu` VALUES (13, 1, 13, 1, '2024-09-09 10:33:17', '2024-09-09 10:33:17');
INSERT INTO `role_menu` VALUES (14, 1, 14, 1, '2024-09-09 10:33:17', '2024-09-09 10:33:17');
INSERT INTO `role_menu` VALUES (15, 1, 15, 1, '2024-09-09 10:33:17', '2024-09-09 10:33:17');
INSERT INTO `role_menu` VALUES (16, 1, 16, 1, '2024-09-09 10:33:17', '2024-09-09 10:33:17');
INSERT INTO `role_menu` VALUES (17, 1, 17, 1, '2024-09-09 10:33:18', '2024-09-09 10:33:18');
INSERT INTO `role_menu` VALUES (18, 1, 18, 1, '2024-09-09 10:33:18', '2024-09-09 10:33:18');
INSERT INTO `role_menu` VALUES (19, 1, 19, 1, '2024-09-09 10:33:18', '2024-09-09 10:33:18');
INSERT INTO `role_menu` VALUES (20, 1, 20, 1, '2024-09-09 10:33:18', '2024-09-09 10:33:18');
INSERT INTO `role_menu` VALUES (21, 1, 21, 1, '2024-09-09 10:33:18', '2024-09-09 10:33:18');
INSERT INTO `role_menu` VALUES (22, 1, 22, 1, '2024-09-09 10:33:18', '2024-09-09 10:33:18');
INSERT INTO `role_menu` VALUES (23, 1, 23, 1, '2024-09-09 10:33:18', '2024-09-09 10:33:18');
INSERT INTO `role_menu` VALUES (24, 1, 24, 1, '2024-09-09 10:33:18', '2024-09-09 10:33:18');
INSERT INTO `role_menu` VALUES (25, 1, 25, 1, '2024-09-09 10:33:18', '2024-09-09 10:33:18');
INSERT INTO `role_menu` VALUES (26, 1, 26, 1, '2024-09-09 10:33:18', '2024-09-09 10:33:18');
INSERT INTO `role_menu` VALUES (27, 1, 27, 1, '2024-09-09 10:33:18', '2024-09-09 10:33:18');
INSERT INTO `role_menu` VALUES (28, 1, 28, 1, '2024-09-09 10:33:18', '2024-09-09 10:33:18');
INSERT INTO `role_menu` VALUES (29, 1, 29, 1, '2024-09-09 10:33:19', '2024-09-09 10:33:19');
INSERT INTO `role_menu` VALUES (30, 1, 30, 1, '2024-09-09 10:33:19', '2024-09-09 10:33:19');
INSERT INTO `role_menu` VALUES (31, 1, 31, 1, '2024-09-09 10:33:19', '2024-09-09 10:33:19');
INSERT INTO `role_menu` VALUES (32, 1, 32, 1, '2024-09-09 10:33:19', '2024-09-09 10:33:19');
INSERT INTO `role_menu` VALUES (33, 1, 33, 1, '2024-09-09 10:33:19', '2024-09-09 10:33:19');
INSERT INTO `role_menu` VALUES (34, 1, 34, 1, '2024-09-09 10:33:19', '2024-09-09 10:33:19');
INSERT INTO `role_menu` VALUES (35, 1, 35, 1, '2024-09-09 10:33:19', '2024-09-09 10:33:19');
INSERT INTO `role_menu` VALUES (36, 1, 36, 1, '2024-09-09 10:33:19', '2024-09-09 10:33:19');
INSERT INTO `role_menu` VALUES (37, 1, 37, 1, '2024-09-09 10:33:19', '2024-09-09 10:33:19');
INSERT INTO `role_menu` VALUES (38, 1, 38, 1, '2024-09-09 10:33:19', '2024-09-09 10:33:19');
INSERT INTO `role_menu` VALUES (39, 1, 39, 1, '2024-09-09 10:33:19', '2024-09-09 10:33:19');
INSERT INTO `role_menu` VALUES (40, 1, 40, 1, '2024-09-09 10:33:19', '2024-09-09 10:33:19');
INSERT INTO `role_menu` VALUES (41, 1, 41, 1, '2024-09-09 10:33:20', '2024-09-09 10:33:20');
INSERT INTO `role_menu` VALUES (42, 1, 42, 1, '2024-09-09 10:33:20', '2024-09-09 10:33:20');
INSERT INTO `role_menu` VALUES (43, 1, 43, 1, '2024-09-09 10:33:20', '2024-09-09 10:33:20');
INSERT INTO `role_menu` VALUES (44, 1, 44, 1, '2024-09-09 10:33:20', '2024-09-09 10:33:20');
INSERT INTO `role_menu` VALUES (45, 1, 45, 1, '2024-09-09 10:33:20', '2024-09-09 10:33:20');
INSERT INTO `role_menu` VALUES (46, 1, 46, 1, '2024-09-09 10:33:20', '2024-09-09 10:33:20');
INSERT INTO `role_menu` VALUES (47, 1, 47, 1, '2024-09-09 10:33:20', '2024-09-09 10:33:20');
INSERT INTO `role_menu` VALUES (48, 1, 48, 1, '2024-09-09 10:33:20', '2024-09-09 10:33:20');
INSERT INTO `role_menu` VALUES (49, 1, 49, 1, '2024-09-09 10:33:20', '2024-09-09 10:33:20');
INSERT INTO `role_menu` VALUES (50, 1, 50, 1, '2024-09-09 10:33:20', '2024-09-09 10:33:20');
INSERT INTO `role_menu` VALUES (51, 1, 51, 1, '2024-09-09 10:33:20', '2024-09-09 10:33:20');
INSERT INTO `role_menu` VALUES (52, 1, 52, 1, '2024-09-09 10:33:20', '2024-09-09 10:33:20');

-- ----------------------------
-- Table structure for shop_cart
-- ----------------------------
DROP TABLE IF EXISTS `shop_cart`;
CREATE TABLE `shop_cart`  (
  `cart_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '購物車id',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `product_id` int(11) NULL DEFAULT NULL COMMENT '商品id',
  `product_price` int(11) NULL DEFAULT NULL,
  `product_num` int(11) NULL DEFAULT NULL COMMENT '数量',
  `status` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '-1刪除 1可用',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`cart_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '購物車' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of shop_cart
-- ----------------------------

-- ----------------------------
-- Table structure for shop_coupon
-- ----------------------------
DROP TABLE IF EXISTS `shop_coupon`;
CREATE TABLE `shop_coupon`  (
  `coupon_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '優惠券id',
  `coupon_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '優惠券名稱',
  `admin_id` int(11) NULL DEFAULT NULL COMMENT '管理員id',
  `coupon_lowest` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '使用优惠券最低价',
  `coupon_type` int(11) NULL DEFAULT 1 COMMENT '优惠券类型 1 ：立减 2：满减 3：立折 4：满折  ',
  `access_type` int(11) NULL DEFAULT 1 COMMENT '1为 积分兑换 2为手動發送 3為已手動發送 ',
  `coupon_price` decimal(10, 2) NOT NULL COMMENT '兑换价格',
  `coupon_discount` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '優惠券折扣',
  `coupon_stock` int(10) NOT NULL DEFAULT 0 COMMENT '優惠券库存',
  `coupon_convert` int(12) NOT NULL DEFAULT 0 COMMENT '兑换次数',
  `coupon_explain` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '使用說明',
  `start_time` datetime NULL DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
  `coupon_status` int(11) NULL DEFAULT 1 COMMENT '状态(0:新发布，1：正常,2：待审批,3：驳回,-1：删除) ',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`coupon_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '优惠卷' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of shop_coupon
-- ----------------------------
INSERT INTO `shop_coupon` VALUES (1, '電子優惠券 $10', 1, 0.00, 1, 1, 20.00, '0.8', 999997, 2, '只要用App下單即減$10.00', '2024-04-01 00:00:00', '2024-08-31 00:00:00', -1, '2024-04-01 00:00:00', '2024-05-15 13:40:39');
INSERT INTO `shop_coupon` VALUES (2, '電子折扣券 9折', 1, 0.00, 3, 1, 20.00, '0.9', 999996, 3, '使用App下單，即可享9折', '2024-04-01 00:00:00', '2024-08-31 00:00:00', -1, '2024-04-01 00:00:00', '2024-05-15 13:40:39');
INSERT INTO `shop_coupon` VALUES (3, '滿減優惠券 $20', 1, 400.00, 2, 1, 20.00, '20', 999996, 3, '使用App下單，滿$400減$20', '2024-04-01 00:00:00', '2024-08-31 00:00:00', -1, '2024-04-01 00:00:00', '2024-05-15 13:40:39');
INSERT INTO `shop_coupon` VALUES (4, '滿折優惠券 8折', 1, 400.00, 4, 1, 20.00, '0.8', 999995, 4, '使用App下單，滿$400享8折', '2024-04-01 00:00:00', '2024-08-31 00:00:00', -1, '2024-04-01 00:00:00', '2024-05-15 13:40:39');
INSERT INTO `shop_coupon` VALUES (5, '滿折優惠券 8折', 1, 100.00, 2, 1, 9.00, '0.8', 999999, 0, '使用App下單，滿$100享8折', '2024-04-01 00:00:00', '2024-08-31 00:00:00', -1, '2024-04-01 00:00:00', '2024-05-15 13:40:39');

-- ----------------------------
-- Table structure for shop_faq
-- ----------------------------
DROP TABLE IF EXISTS `shop_faq`;
CREATE TABLE `shop_faq`  (
  `faq_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '問答系統id',
  `faq_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '問答標題',
  `en_faq_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '問答標題(英)',
  `faq_result` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '問答答案',
  `en_faq_result` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '問答答案(英)',
  `faq_status` int(3) NULL DEFAULT 1 COMMENT '状态(1可用，0禁用,-1删除)',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`faq_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '常見問題' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of shop_faq
-- ----------------------------
INSERT INTO `shop_faq` VALUES (1, '網上訂購產品的價錢與店內產品是否相同？', 'Is the price of the product ordered online the same as the product in store?', '網上訂購產品均以港幣定價，與香港宜家家居門市價格一般相同，但部分推廣優惠只適用於門市購物。澳門門市的產品定價會隨當地貨幣匯率有所不同，並會以澳門幣顯示。', 'Products ordered online are priced in Hong Kong dollars, which are generally the same as IKEA store prices in Hong Kong, but some promotional offers are only applicable to store purchases. Pricing of products in Macau stores will vary according to the local currency exchange rate and will be displayed in Macau dollars.', 1, '2021-06-10 11:38:13', '2021-06-10 11:38:13');
INSERT INTO `shop_faq` VALUES (2, '你們有送貨及/或組裝服務嗎？', 'Do you have delivery and/or assembly services?', '我們可為你的訂單安排送貨服務，並只收取合理費用，部分指定傢俬產品更提供組裝服務。需時7 - 14日。你也可以選擇將貨品免費送至宜家家居港島東提貨中心自行提貨。', 'We can arrange delivery service for your order at a reasonable fee, and also provide assembly service for some selected furniture products. Takes 7-14 days. You can also choose to send your goods to IKEA Island East Pick-up Centre for free and pick them up yourself.', 1, '2021-06-10 11:38:13', '2021-06-10 11:38:13');
INSERT INTO `shop_faq` VALUES (3, '如運抵的貨品有瑕疵或損毀，應該怎麼辦？', 'What should I do if my goods arrive defective or damaged?', '在提貨中心領取貨品或貨品送到府上時，請仔細檢查貨品。如果你收到不完整，有破損或未有送達，請電郵至 enquiry@IKEA.com.hk 並提供以下資料，我們會於48小時內電郵或致電解答相關查詢。', 'Please check the goods carefully when picking them up at the pick-up centre or when they are delivered to your home. If you receive incomplete, damaged or not delivered, please email us at enquiry@IKEA.com.hk with the following information and we will answer your enquiry by email or phone within 48 hours.', 1, '2021-06-10 11:38:13', '2021-06-10 11:38:13');
INSERT INTO `shop_faq` VALUES (4, 'xxx', 'aaa', 'aaa', 'xxx', -1, '2024-07-09 16:48:12', NULL);

-- ----------------------------
-- Table structure for shop_getui
-- ----------------------------
DROP TABLE IF EXISTS `shop_getui`;
CREATE TABLE `shop_getui`  (
  `getui_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '个推id',
  `app_id` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'AppID',
  `app_key` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'AppKey',
  `app_secret` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'AppSecret',
  `master_secret` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'MasterSecret',
  `host` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'HOST',
  `getui_status` int(2) NOT NULL DEFAULT 1 COMMENT '1 可用 0禁用  -1删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`getui_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '个推表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of shop_getui
-- ----------------------------
INSERT INTO `shop_getui` VALUES (1, 'Gr7D7yjOo566eF5HIicBaA', 'yatjfH9gVJ8tzh0t9eRgJ9', 'fvyBYg1IeE6bimgWXDbfkA', 'a08D1ImvIV5xJLLsmha118', 'https://restapi.getui.com', 1, '2024-07-18 15:10:25', '2024-07-18 15:10:25');

-- ----------------------------
-- Table structure for shop_paypal
-- ----------------------------
DROP TABLE IF EXISTS `shop_paypal`;
CREATE TABLE `shop_paypal`  (
  `paypal_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'PayPal支付id',
  `client_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'PayPal支付账号',
  `paypal_secret` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'PayPal支付秘钥',
  `paypal_enable` int(2) NULL DEFAULT 0 COMMENT '是否启用  1是  0关闭 （只能一个启用，其他就得禁用）',
  `paypal_env` int(2) NOT NULL DEFAULT 2 COMMENT 'PayPal支付环境 1 live  2 sandbox',
  `paypal_status` int(11) NULL DEFAULT 1 COMMENT '状态(1可用，0禁用,-1删除)',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`paypal_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'PayPal支付设置' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of shop_paypal
-- ----------------------------
INSERT INTO `shop_paypal` VALUES (1, 'AbNhgz1rwU0mJn7s6M1UZCIhEgT1RT7DKbEAOAPXZ9B3bXeR_anOrH2AwyiACzJ9T8SJaGaSJzgNV3DX', 'ELB0CMbepT52OfMV3Ed7WuvgcJxTJj17Uj877mJRX_PnaMFjITq6nuSB0iwUsbKiPK8sIN6pfLIxJ_Wy', 1, 2, 1, '2023-08-02 15:54:30', '2024-07-12 15:25:46');

-- ----------------------------
-- Table structure for shop_service
-- ----------------------------
DROP TABLE IF EXISTS `shop_service`;
CREATE TABLE `shop_service`  (
  `service_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客服設置id',
  `service_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客服鏈接',
  `service_account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客服設置賬號',
  `service_status` int(11) NULL DEFAULT 1 COMMENT '状态(1可用，0禁用,-1删除)',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`service_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '聯繫我們' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of shop_service
-- ----------------------------
INSERT INTO `shop_service` VALUES (1, 'xxxxxxxxxxxxx', '85293749111', 1, '2024-05-16 15:57:26', '2024-05-16 15:57:26');

-- ----------------------------
-- Table structure for shop_setting
-- ----------------------------
DROP TABLE IF EXISTS `shop_setting`;
CREATE TABLE `shop_setting`  (
  `shop_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '店鋪設置id',
  `shop_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '店鋪名稱',
  `shop_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '店鋪地址',
  `shop_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '店鋪電話',
  `shop_mail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '店鋪郵箱',
  `shop_logo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '店鋪logo',
  `is_tips` int(2) NOT NULL DEFAULT 0 COMMENT '是否開啓低庫存提醒  0否 1是',
  `minStock` int(25) NULL DEFAULT 1 COMMENT '設置低庫存提醒',
  `recharge_min` int(25) NULL DEFAULT NULL COMMENT '充值最小金額',
  `recharge_max` int(25) NULL DEFAULT NULL COMMENT '充值最大金額',
  `is_freight` int(2) NOT NULL DEFAULT 0 COMMENT '是否设置运费  0否 1是',
  `freight_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '运费',
  `is_tostore` int(2) NOT NULL DEFAULT 0 COMMENT '是否開啓預約到店查看價格 0否 1是',
  `tostore_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '預約到店查看價格',
  `shop_status` int(2) NOT NULL DEFAULT 1 COMMENT '狀態1：正常 0：禁用-1：删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`shop_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '店鋪設置' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of shop_setting
-- ----------------------------
INSERT INTO `shop_setting` VALUES (1, 'new demo1', 'Flat/RM 1203, 12/F, 8 Jordan Road, KL, KL', '93749111', 'leeyin@2cmails.com', 'https://brain-storm.oss-cn-hongkong.aliyuncs.com/2023-10-31/1698741959268372.png', 1, 5, 1, 1000000, 1, 20.00, 1, 10.00, 1, '2024-05-16 15:57:26', '2024-05-16 15:57:26');

-- ----------------------------
-- Table structure for shop_stripe
-- ----------------------------
DROP TABLE IF EXISTS `shop_stripe`;
CREATE TABLE `shop_stripe`  (
  `stripe_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'STRIPE支付id',
  `stripe_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'STRIPE支付账号',
  `stripe_secret` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'STRIPE支付秘钥',
  `stripe_enable` int(2) NOT NULL DEFAULT 0 COMMENT '是否启用  1是  0关闭 （只能一个启用，其他就得禁用）',
  `stripe_env` int(2) NOT NULL DEFAULT 1 COMMENT '环境  1：live 2：sandbox',
  `stripe_status` int(11) NULL DEFAULT 1 COMMENT '状态(1可用，0禁用,-1删除)',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`stripe_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'PayPal支付设置' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of shop_stripe
-- ----------------------------
INSERT INTO `shop_stripe` VALUES (1, 'pk_test_51PYfDhExgXF0QlkuL5suxTSse4SNmst9Kcd3y44HxJ1X4xcvcJ1pzdInX5RlDrCSdLIsoseBvu3qALJ6laDkDOWA00WWuLGK3J', 'sk_test_51PYfDhExgXF0Qlkuf66EjL7FBqlmCEfCsobhJZ9h3Rl3lIFww4OsGAPIDE92z3wxdcnlSEJ34mvsrKGfDGDqo6YY00InbSB0oh', 1, 1, 1, '2023-08-02 15:54:30', '2024-10-28 16:23:05');

-- ----------------------------
-- Table structure for specs_key
-- ----------------------------
DROP TABLE IF EXISTS `specs_key`;
CREATE TABLE `specs_key`  (
  `specs_key_id` int(11) NOT NULL AUTO_INCREMENT,
  `specs_sort_id` int(11) NULL DEFAULT NULL COMMENT '規格分類id',
  `specs_key_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '規格名',
  `en_specs_key_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '規格名（英）',
  PRIMARY KEY (`specs_key_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '規格名表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of specs_key
-- ----------------------------
INSERT INTO `specs_key` VALUES (1, 1, '大小', 'size');
INSERT INTO `specs_key` VALUES (2, 1, '材質', 'texture');

-- ----------------------------
-- Table structure for specs_sort
-- ----------------------------
DROP TABLE IF EXISTS `specs_sort`;
CREATE TABLE `specs_sort`  (
  `specs_sort_id` int(11) NOT NULL AUTO_INCREMENT,
  `specs_sort_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '規格分類名',
  `en_specs_sort_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '規格分類名（英）',
  `status` int(11) NULL DEFAULT 1,
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`specs_sort_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '規格分類表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of specs_sort
-- ----------------------------
INSERT INTO `specs_sort` VALUES (1, '海報', 'poster', 1, NULL, NULL);

-- ----------------------------
-- Table structure for specs_value
-- ----------------------------
DROP TABLE IF EXISTS `specs_value`;
CREATE TABLE `specs_value`  (
  `specs_value_id` int(11) NOT NULL AUTO_INCREMENT,
  `specs_key_id` int(11) NULL DEFAULT NULL COMMENT '規格名id',
  `specs_value_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '規格值',
  `en_specs_value_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '規格值（英）',
  PRIMARY KEY (`specs_value_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '規格值表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of specs_value
-- ----------------------------
INSERT INTO `specs_value` VALUES (1, 1, '3*3米', '3*3M');
INSERT INTO `specs_value` VALUES (2, 1, '5*5米', '5*5M');
INSERT INTO `specs_value` VALUES (3, 1, '10*10米', '10*10M');
INSERT INTO `specs_value` VALUES (4, 2, 'PP紙', 'PP Paper');
INSERT INTO `specs_value` VALUES (5, 2, '無紡布', 'nonwovens');
INSERT INTO `specs_value` VALUES (6, 2, '絹絲佈', 'Spun silk cloth');

-- ----------------------------
-- Table structure for subscriptions
-- ----------------------------
DROP TABLE IF EXISTS `subscriptions`;
CREATE TABLE `subscriptions`  (
  `id` int(11) NOT NULL,
  `user_id` int(11) NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `stripe_id` int(11) NULL DEFAULT NULL,
  `stripe_plan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `quantity` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `trial_ends_at` datetime NULL DEFAULT NULL,
  `ends_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付訂閱(暫時沒用，考慮刪除)' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of subscriptions
-- ----------------------------

-- ----------------------------
-- Table structure for system_info
-- ----------------------------
DROP TABLE IF EXISTS `system_info`;
CREATE TABLE `system_info`  (
  `system_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '系統消息id',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用戶id',
  `system_type` int(11) NULL DEFAULT 1 COMMENT '消息類型  1产品  2预约 3系統消息',
  `system_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '系統消息內容',
  `en_system_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '系統消息內容(英文)',
  `is_read` int(11) NULL DEFAULT 1 COMMENT '是否已讀  1未讀  2已讀',
  `system_status` int(2) NOT NULL DEFAULT 1 COMMENT '1 可用 2禁用  -1删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`system_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系統消息' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of system_info
-- ----------------------------

-- ----------------------------
-- Table structure for user_address
-- ----------------------------
DROP TABLE IF EXISTS `user_address`;
CREATE TABLE `user_address`  (
  `address_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '收貨地址id',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用戶id',
  `address_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收貨姓名',
  `address_mail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收貨电邮',
  `address_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收貨電話',
  `address_area` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收貨地址区域',
  `address_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收貨地址',
  `address_default` int(2) NOT NULL DEFAULT 0 COMMENT '是否為預設地址 1是 0不是',
  `address_status` int(2) NOT NULL DEFAULT 1 COMMENT '狀態1：正常 2：禁用-1：删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`address_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '收貨地址表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of user_address
-- ----------------------------

-- ----------------------------
-- Table structure for user_cart
-- ----------------------------
DROP TABLE IF EXISTS `user_cart`;
CREATE TABLE `user_cart`  (
  `cart_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '購物車id',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `product_id` int(11) NULL DEFAULT NULL COMMENT '商品id',
  `product_relation_id` int(11) NULL DEFAULT NULL COMMENT '產品規格組合id',
  `cart_num` int(11) NULL DEFAULT NULL COMMENT '数量',
  `cart_status` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '-1刪除 1可用',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`cart_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '購物車' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of user_cart
-- ----------------------------

-- ----------------------------
-- Table structure for user_collect
-- ----------------------------
DROP TABLE IF EXISTS `user_collect`;
CREATE TABLE `user_collect`  (
  `collect_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '收藏id',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用戶id',
  `product_id` int(11) NULL DEFAULT NULL COMMENT '商品id',
  `collect_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '收藏類型（1產品  2服务）',
  `collect_status` int(2) NULL DEFAULT 1 COMMENT '状态(1可用，2禁用，-1删除)',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`collect_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '收藏表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of user_collect
-- ----------------------------

-- ----------------------------
-- Table structure for user_comment
-- ----------------------------
DROP TABLE IF EXISTS `user_comment`;
CREATE TABLE `user_comment`  (
  `comment_id` int(12) NOT NULL AUTO_INCREMENT COMMENT '評論id',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用戶id',
  `product_id` int(11) NULL DEFAULT NULL COMMENT '商品id',
  `details_id` int(11) NULL DEFAULT NULL COMMENT '訂單詳情id',
  `comment_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '評論圖片',
  `comment_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '評論內容',
  `comment_score` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '評論評分',
  `status` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '状态(1可用，2禁用，-1删除)',
  `created_at` datetime NULL DEFAULT NULL COMMENT '創建時間',
  `updated_at` datetime NULL DEFAULT NULL COMMENT '修改時間',
  PRIMARY KEY (`comment_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '品論表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of user_comment
-- ----------------------------
INSERT INTO `user_comment` VALUES (1, 9, 9, 10, '', 'good', '5', '1', '2024-05-15 13:49:16', '2024-05-15 13:49:16');

-- ----------------------------
-- Table structure for user_exchange
-- ----------------------------
DROP TABLE IF EXISTS `user_exchange`;
CREATE TABLE `user_exchange`  (
  `exchange_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用戶使用優惠券ID',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用戶id',
  `coupon_id` int(11) NULL DEFAULT NULL COMMENT '優惠券id',
  `exchange_status` int(3) NULL DEFAULT 0 COMMENT '状态(1：可使用，2：已使用，-1删除)',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`exchange_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶使用優惠券' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of user_exchange
-- ----------------------------

-- ----------------------------
-- Table structure for user_integral_record
-- ----------------------------
DROP TABLE IF EXISTS `user_integral_record`;
CREATE TABLE `user_integral_record`  (
  `integral_id` int(12) NOT NULL AUTO_INCREMENT COMMENT '用戶積分明細id',
  `user_id` int(12) NULL DEFAULT NULL COMMENT '用戶id',
  `integral_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' 1：增加2：减少',
  `integral_explain` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '说明',
  `en_integral_explain` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '说明（英文）',
  `integral_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '积分数',
  `integral_status` int(2) NOT NULL DEFAULT 1 COMMENT '1：正常  2：禁用  -1：删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`integral_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶積分明細' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of user_integral_record
-- ----------------------------

-- ----------------------------
-- Table structure for user_log
-- ----------------------------
DROP TABLE IF EXISTS `user_log`;
CREATE TABLE `user_log`  (
  `login_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登錄用戶id',
  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登錄管用戶姓名',
  `login_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录IP',
  `login_nation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登錄國家',
  `login_region` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地區',
  `login_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '城市',
  `login_lng` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登錄經度',
  `login_lat` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登錄緯度',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`login_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶登陆日志' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of user_log
-- ----------------------------

-- ----------------------------
-- Table structure for user_member
-- ----------------------------
DROP TABLE IF EXISTS `user_member`;
CREATE TABLE `user_member`  (
  `member_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '會員等級id',
  `member_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '等级显示名称',
  `en_member_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '等级显示名称(英文)',
  `member_start` int(11) NULL DEFAULT NULL COMMENT '范围开始',
  `member_end` int(11) NULL DEFAULT NULL COMMENT '范围结束',
  `member_status` int(2) NOT NULL DEFAULT 1 COMMENT '1：正常  2：禁用  -1：删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`member_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '會員等級' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of user_member
-- ----------------------------
INSERT INTO `user_member` VALUES (1, '普通', 'Member', 0, 1000, 1, '2024-05-16 15:57:26', '2024-05-16 15:57:26');
INSERT INTO `user_member` VALUES (2, '青銅', 'Bronze', 1001, 5000, 1, '2024-05-16 15:57:26', '2024-05-16 15:57:26');
INSERT INTO `user_member` VALUES (3, '白銀', 'Silver', 5001, 20000, 1, '2024-05-16 15:57:26', '2024-05-16 15:57:26');
INSERT INTO `user_member` VALUES (4, '黃金', 'Gold', 20001, 99999, 1, '2024-05-16 15:57:26', '2024-05-16 15:57:26');
INSERT INTO `user_member` VALUES (5, '鑽石', 'Diamond', 100000, 200000, 1, '2024-05-16 15:57:26', '2024-05-16 15:57:26');
INSERT INTO `user_member` VALUES (6, '至臻', 'Platinum', 200001, 1000000, 1, '2024-05-30 10:39:54', '2024-05-30 10:39:54');

-- ----------------------------
-- Table structure for user_message
-- ----------------------------
DROP TABLE IF EXISTS `user_message`;
CREATE TABLE `user_message`  (
  `message_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `message_content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '留言内容',
  `message_status` int(11) NOT NULL DEFAULT 1 COMMENT '1：正常-1：删除',
  `created_at` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`message_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户留言表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of user_message
-- ----------------------------

-- ----------------------------
-- Table structure for user_reservation
-- ----------------------------
DROP TABLE IF EXISTS `user_reservation`;
CREATE TABLE `user_reservation`  (
  `user_reservation_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用戶項目票據id',
  `reservation_project_id` int(11) NULL DEFAULT NULL COMMENT '项目id',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `user_ref` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户编号',
  `user_numerical` int(11) NULL DEFAULT NULL COMMENT '用戶序號',
  `user_status` int(11) NULL DEFAULT 1 COMMENT '1：排队中2：已签到3：已取消 4：超时',
  `user_date` date NULL DEFAULT NULL COMMENT '排队日期',
  `user_reservation_status` int(11) NULL DEFAULT 1 COMMENT '1：正常-1：删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  `reservation_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '票据二维码',
  PRIMARY KEY (`user_reservation_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户排号表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of user_reservation
-- ----------------------------

-- ----------------------------
-- Table structure for user_wallet_record
-- ----------------------------
DROP TABLE IF EXISTS `user_wallet_record`;
CREATE TABLE `user_wallet_record`  (
  `wallet_id` int(12) NOT NULL AUTO_INCREMENT COMMENT '用戶錢包明細id',
  `user_id` int(12) NULL DEFAULT NULL COMMENT '用户id',
  `wallet_type` int(2) NULL DEFAULT NULL COMMENT '1：购买  2：充值 3：提现',
  `payment_mode` int(2) NOT NULL DEFAULT 1 COMMENT '支付方式 1：paypal  2：Stripe，3：錢包 ，4：其他支付（上傳支付圖片）',
  `wallet_explain` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '錢包说明',
  `en_wallet_explain` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '錢包说明(英文)',
  `wallet_money` decimal(10, 2) NOT NULL COMMENT '錢包金额',
  `wallet_status` int(2) NOT NULL DEFAULT 1 COMMENT '1：正常  2：禁用  -1：删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`wallet_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶錢包明細' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of user_wallet_record
-- ----------------------------

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `user_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `user_number` varchar(22) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用户會員卡號(*)',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用戶姓名',
  `user_email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用戶邮箱',
  `user_password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用戶密码',
  `area_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '86' COMMENT '用户電話區號',
  `user_phone` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用戶手机号',
  `user_integral` int(10) NOT NULL DEFAULT 0 COMMENT '现有可用積分',
  `user_integral_all` int(10) NOT NULL DEFAULT 0 COMMENT '用户總積分',
  `user_avatar` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '用戶头像',
  `user_sex` int(2) NOT NULL DEFAULT 1 COMMENT '用户性别  1男  0女',
  `user_profession` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用戶职业',
  `user_autograph` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用戶个性签名',
  `user_birthday` datetime NULL DEFAULT NULL COMMENT '用户生日',
  `user_balance` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '用戶余额',
  `open_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用户第三方登錄的open_id',
  `client_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用户推送的id',
  `login_type` int(2) NOT NULL DEFAULT 1 COMMENT '登錄類型  1賬號密碼  2蘋果登錄  3谷歌',
  `token_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用户手机系统',
  `user_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用戶二維碼',
  `user_card` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用戶名片',
  `user_status` int(2) NULL DEFAULT 1 COMMENT '1 可用 0禁用  -1删除',
  `login_time` int(5) NOT NULL DEFAULT 0 COMMENT '用户登錄次數',
  `created_at` datetime NULL DEFAULT NULL COMMENT '用户创建时间',
  `updated_at` datetime NULL DEFAULT NULL COMMENT '用户更新时间',
  `finally_at` datetime NULL DEFAULT NULL COMMENT '用户最後登錄時間',
  `stripe_id` varchar(110) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'stripe支付订阅ID',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 100002 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, '1720167372277569', '線下會員', 'leeyin@2cmails.com', '$2y$10$AjVv3cPIybRlQjGjItvXa.KRBI9pQLW72D3Ovu0BNk9N2XVvb8p9u', '852', '93749111', 0, 0, 'https://brain-storm.oss-cn-hongkong.aliyuncs.com/2023-10-31/1698741959268372.png', 1, NULL, NULL, NULL, 0.00, NULL, NULL, 0, NULL, NULL, NULL, 1, 0, '2024-07-05 16:16:12', '2024-08-27 11:01:28', '2024-07-05 16:16:12', '');
INSERT INTO `users` VALUES (100001, '1724814798401016', 'sasori', 'sasori@gmail.com', '$2y$10$/lxhuidxtemMM/I/N101l.y4YdUvDf0ciUN670NGaKbiUTCR1CKAq', '852', '91234567', 1000, 0, 'https://brain-storm.oss-cn-hongkong.aliyuncs.com/2021-04-23/1619147964.jpg', 1, NULL, NULL, NULL, 20000.00, NULL, NULL, 1, 'ios', NULL, NULL, 1, 1, '2024-08-28 11:13:18', '2024-08-28 11:13:26', '2024-08-28 11:13:26', NULL);

-- ----------------------------
-- Table structure for wastage_record
-- ----------------------------
DROP TABLE IF EXISTS `wastage_record`;
CREATE TABLE `wastage_record`  (
  `wastage_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '損耗記錄id',
  `admin_id` int(11) NULL DEFAULT NULL COMMENT '管理員id',
  `product_id` int(11) NULL DEFAULT NULL COMMENT '產品id',
  `product_relation_id` int(11) NULL DEFAULT NULL COMMENT '產品規格組合id',
  `product_specs` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '產品規格',
  `wastage_number` int(11) NULL DEFAULT NULL COMMENT '損耗數量',
  `wastage_remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '損耗備註',
  `wastage_status` int(11) NOT NULL DEFAULT 1 COMMENT '1：正常  2：禁用  -1：删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`wastage_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '損耗記錄' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of wastage_record
-- ----------------------------

-- ----------------------------
-- Table structure for week_workday
-- ----------------------------
DROP TABLE IF EXISTS `week_workday`;
CREATE TABLE `week_workday`  (
  `weekday_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '星期id',
  `start_time` time NULL DEFAULT NULL COMMENT '開店時間',
  `end_time` time NULL DEFAULT NULL COMMENT '閉店時間',
  `weekday` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '星期0:一,1:二,2:三類推',
  `is_open` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否營業0:否 1:是',
  `weekday_status` int(2) NOT NULL DEFAULT 1 COMMENT '1 可用 2禁用  -1删除',
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`weekday_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of week_workday
-- ----------------------------
INSERT INTO `week_workday` VALUES (1, '08:00:00', '18:00:00', '0', '1', 1, '2024-05-30 17:14:20', '2024-08-27 11:01:28');
INSERT INTO `week_workday` VALUES (2, '08:00:00', '18:00:00', '1', '1', 1, '2024-05-30 17:14:20', '2024-08-27 11:01:28');
INSERT INTO `week_workday` VALUES (3, '08:00:00', '18:00:00', '2', '1', 1, '2024-05-30 17:14:20', '2024-08-27 11:01:28');
INSERT INTO `week_workday` VALUES (4, '08:00:00', '18:00:00', '3', '1', 1, '2024-05-30 17:14:20', '2024-08-27 11:01:28');
INSERT INTO `week_workday` VALUES (5, '09:00:00', '17:00:00', '4', '1', 1, '2024-05-30 17:14:20', '2024-08-27 11:01:28');
INSERT INTO `week_workday` VALUES (6, '08:00:00', '18:00:00', '5', '0', 1, '2024-05-30 17:14:20', '2024-08-27 11:01:28');
INSERT INTO `week_workday` VALUES (7, '08:00:00', '18:00:00', '6', '0', 1, '2024-05-30 17:14:20', '2024-08-27 11:01:28');

SET FOREIGN_KEY_CHECKS = 1;