dibang-xiaoshou/dibang-test.sql

/*
 Navicat Premium Dump SQL

 Source Server         : 121.43.228.102 hn02le.34lkdLKD
 Source Server Type    : MySQL
 Source Server Version : 50736 (5.7.36)
 Source Host           : 121.43.228.102:3306
 Source Schema         : dibang-test

 Target Server Type    : MySQL
 Target Server Version : 50736 (5.7.36)
 File Encoding         : 65001

 Date: 06/03/2026 18:37:13
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cargos
-- ----------------------------
DROP TABLE IF EXISTS `cargos`;
CREATE TABLE `cargos` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '货物名称',
  `remarks` text COLLATE utf8mb4_unicode_ci COMMENT '备注',
  `is_deleted` int(11) DEFAULT '0' COMMENT '是否删除(0=否,1=是)',
  `created_at` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `idx_name` (`name`),
  KEY `idx_cargo_is_deleted` (`is_deleted`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='货物名称表';

-- ----------------------------
-- Table structure for companies
-- ----------------------------
DROP TABLE IF EXISTS `companies`;
CREATE TABLE `companies` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '公司名称',
  `remarks` text COLLATE utf8mb4_unicode_ci COMMENT '备注',
  `is_deleted` int(11) DEFAULT '0' COMMENT '是否删除(0=否,1=是)',
  `created_at` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `idx_name` (`name`),
  KEY `idx_company_is_deleted` (`is_deleted`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='公司名称表';

-- ----------------------------
-- Table structure for inbound_outbound
-- ----------------------------
DROP TABLE IF EXISTS `inbound_outbound`;
CREATE TABLE `inbound_outbound` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '日期',
  `partner_company` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '往来单位',
  `business_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '业务类型（入库/出库）',
  `product` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '产品',
  `quantity` double NOT NULL COMMENT '本次量（t）',
  `plan_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '计划号（关联计划）',
  `batch_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '批次号',
  `vehicle_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '车牌号',
  `status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '状态（待入库/待出库，已入库/已出库）',
  `remarks` text COLLATE utf8mb4_unicode_ci COMMENT '备注',
  `purchase_plan_id` int(11) DEFAULT NULL COMMENT '关联的计划ID',
  `is_deleted` int(11) DEFAULT '0' COMMENT '是否删除(0=否,1=是)',
  `created_at` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_plan_no` (`plan_no`),
  KEY `idx_purchase_plan_id` (`purchase_plan_id`),
  KEY `idx_date` (`date`),
  KEY `idx_is_deleted` (`is_deleted`),
  KEY `idx_status` (`status`),
  KEY `idx_vehicle_no` (`vehicle_no`)
) ENGINE=InnoDB AUTO_INCREMENT=1095 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='出入库单表';

-- ----------------------------
-- Table structure for operation_logs
-- ----------------------------
DROP TABLE IF EXISTS `operation_logs`;
CREATE TABLE `operation_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `operation_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `resource_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `resource_id` int(11) DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ix_operation_logs_operation_type` (`operation_type`),
  KEY `ix_operation_logs_resource_type` (`resource_type`),
  KEY `ix_operation_logs_user_id` (`user_id`),
  KEY `ix_operation_logs_created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for purchase_plans
-- ----------------------------
DROP TABLE IF EXISTS `purchase_plans`;
CREATE TABLE `purchase_plans` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `plan_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '计划号（自动生成，格式：SX-YYYYMMDDMMHHSS001）',
  `plan_date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '计划日期（兼容字段）',
  `start_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '开始时间',
  `end_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '结束时间',
  `business_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '业务类型（入库/出库）',
  `product` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '产品名称',
  `specification` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '规格',
  `planned_quantity` double NOT NULL COMMENT '计划数量（t）',
  `vehicle_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `customer_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '往来单位',
  `remarks` text COLLATE utf8mb4_unicode_ci COMMENT '备注',
  `is_deleted` int(11) DEFAULT '0' COMMENT '是否删除(0=否,1=是)',
  `execution_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '执行状态（待入库/待出库，已入库/已出库）',
  `executed_at` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '执行时间',
  `last_weighing_slip_id` int(11) DEFAULT NULL COMMENT '最后关联的地磅单ID',
  `executed_quantity` double DEFAULT '0' COMMENT '已执行量（kg）',
  `created_at` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_plan_no` (`plan_no`),
  KEY `idx_plan_date` (`plan_date`),
  KEY `idx_start_date` (`start_date`),
  KEY `idx_end_date` (`end_date`),
  KEY `idx_business_type` (`business_type`),
  KEY `idx_product` (`product`),
  KEY `idx_is_deleted` (`is_deleted`),
  KEY `idx_execution_status` (`execution_status`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='计划表';

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `role` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user' COMMENT '角色（admin/user）',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `username` (`username`) USING BTREE,
  KEY `idx_username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户表';

-- ----------------------------
-- Table structure for vehicles
-- ----------------------------
DROP TABLE IF EXISTS `vehicles`;
CREATE TABLE `vehicles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `vehicle_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `is_deleted` int(11) NOT NULL DEFAULT '0',
  `created_at` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `uq_vehicles_vehicle_no` (`vehicle_no`),
  KEY `ix_vehicles_vehicle_no` (`vehicle_no`),
  KEY `ix_vehicles_is_deleted` (`is_deleted`)
) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for weighing_slips
-- ----------------------------
DROP TABLE IF EXISTS `weighing_slips`;
CREATE TABLE `weighing_slips` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `vehicle_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '车号',
  `plan_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '计划单号',
  `cargo_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '货物名称',
  `business_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '业务类型（入库/出库）',
  `batch_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '批次号',
  `supplier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '供货单位',
  `consignee` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '收货单位',
  `gross_weight` double NOT NULL COMMENT '毛重（kg）',
  `gross_weight_time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '毛重时间',
  `tare_weight` double NOT NULL COMMENT '皮重（kg）',
  `tare_weight_time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '皮重时间',
  `deduction` double DEFAULT '0' COMMENT '扣杂（kg）',
  `net_weight` double NOT NULL COMMENT '净重（kg）',
  `planned_quantity` double DEFAULT NULL COMMENT '计划数量（kg）',
  `executed_quantity` double DEFAULT NULL COMMENT '执行数量（kg）',
  `purchase_plan_id` int(11) DEFAULT NULL COMMENT '关联的计划ID',
  `inbound_outbound_id` int(11) DEFAULT NULL COMMENT '关联的出入库单ID',
  `weighing_point` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '山峡地磅' COMMENT '称重点',
  `remarks` text COLLATE utf8mb4_unicode_ci COMMENT '备注',
  `current_quantity` double DEFAULT NULL COMMENT '本次量（kg）',
  `is_voided` int(11) DEFAULT '0' COMMENT '是否作废(0=否, 1=是)',
  `created_at` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_vehicle_no` (`vehicle_no`),
  KEY `idx_plan_no` (`plan_no`),
  KEY `idx_cargo_name` (`cargo_name`),
  KEY `idx_gross_weight_time` (`gross_weight_time`),
  KEY `idx_is_voided` (`is_voided`),
  KEY `idx_purchase_plan_id` (`purchase_plan_id`),
  KEY `idx_inbound_outbound_id` (`inbound_outbound_id`)
) ENGINE=InnoDB AUTO_INCREMENT=801 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='地磅单表';

SET FOREIGN_KEY_CHECKS = 1;