Table homo_sapiens_core_98_38.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 6
analysis_id smallint unsigned 5
analysis.analysis_id Implied Constraint R
external_db_id int unsigned 10  √  null
external_db.external_db_id Implied Constraint R
identifier varchar 255
unmapped_reason_id int unsigned 10
unmapped_reason.unmapped_reason_id Implied Constraint R
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 1,006,960 rows at Wed Nov 27 11:43 CET 2019

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
external_db_id + identifier Performance Asc/Asc ext_db_identifier_idx
identifier Performance Asc id_idx
ensembl_id + ensembl_object_type + identifier + unmapped_reason_id + parent + external_db_id Must be unique Asc/Asc/Asc/Asc/Asc/Asc unique_unmapped_obj_idx

Close relationships: