Table homo_sapiens_core_98_38.data_file 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
data_file_id int unsigned 10  √ 
coord_system_id int unsigned 10
coord_system.coord_system_id Implied Constraint R
analysis_id smallint unsigned 5
analysis.analysis_id Implied Constraint R
name varchar 100
version_lock bit 0 0
absolute bit 0 0
url text 65535  √  null
file_type enum 6  √  null

Table contained 0 rows at Wed Nov 27 11:43 CET 2019

Indexes:
Column(s) Type Sort Constraint Name
data_file_id Primary key Asc PRIMARY
analysis_id Performance Asc df_analysis_idx
name Performance Asc df_name_idx
coord_system_id + analysis_id + name + file_type Must be unique Asc/Asc/Asc/Asc df_unq_idx

Close relationships: