SchemaSpy Analysis of homo_sapiens_core_52_36n - Columns Generated by
SchemaSpy
Generated by SchemaSpy on ma maalis 23 00:31 EET 2009
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

homo_sapiens_core_52_36n contains 431 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Children Parents Comments
analysis created datetime 0 0000-00-00 00:00:00
mapping_session created datetime 0 0000-00-00 00:00:00
exon_stable_id created_date datetime 0 0000-00-00 00:00:00
gene_stable_id created_date datetime 0 0000-00-00 00:00:00
transcript_stable_id created_date datetime 0 0000-00-00 00:00:00
translation_stable_id created_date datetime 0 0000-00-00 00:00:00
external_db dbprimary_acc_linkable bit 0 1
external_db display_label_linkable bit 0 0
analysis_description displayable bit 0 1
ditag_feature hit_strand bit 0 0
dna_align_feature hit_strand bit 0 0
exon is_current bit 0 1
gene is_current bit 0 1
transcript is_current bit 0 1
exon_stable_id modified_date datetime 0 0000-00-00 00:00:00
gene_stable_id modified_date datetime 0 0000-00-00 00:00:00
transcript_stable_id modified_date datetime 0 0000-00-00 00:00:00
translation_stable_id modified_date datetime 0 0000-00-00 00:00:00
ditag_feature seq_region_strand bit 0 0
dna_align_feature seq_region_strand bit 0 0
protein_align_feature seq_region_strand bit 0 0
repeat_feature seq_region_strand bit 0 1
simple_feature seq_region_strand bit 0 0
ditag_feature ditag_side enum 2 F
exon end_phase tinyint 3 0
go_xref linkage_type enum 3 IC
oligo_feature mismatches tinyint 3  √  null
assembly ori tinyint 3 0
exon phase tinyint 3 0
oligo_array probe_setsize tinyint 3 0
exon seq_region_strand tinyint 3 0
gene seq_region_strand tinyint 3 0
misc_feature seq_region_strand tinyint 3 0
oligo_feature seq_region_strand tinyint 3 0
prediction_exon seq_region_strand tinyint 3 0
prediction_transcript seq_region_strand tinyint 3 0
transcript seq_region_strand tinyint 3 0
prediction_exon start_phase tinyint 3 0
assembly_exception exc_type enum 4 HAP
analysis 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
analysis_description analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
density_type analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
ditag_feature analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
dna_align_feature analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
gene analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
identity_xref analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
marker_feature analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
oligo_feature analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
prediction_transcript analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
protein_align_feature analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
protein_feature analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
qtl_feature analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
repeat_feature analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
simple_feature analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
transcript analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
unmapped_object analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
attrib_type attrib_type_id smallint unsigned 5  √ 
gene_attrib.attrib_type_id Implied Constraint
misc_attrib.attrib_type_id Implied Constraint
seq_region_attrib.attrib_type_id Implied Constraint
transcript_attrib.attrib_type_id Implied Constraint
translation_attrib.attrib_type_id Implied Constraint
gene_attrib attrib_type_id smallint unsigned 5 0
attrib_type.attrib_type_id Implied Constraint
misc_attrib attrib_type_id smallint unsigned 5 0
attrib_type.attrib_type_id Implied Constraint
seq_region_attrib attrib_type_id smallint unsigned 5 0
attrib_type.attrib_type_id Implied Constraint
transcript_attrib attrib_type_id smallint unsigned 5 0
attrib_type.attrib_type_id Implied Constraint
translation_attrib attrib_type_id smallint unsigned 5 0
attrib_type.attrib_type_id Implied Constraint
prediction_exon exon_rank smallint unsigned 5 0
dna_align_feature external_db_id smallint unsigned 5  √  null
external_db.external_db_id Implied Constraint
external_db external_db_id smallint unsigned 5 0
dna_align_feature.external_db_id Implied Constraint
protein_align_feature.external_db_id Implied Constraint
unmapped_object.external_db_id Implied Constraint
xref.external_db_id Implied Constraint
protein_align_feature external_db_id smallint unsigned 5  √  null
external_db.external_db_id Implied Constraint
unmapped_object external_db_id smallint unsigned 5  √  null
external_db.external_db_id Implied Constraint
xref external_db_id smallint unsigned 5 0
external_db.external_db_id Implied Constraint
gene_archive gene_version smallint 5 0
oligo_probe length smallint 5 0
misc_feature_misc_set misc_set_id smallint unsigned 5 0
misc_set.misc_set_id Implied Constraint
misc_set misc_set_id smallint unsigned 5  √ 
misc_feature_misc_set.misc_set_id Implied Constraint
mapping_session new_release varchar 5
stable_id_event new_version smallint 5  √  null
mapping_session old_release varchar 5
stable_id_event old_version smallint 5  √  null
ditag tag_count smallint unsigned 5 1
gene_archive transcript_version smallint 5 0
gene_archive translation_version smallint 5 0
oligo_array type enum 5  √  null
unmapped_object unmapped_reason_id smallint unsigned 5 0
unmapped_reason.unmapped_reason_id Implied Constraint
unmapped_reason unmapped_reason_id smallint unsigned 5  √ 
unmapped_object.unmapped_reason_id Implied Constraint
density_type value_type enum 5 sum
alt_allele alt_allele_id int unsigned 10  √ 
assembly asm_end int 10 0
assembly asm_seq_region_id int unsigned 10 0
assembly asm_start int 10 0
assembly_exception assembly_exception_id int unsigned 10  √ 
density_type block_size int 10 0
gene canonical_transcript_id int unsigned 10
assembly cmp_end int 10 0
assembly cmp_seq_region_id int unsigned 10 0
assembly cmp_start int 10 0
coord_system coord_system_id int unsigned 10  √ 
meta_coord.coord_system_id Implied Constraint
seq_region.coord_system_id Implied Constraint
meta_coord coord_system_id int unsigned 10 0
coord_system.coord_system_id Implied Constraint
seq_region coord_system_id int unsigned 10 0
coord_system.coord_system_id Implied Constraint
density_feature density_feature_id int unsigned 10  √ 
density_feature density_type_id int unsigned 10 0
density_type.density_type_id Implied Constraint
density_type density_type_id int unsigned 10  √ 
density_feature.density_type_id Implied Constraint
marker display_marker_synonym_id int unsigned 10  √  null
gene display_xref_id int unsigned 10  √  null
transcript display_xref_id int unsigned 10  √  null
ditag_feature ditag_feature_id int unsigned 10  √ 
ditag ditag_id int unsigned 10  √ 
ditag_feature.ditag_id Implied Constraint
ditag_feature ditag_id int unsigned 10 0
ditag.ditag_id Implied Constraint
ditag_feature ditag_pair_id int unsigned 10 0
dna_align_feature dna_align_feature_id int unsigned 10  √ 
translation end_exon_id int unsigned 10 0
object_xref ensembl_id int unsigned 10 0
unmapped_object ensembl_id int unsigned 10  √  0
assembly_exception exc_seq_region_end int unsigned 10 0
assembly_exception exc_seq_region_id int unsigned 10 0
assembly_exception exc_seq_region_start int unsigned 10 0
exon exon_id int unsigned 10  √ 
exon_stable_id.exon_id Implied Constraint
exon_stable_id exon_id int unsigned 10 0
exon.exon_id Implied Constraint
exon_transcript.exon_id Implied Constraint
supporting_feature.exon_id Implied Constraint
exon_transcript exon_id int unsigned 10 0
exon_stable_id.exon_id Implied Constraint
supporting_feature exon_id int unsigned 10 0
exon_stable_id.exon_id Implied Constraint
seq_region_mapping external_seq_region_id int unsigned 10
supporting_feature feature_id int unsigned 10 0
transcript_supporting_feature feature_id int unsigned 10 0
qtl flank_marker_id_1 int unsigned 10  √  null
qtl flank_marker_id_2 int unsigned 10  √  null
alt_allele gene_id int unsigned 10 0
gene.gene_id Implied Constraint
gene gene_id int unsigned 10  √ 
alt_allele.gene_id Implied Constraint
gene_attrib.gene_id Implied Constraint
gene_stable_id.gene_id Implied Constraint
transcript.gene_id Implied Constraint
unconventional_transcript_association.gene_id Implied Constraint
gene_attrib gene_id int unsigned 10 0
gene.gene_id Implied Constraint
gene_stable_id gene_id int unsigned 10 0
gene.gene_id Implied Constraint
transcript gene_id int unsigned 10  √  null
gene.gene_id Implied Constraint
unconventional_transcript_association gene_id int unsigned 10 0
gene.gene_id Implied Constraint
ditag_feature hit_end int unsigned 10 0
dna_align_feature hit_end int 10 0
identity_xref hit_end int 10  √  null
protein_align_feature hit_end int 10
protein_feature hit_end int 10 0
ditag_feature hit_start int unsigned 10 0
dna_align_feature hit_start int 10 0
identity_xref hit_start int 10  √  null
protein_align_feature hit_start int 10
protein_feature hit_start int 10 0
seq_region_mapping internal_seq_region_id int unsigned 10
karyotype karyotype_id int unsigned 10  √ 
seq_region length int 10 0
map map_id int unsigned 10  √ 
marker_map_location.map_id Implied Constraint
marker_map_location map_id int unsigned 10 0
map.map_id Implied Constraint
marker_feature map_weight int unsigned 10  √  null
gene_archive mapping_session_id int unsigned 10 0
mapping_session.mapping_session_id Implied Constraint
mapping_session mapping_session_id int unsigned 10  √ 
gene_archive.mapping_session_id Implied Constraint
stable_id_event.mapping_session_id Implied Constraint
stable_id_event mapping_session_id int unsigned 10 0
mapping_session.mapping_session_id Implied Constraint
mapping_set mapping_set_id int unsigned 10
seq_region_mapping mapping_set_id int unsigned 10
marker_feature marker_feature_id int unsigned 10  √ 
marker marker_id int unsigned 10  √ 
marker_feature.marker_id Implied Constraint
marker_map_location.marker_id Implied Constraint
marker_synonym.marker_id Implied Constraint
marker_feature marker_id int unsigned 10 0
marker.marker_id Implied Constraint
marker_map_location marker_id int unsigned 10 0
marker.marker_id Implied Constraint
marker_synonym marker_id int unsigned 10 0
marker.marker_id Implied Constraint
marker_map_location marker_synonym_id int unsigned 10 0
marker_synonym.marker_synonym_id Implied Constraint
marker_synonym marker_synonym_id int unsigned 10  √ 
marker_map_location.marker_synonym_id Implied Constraint
meta_coord max_length int 10  √  null
misc_set max_length int unsigned 10 0
marker max_primer_dist int unsigned 10 0
meta meta_id int 10  √ 
marker min_primer_dist int unsigned 10 0
misc_attrib misc_feature_id int unsigned 10 0
misc_feature.misc_feature_id Implied Constraint
misc_feature misc_feature_id int unsigned 10  √ 
misc_attrib.misc_feature_id Implied Constraint
misc_feature_misc_set.misc_feature_id Implied Constraint
misc_feature_misc_set misc_feature_id int unsigned 10 0
misc_feature.misc_feature_id Implied Constraint
go_xref object_xref_id int unsigned 10 0
identity_xref.object_xref_id Implied Constraint
identity_xref object_xref_id int unsigned 10 0
go_xref.object_xref_id Implied Constraint
object_xref.object_xref_id Implied Constraint
object_xref object_xref_id int unsigned 10  √ 
identity_xref.object_xref_id Implied Constraint
oligo_array oligo_array_id int unsigned 10  √ 
oligo_probe.oligo_array_id Implied Constraint
oligo_probe oligo_array_id int unsigned 10 0
oligo_array.oligo_array_id Implied Constraint
oligo_feature oligo_feature_id int unsigned 10  √ 
oligo_feature oligo_probe_id int unsigned 10 0
oligo_probe oligo_probe_id int unsigned 10  √ 
assembly_exception ori int 10 0
dna_align_feature pair_dna_align_feature_id int unsigned 10  √  null
oligo_array parent_array_id int unsigned 10  √  null
qtl peak_marker_id int unsigned 10  √  null
gene_archive peptide_archive_id int unsigned 10 0
peptide_archive.peptide_archive_id Implied Constraint
peptide_archive peptide_archive_id int unsigned 10  √ 
gene_archive.peptide_archive_id Implied Constraint
prediction_exon prediction_exon_id int unsigned 10  √ 
prediction_exon prediction_transcript_id int unsigned 10 0
prediction_transcript.prediction_transcript_id Implied Constraint
prediction_transcript prediction_transcript_id int unsigned 10  √ 
prediction_exon.prediction_transcript_id Implied Constraint
external_db priority int 10 0
marker priority int 10  √  null
protein_align_feature protein_align_feature_id int unsigned 10  √ 
protein_feature protein_feature_id int unsigned 10  √ 
qtl qtl_id int unsigned 10  √ 
qtl_feature.qtl_id Implied Constraint
qtl_synonym.qtl_id Implied Constraint
qtl_feature qtl_id int unsigned 10 0
qtl.qtl_id Implied Constraint
qtl_synonym qtl_id int unsigned 10 0
qtl.qtl_id Implied Constraint
qtl_synonym qtl_synonym_id int unsigned 10  √ 
identity_xref query_identity int 10  √  null
coord_system rank int 10 0
exon_transcript rank int 10 0
density_type region_features int 10 0
repeat_consensus repeat_consensus_id int unsigned 10  √ 
repeat_feature.repeat_consensus_id Implied Constraint
repeat_feature repeat_consensus_id int unsigned 10 0
repeat_consensus.repeat_consensus_id Implied Constraint
repeat_feature repeat_end int 10 0
repeat_feature repeat_feature_id int unsigned 10  √ 
repeat_feature repeat_start int 10 0
protein_feature seq_end int 10 0
translation seq_end int 10 0
assembly_exception seq_region_end int unsigned 10 0
density_feature seq_region_end int unsigned 10 0
ditag_feature seq_region_end int unsigned 10 0
dna_align_feature seq_region_end int unsigned 10 0
exon seq_region_end int unsigned 10 0
gene seq_region_end int unsigned 10 0
karyotype seq_region_end int 10 0
marker_feature seq_region_end int unsigned 10 0
misc_feature seq_region_end int unsigned 10 0
oligo_feature seq_region_end int unsigned 10 0
prediction_exon seq_region_end int unsigned 10 0
prediction_transcript seq_region_end int unsigned 10 0
protein_align_feature seq_region_end int unsigned 10 0
qtl_feature seq_region_end int unsigned 10 0
repeat_feature seq_region_end int unsigned 10 0
simple_feature seq_region_end int unsigned 10 0
transcript seq_region_end int unsigned 10 0
assembly_exception seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
density_feature seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
ditag_feature seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
dna seq_region_id int unsigned 10 0
assembly_exception.seq_region_id Implied Constraint
density_feature.seq_region_id Implied Constraint
ditag_feature.seq_region_id Implied Constraint
dna_align_feature.seq_region_id Implied Constraint
dnac.seq_region_id Implied Constraint
exon.seq_region_id Implied Constraint
gene.seq_region_id Implied Constraint
karyotype.seq_region_id Implied Constraint
marker_feature.seq_region_id Implied Constraint
misc_feature.seq_region_id Implied Constraint
oligo_feature.seq_region_id Implied Constraint
prediction_exon.seq_region_id Implied Constraint
prediction_transcript.seq_region_id Implied Constraint
protein_align_feature.seq_region_id Implied Constraint
qtl_feature.seq_region_id Implied Constraint
repeat_feature.seq_region_id Implied Constraint
seq_region.seq_region_id Implied Constraint
seq_region_attrib.seq_region_id Implied Constraint
simple_feature.seq_region_id Implied Constraint
transcript.seq_region_id Implied Constraint
dna_align_feature seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
dnac seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
exon seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
gene seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
karyotype seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
marker_feature seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
misc_feature seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
oligo_feature seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
prediction_exon seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
prediction_transcript seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
protein_align_feature seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
qtl_feature seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
repeat_feature seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
seq_region seq_region_id int unsigned 10  √ 
dna.seq_region_id Implied Constraint
seq_region_attrib seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
simple_feature seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
transcript seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
assembly_exception seq_region_start int unsigned 10 0
density_feature seq_region_start int unsigned 10 0
ditag_feature seq_region_start int unsigned 10 0
dna_align_feature seq_region_start int unsigned 10 0
exon seq_region_start int unsigned 10 0
gene seq_region_start int unsigned 10 0
karyotype seq_region_start int 10 0
marker_feature seq_region_start int unsigned 10 0
misc_feature seq_region_start int unsigned 10 0
oligo_feature seq_region_start int unsigned 10 0
prediction_exon seq_region_start int unsigned 10 0
prediction_transcript seq_region_start int unsigned 10 0
protein_align_feature seq_region_start int unsigned 10 0
qtl_feature seq_region_start int unsigned 10 0
repeat_feature seq_region_start int unsigned 10 0
simple_feature seq_region_start int unsigned 10 0
transcript seq_region_start int unsigned 10 0
protein_feature seq_start int 10 0
translation seq_start int 10 0
simple_feature simple_feature_id int unsigned 10  √ 
go_xref source_xref_id int unsigned 10  √  null
coord_system species_id int unsigned 10 1
meta species_id int unsigned 10  √  1
translation start_exon_id int unsigned 10 0
external_db status enum 10 KNOWNXREF
identity_xref target_identity int 10  √  null
exon_transcript transcript_id int unsigned 10 0
transcript.transcript_id Implied Constraint
transcript transcript_id int unsigned 10  √ 
exon_transcript.transcript_id Implied Constraint
transcript_attrib.transcript_id Implied Constraint
transcript_stable_id.transcript_id Implied Constraint
transcript_supporting_feature.transcript_id Implied Constraint
translation.transcript_id Implied Constraint
unconventional_transcript_association.transcript_id Implied Constraint
transcript_attrib transcript_id int unsigned 10 0
transcript.transcript_id Implied Constraint
transcript_stable_id transcript_id int unsigned 10 0
transcript.transcript_id Implied Constraint
transcript_supporting_feature transcript_id int unsigned 10 0
transcript.transcript_id Implied Constraint
translation transcript_id int unsigned 10 0
transcript.transcript_id Implied Constraint
unconventional_transcript_association transcript_id int unsigned 10 0
transcript.transcript_id Implied Constraint
identity_xref translation_end int 10  √  null
protein_feature translation_id int unsigned 10 0
translation.translation_id Implied Constraint
translation translation_id int unsigned 10  √ 
protein_feature.translation_id Implied Constraint
translation_attrib.translation_id Implied Constraint
translation_stable_id.translation_id Implied Constraint
translation_attrib translation_id int unsigned 10 0
translation.translation_id Implied Constraint
translation_stable_id translation_id int unsigned 10 0
translation.translation_id Implied Constraint
identity_xref translation_start int 10  √  null
unmapped_object unmapped_object_id int unsigned 10  √ 
exon_stable_id version int 10  √  null
gene_stable_id version int 10  √  null
transcript_stable_id version int 10  √  null
translation_stable_id version int 10  √  null
xref version varchar 10 0
external_synonym xref_id int unsigned 10 0
xref.xref_id Implied Constraint
object_xref xref_id int unsigned 10 0
xref.xref_id Implied Constraint
xref xref_id int unsigned 10  √ 
external_synonym.xref_id Implied Constraint
object_xref.xref_id Implied Constraint
object_xref ensembl_object_type enum 11
unmapped_object ensembl_object_type enum 11  √  RawContig
stable_id_event type enum 11 gene
density_feature density_value float 12 0
qtl lod_score float 12  √  null
dna_align_feature perc_ident float 12  √  null
protein_align_feature perc_ident float 12  √  null
protein_feature perc_ident float 12  √  null
stable_id_event score float 12 0
marker type enum 14  √  null
marker_map_location chromosome_name varchar 15
attrib_type code varchar 15
marker_map_location position varchar 15
unmapped_object type enum 16 xref
xref info_type enum 18  √  null
external_db type enum 18  √  null
gene status enum 19  √  null
transcript status enum 19  √  null
oligo_probe name varchar 20  √  null
mapping_session new_assembly varchar 20
mapping_session old_assembly varchar 20
mapping_set schema_build varchar 20
gene source varchar 20
marker_synonym source varchar 20  √  null
qtl_synonym source_database enum 20 rat genome database
supporting_feature feature_type enum 21  √  null
transcript_supporting_feature feature_type enum 21  √  null
dna_align_feature evalue double 22  √  null
identity_xref evalue double 22  √  null
protein_align_feature evalue double 22  √  null
protein_feature evalue double 22  √  null
dna_align_feature hcoverage double 22  √  null
protein_align_feature hcoverage double 22  √  null
marker_map_location lod_score double 22  √  null
prediction_exon p_value double 22  √  null
unmapped_object query_score double 22  √  null
dna_align_feature score double 22  √  null
identity_xref score double 22  √  null
prediction_exon score double 22  √  null
protein_align_feature score double 22  √  null
protein_feature score double 22  √  null
repeat_feature score double 22  √  null
simple_feature score double 22  √  null
unmapped_object target_score double 22  √  null
unconventional_transcript_association interaction_type enum 23  √  null
misc_set code varchar 25
map map_name varchar 30
ditag name varchar 30
ditag type varchar 30
coord_system attrib set 32  √  null
peptide_archive md5_checksum varchar 32  √  null
karyotype band varchar 40
gene biotype varchar 40
transcript biotype varchar 40
external_db db_name varchar 40
analysis db_version varchar 40  √  null
xref dbprimary_acc varchar 40
simple_feature display_label varchar 40
analysis gff_feature varchar 40  √  null
analysis gff_source varchar 40  √  null
dna_align_feature hit_name varchar 40
protein_align_feature hit_name varchar 40
protein_feature hit_name varchar 40
interpro id varchar 40
interpro interpro_ac varchar 40
analysis logic_name varchar 40
meta meta_key varchar 40
analysis module_version varchar 40  √  null
coord_system name varchar 40
oligo_array name varchar 40
seq_region name varchar 40
oligo_probe probeset varchar 40  √  null
analysis program_version varchar 40  √  null
repeat_consensus repeat_type varchar 40
karyotype stain varchar 40
external_synonym synonym varchar 40
meta_coord table_name varchar 40
marker_synonym name varchar 50  √  null
analysis module varchar 80  √  null
mapping_session new_db_name varchar 80
mapping_session old_db_name varchar 80
analysis program varchar 80  √  null
analysis program_file varchar 80  √  null
marker left_primer varchar 100
repeat_consensus repeat_class varchar 100
marker right_primer varchar 100
analysis db varchar 120  √  null
analysis db_file varchar 120  √  null
xref display_label varchar 128
gene_archive gene_stable_id varchar 128
stable_id_event new_stable_id varchar 128  √  null
stable_id_event old_stable_id varchar 128  √  null
exon_stable_id stable_id varchar 128
gene_stable_id stable_id varchar 128
transcript_stable_id stable_id varchar 128
translation_stable_id stable_id varchar 128
gene_archive transcript_stable_id varchar 128
gene_archive translation_stable_id varchar 128
gene canonical_annotation varchar 255  √  null
ditag_feature cigar_line tinytext 255
external_db db_display_name varchar 255  √  null
external_db db_release varchar 255  √  null
analysis_description display_label varchar 255  √  null
prediction_transcript display_label varchar 255  √  null
unmapped_reason full_description varchar 255  √  null
unmapped_object identifier varchar 255
xref info_text varchar 255  √  null
object_xref linkage_annotation varchar 255  √  null
meta meta_value varchar 255
attrib_type name varchar 255
misc_set name varchar 255
unmapped_object parent varchar 255  √  null
repeat_consensus repeat_name varchar 255
external_db secondary_db_name varchar 255  √  null
external_db secondary_db_table varchar 255  √  null
ditag sequence tinytext 255
qtl_synonym source_primary_id varchar 255
unmapped_reason summary_description varchar 255  √  null
qtl trait varchar 255
coord_system version varchar 255  √  null
dna_align_feature cigar_line text 65535  √  null
identity_xref cigar_line text 65535  √  null
protein_align_feature cigar_line text 65535  √  null
analysis_description description text 65535  √  null
attrib_type description text 65535  √  null
external_db description text 65535  √  null
gene description text 65535  √  null
misc_set description text 65535
oligo_probe description text 65535  √  null
transcript description text 65535  √  null
xref description text 65535  √  null
dna_align_feature external_data text 65535  √  null
protein_feature external_data text 65535  √  null
dnac n_line text 65535  √  null
analysis parameters text 65535  √  null
repeat_consensus repeat_consensus text 65535  √  null
gene_attrib value text 65535
misc_attrib value text 65535
seq_region_attrib value text 65535
transcript_attrib value text 65535
translation_attrib value text 65535
analysis_description web_data text 65535  √  null
peptide_archive peptide_seq mediumtext 16777215
dnac sequence mediumblob 16777215
dna sequence longtext 2147483647