openspecimen_demo
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
create_specimen_stats_table
Parameters
Name
Type
Mode
Definition
begin drop table if exists tmp_specimen_stats; create table tmp_specimen_stats ( specimen_id bigint(19) not null, collector_id bigint(19) default null, collection_procedure varchar(255) default null, collection_container varchar(255) default null, collection_time datetime null default null, receiver_id bigint(19) default null, received_quality varchar(255) default null, received_time datetime null default null, frozen_time datetime null default null, processing_time bigint(19) default null, ischemia_time bigint(19) default null, aliquot_seq bigint(19) default null ); end