/*
 Navicat Premium Data Transfer

 Source Server         : 966120
 Source Server Type    : MySQL
 Source Server Version : 50521 (5.5.21)
 Source Host           : 120.25.98.119:3307
 Source Schema         : ruoyi

 Target Server Type    : MySQL
 Target Server Version : 50521 (5.5.21)
 File Encoding         : 65001

 Date: 01/05/2025 11:46:45
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_orders
-- ----------------------------
DROP TABLE IF EXISTS `tb_orders`;
CREATE TABLE `tb_orders`  (
  `OrderID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '广交的订单 ID，系统唯一创建订单',
  `LinkPerson` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '联系人',
  `LinkTel` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '联系电话',
  `AlarmTel` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '受理电话,来电电话',
  `PatientName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '患者姓名',
  `Sex` int(1) NULL DEFAULT NULL COMMENT '患者性别',
  `Age` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '患者年龄',
  `Kg` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '患者体重',
  `Sense` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '患者有无意识',
  `LocalAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '现场地址',
  `LocalLongitude` double NULL DEFAULT NULL COMMENT '现场地址经度（目前是 gcj02 坐标系）',
  `LocalLatitude` double NULL DEFAULT NULL COMMENT '现场地址纬度',
  `LocalProvince` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '现场所在省',
  `LocalCity` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '现场所在城市',
  `LocalDistrict` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '现场所在区',
  `SendAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '送往地址',
  `SendLongitude` double NULL DEFAULT NULL COMMENT '送往经度',
  `SendLatitude` double NULL DEFAULT NULL COMMENT '送往纬度',
  `SendProvince` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '送往所在省',
  `SendCity` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '送往所在城市',
  `SendDistrict` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '送往所在区',
  `BookingPrice` decimal(10, 2) NULL DEFAULT NULL COMMENT '预估金额',
  `BookingDate` datetime NULL DEFAULT NULL COMMENT '预约时间（时间类型，精确到小时）',
  `Remark` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '备注',
  `Complaint` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '病人情况',
  `PatientCount` int(11) NULL DEFAULT NULL COMMENT '人数',
  `BookingKM` double NULL DEFAULT NULL COMMENT '预估预约公里',
  `EscortCode` int(11) NULL DEFAULT NULL COMMENT '普通护送，监护护送（可按照第三方的字典新增或赋值）',
  `LiftingCode` int(11) NULL DEFAULT NULL COMMENT '步梯或电梯',
  `LiftingFloor` int(11) NULL DEFAULT NULL COMMENT '楼层',
  `RequirementCode` int(11) NULL DEFAULT NULL COMMENT '监护，重症(可按照第三方的字典新增或赋值)',
  `TypeCode` int(11) NULL DEFAULT NULL COMMENT '转运类型（市内，市外，省外等，可按照第三方的字典新增或赋值）',
  `ThirdPartyResult` int(1) NULL DEFAULT NULL COMMENT '第三方调用接口返回结果,1-成功，2-失败',
  `ServiceOrdID` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '第三方服务ID',
  `ServiceOrdNo` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '第三方服务单号',
  `CreateTime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `UpdateTime` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`OrderID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = COMPACT;

SET FOREIGN_KEY_CHECKS = 1;
