khyznh/script/sql/multi_site_path.sql

-- 多站点路线表
CREATE TABLE `tbl_dzbc_multi_site_path` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `name` varchar(100) NOT NULL COMMENT '路线名称',
  `status` int DEFAULT '0' COMMENT '状态 0-禁用 1-启用',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `ext1` varchar(255) DEFAULT NULL COMMENT '扩展1',
  `ext2` varchar(255) DEFAULT NULL COMMENT '扩展2',
  `create_dept` bigint DEFAULT NULL,
  `create_by` bigint DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` bigint DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='多站点路线表';

-- 路线站点关联表
CREATE TABLE `tbl_dzbc_path_site` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `path_id` bigint NOT NULL COMMENT '路线ID',
  `site_id` bigint NOT NULL COMMENT '站点ID',
  `site_order` int NOT NULL COMMENT '站点顺序',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `ext1` varchar(255) DEFAULT NULL COMMENT '扩展1',
  `ext2` varchar(255) DEFAULT NULL COMMENT '扩展2',
  `create_dept` bigint DEFAULT NULL,
  `create_by` bigint DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` bigint DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_path_id` (`path_id`),
  KEY `idx_site_id` (`site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='路线站点关联表';

-- 站点价格表
CREATE TABLE `tbl_dzbc_site_price` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `path_id` bigint NOT NULL COMMENT '路线ID',
  `from_site_id` bigint NOT NULL COMMENT '出发站点ID',
  `to_site_id` bigint NOT NULL COMMENT '到达站点ID',
  `price` int NOT NULL COMMENT '价格（分）',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `ext1` varchar(255) DEFAULT NULL COMMENT '扩展1',
  `ext2` varchar(255) DEFAULT NULL COMMENT '扩展2',
  `create_dept` bigint DEFAULT NULL,
  `create_by` bigint DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` bigint DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_path_site` (`path_id`, `from_site_id`, `to_site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='站点价格表';