/* Navicat Premium Data Transfer Source Server : 127.0.0.1 MySQL Source Server Type : MySQL Source Server Version : 80200 (8.2.0) Source Host : 127.0.0.1:3306 Source Schema : ruoyi-vue-pro Target Server Type : MySQL Target Server Version : 80200 (8.2.0) File Encoding : 65001 Date: 03/05/2024 10:51:51 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for erp_account -- ---------------------------- DROP TABLE IF EXISTS `erp_account`; CREATE TABLE `erp_account` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '结算账户编号', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '账户名称', `no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '账户编码', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `status` tinyint NOT NULL COMMENT '开启状态', `sort` int NOT NULL COMMENT '排序', `default_status` bit(1) NULL DEFAULT b'0' COMMENT '是否默认', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id` DESC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 结算账户'; -- ---------------------------- -- Records of erp_account -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_customer -- ---------------------------- DROP TABLE IF EXISTS `erp_customer`; CREATE TABLE `erp_customer` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '客户编号', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '客户名称', `contact` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '联系人', `mobile` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '手机号码', `telephone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '联系电话', `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '电子邮箱', `fax` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '传真', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `status` tinyint NOT NULL COMMENT '开启状态', `sort` int NOT NULL COMMENT '排序', `tax_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '纳税人识别号', `tax_percent` decimal(24, 6) NULL DEFAULT NULL COMMENT '税率', `bank_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '开户行', `bank_account` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '开户账号', `bank_address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '开户地址', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id` DESC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 客户表'; -- ---------------------------- -- Records of erp_customer -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_finance_payment -- ---------------------------- DROP TABLE IF EXISTS `erp_finance_payment`; CREATE TABLE `erp_finance_payment` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '付款单号', `status` tinyint NOT NULL COMMENT '状态', `payment_time` datetime NOT NULL COMMENT '付款时间', `finance_user_id` bigint NULL DEFAULT NULL COMMENT '财务人员编号', `supplier_id` bigint NOT NULL COMMENT '供应商编号', `account_id` bigint NOT NULL COMMENT '付款账户编号', `total_price` decimal(24, 6) NOT NULL COMMENT '合计价格，单位：元', `discount_price` decimal(24, 6) NOT NULL COMMENT '优惠金额，单位：元', `payment_price` decimal(24, 6) NOT NULL COMMENT '实付金额，单位：分', `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 付款单表'; -- ---------------------------- -- Records of erp_finance_payment -- ---------------------------- BEGIN; INSERT INTO `erp_finance_payment` (`id`, `no`, `status`, `payment_time`, `finance_user_id`, `supplier_id`, `account_id`, `total_price`, `discount_price`, `payment_price`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2, 'FKD20240214000001', 10, '2024-02-26 00:00:00', 112, 1, 1, 300.000000, 10.000000, 290.000000, '哈哈哈哈', '1', '2024-02-14 15:05:19', '1', '2024-02-14 09:00:22', b'1', 1), (3, 'FKD20240214000002', 10, '2024-02-20 00:00:00', NULL, 1, 1, -10.000000, 4.000000, -14.000000, NULL, '1', '2024-02-14 15:34:11', '1', '2024-02-14 09:00:18', b'1', 1), (4, 'FKD20240214000003', 10, '2024-02-18 00:00:00', NULL, 1, 1, 114.700000, 0.000000, 114.700000, NULL, '1', '2024-02-14 16:43:59', '1', '2024-02-14 08:58:43', b'1', 1), (5, 'FKD20240214000004', 10, '2024-02-19 00:00:00', NULL, 1, 1, 114.700000, 0.000000, 114.700000, NULL, '1', '2024-02-14 16:44:31', '1', '2024-02-14 08:55:13', b'1', 1), (6, 'FKD20240214000005', 10, '2024-02-19 00:00:00', NULL, 1, 1, -20.000000, 0.000000, -20.000000, NULL, '1', '2024-02-14 16:59:30', '1', '2024-02-14 09:00:16', b'1', 1), (7, 'FKD20240214000006', 10, '2024-02-20 00:00:00', NULL, 1, 1, -20.000000, 0.000000, -20.000000, NULL, '1', '2024-02-14 17:00:11', '1', '2024-02-14 09:00:41', b'1', 1), (8, 'FKD20240214000007', 10, '2024-02-20 00:00:00', 115, 1, 1, -20.000000, 0.000000, -20.000000, NULL, '1', '2024-02-14 17:01:27', '1', '2024-02-14 09:05:28', b'1', 1), (9, 'FKD20240214000008', 10, '2024-02-27 00:00:00', NULL, 1, 1, -143.200000, 0.000000, -143.200000, NULL, '1', '2024-02-14 17:04:03', '1', '2024-02-14 09:04:35', b'1', 1); COMMIT; -- ---------------------------- -- Table structure for erp_finance_payment_item -- ---------------------------- DROP TABLE IF EXISTS `erp_finance_payment_item`; CREATE TABLE `erp_finance_payment_item` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `payment_id` bigint NOT NULL COMMENT '付款单编号', `biz_type` tinyint NOT NULL COMMENT '业务类型', `biz_id` bigint NOT NULL COMMENT '业务编号', `biz_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '业务单号', `total_price` decimal(24, 6) NOT NULL COMMENT '应付欠款，单位：分', `paid_price` decimal(24, 6) NOT NULL COMMENT '已付欠款，单位：分', `payment_price` decimal(24, 6) NOT NULL COMMENT '本次付款，单位：分', `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 付款项表'; -- ---------------------------- -- Records of erp_finance_payment_item -- ---------------------------- BEGIN; INSERT INTO `erp_finance_payment_item` (`id`, `payment_id`, `biz_type`, `biz_id`, `biz_no`, `total_price`, `paid_price`, `payment_price`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (11, 2, 11, 16, 'CGRK20240213000001', 414.700000, 0.000000, 300.000000, '测试一下', '1', '2024-02-14 15:05:19', '1', '2024-02-14 09:00:22', b'1', 1), (12, 3, 12, 24, 'CGTH20240213000001', -163.200000, 0.000000, -10.000000, NULL, '1', '2024-02-14 15:34:11', '1', '2024-02-14 09:00:18', b'1', 1), (13, 4, 11, 16, 'CGRK20240213000001', 414.700000, 300.000000, 114.700000, NULL, '1', '2024-02-14 16:43:59', '1', '2024-02-14 08:58:43', b'1', 1), (14, 5, 11, 16, 'CGRK20240213000001', 414.700000, 300.000000, 114.700000, NULL, '1', '2024-02-14 16:44:31', '1', '2024-02-14 08:55:13', b'1', 1), (15, 6, 12, 24, 'CGTH20240213000001', -163.200000, -10.000000, -20.000000, NULL, '1', '2024-02-14 16:59:30', '1', '2024-02-14 09:00:16', b'1', 1), (16, 7, 12, 24, 'CGTH20240213000001', -163.200000, -10.000000, -20.000000, NULL, '1', '2024-02-14 17:00:11', '1', '2024-02-14 09:00:41', b'1', 1), (17, 8, 12, 24, 'CGTH20240213000001', -163.200000, 0.000000, -20.000000, NULL, '1', '2024-02-14 17:01:27', '1', '2024-02-14 09:05:29', b'1', 1), (18, 9, 12, 24, 'CGTH20240213000001', -163.200000, -20.000000, -143.200000, NULL, '1', '2024-02-14 17:04:03', '1', '2024-02-14 09:04:35', b'1', 1); COMMIT; -- ---------------------------- -- Table structure for erp_finance_receipt -- ---------------------------- DROP TABLE IF EXISTS `erp_finance_receipt`; CREATE TABLE `erp_finance_receipt` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '收款单号', `status` tinyint NOT NULL COMMENT '状态', `receipt_time` datetime NOT NULL COMMENT '收款时间', `finance_user_id` bigint NULL DEFAULT NULL COMMENT '财务人员编号', `customer_id` bigint NOT NULL COMMENT '客户编号', `account_id` bigint NOT NULL COMMENT '收款账户编号', `total_price` decimal(24, 6) NOT NULL COMMENT '合计价格，单位：元', `discount_price` decimal(24, 6) NOT NULL COMMENT '优惠金额，单位：元', `receipt_price` decimal(24, 6) NOT NULL COMMENT '实收金额，单位：分', `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 收款单表'; -- ---------------------------- -- Records of erp_finance_receipt -- ---------------------------- BEGIN; INSERT INTO `erp_finance_receipt` (`id`, `no`, `status`, `receipt_time`, `finance_user_id`, `customer_id`, `account_id`, `total_price`, `discount_price`, `receipt_price`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2, 'FKD20240214000001', 10, '2024-02-26 00:00:00', 112, 1, 1, 300.000000, 10.000000, 290.000000, '哈哈哈哈', '1', '2024-02-14 15:05:19', '1', '2024-02-14 09:00:22', b'1', 1), (3, 'FKD20240214000002', 10, '2024-02-20 00:00:00', NULL, 1, 1, -10.000000, 4.000000, -14.000000, NULL, '1', '2024-02-14 15:34:11', '1', '2024-02-14 09:00:18', b'1', 1), (4, 'FKD20240214000003', 10, '2024-02-18 00:00:00', NULL, 1, 1, 114.700000, 0.000000, 114.700000, NULL, '1', '2024-02-14 16:43:59', '1', '2024-02-14 08:58:43', b'1', 1), (5, 'FKD20240214000004', 10, '2024-02-19 00:00:00', NULL, 1, 1, 114.700000, 0.000000, 114.700000, NULL, '1', '2024-02-14 16:44:31', '1', '2024-02-14 08:55:13', b'1', 1), (6, 'FKD20240214000005', 10, '2024-02-19 00:00:00', NULL, 1, 1, -20.000000, 0.000000, -20.000000, NULL, '1', '2024-02-14 16:59:30', '1', '2024-02-14 09:00:16', b'1', 1), (7, 'FKD20240214000006', 10, '2024-02-20 00:00:00', NULL, 1, 1, -20.000000, 0.000000, -20.000000, NULL, '1', '2024-02-14 17:00:11', '1', '2024-02-14 09:00:41', b'1', 1), (8, 'FKD20240214000007', 10, '2024-02-20 00:00:00', 115, 1, 1, -20.000000, 0.000000, -20.000000, NULL, '1', '2024-02-14 17:01:27', '1', '2024-02-14 09:05:28', b'1', 1), (9, 'FKD20240214000008', 10, '2024-02-27 00:00:00', NULL, 1, 1, -143.200000, 0.000000, -143.200000, NULL, '1', '2024-02-14 17:04:03', '1', '2024-02-14 09:04:35', b'1', 1), (11, 'SKD20240216000001', 10, '2024-02-16 00:00:00', NULL, 2, 1, 50.000000, 10.000000, 40.000000, NULL, '1', '2024-02-16 07:59:54', '1', '2024-02-16 00:04:53', b'1', 1), (12, 'SKD20240216000002', 10, '2024-02-08 00:00:00', NULL, 2, 1, 50.000000, 0.000000, 50.000000, NULL, '1', '2024-02-16 08:02:24', '1', '2024-02-16 00:04:55', b'1', 1); COMMIT; -- ---------------------------- -- Table structure for erp_finance_receipt_item -- ---------------------------- DROP TABLE IF EXISTS `erp_finance_receipt_item`; CREATE TABLE `erp_finance_receipt_item` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `receipt_id` bigint NOT NULL COMMENT '收款单编号', `biz_type` tinyint NOT NULL COMMENT '业务类型', `biz_id` bigint NOT NULL COMMENT '业务编号', `biz_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '业务单号', `total_price` decimal(24, 6) NOT NULL COMMENT '应收金额，单位：分', `receipted_price` decimal(24, 6) NOT NULL COMMENT '已收金额，单位：分', `receipt_price` decimal(24, 6) NOT NULL COMMENT '本次收款，单位：分', `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 收款项表'; -- ---------------------------- -- Records of erp_finance_receipt_item -- ---------------------------- BEGIN; INSERT INTO `erp_finance_receipt_item` (`id`, `receipt_id`, `biz_type`, `biz_id`, `biz_no`, `total_price`, `receipted_price`, `receipt_price`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (11, 2, 11, 16, 'CGRK20240213000001', 414.700000, 0.000000, 300.000000, '测试一下', '1', '2024-02-14 15:05:19', '1', '2024-02-14 09:00:22', b'1', 1), (12, 3, 12, 24, 'CGTH20240213000001', -163.200000, 0.000000, -10.000000, NULL, '1', '2024-02-14 15:34:11', '1', '2024-02-14 09:00:18', b'1', 1), (13, 4, 11, 16, 'CGRK20240213000001', 414.700000, 300.000000, 114.700000, NULL, '1', '2024-02-14 16:43:59', '1', '2024-02-14 08:58:43', b'1', 1), (14, 5, 11, 16, 'CGRK20240213000001', 414.700000, 300.000000, 114.700000, NULL, '1', '2024-02-14 16:44:31', '1', '2024-02-14 08:55:13', b'1', 1), (15, 6, 12, 24, 'CGTH20240213000001', -163.200000, -10.000000, -20.000000, NULL, '1', '2024-02-14 16:59:30', '1', '2024-02-14 09:00:16', b'1', 1), (16, 7, 12, 24, 'CGTH20240213000001', -163.200000, -10.000000, -20.000000, NULL, '1', '2024-02-14 17:00:11', '1', '2024-02-14 09:00:41', b'1', 1), (17, 8, 12, 24, 'CGTH20240213000001', -163.200000, 0.000000, -20.000000, NULL, '1', '2024-02-14 17:01:27', '1', '2024-02-14 09:05:29', b'1', 1), (18, 9, 12, 24, 'CGTH20240213000001', -163.200000, -20.000000, -143.200000, NULL, '1', '2024-02-14 17:04:03', '1', '2024-02-14 09:04:35', b'1', 1), (20, 11, 21, 14, 'XSCK20240215000001', 67.590000, 0.000000, 50.000000, NULL, '1', '2024-02-16 07:59:54', '1', '2024-02-16 00:04:53', b'1', 1), (21, 12, 21, 14, 'XSCK20240215000001', 67.590000, 0.000000, 50.000000, NULL, '1', '2024-02-16 08:02:24', '1', '2024-02-16 00:04:55', b'1', 1); COMMIT; -- ---------------------------- -- Table structure for erp_product -- ---------------------------- DROP TABLE IF EXISTS `erp_product`; CREATE TABLE `erp_product` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '产品编号', `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '产品名称', `bar_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '产品条码', `category_id` bigint NOT NULL COMMENT '产品分类编号', `unit_id` int NOT NULL COMMENT '单位编号', `status` tinyint NOT NULL COMMENT '产品状态', `standard` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '产品规格', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '产品备注', `expiry_day` int NULL DEFAULT NULL COMMENT '保质期天数', `weight` decimal(24, 6) NULL DEFAULT NULL COMMENT '基础重量（kg）', `purchase_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '采购价格，单位：元', `sale_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '销售价格，单位：元', `min_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '最低价格，单位：元', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 产品表'; -- ---------------------------- -- Records of erp_product -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_product_category -- ---------------------------- DROP TABLE IF EXISTS `erp_product_category`; CREATE TABLE `erp_product_category` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '分类编号', `parent_id` bigint NOT NULL COMMENT '父分类编号', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分类名称', `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分类编码', `sort` int NULL DEFAULT 0 COMMENT '分类排序', `status` tinyint NOT NULL COMMENT '开启状态', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 87 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 产品分类'; -- ---------------------------- -- Records of erp_product_category -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_product_unit -- ---------------------------- DROP TABLE IF EXISTS `erp_product_unit`; CREATE TABLE `erp_product_unit` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '单位编号', `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '单位名字', `status` tinyint NOT NULL COMMENT '单位状态', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 产品单位表'; -- ---------------------------- -- Records of erp_product_unit -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_purchase_in -- ---------------------------- DROP TABLE IF EXISTS `erp_purchase_in`; CREATE TABLE `erp_purchase_in` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '采购入库编号', `status` tinyint NOT NULL COMMENT '采购状态', `supplier_id` bigint NOT NULL COMMENT '供应商编号', `account_id` bigint NOT NULL COMMENT '结算账户编号', `in_time` datetime NOT NULL COMMENT '入库时间', `order_id` bigint NOT NULL COMMENT '采购订单编号', `order_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '采购订单号', `total_count` decimal(24, 6) NOT NULL COMMENT '合计数量', `total_price` decimal(24, 6) NOT NULL COMMENT '合计价格，单位：元', `payment_price` decimal(24, 6) NOT NULL DEFAULT 0.000000 COMMENT '已付款金额，单位：元', `total_product_price` decimal(24, 6) NOT NULL COMMENT '合计产品价格，单位：元', `total_tax_price` decimal(24, 6) NOT NULL COMMENT '合计税额，单位：元', `discount_percent` decimal(24, 6) NOT NULL COMMENT '优惠率，百分比', `discount_price` decimal(24, 6) NOT NULL COMMENT '优惠金额，单位：元', `other_price` decimal(24, 6) NOT NULL DEFAULT 0.000000 COMMENT '其它金额，单位：元', `file_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '附件地址', `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `no`(`no` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 采购入库表'; -- ---------------------------- -- Records of erp_purchase_in -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_purchase_in_items -- ---------------------------- DROP TABLE IF EXISTS `erp_purchase_in_items`; CREATE TABLE `erp_purchase_in_items` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `in_id` bigint NOT NULL COMMENT '采购入库编号', `order_item_id` bigint NOT NULL COMMENT '采购订单项编号', `warehouse_id` bigint NOT NULL COMMENT '仓库编号', `product_id` bigint NOT NULL COMMENT '产品编号', `product_unit_id` bigint NOT NULL COMMENT '产品单位单位', `product_price` decimal(24, 6) NOT NULL COMMENT '产品单价', `count` decimal(24, 6) NOT NULL COMMENT '数量', `total_price` decimal(24, 6) NOT NULL COMMENT '总价', `tax_percent` decimal(24, 6) NULL DEFAULT NULL COMMENT '税率，百分比', `tax_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '税额，单位：元', `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 销售入库项表'; -- ---------------------------- -- Records of erp_purchase_in_items -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_purchase_order -- ---------------------------- DROP TABLE IF EXISTS `erp_purchase_order`; CREATE TABLE `erp_purchase_order` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '采购单编号', `status` tinyint NOT NULL COMMENT '采购状态', `supplier_id` bigint NOT NULL COMMENT '供应商编号', `account_id` bigint NULL DEFAULT NULL COMMENT '结算账户编号', `order_time` datetime NOT NULL COMMENT '采购时间', `total_count` decimal(24, 6) NOT NULL COMMENT '合计数量', `total_price` decimal(24, 6) NOT NULL COMMENT '合计价格，单位：元', `total_product_price` decimal(24, 6) NOT NULL COMMENT '合计产品价格，单位：元', `total_tax_price` decimal(24, 6) NOT NULL COMMENT '合计税额，单位：元', `discount_percent` decimal(24, 6) NOT NULL COMMENT '优惠率，百分比', `discount_price` decimal(24, 6) NOT NULL COMMENT '优惠金额，单位：元', `deposit_price` decimal(24, 6) NOT NULL DEFAULT 0.000000 COMMENT '定金金额，单位：元', `file_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '附件地址', `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `in_count` decimal(24, 6) NOT NULL DEFAULT 0.000000 COMMENT '采购入库数量', `return_count` decimal(24, 6) NOT NULL DEFAULT 0.000000 COMMENT '采购退货数量', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `no`(`no` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 采购订单表'; -- ---------------------------- -- Records of erp_purchase_order -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_purchase_order_items -- ---------------------------- DROP TABLE IF EXISTS `erp_purchase_order_items`; CREATE TABLE `erp_purchase_order_items` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `order_id` bigint NOT NULL COMMENT '采购订单编号', `product_id` bigint NOT NULL COMMENT '产品编号', `product_unit_id` bigint NOT NULL COMMENT '产品单位单位', `product_price` decimal(24, 6) NOT NULL COMMENT '产品单价', `count` decimal(24, 6) NOT NULL COMMENT '数量', `total_price` decimal(24, 6) NOT NULL COMMENT '总价', `tax_percent` decimal(24, 6) NULL DEFAULT NULL COMMENT '税率，百分比', `tax_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '税额，单位：元', `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `in_count` decimal(24, 6) NOT NULL DEFAULT 0.000000 COMMENT '采购入库数量', `return_count` decimal(24, 6) NOT NULL DEFAULT 0.000000 COMMENT '采购退货数量', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 采购订单项表'; -- ---------------------------- -- Records of erp_purchase_order_items -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_purchase_return -- ---------------------------- DROP TABLE IF EXISTS `erp_purchase_return`; CREATE TABLE `erp_purchase_return` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '采购退货编号', `status` tinyint NOT NULL COMMENT '退货状态', `supplier_id` bigint NOT NULL COMMENT '供应商编号', `account_id` bigint NOT NULL COMMENT '结算账户编号', `return_time` datetime NOT NULL COMMENT '退货时间', `order_id` bigint NOT NULL COMMENT '采购订单编号', `order_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '采购订单号', `total_count` decimal(24, 6) NOT NULL COMMENT '合计数量', `total_price` decimal(24, 6) NOT NULL COMMENT '合计价格，单位：元', `refund_price` decimal(24, 6) NOT NULL DEFAULT 0.000000 COMMENT '已退款金额，单位：元', `total_product_price` decimal(24, 6) NOT NULL COMMENT '合计产品价格，单位：元', `total_tax_price` decimal(24, 6) NOT NULL COMMENT '合计税额，单位：元', `discount_percent` decimal(24, 6) NOT NULL COMMENT '优惠率，百分比', `discount_price` decimal(24, 6) NOT NULL COMMENT '优惠金额，单位：元', `other_price` decimal(24, 6) NOT NULL DEFAULT 0.000000 COMMENT '其它金额，单位：元', `file_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '附件地址', `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `no`(`no` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 采购退货表'; -- ---------------------------- -- Records of erp_purchase_return -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_purchase_return_items -- ---------------------------- DROP TABLE IF EXISTS `erp_purchase_return_items`; CREATE TABLE `erp_purchase_return_items` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `return_id` bigint NOT NULL COMMENT '采购退货编号', `order_item_id` bigint NOT NULL COMMENT '采购订单项编号', `warehouse_id` bigint NOT NULL COMMENT '仓库编号', `product_id` bigint NOT NULL COMMENT '产品编号', `product_unit_id` bigint NOT NULL COMMENT '产品单位单位', `product_price` decimal(24, 6) NOT NULL COMMENT '产品单价', `count` decimal(24, 6) NOT NULL COMMENT '数量', `total_price` decimal(24, 6) NOT NULL COMMENT '总价', `tax_percent` decimal(24, 6) NULL DEFAULT NULL COMMENT '税率，百分比', `tax_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '税额，单位：元', `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 47 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 采购退货项表'; -- ---------------------------- -- Records of erp_purchase_return_items -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_sale_order -- ---------------------------- DROP TABLE IF EXISTS `erp_sale_order`; CREATE TABLE `erp_sale_order` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '销售单编号', `status` tinyint NOT NULL COMMENT '销售状态', `customer_id` bigint NOT NULL COMMENT '客户编号', `account_id` bigint NULL DEFAULT NULL COMMENT '结算账户编号', `sale_user_id` bigint NULL DEFAULT NULL COMMENT '销售用户编号', `order_time` datetime NOT NULL COMMENT '下单时间', `total_count` decimal(24, 6) NOT NULL COMMENT '合计数量', `total_price` decimal(24, 6) NOT NULL COMMENT '合计价格，单位：元', `total_product_price` decimal(24, 6) NOT NULL COMMENT '合计产品价格，单位：元', `total_tax_price` decimal(24, 6) NOT NULL COMMENT '合计税额，单位：元', `discount_percent` decimal(24, 6) NOT NULL COMMENT '优惠率，百分比', `discount_price` decimal(24, 6) NOT NULL COMMENT '优惠金额，单位：元', `deposit_price` decimal(24, 6) NOT NULL DEFAULT 0.000000 COMMENT '定金金额，单位：元', `file_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '附件地址', `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `out_count` decimal(24, 6) NOT NULL DEFAULT 0.000000 COMMENT '销售出库数量', `return_count` decimal(24, 6) NOT NULL DEFAULT 0.000000 COMMENT '销售退货数量', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `no`(`no` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 销售订单表'; -- ---------------------------- -- Records of erp_sale_order -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_sale_order_items -- ---------------------------- DROP TABLE IF EXISTS `erp_sale_order_items`; CREATE TABLE `erp_sale_order_items` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `order_id` bigint NOT NULL COMMENT '销售订单编号', `product_id` bigint NOT NULL COMMENT '产品编号', `product_unit_id` bigint NOT NULL COMMENT '产品单位单位', `product_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '产品单价', `count` decimal(24, 6) NOT NULL COMMENT '数量', `total_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '总价', `tax_percent` decimal(24, 6) NULL DEFAULT NULL COMMENT '税率，百分比', `tax_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '税额，单位：元', `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `out_count` decimal(24, 6) NOT NULL DEFAULT 0.000000 COMMENT '销售出库数量', `return_count` decimal(24, 6) NOT NULL DEFAULT 0.000000 COMMENT '销售退货数量', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 销售订单项表'; -- ---------------------------- -- Records of erp_sale_order_items -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_sale_out -- ---------------------------- DROP TABLE IF EXISTS `erp_sale_out`; CREATE TABLE `erp_sale_out` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '销售出库编号', `status` tinyint NOT NULL COMMENT '出库状态', `customer_id` bigint NOT NULL COMMENT '客户编号', `account_id` bigint NOT NULL COMMENT '结算账户编号', `sale_user_id` bigint NULL DEFAULT NULL COMMENT '销售用户编号', `out_time` datetime NOT NULL COMMENT '出库时间', `order_id` bigint NOT NULL COMMENT '销售订单编号', `order_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '销售订单号', `total_count` decimal(24, 6) NOT NULL COMMENT '合计数量', `total_price` decimal(24, 6) NOT NULL COMMENT '合计价格，单位：元', `receipt_price` decimal(24, 6) NOT NULL DEFAULT 0.000000 COMMENT '已收款金额，单位：元', `total_product_price` decimal(24, 6) NOT NULL COMMENT '合计产品价格，单位：元', `total_tax_price` decimal(24, 6) NOT NULL COMMENT '合计税额，单位：元', `discount_percent` decimal(24, 6) NOT NULL COMMENT '优惠率，百分比', `discount_price` decimal(24, 6) NOT NULL COMMENT '优惠金额，单位：元', `other_price` decimal(24, 6) NOT NULL DEFAULT 0.000000 COMMENT '其它金额，单位：元', `file_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '附件地址', `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `no`(`no` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 销售出库表'; -- ---------------------------- -- Records of erp_sale_out -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_sale_out_items -- ---------------------------- DROP TABLE IF EXISTS `erp_sale_out_items`; CREATE TABLE `erp_sale_out_items` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `out_id` bigint NOT NULL COMMENT '销售出库编号', `order_item_id` bigint NOT NULL COMMENT '销售订单项编号', `warehouse_id` bigint NOT NULL COMMENT '仓库编号', `product_id` bigint NOT NULL COMMENT '产品编号', `product_unit_id` bigint NOT NULL COMMENT '产品单位单位', `product_price` decimal(24, 6) NOT NULL COMMENT '产品单价', `count` decimal(24, 6) NOT NULL COMMENT '数量', `total_price` decimal(24, 6) NOT NULL COMMENT '总价', `tax_percent` decimal(24, 6) NULL DEFAULT NULL COMMENT '税率，百分比', `tax_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '税额，单位：元', `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 销售出库项表'; -- ---------------------------- -- Records of erp_sale_out_items -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_sale_return -- ---------------------------- DROP TABLE IF EXISTS `erp_sale_return`; CREATE TABLE `erp_sale_return` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '销售退货编号', `status` tinyint NOT NULL COMMENT '退货状态', `customer_id` bigint NOT NULL COMMENT '客户编号', `account_id` bigint NOT NULL COMMENT '结算账户编号', `sale_user_id` bigint NULL DEFAULT NULL COMMENT '销售用户编号', `return_time` datetime NOT NULL COMMENT '退货时间', `order_id` bigint NOT NULL COMMENT '销售订单编号', `order_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '销售订单号', `total_count` decimal(24, 6) NOT NULL COMMENT '合计数量', `total_price` decimal(24, 6) NOT NULL COMMENT '合计价格，单位：元', `refund_price` decimal(24, 6) NOT NULL DEFAULT 0.000000 COMMENT '已退款金额，单位：元', `total_product_price` decimal(24, 6) NOT NULL COMMENT '合计产品价格，单位：元', `total_tax_price` decimal(24, 6) NOT NULL COMMENT '合计税额，单位：元', `discount_percent` decimal(24, 6) NOT NULL COMMENT '优惠率，百分比', `discount_price` decimal(24, 6) NOT NULL COMMENT '优惠金额，单位：元', `other_price` decimal(24, 6) NOT NULL DEFAULT 0.000000 COMMENT '其它金额，单位：元', `file_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '附件地址', `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `no`(`no` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 销售退货表'; -- ---------------------------- -- Records of erp_sale_return -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_sale_return_items -- ---------------------------- DROP TABLE IF EXISTS `erp_sale_return_items`; CREATE TABLE `erp_sale_return_items` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `return_id` bigint NOT NULL COMMENT '销售退货编号', `order_item_id` bigint NOT NULL COMMENT '销售订单项编号', `warehouse_id` bigint NOT NULL COMMENT '仓库编号', `product_id` bigint NOT NULL COMMENT '产品编号', `product_unit_id` bigint NOT NULL COMMENT '产品单位单位', `product_price` decimal(24, 6) NOT NULL COMMENT '产品单价', `count` decimal(24, 6) NOT NULL COMMENT '数量', `total_price` decimal(24, 6) NOT NULL COMMENT '总价', `tax_percent` decimal(24, 6) NULL DEFAULT NULL COMMENT '税率，百分比', `tax_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '税额，单位：元', `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 销售退货项表'; -- ---------------------------- -- Records of erp_sale_return_items -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_stock -- ---------------------------- DROP TABLE IF EXISTS `erp_stock`; CREATE TABLE `erp_stock` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `product_id` bigint NOT NULL COMMENT '产品编号', `warehouse_id` bigint NOT NULL COMMENT '仓库编号', `count` decimal(24, 6) NOT NULL COMMENT '库存数量', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 产品库存表'; -- ---------------------------- -- Records of erp_stock -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_stock_check -- ---------------------------- DROP TABLE IF EXISTS `erp_stock_check`; CREATE TABLE `erp_stock_check` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '盘点编号', `no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '盘点单号', `check_time` datetime NOT NULL COMMENT '盘点时间', `total_count` decimal(24, 6) NOT NULL COMMENT '合计数量', `total_price` decimal(24, 6) NOT NULL COMMENT '合计金额，单位：元', `status` tinyint NOT NULL COMMENT '状态', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '附件 URL', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 库存盘点单表'; -- ---------------------------- -- Records of erp_stock_check -- ---------------------------- BEGIN; INSERT INTO `erp_stock_check` (`id`, `no`, `check_time`, `total_count`, `total_price`, `status`, `remark`, `file_url`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (10, 'QCDB20240207000002', '2024-02-06 00:00:00', 23.000000, 76.590000, 10, NULL, NULL, '1', '2024-02-07 19:34:47', '1', '2024-02-08 00:49:53', b'1', 1); COMMIT; -- ---------------------------- -- Table structure for erp_stock_check_item -- ---------------------------- DROP TABLE IF EXISTS `erp_stock_check_item`; CREATE TABLE `erp_stock_check_item` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '盘点项编号', `check_id` bigint NOT NULL COMMENT '盘点编号', `warehouse_id` bigint NOT NULL COMMENT '仓库编号', `product_id` bigint NOT NULL COMMENT '产品编号', `product_unit_id` bigint NOT NULL COMMENT '产品单位编号', `product_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '产品单价', `stock_count` decimal(24, 6) NOT NULL COMMENT '账面数量（当前库存）', `actual_count` decimal(24, 6) NOT NULL COMMENT '实际数量（实际库存）', `count` decimal(24, 6) NOT NULL COMMENT '盈亏数量', `total_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '合计金额，单位：元', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 库存盘点项表'; -- ---------------------------- -- Records of erp_stock_check_item -- ---------------------------- BEGIN; INSERT INTO `erp_stock_check_item` (`id`, `check_id`, `warehouse_id`, `product_id`, `product_unit_id`, `product_price`, `stock_count`, `actual_count`, `count`, `total_price`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (10, 10, 2, 1, 2, 3.330000, 0.000000, 0.000000, 23.000000, 76.590000, NULL, '1', '2024-02-07 19:34:47', '1', '2024-02-08 00:49:53', b'1', 1); COMMIT; -- ---------------------------- -- Table structure for erp_stock_in -- ---------------------------- DROP TABLE IF EXISTS `erp_stock_in`; CREATE TABLE `erp_stock_in` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '入库编号', `no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '入库单号', `supplier_id` bigint NULL DEFAULT NULL COMMENT '供应商编号', `in_time` datetime NOT NULL COMMENT '入库时间', `total_count` decimal(24, 6) NOT NULL COMMENT '合计数量', `total_price` decimal(24, 6) NOT NULL COMMENT '合计金额，单位：元', `status` tinyint NOT NULL COMMENT '状态', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '附件 URL', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 其它入库单表'; -- ---------------------------- -- Records of erp_stock_in -- ---------------------------- BEGIN; INSERT INTO `erp_stock_in` (`id`, `no`, `supplier_id`, `in_time`, `total_count`, `total_price`, `status`, `remark`, `file_url`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (1, 'AAA', NULL, '2024-02-06 00:00:00', 5.010000, 14.683300, 10, NULL, NULL, '1', '2024-02-06 14:43:04', '1', '2024-02-16 09:26:55', b'1', 1), (2, '单据2', 1, '2024-02-22 00:00:00', 2.000000, 6.660000, 10, '测试一下', 'http://test.yudao.iocoder.cn/e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855.xls', '1', '2024-02-06 15:54:58', '1', '2024-02-16 09:26:53', b'1', 1), (3, '001', 1, '2024-02-06 00:00:00', 1.000000, 3.330000, 10, '给一个', NULL, '1', '2024-02-06 19:55:05', '1', '2024-02-16 09:26:50', b'1', 1), (4, '10', 1, '2024-02-06 00:00:00', 1.000000, 2.000000, 10, NULL, NULL, '1', '2024-02-06 20:18:48', '1', '2024-02-16 09:26:48', b'1', 1); COMMIT; -- ---------------------------- -- Table structure for erp_stock_in_item -- ---------------------------- DROP TABLE IF EXISTS `erp_stock_in_item`; CREATE TABLE `erp_stock_in_item` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '入库项编号', `in_id` bigint NOT NULL COMMENT '入库编号', `warehouse_id` bigint NOT NULL COMMENT '仓库编号', `product_id` bigint NOT NULL COMMENT '产品编号', `product_unit_id` bigint NOT NULL COMMENT '产品单位编号', `product_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '产品单价', `count` decimal(24, 6) NOT NULL COMMENT '产品数量', `total_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '合计金额，单位：元', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 其它入库单项表'; -- ---------------------------- -- Records of erp_stock_in_item -- ---------------------------- BEGIN; INSERT INTO `erp_stock_in_item` (`id`, `in_id`, `warehouse_id`, `product_id`, `product_unit_id`, `product_price`, `count`, `total_price`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (1, 1, 1, 1, 2, 2.330000, 2.000000, 4.660000, NULL, '1', '2024-02-06 14:43:04', '1', '2024-02-16 09:26:55', b'1', 1), (2, 1, 2, 1, 2, 3.330000, 3.010000, 10.023300, NULL, '1', '2024-02-06 15:15:07', '1', '2024-02-16 09:26:55', b'1', 1), (3, 2, 2, 2, 2, 3.330000, 2.000000, 6.660000, NULL, '1', '2024-02-06 15:54:58', '1', '2024-02-16 09:26:53', b'1', 1), (4, 3, 2, 1, 2, 3.330000, 1.000000, 3.330000, NULL, '1', '2024-02-06 19:55:05', '1', '2024-02-16 09:26:50', b'1', 1), (5, 4, 2, 2, 2, 2.000000, 1.000000, 2.000000, NULL, '1', '2024-02-06 20:18:48', '1', '2024-02-16 09:26:48', b'1', 1); COMMIT; -- ---------------------------- -- Table structure for erp_stock_move -- ---------------------------- DROP TABLE IF EXISTS `erp_stock_move`; CREATE TABLE `erp_stock_move` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '调拨编号', `no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '调拨单号', `move_time` datetime NOT NULL COMMENT '调拨时间', `total_count` decimal(24, 6) NOT NULL COMMENT '合计数量', `total_price` decimal(24, 6) NOT NULL COMMENT '合计金额，单位：元', `status` tinyint NOT NULL COMMENT '状态', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '附件 URL', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 库存调拨单表'; -- ---------------------------- -- Records of erp_stock_move -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_stock_move_item -- ---------------------------- DROP TABLE IF EXISTS `erp_stock_move_item`; CREATE TABLE `erp_stock_move_item` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '调拨项编号', `move_id` bigint NOT NULL COMMENT '调拨编号', `from_warehouse_id` bigint NOT NULL COMMENT '调出仓库编号', `to_warehouse_id` bigint NOT NULL COMMENT '调入仓库编号', `product_id` bigint NOT NULL COMMENT '产品编号', `product_unit_id` bigint NOT NULL COMMENT '产品单位编号', `product_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '产品单价', `count` decimal(24, 6) NOT NULL COMMENT '产品数量', `total_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '合计金额，单位：元', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 库存调拨项表'; -- ---------------------------- -- Records of erp_stock_move_item -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_stock_out -- ---------------------------- DROP TABLE IF EXISTS `erp_stock_out`; CREATE TABLE `erp_stock_out` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '出库编号', `no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '出库单号', `customer_id` bigint NULL DEFAULT NULL COMMENT '客户编号', `out_time` datetime NOT NULL COMMENT '出库时间', `total_count` decimal(24, 6) NOT NULL COMMENT '合计数量', `total_price` decimal(24, 6) NOT NULL COMMENT '合计金额，单位：元', `status` tinyint NOT NULL COMMENT '状态', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '附件 URL', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 其它入库单表'; -- ---------------------------- -- Records of erp_stock_out -- ---------------------------- BEGIN; INSERT INTO `erp_stock_out` (`id`, `no`, `customer_id`, `out_time`, `total_count`, `total_price`, `status`, `remark`, `file_url`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (9, 'QCKD20240207000001', NULL, '2024-02-14 00:00:00', 1.000000, 2.000000, 10, '333', NULL, '1', '2024-02-07 14:59:53', '1', '2024-02-07 07:00:13', b'1', 1); COMMIT; -- ---------------------------- -- Table structure for erp_stock_out_item -- ---------------------------- DROP TABLE IF EXISTS `erp_stock_out_item`; CREATE TABLE `erp_stock_out_item` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '出库项编号', `out_id` bigint NOT NULL COMMENT '出库编号', `warehouse_id` bigint NOT NULL COMMENT '仓库编号', `product_id` bigint NOT NULL COMMENT '产品编号', `product_unit_id` bigint NOT NULL COMMENT '产品单位编号', `product_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '产品单价', `count` decimal(24, 6) NOT NULL COMMENT '产品数量', `total_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '合计金额，单位：元', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 其它出库单项表'; -- ---------------------------- -- Records of erp_stock_out_item -- ---------------------------- BEGIN; INSERT INTO `erp_stock_out_item` (`id`, `out_id`, `warehouse_id`, `product_id`, `product_unit_id`, `product_price`, `count`, `total_price`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (10, 9, 2, 2, 2, 2.000000, 1.000000, 2.000000, NULL, '1', '2024-02-07 14:59:53', '1', '2024-02-07 07:00:13', b'1', 1); COMMIT; -- ---------------------------- -- Table structure for erp_stock_record -- ---------------------------- DROP TABLE IF EXISTS `erp_stock_record`; CREATE TABLE `erp_stock_record` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `product_id` bigint NOT NULL COMMENT '产品编号', `warehouse_id` bigint NOT NULL COMMENT '仓库编号', `count` decimal(24, 6) NOT NULL COMMENT '出入库数量', `total_count` decimal(24, 6) NOT NULL COMMENT '总库存量', `biz_type` tinyint NOT NULL COMMENT '业务类型', `biz_id` bigint NOT NULL COMMENT '业务编号', `biz_item_id` bigint NOT NULL COMMENT '业务项编号', `biz_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '业务单号', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 104 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 产品库存明细表'; -- ---------------------------- -- Records of erp_stock_record -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_supplier -- ---------------------------- DROP TABLE IF EXISTS `erp_supplier`; CREATE TABLE `erp_supplier` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '供应商编号', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '供应商名称', `contact` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '联系人', `mobile` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '手机号码', `telephone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '联系电话', `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '电子邮箱', `fax` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '传真', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `status` tinyint NOT NULL COMMENT '开启状态', `sort` int NOT NULL COMMENT '排序', `tax_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '纳税人识别号', `tax_percent` decimal(24, 6) NULL DEFAULT NULL COMMENT '税率', `bank_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '开户行', `bank_account` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '开户账号', `bank_address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '开户地址', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id` DESC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 供应商表'; -- ---------------------------- -- Records of erp_supplier -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for erp_warehouse -- ---------------------------- DROP TABLE IF EXISTS `erp_warehouse`; CREATE TABLE `erp_warehouse` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '仓库编号', `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '仓库名称', `address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '仓库地址', `sort` bigint NOT NULL COMMENT '排序', `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `principal` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '负责人', `warehouse_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '仓储费，单位：元', `truckage_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '搬运费，单位：元', `status` tinyint NOT NULL COMMENT '开启状态', `default_status` bit(1) NULL DEFAULT b'0' COMMENT '是否默认', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'ERP 仓库表'; -- ---------------------------- -- Records of erp_warehouse -- ---------------------------- BEGIN; COMMIT; SET FOREIGN_KEY_CHECKS = 1;