43 lines
3.6 KiB
SQL
43 lines
3.6 KiB
SQL
CREATE TABLE IF NOT EXISTS `blade_voucher_manage` (
|
|
`id` bigint NOT NULL,
|
|
`tenant_id` varchar(12) NOT NULL DEFAULT '000000',
|
|
`project_id` bigint NOT NULL COMMENT '项目ID',
|
|
`project_name` varchar(200) NOT NULL COMMENT '项目名称',
|
|
`voucher_batch_no` varchar(30) NOT NULL COMMENT '凭证批次号',
|
|
`waybill_batch_no` varchar(1000) DEFAULT NULL COMMENT '关联运单批次号',
|
|
`file_name` varchar(100) NOT NULL COMMENT '凭证压缩包文件名',
|
|
`file_url` varchar(1000) NOT NULL COMMENT '凭证压缩包地址',
|
|
`file_task_id` bigint DEFAULT NULL COMMENT '分片上传任务ID',
|
|
`upload_source` varchar(20) NOT NULL DEFAULT '内部' COMMENT '上传来源：内部、承运商',
|
|
`carrier_name` varchar(50) DEFAULT NULL COMMENT '承运商名称',
|
|
`process_status` varchar(20) NOT NULL DEFAULT '上传中' COMMENT '上传中、处理中、处理完成',
|
|
`voucher_count` int NOT NULL DEFAULT 0 COMMENT '凭证数量',
|
|
`related_waybill_count` int NOT NULL DEFAULT 0 COMMENT '已关联运单数',
|
|
`un_related_waybill_count` int NOT NULL DEFAULT 0 COMMENT '未关联运单数',
|
|
`audit_status` varchar(20) NOT NULL DEFAULT '-' COMMENT '待审核、审核通过、审核驳回',
|
|
`create_user` bigint DEFAULT NULL, `create_dept` bigint DEFAULT NULL,
|
|
`create_time` datetime DEFAULT NULL, `update_user` bigint DEFAULT NULL, `update_time` datetime DEFAULT NULL,
|
|
`status` tinyint NOT NULL DEFAULT 1, `is_deleted` tinyint NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`), UNIQUE KEY `uk_voucher_manage_no` (`tenant_id`, `voucher_batch_no`),
|
|
KEY `idx_voucher_manage_create_time` (`create_time`), KEY `idx_voucher_manage_process_status` (`process_status`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='凭证管理';
|
|
|
|
CREATE TABLE IF NOT EXISTS `blade_voucher_waybill_batch` (
|
|
`id` bigint NOT NULL, `tenant_id` varchar(12) NOT NULL DEFAULT '000000',
|
|
`voucher_id` bigint NOT NULL COMMENT '凭证批次ID', `waybill_import_batch_id` bigint NOT NULL COMMENT '运单导入批次ID',
|
|
`waybill_batch_no` varchar(64) NOT NULL COMMENT '运单批次号', `waybill_count` int NOT NULL DEFAULT 0 COMMENT '运单数',
|
|
`create_user` bigint DEFAULT NULL, `create_dept` bigint DEFAULT NULL, `create_time` datetime DEFAULT NULL,
|
|
`update_user` bigint DEFAULT NULL, `update_time` datetime DEFAULT NULL, `status` tinyint NOT NULL DEFAULT 1, `is_deleted` tinyint NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`), UNIQUE KEY `uk_voucher_waybill_batch` (`voucher_id`, `waybill_import_batch_id`),
|
|
KEY `idx_voucher_waybill_batch_voucher` (`voucher_id`), KEY `idx_voucher_waybill_batch_waybill` (`waybill_import_batch_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='凭证关联运单批次';
|
|
|
|
INSERT INTO `blade_menu` (`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`, `component`, `remark`, `is_deleted`)
|
|
VALUES
|
|
(2090000000000000900, 2090000000000000000, 'voucher_manage', '凭证管理', 'voucher_manage', '/business/voucher-manage', 'iconfont icon-caidanguanli', 90, 1, 0, 1, NULL, '', 0),
|
|
(2090000000000000901, 2090000000000000900, 'voucher_manage_view', '查看', 'voucher_manage_view', '', '', 1, 2, 0, 1, NULL, '', 0),
|
|
(2090000000000000902, 2090000000000000900, 'voucher_manage_add', '批量导入凭证', 'voucher_manage_add', '', '', 2, 2, 0, 1, NULL, '', 0),
|
|
(2090000000000000903, 2090000000000000900, 'voucher_manage_edit', '更换运单批次', 'voucher_manage_edit', '', '', 3, 2, 0, 1, NULL, '', 0),
|
|
(2090000000000000904, 2090000000000000900, 'voucher_manage_delete', '删除', 'voucher_manage_delete', '', '', 4, 2, 0, 1, NULL, '', 0)
|
|
ON DUPLICATE KEY UPDATE `name` = VALUES(`name`), `path` = VALUES(`path`), `is_deleted` = 0;
|