Table homo_sapiens_core_98_38.analysis 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
analysis_id smallint unsigned 5  √ 
analysis_description.analysis_id Implied Constraint R
data_file.analysis_id Implied Constraint R
density_type.analysis_id Implied Constraint R
ditag_feature.analysis_id Implied Constraint R
dna_align_feature.analysis_id Implied Constraint R
gene.analysis_id Implied Constraint R
intron_supporting_evidence.analysis_id Implied Constraint R
marker_feature.analysis_id Implied Constraint R
object_xref.analysis_id Implied Constraint R
operon.analysis_id Implied Constraint R
operon_transcript.analysis_id Implied Constraint R
prediction_transcript.analysis_id Implied Constraint R
protein_align_feature.analysis_id Implied Constraint R
protein_feature.analysis_id Implied Constraint R
repeat_feature.analysis_id Implied Constraint R
simple_feature.analysis_id Implied Constraint R
transcript.analysis_id Implied Constraint R
unmapped_object.analysis_id Implied Constraint R
created datetime 19  √  null
logic_name varchar 128
db varchar 120  √  null
db_version varchar 40  √  null
db_file varchar 120  √  null
program varchar 80  √  null
program_version varchar 40  √  null
program_file varchar 80  √  null
parameters text 65535  √  null
module varchar 80  √  null
module_version varchar 40  √  null
gff_source varchar 40  √  null
gff_feature varchar 40  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
analysis_id Primary key Asc PRIMARY
logic_name Must be unique Asc logic_name_idx

Close relationships: