openspecimen
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
refresh_specimen_stats
Parameters
Name
Type
Mode
Definition
begin call create_specimen_stats_table(); call populate_specimen_stats(); drop table if exists os_specimen_stats; alter table tmp_specimen_stats rename os_specimen_stats; create index os_specimen_stats_idx on os_specimen_stats (specimen_id); end