Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.mgi_refassoctype
A record in this table represents a Reference Association Type (e.g. General, Original).

 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
_refassoctype_key int4 10
mgi_reference_allele_view._refassoctype_key Implied Constraint R
mgi_reference_allelevariant_view._refassoctype_key Implied Constraint R
mgi_reference_antibody_view._refassoctype_key Implied Constraint R
mgi_reference_assoc._refassoctype_key mgi_reference_assoc__refassoctype_key_fkey R
mgi_reference_marker_view._refassoctype_key Implied Constraint R
mgi_reference_sequence_view._refassoctype_key Implied Constraint R
mgi_reference_strain_view._refassoctype_key Implied Constraint R
mgi_reftype_allele_view._refassoctype_key Implied Constraint R
mgi_reftype_antibody_view._refassoctype_key Implied Constraint R
mgi_reftype_marker_view._refassoctype_key Implied Constraint R
mgi_reftype_sequence_view._refassoctype_key Implied Constraint R
mgi_reftype_strain_view._refassoctype_key Implied Constraint R
primary key
_mgitype_key int4 10  √  null
acc_mgitype._mgitype_key mgi_refassoctype__mgitype_key_fkey R
foreign key to ACC_MGIType
assoctype text 2147483647 name of this reference association type (ex. "General").
allowonlyone int2 5 does this reference type allow only one association?
_createdby_key int4 10 1001
mgi_user._user_key mgi_refassoctype__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key mgi_refassoctype__modifiedby_key_fkey R
user who last modified the record
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 24 rows at Mon Mar 09 10:28 EDT 2020

Indexes:
Column(s) Type Sort Constraint Name
_refassoctype_key Primary key, Used to cluster data Asc mgi_refassoctype_pkey
_createdby_key Performance Asc mgi_refassoctype_idx_createdby_key
_mgitype_key Performance Asc mgi_refassoctype_idx_mgitype_key
_modifiedby_key Performance Asc mgi_refassoctype_idx_modifiedby_key

Close relationships  within of separation: