/* Navicat MySQL Dump SQL Source Server : yunshu Source Server Type : MySQL Source Server Version : 80406 (8.4.6) Source Host : 8.148.211.203:3306 Source Schema : cold_delivery Target Server Type : MySQL Target Server Version : 80406 (8.4.6) File Encoding : 65001 Date: 23/07/2026 10:08:26 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for address -- ---------------------------- DROP TABLE IF EXISTS `address`; CREATE TABLE `address` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `address_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', `dept_id` bigint NULL DEFAULT NULL COMMENT '部门id', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_address_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_address_update_by`(`update_by` ASC) USING BTREE, INDEX `idx_address_deleted_at`(`deleted_at` ASC) USING BTREE, INDEX `idx_address_dept_id`(`dept_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for address_default -- ---------------------------- DROP TABLE IF EXISTS `address_default`; CREATE TABLE `address_default` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `address_id` bigint NULL DEFAULT NULL COMMENT '地址id', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_address_default_user_id`(`user_id` ASC) USING BTREE, INDEX `idx_address_default_update_by`(`update_by` ASC) USING BTREE, INDEX `idx_address_default_deleted_at`(`deleted_at` ASC) USING BTREE, INDEX `idx_address_default_create_by`(`create_by` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for cooler_box -- ---------------------------- DROP TABLE IF EXISTS `cooler_box`; CREATE TABLE `cooler_box` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `sn` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '2' COMMENT '状态', `history_sn` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `cold_spots` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `cold_temperatures` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `for_cold_cooler_time` decimal(10, 2) NULL DEFAULT NULL COMMENT '预冷要求', `monitor_status` bigint NULL DEFAULT NULL COMMENT '监控状态', `for_cold_status` bigint NULL DEFAULT 0 COMMENT '预冷状态', `bind_ice_raft_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '绑定冰排', `use_status` bigint NULL DEFAULT 0 COMMENT '预冷状态', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', `dept_id` bigint NULL DEFAULT NULL COMMENT '部门id', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_cooler_box_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_cooler_box_update_by`(`update_by` ASC) USING BTREE, INDEX `idx_cooler_box_deleted_at`(`deleted_at` ASC) USING BTREE, INDEX `idx_cooler_box_dept_id`(`dept_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for cooler_box_record -- ---------------------------- DROP TABLE IF EXISTS `cooler_box_record`; CREATE TABLE `cooler_box_record` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `cooler_box_id` bigint NULL DEFAULT NULL, `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `sn` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `history_code` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '状态', `cooler_box_star_time` datetime(3) NULL DEFAULT NULL COMMENT '保温箱开始预冷时间', `cooler_user_time` datetime(3) NULL DEFAULT NULL COMMENT '保温箱开始使用时间', `cooler_cold_address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '保温箱预冷地点', `cold_temperatures` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '保温箱预冷温度', `cooler_cold_users` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '保温箱预冷操作人员', `cooler_use_users` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '保温箱使用操作人员', `cooler_end_use_time` datetime(3) NULL DEFAULT NULL COMMENT '保温箱结束使用时间', `for_cold_cooler_time` decimal(10, 2) NULL DEFAULT NULL COMMENT '预冷要求', `for_cold_duration` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '预冷累计时长', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', `dept_id` bigint NULL DEFAULT NULL COMMENT '部门id', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_cooler_box_record_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_cooler_box_record_update_by`(`update_by` ASC) USING BTREE, INDEX `idx_cooler_box_record_deleted_at`(`deleted_at` ASC) USING BTREE, INDEX `idx_cooler_box_record_dept_id`(`dept_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for drug -- ---------------------------- DROP TABLE IF EXISTS `drug`; CREATE TABLE `drug` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', `dept_id` bigint NULL DEFAULT NULL COMMENT '部门id', `waybill_no` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '运单id', `physic_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '药品名称', `physic_type_desc` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '药品类型', `pkg_spec_crit` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '包装规格', `prepn_spec` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '制剂规格', `prepn_type_desc` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '制剂类型', `approval_licence_no` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '批准文号', `drug_ent_base_info_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '药品id', `ent_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '企业名称', `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '药品编码', `count` bigint NULL DEFAULT NULL COMMENT '数量', `is_assignment` tinyint(1) NULL DEFAULT 0 COMMENT '是否分配', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_drug_dept_id`(`dept_id` ASC) USING BTREE, INDEX `idx_drug_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_drug_update_by`(`update_by` ASC) USING BTREE, INDEX `idx_drug_deleted_at`(`deleted_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for ice_locker -- ---------------------------- DROP TABLE IF EXISTS `ice_locker`; CREATE TABLE `ice_locker` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '2' COMMENT '状态', `sn` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `history_sn` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', `dept_id` bigint NULL DEFAULT NULL COMMENT '部门id', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_ice_locker_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_ice_locker_update_by`(`update_by` ASC) USING BTREE, INDEX `idx_ice_locker_deleted_at`(`deleted_at` ASC) USING BTREE, INDEX `idx_ice_locker_dept_id`(`dept_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for ice_raft -- ---------------------------- DROP TABLE IF EXISTS `ice_raft`; CREATE TABLE `ice_raft` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '2' COMMENT '状态', `ice_raft_record_id` bigint NULL DEFAULT NULL, `freeze_claim` json NULL COMMENT '冷冻要求', `label` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '标签', `ice_cold_address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '冰排预冷地点', `suitable_for_cold` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '冰排适冷温度', `sort` tinyint NULL DEFAULT NULL COMMENT '排序', `for_cold_time` decimal(10, 2) NULL DEFAULT NULL COMMENT '适冷时长', `bind_cooler_box` json NULL COMMENT '绑定保温箱', `cooler_box_name` json NULL COMMENT '保温箱名称', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', `dept_id` bigint NULL DEFAULT NULL COMMENT '部门id', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_ice_raft_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_ice_raft_update_by`(`update_by` ASC) USING BTREE, INDEX `idx_ice_raft_deleted_at`(`deleted_at` ASC) USING BTREE, INDEX `idx_ice_raft_dept_id`(`dept_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for ice_raft_record -- ---------------------------- DROP TABLE IF EXISTS `ice_raft_record`; CREATE TABLE `ice_raft_record` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `ice_raft_id` bigint NULL DEFAULT NULL COMMENT '冰排id', `label` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '标签', `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '编号', `status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '2' COMMENT '状态', `sort` tinyint NULL DEFAULT NULL COMMENT '排序', `for_cold_time` decimal(10, 2) NULL DEFAULT NULL COMMENT '要求适冷时间', `for_cold_time_actual` decimal(10, 0) NULL DEFAULT NULL COMMENT '实际适冷时间', `in_storage_time` datetime(3) NULL DEFAULT NULL COMMENT '入库时间', `out_storage_time` datetime(3) NULL DEFAULT NULL COMMENT '出库时间', `ice_locker_id` bigint NULL DEFAULT NULL COMMENT '冷冻柜id', `cooler_box_id` bigint NULL DEFAULT NULL COMMENT '保温箱id', `freeze_claim` json NULL COMMENT '冷冻要求', `freeze_duration` decimal(10, 2) NULL DEFAULT NULL COMMENT '冷冻时长', `suitable_for_cold` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '冰排适冷温度', `end_for_cold_time` datetime(3) NULL DEFAULT NULL COMMENT '适冷结束时间', `is_suitable_for_cold` tinyint NOT NULL COMMENT '是否结束适冷', `cooler_box_star_time` datetime(3) NULL DEFAULT NULL COMMENT '保温箱开始预冷时间', `cooler_box_end_time` datetime(3) NULL DEFAULT NULL COMMENT '保温箱结束记录时间', `start_ice_cold_time` datetime(3) NULL DEFAULT NULL COMMENT '释冷开始时间', `ice_cold_address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '冰排预冷地点', `ice_cold_users` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '冰排预冷操作人员', `ice_use_users` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '冰排使用操作人员', `ice_use_time` datetime(3) NULL DEFAULT NULL COMMENT '冰排使用时间', `cooler_cold_address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '保温箱预冷地点', `cooler_cold_users` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '保温箱预冷操作人员', `cooler_use_users` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '保温箱使用操作人员', `return_date` datetime(3) NULL DEFAULT NULL COMMENT '归还日期', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', `dept_id` bigint NULL DEFAULT NULL COMMENT '部门id', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_ice_raft_record_deleted_at`(`deleted_at` ASC) USING BTREE, INDEX `idx_ice_raft_record_dept_id`(`dept_id` ASC) USING BTREE, INDEX `idx_ice_raft_record_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_ice_raft_record_update_by`(`update_by` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_casbin_rule -- ---------------------------- DROP TABLE IF EXISTS `sys_casbin_rule`; CREATE TABLE `sys_casbin_rule` ( `p_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `v0` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `v1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `v2` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `v3` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `v4` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `v5` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, UNIQUE INDEX `idx_sys_casbin_rule`(`p_type` ASC, `v0` ASC, `v1` ASC, `v2` ASC, `v3` ASC, `v4` ASC, `v5` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_dept -- ---------------------------- DROP TABLE IF EXISTS `sys_dept`; CREATE TABLE `sys_dept` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `parent_id` bigint NULL DEFAULT NULL, `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '路径', `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '部门名称', `sort` tinyint NULL DEFAULT NULL, `status` tinyint NULL DEFAULT NULL, `remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `cold_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', `cold_pid` bigint NULL DEFAULT NULL, `company_address` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `is_ice_release_cold` tinyint(1) NULL DEFAULT 0, `is_cooler_release_cold` tinyint(1) NULL DEFAULT 0, `is_cooler_show` tinyint(1) NULL DEFAULT 0, `is_out_storage` tinyint(1) NULL DEFAULT 1, `app_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'app名称', `ice_raft_manage` tinyint(1) NULL DEFAULT 0, `company_coordinate` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_sys_dept_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_sys_dept_update_by`(`update_by` ASC) USING BTREE, INDEX `idx_sys_dept_deleted_at`(`deleted_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_job -- ---------------------------- DROP TABLE IF EXISTS `sys_job`; CREATE TABLE `sys_job` ( `job_id` bigint NOT NULL AUTO_INCREMENT, `job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `job_group` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `job_type` tinyint NULL DEFAULT NULL, `cron_expression` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `invoke_target` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `args` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `misfire_policy` bigint NULL DEFAULT NULL, `concurrent` tinyint NULL DEFAULT NULL, `status` tinyint NULL DEFAULT NULL, `entry_id` smallint NULL DEFAULT NULL, `auto` tinyint(1) NULL DEFAULT NULL, `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', PRIMARY KEY (`job_id`) USING BTREE, INDEX `idx_sys_job_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_sys_job_update_by`(`update_by` ASC) USING BTREE, INDEX `idx_sys_job_deleted_at`(`deleted_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_login_log -- ---------------------------- DROP TABLE IF EXISTS `sys_login_log`; CREATE TABLE `sys_login_log` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `username` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名', `status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '状态', `ipaddr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'ip地址', `login_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '归属地', `browser` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '浏览器', `os` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '系统', `platform` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '固件', `login_time` datetime(3) NULL DEFAULT NULL COMMENT '登录时间', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '信息', `created_at` datetime(3) NULL DEFAULT NULL COMMENT '创建时间', `updated_at` datetime(3) NULL DEFAULT NULL COMMENT '最后更新时间', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_sys_login_log_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_sys_login_log_update_by`(`update_by` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 180 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_menu`; CREATE TABLE `sys_menu` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `parent_id` smallint NULL DEFAULT NULL, `sort` tinyint NULL DEFAULT NULL, `visible` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '1', `menu_path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `redirect` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `menu_type` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `icon` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `is_frame` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0', `path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `is_dept` bigint NULL DEFAULT 1, `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_sys_menu_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_sys_menu_update_by`(`update_by` ASC) USING BTREE, INDEX `idx_sys_menu_deleted_at`(`deleted_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 153 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_opera_log -- ---------------------------- DROP TABLE IF EXISTS `sys_opera_log`; CREATE TABLE `sys_opera_log` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作模块', `business_type` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作类型', `business_types` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'BusinessTypes', `method` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '函数', `request_method` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '请求方式 GET POST PUT DELETE', `operator_type` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作类型', `opera_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作者', `dept_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '机构名称', `opera_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '访问地址', `opera_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '客户端ip', `opera_location` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '访问位置', `opera_param` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '请求参数', `status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作状态 1:正常 2:关闭', `opera_time` datetime(3) NULL DEFAULT NULL COMMENT '操作时间', `json_result` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '返回数据', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `latency_time` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '耗时', `user_agent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'ua', `created_at` datetime(3) NULL DEFAULT NULL COMMENT '创建时间', `updated_at` datetime(3) NULL DEFAULT NULL COMMENT '最后更新时间', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_sys_opera_log_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_sys_opera_log_update_by`(`update_by` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6661 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_post -- ---------------------------- DROP TABLE IF EXISTS `sys_post`; CREATE TABLE `sys_post` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `post_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '岗位名称', `post_code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '岗位编码', `sort` tinyint NULL DEFAULT 0 COMMENT '排序', `status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '2' COMMENT '状态 1停用 2正常', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', `dept_id` bigint NULL DEFAULT NULL COMMENT '部门id', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_sys_post_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_sys_post_update_by`(`update_by` ASC) USING BTREE, INDEX `idx_sys_post_deleted_at`(`deleted_at` ASC) USING BTREE, INDEX `idx_sys_post_dept_id`(`dept_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_post_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_post_menu`; CREATE TABLE `sys_post_menu` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `post_id` bigint NULL DEFAULT NULL COMMENT '岗位ID', `menu_id` bigint NULL DEFAULT NULL COMMENT '菜单ID', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_sys_post_menu_post_id`(`post_id` ASC) USING BTREE, INDEX `idx_sys_post_menu_menu_id`(`menu_id` ASC) USING BTREE, INDEX `idx_sys_post_menu_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_sys_post_menu_update_by`(`update_by` ASC) USING BTREE, INDEX `idx_sys_post_menu_deleted_at`(`deleted_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2205 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_role -- ---------------------------- DROP TABLE IF EXISTS `sys_role`; CREATE TABLE `sys_role` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '2', `role_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `sort` bigint NULL DEFAULT NULL, `data_scope` bigint NULL DEFAULT NULL, `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', `dept_id` bigint NULL DEFAULT NULL COMMENT '部门id', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_sys_role_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_sys_role_update_by`(`update_by` ASC) USING BTREE, INDEX `idx_sys_role_deleted_at`(`deleted_at` ASC) USING BTREE, INDEX `idx_sys_role_dept_id`(`dept_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_role_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_role_menu`; CREATE TABLE `sys_role_menu` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `role_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '角色编码', `menu_id` bigint NULL DEFAULT NULL COMMENT '菜单id', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_sys_role_menu_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_sys_role_menu_update_by`(`update_by` ASC) USING BTREE, INDEX `idx_sys_role_menu_deleted_at`(`deleted_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_user -- ---------------------------- DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `uuid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'uuid', `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名', `password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码', `nick_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '昵称', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '手机号', `role_id` bigint NULL DEFAULT NULL COMMENT '角色ID', `salt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '加盐', `dept_id` bigint NULL DEFAULT NULL COMMENT '部门', `post_id` bigint NULL DEFAULT NULL COMMENT '岗位', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '2' COMMENT '状态', `type` bigint NULL DEFAULT NULL COMMENT '类型', `user_type` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户类型', `openid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '微信openid', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_sys_user_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_sys_user_update_by`(`update_by` ASC) USING BTREE, INDEX `idx_sys_user_deleted_at`(`deleted_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 104 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for waybill -- ---------------------------- DROP TABLE IF EXISTS `waybill`; CREATE TABLE `waybill` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `waybill_no` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `order_no` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `status` bigint NULL DEFAULT NULL, `sender_address_details` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `sender_address_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `sender_address_phone` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `consignee_address_details` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `consignee_address_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `consignee_address_phone` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `delivery_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `delivery_phone` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `delivery_id` bigint NULL DEFAULT NULL, `re_check_id` bigint NULL DEFAULT NULL, `remark` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `order_time` datetime(3) NULL DEFAULT NULL, `delivery_time` datetime(3) NULL DEFAULT NULL, `delivery_duration` bigint NULL DEFAULT NULL COMMENT '冷冻时长', `receipt_time` datetime(3) NULL DEFAULT NULL, `quantity` bigint NULL DEFAULT NULL, `cooler_box_id` bigint NULL DEFAULT NULL, `receipt_img` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `receiptsign` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `tamper_proof_label` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `tamper_proof_label_img` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `rejection_reason` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `send_log` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `child_waybills` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `ice_raft_code` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `assess_star` bigint NULL DEFAULT NULL, `assess_content` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `prescription_is_audit` bigint NULL DEFAULT 1, `invoice_is_audit` bigint NULL DEFAULT 1, `inspection_report_is_audit` bigint NULL DEFAULT 1, `dispensing_medicines_is_audit` bigint NULL DEFAULT 1, `is_cold` bigint NULL DEFAULT 1, `payment_status` bigint NULL DEFAULT 1, `payment_type` bigint NULL DEFAULT 0, `payment_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `assignment_status` bigint NULL DEFAULT 1, `audit_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `admin_audit_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `is_secondary_distribution` tinyint(1) NULL DEFAULT 0, `confirmer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `confirmer_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `prescription` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `is_child` tinyint(1) NULL DEFAULT 0, `secondary_time` datetime(3) NULL DEFAULT NULL COMMENT '分配时间', `ask_for_time` datetime(3) NULL DEFAULT NULL COMMENT '客户要求时间', `delivery_type` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '配送方式', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', `dept_id` bigint NULL DEFAULT NULL COMMENT '部门id', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_waybill_update_by`(`update_by` ASC) USING BTREE, INDEX `idx_waybill_deleted_at`(`deleted_at` ASC) USING BTREE, INDEX `idx_waybill_dept_id`(`dept_id` ASC) USING BTREE, INDEX `idx_waybill_create_by`(`create_by` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for waybill_logistics -- ---------------------------- DROP TABLE IF EXISTS `waybill_logistics`; CREATE TABLE `waybill_logistics` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `waybill_no` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `status` bigint NULL DEFAULT NULL, `cooler_box_id` bigint NULL DEFAULT NULL, `user_id` bigint NULL DEFAULT NULL, `lng` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `lat` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', `dept_id` bigint NULL DEFAULT NULL COMMENT '部门id', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_waybill_logistics_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_waybill_logistics_update_by`(`update_by` ASC) USING BTREE, INDEX `idx_waybill_logistics_deleted_at`(`deleted_at` ASC) USING BTREE, INDEX `idx_waybill_logistics_dept_id`(`dept_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for waybill_task -- ---------------------------- DROP TABLE IF EXISTS `waybill_task`; CREATE TABLE `waybill_task` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键编码', `waybill_no` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `cooler_box_id` bigint NULL DEFAULT NULL, `user_id` bigint NULL DEFAULT NULL, `sn` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `start_time` datetime(3) NULL DEFAULT NULL, `end_time` datetime(3) NULL DEFAULT NULL, `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间', `updated_at` timestamp NULL DEFAULT NULL COMMENT '最后更新时间', `deleted_at` datetime(3) NULL DEFAULT NULL COMMENT '删除时间', `dept_id` bigint NULL DEFAULT NULL COMMENT '部门id', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_waybill_task_dept_id`(`dept_id` ASC) USING BTREE, INDEX `idx_waybill_task_create_by`(`create_by` ASC) USING BTREE, INDEX `idx_waybill_task_update_by`(`update_by` ASC) USING BTREE, INDEX `idx_waybill_task_deleted_at`(`deleted_at` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1;