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
SchemaSpy
Legend: SourceForge.net
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 108,924 rows at Mon Nov 20 05:26 EST 2017

Indexes:
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: