openspecimen
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 not null, collector_id bigint default null, collection_procedure_id bigint default null, collection_container_id bigint default null, collection_time datetime null default null, receiver_id bigint default null, received_quality_id bigint default null, received_time datetime null default null, frozen_time datetime null default null, processing_time bigint default null, ischemia_time bigint default null, specimen_seq mediumint default null ); end