Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.acc_actualdb
Defines physical location, by URL, of an external data resource. Used to dynamically construct HTML links for the Web interface.

Detail table of ACC_LogicalDB.

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
_actualdb_key int4 10 primary key
_logicaldb_key int4 10
acc_logicaldb._logicaldb_key acc_actualdb__logicaldb_key_fkey C
foreign key to ACC_LogicalDB
name text 2147483647 name of the actual database; the HTML label that appears in the WI
active int2 5 should the link be constructed? yes (1), no (0)
url text 2147483647 template of the URL; includes place holder string of '@@@@'. during construction of the full URL, the '@@@@' will be replaced by the appropriate term (accession number, symbol, etc.)
allowsmultiple int2 5 does the URL support a query using more than one accession number? yes (1), no (0)
delimiter bpchar 8  √  null the delimiter which separates multiple accession numbers; used when construcuting the full URL.
_createdby_key int4 10 1001
mgi_user._user_key acc_actualdb__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key acc_actualdb__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 122 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_actualdb_key Primary key, Used to cluster data Asc acc_actualdb_pkey
_logicaldb_key Performance Asc acc_actualdb_idx_logicaldb_key
name Performance Asc acc_actualdb_idx_name

Close relationships  within of separation: