shanxia/docs/地磅系统sql模型/dibang-table-保留.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: 09/05/2026 22:56:15
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- 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=1632 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='出入库单表';

-- ----------------------------
-- 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 '创建时间',
  `auto_generate_enabled` int(11) NOT NULL DEFAULT '0' COMMENT '是否自动按月生成(0=否,1=是)',
  `auto_generate_end_month` varchar(7) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '自动生成结束月份(YYYY-MM，NULL=一直生成)',
  `auto_generate_last_month` varchar(7) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '最后一次自动生成的月份(YYYY-MM，用于防重复)',
  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`),
  KEY `idx_auto_generate_enabled` (`auto_generate_enabled`),
  KEY `idx_auto_generate_end_month` (`auto_generate_end_month`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='计划表';

-- ----------------------------
-- 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=1223 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='地磅单表';

SET FOREIGN_KEY_CHECKS = 1;