53 lines
3.0 KiB
SQL
53 lines
3.0 KiB
SQL
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : Qi
|
|
Source Server Type : MySQL
|
|
Source Server Version : 80041
|
|
Source Host : localhost:3306
|
|
Source Schema : oroqen
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 80041
|
|
File Encoding : 65001
|
|
|
|
Date: 19/08/2025 19:39:12
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for oroqen_order
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `oroqen_order`;
|
|
CREATE TABLE `oroqen_order` (
|
|
`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键ID',
|
|
`create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
|
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建日期',
|
|
`update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
|
|
`update_time` datetime NULL DEFAULT NULL COMMENT '更新日期',
|
|
`order_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单号',
|
|
`user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID',
|
|
`total_amount` decimal(10, 2) NOT NULL COMMENT '订单总金额',
|
|
`discount_amount` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '优惠金额',
|
|
`actual_amount` decimal(10, 2) NOT NULL COMMENT '实付金额',
|
|
`order_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'PENDING' COMMENT '订单状态(PENDING:待付款,PAID:已付款,SHIPPED:已发货,DELIVERED:已送达,CANCELLED:已取消)',
|
|
`payment_method` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付方式(WECHAT:微信,ALIPAY:支付宝)',
|
|
`payment_time` datetime NULL DEFAULT NULL COMMENT '支付时间',
|
|
`ship_time` datetime NULL DEFAULT NULL COMMENT '发货时间',
|
|
`delivery_time` datetime NULL DEFAULT NULL COMMENT '送达时间',
|
|
`receiver_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收货人姓名',
|
|
`receiver_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收货人电话',
|
|
`receiver_address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收货地址',
|
|
`logistics_company` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物流公司',
|
|
`tracking_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物流单号',
|
|
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE INDEX `uk_order_no`(`order_no` ASC) USING BTREE,
|
|
INDEX `idx_user_id`(`user_id` ASC) USING BTREE,
|
|
INDEX `idx_order_status`(`order_status` ASC) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|