zkxw/docs/sql/biz_storage_release_review.sql

-- ============================================================
-- 入库放行审核 biz_storage_release_review
-- Date: 2026-05-23
-- ============================================================

SET NAMES utf8mb4;

-- ----------------------------
-- Table structure for biz_storage_release_review
-- ----------------------------
DROP TABLE IF EXISTS `biz_storage_release_review`;
CREATE TABLE `biz_storage_release_review` (
  `id`                  VARCHAR(64)  NOT NULL COMMENT '主键ID',
  `sample_code`         VARCHAR(64)  NOT NULL COMMENT '样本编码（关联键）',
  `reception_source`    VARCHAR(32)  NOT NULL COMMENT '来源：cell_storage=采集/research_donation=捐赠',
  `protocol_id`         VARCHAR(64)  DEFAULT NULL COMMENT '协议单ID',
  `reception_id`        VARCHAR(64)  DEFAULT NULL COMMENT '样本接收记录ID',
  `protocol_no`         VARCHAR(64)  DEFAULT NULL COMMENT '协议编号',
  `sample_name`         VARCHAR(128) DEFAULT NULL COMMENT '样本名称',
  `review_conclusion`   VARCHAR(16)  DEFAULT NULL COMMENT '审核结论：tg=通过/btg=不通过/NULL=待审核',
  `review_remark`       VARCHAR(512) DEFAULT NULL COMMENT '审核备注',
  `review_attachments`  VARCHAR(4000) DEFAULT NULL COMMENT '审核附件（逗号分隔URL）',
  `review_by`           VARCHAR(64)  DEFAULT NULL COMMENT '审核人ID',
  `review_by_name`      VARCHAR(64)  DEFAULT NULL COMMENT '审核人姓名',
  `review_time`         DATETIME     DEFAULT NULL COMMENT '审核时间',
  `storage_status`      VARCHAR(16)  NOT NULL DEFAULT 'drk' COMMENT '入库状态：drk=待入库/yrk=已入库',
  `storage_by`          VARCHAR(64)  DEFAULT NULL COMMENT '入库操作人ID',
  `storage_by_name`     VARCHAR(64)  DEFAULT NULL COMMENT '入库操作人姓名',
  `storage_time`        DATETIME     DEFAULT NULL COMMENT '入库时间',
  `tenant_no`           VARCHAR(64)  NOT NULL DEFAULT '' COMMENT '租户编号',
  `order_num`           INT(11)      DEFAULT NULL COMMENT '排序号',
  `remark`              VARCHAR(512) DEFAULT NULL COMMENT '备注',
  `create_by`           VARCHAR(64)  DEFAULT NULL COMMENT '创建人ID',
  `create_dept_id`      VARCHAR(64)  NOT NULL DEFAULT '' COMMENT '创建人部门ID',
  `create_time`         DATETIME     NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by`           VARCHAR(64)  DEFAULT NULL COMMENT '更新人ID',
  `update_time`         DATETIME     NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag`            TINYINT(4)   NOT NULL DEFAULT 0 COMMENT '删除标记：0-正常 1-已删除',
  PRIMARY KEY (`id`),
  KEY `idx_srr_sample`   (`tenant_no`, `sample_code`, `del_flag`),
  KEY `idx_srr_protocol` (`tenant_no`, `protocol_id`, `del_flag`),
  KEY `idx_srr_status`   (`tenant_no`, `review_conclusion`, `storage_status`, `del_flag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='入库放行审核';

-- ----------------------------
-- Menu entry: 入库放行审核 (under 质量检测)
-- ----------------------------
-- 父菜单: 质量检测 id=70000000000000000000000000000001
-- 新菜单 ID: 70000000000000000000000000000011 (递增)
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `menu_type`, `path`, `component`, `perms`, `is_frame`, `visible`, `status`, `tenant_no`, `order_num`, `remark`, `create_by`, `create_dept_id`, `create_time`, `update_by`, `update_time`, `del_flag`)
VALUES ('70000000000000000000000000000011', '入库放行审核', '70000000000000000000000000000001', 'C', 'storage-release-review', '/quality-inspection/storage-release-review/index', 'biz:storageReleaseReview:list', 1, '1', '1', 'zkxw', 10, NULL, NULL, '', NOW(), NULL, NOW(), 0);