Table homo_sapiens_core_52_36n.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
density_type.analysis_id Implied Constraint
ditag_feature.analysis_id Implied Constraint
dna_align_feature.analysis_id Implied Constraint
gene.analysis_id Implied Constraint
identity_xref.analysis_id Implied Constraint
marker_feature.analysis_id Implied Constraint
oligo_feature.analysis_id Implied Constraint
prediction_transcript.analysis_id Implied Constraint
protein_align_feature.analysis_id Implied Constraint
protein_feature.analysis_id Implied Constraint
qtl_feature.analysis_id Implied Constraint
repeat_feature.analysis_id Implied Constraint
simple_feature.analysis_id Implied Constraint
transcript.analysis_id Implied Constraint
unmapped_object.analysis_id Implied Constraint
created datetime 0 0000-00-00 00:00:00
logic_name varchar 40
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 61 rows at ma maalis 23 00:31 EET 2009

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

Close relationships: