Table homo_sapiens_core_52_36n.unmapped_object 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
unmapped_object_id int unsigned 10  √ 
type enum 16 xref
analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
external_db_id smallint unsigned 5  √  null
external_db.external_db_id Implied Constraint
identifier varchar 255
unmapped_reason_id smallint unsigned 5 0
unmapped_reason.unmapped_reason_id Implied Constraint
query_score double 22  √  null
target_score double 22  √  null
ensembl_id int unsigned 10  √  0
ensembl_object_type enum 11  √  RawContig
parent varchar 255  √  null

Table contained 0 rows at ma maalis 23 00:31 EET 2009

Indexes:
Column(s) Type Sort Constraint Name
unmapped_object_id Primary key Asc PRIMARY
analysis_id + external_db_id Performance Asc/Asc anal_exdb_idx
analysis_id Performance Asc anal_idx
identifier Performance Asc id_idx

Close relationships: