Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
Table pub.mgd.mgi_measurement
A record in this table represents the measurement for a particular type of statistic

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_measurement__statistic_key_fkey C
FK to MGI_Statistic, indicating which statistic we are measuring
timerecorded timestamp 29,6 now() date/time at which the measurement was taken
intvalue int4 10  √  null the measurement itself (if the value is an integer), or null if it is a float
floatvalue numeric 131089  √  null the measurement itself (if the value is a float), or null if it is an integer
islatest int4 10 flag to indicate whether this measurement is the most recent for this statistic (1) or not (0); is an int so it can be indexed

Table contained 115,196 rows at Mon May 07 06:18 EDT 2018

Column(s) Type Sort Constraint Name
_statistic_key + timerecorded Primary key, Used to cluster data Asc/Asc mgi_measurement_pkey
islatest + _statistic_key Performance Asc/Asc mgi_measurement_idx_islatest

Close relationships  within of separation: