Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.mgi_dbinfo
This table has one and only one record which contains information about the database such as the public version name, the product name, the last time the database was dumped.

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
public_version text 2147483647 public version
product_name text 2147483647 product name
schema_version text 2147483647 schema version
snp_schema_version text 2147483647 snp schema version
snp_data_version text 2147483647 snp data version
lastdump_date timestamp 29,6 now() date of last database dump
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 1 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
public_version Primary key Asc mgi_dbinfo_pkey
public_version Primary key Asc mgi_dbinfo_pkey
public_version Primary key Asc mgi_dbinfo_pkey