/*
|
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;
|
