67 lines
4.3 KiB
SQL
67 lines
4.3 KiB
SQL
-- 风险处置模块初始化脚本
|
|
-- 父菜单：在途管理
|
|
|
|
INSERT INTO `blade_menu` (
|
|
`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`,
|
|
`remark`, `tenant_id`, `create_user`, `create_dept`, `create_time`, `update_user`, `update_time`, `status`,
|
|
`is_deleted`
|
|
) VALUES (
|
|
'1710000000000000001', 0, 'transit_manage', '在途管理', 'transit_manage', '/transit', 'el-icon-truck',
|
|
20, 1, 1, 1, '在途管理父菜单', '000000', 1, 1, NOW(), 1, NOW(), 1, 0
|
|
);
|
|
|
|
INSERT INTO `blade_menu` (
|
|
`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`,
|
|
`remark`, `tenant_id`, `create_user`, `create_dept`, `create_time`, `update_user`, `update_time`, `status`,
|
|
`is_deleted`
|
|
) VALUES (
|
|
'1710000000000000002', '1710000000000000001', 'risk_disposal', '风险处置', 'risk_disposal',
|
|
'/transit/risk-disposal', 'el-icon-warning-outline', 20, 1, 1, 1, '风险处置页面',
|
|
'000000', 1, 1, NOW(), 1, NOW(), 1, 0
|
|
);
|
|
|
|
INSERT INTO `blade_menu` (
|
|
`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`,
|
|
`remark`, `tenant_id`, `create_user`, `create_dept`, `create_time`, `update_user`, `update_time`, `status`,
|
|
`is_deleted`
|
|
) VALUES
|
|
('1710000000000000003', '1710000000000000002', 'risk_disposal_query', '查询', 'risk_disposal_query', '', '', 10, 2, 1, 1, '风险处置查询权限', '000000', 1, 1, NOW(), 1, NOW(), 1, 0),
|
|
('1710000000000000004', '1710000000000000002', 'risk_disposal_process', '处理', 'risk_disposal_process', '', '', 20, 2, 1, 1, '风险处置处理权限', '000000', 1, 1, NOW(), 1, NOW(), 1, 0),
|
|
('1710000000000000005', '1710000000000000002', 'risk_disposal_ignore', '忽略', 'risk_disposal_ignore', '', '', 30, 2, 1, 1, '风险处置忽略权限', '000000', 1, 1, NOW(), 1, NOW(), 1, 0),
|
|
('1710000000000000006', '1710000000000000002', 'risk_disposal_batch_process', '批量处理', 'risk_disposal_batch_process', '', '', 40, 2, 1, 1, '风险处置批量处理权限', '000000', 1, 1, NOW(), 1, NOW(), 1, 0),
|
|
('1710000000000000007', '1710000000000000002', 'risk_disposal_batch_ignore', '批量忽略', 'risk_disposal_batch_ignore', '', '', 50, 2, 1, 1, '风险处置批量忽略权限', '000000', 1, 1, NOW(), 1, NOW(), 1, 0),
|
|
('1710000000000000008', '1710000000000000002', 'risk_disposal_view', '查看', 'risk_disposal_view', '', '', 60, 2, 1, 1, '风险处置查看权限', '000000', 1, 1, NOW(), 1, NOW(), 1, 0);
|
|
|
|
CREATE TABLE IF NOT EXISTS `tms_risk_disposal` (
|
|
`id` bigint NOT NULL COMMENT '主键',
|
|
`tenant_id` varchar(12) DEFAULT '000000' COMMENT '租户ID',
|
|
`risk_no` varchar(30) NOT NULL COMMENT '风险编号',
|
|
`rule_name` varchar(50) NOT NULL COMMENT '规则名称',
|
|
`waybill_id` bigint DEFAULT NULL COMMENT '运单ID',
|
|
`waybill_no` varchar(30) DEFAULT NULL COMMENT '运单号',
|
|
`project_id` bigint DEFAULT NULL COMMENT '项目ID',
|
|
`project_name` varchar(50) DEFAULT NULL COMMENT '项目名称',
|
|
`risk_level` varchar(20) NOT NULL COMMENT '风险等级：low/medium/high',
|
|
`transport_type` varchar(20) DEFAULT NULL COMMENT '运输类型',
|
|
`risk_description` varchar(500) DEFAULT NULL COMMENT '风险描述',
|
|
`trigger_time` datetime DEFAULT NULL COMMENT '触发时间',
|
|
`disposal_status` varchar(20) NOT NULL DEFAULT 'pending' COMMENT '处理状态：pending/processed/ignored',
|
|
`disposal_method` varchar(20) DEFAULT NULL COMMENT '处理方式：process/ignore',
|
|
`disposal_remark` varchar(500) DEFAULT NULL COMMENT '处置说明',
|
|
`dispose_user` bigint DEFAULT NULL COMMENT '处置人',
|
|
`dispose_user_name` varchar(50) DEFAULT NULL COMMENT '处置人名称',
|
|
`dispose_time` datetime DEFAULT NULL COMMENT '处置时间',
|
|
`create_user` bigint DEFAULT NULL COMMENT '创建人',
|
|
`create_dept` bigint DEFAULT NULL COMMENT '创建部门',
|
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
|
`update_user` bigint DEFAULT NULL COMMENT '更新人',
|
|
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
|
`status` int DEFAULT 1 COMMENT '状态',
|
|
`is_deleted` int DEFAULT 0 COMMENT '是否已删除',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `uk_tms_risk_disposal_no` (`risk_no`),
|
|
KEY `idx_tms_risk_disposal_status` (`disposal_status`),
|
|
KEY `idx_tms_risk_disposal_level` (`risk_level`),
|
|
KEY `idx_tms_risk_disposal_waybill` (`waybill_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='风险处置';
|