dibang-xiaoshou/weighing_slips.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

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

 Date: 29/11/2025 19:50:48
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- 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`) USING BTREE,
  KEY `idx_vehicle_no` (`vehicle_no`) USING BTREE,
  KEY `idx_plan_no` (`plan_no`) USING BTREE,
  KEY `idx_cargo_name` (`cargo_name`) USING BTREE,
  KEY `idx_gross_weight_time` (`gross_weight_time`) USING BTREE,
  KEY `idx_is_voided` (`is_voided`) USING BTREE,
  KEY `idx_purchase_plan_id` (`purchase_plan_id`) USING BTREE,
  KEY `idx_inbound_outbound_id` (`inbound_outbound_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='地磅单表';

SET FOREIGN_KEY_CHECKS = 1;