Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
Table pub.mgd.mgi_statisticsql
Each statistic (see MGI_Statistic) can have an associated SQL statement that is used to compute a measurement. That SQL statement may be split into multiple records in this table, with each record being one chunk of text to be concatenated together.

Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
_statistic_key int4 10
mgi_statistic._statistic_key mgi_statisticsql__statistic_key_fkey C
FK to MGI_Statistic, indicating the statistic for which we are defining the SQL
sequencenum int4 10 integer value to use in ordering the various records (SQL chunks) for a statistic's SQL
sqlchunk text 2147483647 portion of the SQL statement for computing a measurement of this statistic

Table contained 56 rows at Thu Dec 21 05:31 EST 2017

Column(s) Type Sort Constraint Name
_statistic_key + sequencenum Primary key, Used to cluster data Asc/Asc mgi_statisticsql_pkey

Close relationships  within of separation: