museums/yudao-module-museums/yudao-module-museums-biz/src/test/resources/create_tables.sql

CREATE TABLE IF NOT EXISTS "museums_specimen_outbound" (
                                                           "id" int NOT NULL GENERATED BY DEFAULT AS IDENTITY,
                                                           "info_id" varchar NOT NULL,
                                                           "chinese_name" varchar NOT NULL,
                                                           "specimen_number" varchar NOT NULL,
                                                           "applicant_name" varchar NOT NULL,
                                                           "application_date" varchar,
                                                           "application_usage" varchar NOT NULL,
                                                           "attachments" varchar,
                                                           "status" int,
                                                           "remarks" varchar,
                                                           "process_instance_id" varchar,
                                                           "operator" varchar NOT NULL,
                                                           "outgoing_time" varchar,
                                                           "returner" varchar NOT NULL,
                                                           "receiver" varchar NOT NULL,
                                                           "return_date" varchar NOT NULL,
                                                           "specimen_condition" varchar,
                                                           "creator" varchar DEFAULT '',
                                                           "create_time" datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
                                                           "updater" varchar DEFAULT '',
                                                           "update_time" datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                                                           "deleted" bit NOT NULL DEFAULT FALSE,
                                                           "tenant_id" bigint NOT NULL DEFAULT 0,
                                                           "sample_status" int,
                                                           PRIMARY KEY ("id")
    ) COMMENT '标本出库回库信息表';