SchemaSpy Analysis of homo_sapiens_core_98_38 - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Wed Nov 27 11:43 CET 2019
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

homo_sapiens_core_98_38 contains 492 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
attrib_type code varchar 20
misc_set code varchar 25
rnaproduct_type code varchar 20
xref info_text varchar 255
attrib_type name varchar 255
misc_set name varchar 255
rnaproduct_type name varchar 255
mapping_session new_assembly varchar 20
mapping_session new_db_name varchar 80
mapping_session new_release varchar 5
mapping_session old_assembly varchar 20
mapping_session old_db_name varchar 80
mapping_session old_release varchar 5
data_file absolute bit 0 0
ditag_feature analysis_id smallint unsigned 5 0
gene_attrib attrib_type_id smallint unsigned 5 0
misc_attrib attrib_type_id smallint unsigned 5 0
rnaproduct_attrib attrib_type_id smallint unsigned 5 0
seq_region_attrib attrib_type_id smallint unsigned 5 0
transcript_attrib attrib_type_id smallint unsigned 5 0
translation_attrib attrib_type_id smallint unsigned 5 0
ditag_feature ditag_id int unsigned 10 0
ditag_feature ditag_pair_id int unsigned 10 0
unmapped_object ensembl_id int unsigned 10  √  0
supporting_feature exon_id int unsigned 10 0
supporting_feature feature_id int unsigned 10 0
transcript_supporting_feature feature_id int unsigned 10 0
gene_attrib gene_id int unsigned 10 0
ditag_feature hit_end int unsigned 10 0
ditag_feature hit_start int unsigned 10 0
ditag_feature hit_strand bit 0 0
exon is_constitutive bit 0 0
intron_supporting_evidence is_splice_canonical bit 0 0
stable_id_event mapping_session_id int unsigned 10 0
misc_attrib misc_feature_id int unsigned 10 0
misc_feature_misc_set misc_feature_id int unsigned 10 0
misc_feature_misc_set misc_set_id smallint unsigned 5 0
associated_xref object_xref_id int unsigned 10 0
ontology_xref object_xref_id int unsigned 10 0
associated_xref rank int unsigned 10  √  0
rnaproduct_attrib rnaproduct_id int unsigned 10 0
stable_id_event score float 12 0
ditag_feature seq_region_end int unsigned 10 0
misc_feature seq_region_end int unsigned 10 0
ditag_feature seq_region_id int unsigned 10 0
misc_feature seq_region_id int unsigned 10 0
seq_region_attrib seq_region_id int unsigned 10 0
ditag_feature seq_region_start int unsigned 10 0
misc_feature seq_region_start int unsigned 10 0
ditag_feature seq_region_strand bit 0 0
misc_feature seq_region_strand tinyint 3 0
transcript_attrib transcript_id int unsigned 10 0
transcript_supporting_feature transcript_id int unsigned 10 0
translation_attrib translation_id int unsigned 10 0
genome_statistics value bigint unsigned 20 0
data_file version_lock bit 0 0
associated_xref xref_id int unsigned 10 0
analysis_description displayable bit 0 1
gene_archive gene_version smallint 5 1
exon is_current bit 0 1
gene is_current bit 0 1
transcript is_current bit 0 1
protein_align_feature seq_region_strand bit 0 1
repeat_feature seq_region_strand bit 0 1
coord_system species_id int unsigned 10 1
genome_statistics species_id int unsigned 10  √  1
meta species_id int unsigned 10  √  1
ditag tag_count smallint unsigned 5 1
gene_archive transcript_version smallint 5 1
gene_archive translation_version smallint 5 1
biotype db_type set 128 core
dna_align_feature align_type enum 8  √  ensembl
protein_align_feature align_type enum 8  √  ensembl
transcript source varchar 40 ensembl
biotype object_type enum 10 gene
xref info_type enum 18 NONE
intron_supporting_evidence score_type enum 5  √  NONE
protein_feature align_type enum 9  √  null
alt_allele alt_allele_group_id int unsigned 10
alt_allele_group alt_allele_group_id int unsigned 10  √ 
alt_allele alt_allele_id int unsigned 10  √ 
alt_allele_attrib alt_allele_id int unsigned 10  √  null
analysis analysis_id smallint unsigned 5  √ 
analysis_description analysis_id smallint unsigned 5
data_file analysis_id smallint unsigned 5
density_type analysis_id smallint unsigned 5
dna_align_feature analysis_id smallint unsigned 5
gene analysis_id smallint unsigned 5
intron_supporting_evidence analysis_id smallint unsigned 5
marker_feature analysis_id smallint unsigned 5
object_xref analysis_id smallint unsigned 5  √  null
operon analysis_id smallint unsigned 5
operon_transcript analysis_id smallint unsigned 5
prediction_transcript analysis_id smallint unsigned 5
protein_align_feature analysis_id smallint unsigned 5
protein_feature analysis_id smallint unsigned 5
repeat_feature analysis_id smallint unsigned 5
simple_feature analysis_id smallint unsigned 5
transcript analysis_id smallint unsigned 5
unmapped_object analysis_id smallint unsigned 5
assembly asm_end int 10
assembly asm_seq_region_id int unsigned 10
assembly asm_start int 10
assembly_exception assembly_exception_id int unsigned 10  √ 
associated_group associated_group_id int unsigned 10  √ 
associated_xref associated_group_id int unsigned 10  √  null
associated_xref associated_xref_id int unsigned 10  √ 
alt_allele_attrib attrib enum 35  √  null
coord_system attrib set 30  √  null
attrib_type attrib_type_id smallint unsigned 5  √ 
biotype attrib_type_id int 10  √  null
dna_align_feature_attrib attrib_type_id smallint unsigned 5
genome_statistics attrib_type_id int unsigned 10  √  null
karyotype band varchar 40  √  null
gene biotype varchar 40
transcript biotype varchar 40
biotype biotype_group enum 10  √  null
biotype biotype_id int unsigned 10  √ 
density_type block_size int 10
gene canonical_transcript_id int unsigned 10
transcript canonical_translation_id int unsigned 10  √  null
marker_map_location chromosome_name varchar 15
ditag_feature cigar_line tinytext 255
dna_align_feature cigar_line text 65535  √  null
identity_xref cigar_line text 65535  √  null
protein_align_feature cigar_line text 65535  √  null
protein_feature cigar_line text 65535  √  null
assembly cmp_end int 10
assembly cmp_seq_region_id int unsigned 10
assembly cmp_start int 10
associated_xref condition_type varchar 128  √  null
coord_system coord_system_id int unsigned 10  √ 
data_file coord_system_id int unsigned 10
meta_coord coord_system_id int unsigned 10
seq_region coord_system_id int unsigned 10
analysis created datetime 19  √  null
mapping_session created datetime 19
exon created_date datetime 19  √  null
gene created_date datetime 19  √  null
operon created_date datetime 19  √  null
operon_transcript created_date datetime 19  √  null
rnaproduct created_date datetime 19  √  null
transcript created_date datetime 19  √  null
translation created_date datetime 19  √  null
data_file data_file_id int unsigned 10  √ 
analysis db varchar 120  √  null
external_db db_display_name varchar 255  √  null
analysis db_file varchar 120  √  null
external_db db_name varchar 100
external_db db_release varchar 255  √  null
analysis db_version varchar 40  √  null
xref dbprimary_acc varchar 512
density_feature density_feature_id int unsigned 10  √ 
density_feature density_type_id int unsigned 10
density_type density_type_id int unsigned 10  √ 
density_feature density_value float 12
dependent_xref dependent_xref_id int unsigned 10
analysis_description description text 65535  √  null
associated_group description varchar 128  √  null
attrib_type description text 65535  √  null
biotype description text 65535  √  null
external_db description text 65535  √  null
gene description text 65535  √  null
misc_set description text 65535
rnaproduct_type description text 65535  √  null
transcript description text 65535  √  null
xref description text 65535  √  null
analysis_description display_label varchar 255
operon display_label varchar 255  √  null
operon_transcript display_label varchar 255  √  null
prediction_transcript display_label varchar 255  √  null
simple_feature display_label varchar 255
xref display_label varchar 512
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_side enum 2
dna_align_feature dna_align_feature_id int unsigned 10  √ 
dna_align_feature_attrib dna_align_feature_id int unsigned 10
rnaproduct end_exon_id int unsigned 10  √  null
translation end_exon_id int unsigned 10
exon end_phase tinyint 3
identity_xref ensembl_end int 10  √  null
object_xref ensembl_id int unsigned 10
identity_xref ensembl_identity int 10  √  null
object_xref ensembl_object_type enum 16
identity_xref ensembl_start int 10  √  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
assembly_exception exc_seq_region_end int unsigned 10
assembly_exception exc_seq_region_id int unsigned 10
assembly_exception exc_seq_region_start int unsigned 10
assembly_exception exc_type enum 11
exon exon_id int unsigned 10  √ 
exon_transcript exon_id int unsigned 10
prediction_exon exon_rank smallint unsigned 5
protein_feature external_data text 65535  √  null
dna_align_feature external_db_id int unsigned 10  √  null
external_db external_db_id int unsigned 10  √ 
protein_align_feature external_db_id int unsigned 10  √  null
seq_region_synonym external_db_id int unsigned 10  √  null
unmapped_object external_db_id int unsigned 10  √  null
xref external_db_id int unsigned 10
mapping_set external_schema_build varchar 20
seq_region_mapping external_seq_region_id int unsigned 10
supporting_feature feature_type enum 21  √  null
transcript_supporting_feature feature_type enum 21  √  null
data_file file_type enum 6  √  null
unmapped_reason full_description varchar 255  √  null
alt_allele gene_id int unsigned 10
gene gene_id int unsigned 10  √ 
operon_transcript_gene gene_id int unsigned 10  √  null
transcript gene_id int unsigned 10  √  null
gene_archive gene_stable_id varchar 128
genome_statistics genome_statistics_id int unsigned 10  √ 
analysis gff_feature varchar 40  √  null
analysis gff_source varchar 40  √  null
dna_align_feature hcoverage double 22  √  null
protein_align_feature hcoverage double 22  √  null
protein_feature hit_description text 65535  √  null
dna_align_feature hit_end int 10
protein_align_feature hit_end int 10
protein_feature hit_end int 10
dna_align_feature hit_name varchar 40
intron_supporting_evidence hit_name varchar 100
protein_align_feature hit_name varchar 40
protein_feature hit_name varchar 40
dna_align_feature hit_start int 10
protein_align_feature hit_start int 10
protein_feature hit_start int 10
dna_align_feature hit_strand bit 0
interpro id varchar 40
unmapped_object identifier varchar 255
mapping_set internal_schema_build varchar 20
seq_region_mapping internal_seq_region_id int unsigned 10
interpro interpro_ac varchar 40
intron_supporting_evidence intron_supporting_evidence_id int unsigned 10  √ 
transcript_intron_supporting_evidence intron_supporting_evidence_id int unsigned 10
karyotype karyotype_id int unsigned 10  √ 
marker left_primer varchar 100
seq_region length int unsigned 10
object_xref linkage_annotation varchar 255  √  null
ontology_xref linkage_type varchar 3  √  null
marker_map_location lod_score double 22  √  null
analysis logic_name varchar 128
map map_id int unsigned 10  √ 
marker_map_location map_id int unsigned 10
map map_name varchar 30
marker_feature map_weight int unsigned 10  √  null
gene_archive mapping_session_id int unsigned 10
mapping_session mapping_session_id int unsigned 10  √ 
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 int unsigned 10
marker_map_location marker_id int unsigned 10
marker_synonym marker_id int unsigned 10
marker_map_location marker_synonym_id int unsigned 10
marker_synonym marker_synonym_id int unsigned 10  √ 
dependent_xref master_xref_id int unsigned 10
meta_coord max_length int 10  √  null
misc_set max_length int unsigned 10
marker max_primer_dist int unsigned 10
peptide_archive md5_checksum varchar 32  √  null
meta meta_id int 10  √ 
meta meta_key varchar 40
meta meta_value varchar 255
marker min_primer_dist int unsigned 10
misc_feature misc_feature_id int unsigned 10  √ 
misc_set misc_set_id smallint unsigned 5  √ 
exon modified_date datetime 19  √  null
gene modified_date datetime 19  √  null
operon modified_date datetime 19  √  null
operon_transcript modified_date datetime 19  √  null
rnaproduct modified_date datetime 19  √  null
transcript modified_date datetime 19  √  null
translation modified_date datetime 19  √  null
analysis module varchar 80  √  null
analysis module_version varchar 40  √  null
biotype name varchar 64
coord_system name varchar 40
data_file name varchar 100
ditag name varchar 30
marker_synonym name varchar 50  √  null
seq_region name varchar 255
stable_id_event new_stable_id varchar 128  √  null
stable_id_event new_version smallint 5  √  null
transcript_intron_supporting_evidence next_exon_id int unsigned 10
dependent_xref object_xref_id int unsigned 10
identity_xref object_xref_id int unsigned 10
object_xref object_xref_id int unsigned 10  √ 
stable_id_event old_stable_id varchar 128  √  null
stable_id_event old_version smallint 5  √  null
operon operon_id int unsigned 10  √ 
operon_transcript operon_id int unsigned 10
operon_transcript operon_transcript_id int unsigned 10  √ 
operon_transcript_gene operon_transcript_id int unsigned 10  √  null
assembly ori tinyint 3
assembly_exception ori int 10
prediction_exon p_value double 22  √  null
analysis parameters text 65535  √  null
unmapped_object parent varchar 255  √  null
gene_archive peptide_archive_id int unsigned 10  √  null
peptide_archive peptide_archive_id int unsigned 10  √ 
peptide_archive peptide_seq mediumtext 16777215
dna_align_feature perc_ident float 12  √  null
protein_align_feature perc_ident float 12  √  null
protein_feature perc_ident float 12  √  null
exon phase tinyint 3
marker_map_location position varchar 15
prediction_exon prediction_exon_id int unsigned 10  √ 
prediction_exon prediction_transcript_id int unsigned 10
prediction_transcript prediction_transcript_id int unsigned 10  √ 
transcript_intron_supporting_evidence previous_exon_id int unsigned 10
external_db priority int 10
marker priority int 10  √  null
analysis program varchar 80  √  null
analysis program_file varchar 80  √  null
analysis program_version varchar 40  √  null
protein_align_feature protein_align_feature_id int unsigned 10  √ 
protein_feature protein_feature_id int unsigned 10  √ 
unmapped_object query_score double 22  √  null
coord_system rank int 10
exon_transcript rank int 10
density_type region_features int 10
repeat_consensus repeat_class varchar 100
repeat_consensus repeat_consensus text 65535  √  null
repeat_consensus repeat_consensus_id int unsigned 10  √ 
repeat_feature repeat_consensus_id int unsigned 10
repeat_feature repeat_end int 10
repeat_feature repeat_feature_id int unsigned 10  √ 
repeat_consensus repeat_name varchar 255
repeat_feature repeat_start int 10
repeat_consensus repeat_type varchar 40
marker right_primer varchar 100
rnaproduct rnaproduct_id int unsigned 10  √ 
rnaproduct rnaproduct_type_id smallint unsigned 5
rnaproduct_type rnaproduct_type_id smallint unsigned 5  √ 
dna_align_feature score double 22  √  null
identity_xref score double 22  √  null
intron_supporting_evidence score decimal 10,3  √  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
external_db secondary_db_name varchar 255  √  null
external_db secondary_db_table varchar 255  √  null
protein_feature seq_end int 10
rnaproduct seq_end int 10
translation seq_end int 10
assembly_exception seq_region_end int unsigned 10
density_feature seq_region_end int unsigned 10
dna_align_feature seq_region_end int unsigned 10
exon seq_region_end int unsigned 10
gene seq_region_end int unsigned 10
intron_supporting_evidence seq_region_end int unsigned 10
karyotype seq_region_end int unsigned 10
marker_feature seq_region_end int unsigned 10
operon seq_region_end int unsigned 10
operon_transcript seq_region_end int unsigned 10
prediction_exon seq_region_end int unsigned 10
prediction_transcript seq_region_end int unsigned 10
protein_align_feature seq_region_end int unsigned 10
repeat_feature seq_region_end int unsigned 10
simple_feature seq_region_end int unsigned 10
transcript seq_region_end int unsigned 10
assembly_exception seq_region_id int unsigned 10
density_feature seq_region_id int unsigned 10
dna seq_region_id int unsigned 10
dna_align_feature seq_region_id int unsigned 10
exon seq_region_id int unsigned 10
gene seq_region_id int unsigned 10
intron_supporting_evidence seq_region_id int unsigned 10
karyotype seq_region_id int unsigned 10
marker_feature seq_region_id int unsigned 10
operon seq_region_id int unsigned 10
operon_transcript seq_region_id int unsigned 10
prediction_exon seq_region_id int unsigned 10
prediction_transcript seq_region_id int unsigned 10
protein_align_feature seq_region_id int unsigned 10
repeat_feature seq_region_id int unsigned 10
seq_region seq_region_id int unsigned 10  √ 
seq_region_synonym seq_region_id int unsigned 10
simple_feature seq_region_id int unsigned 10
transcript seq_region_id int unsigned 10
assembly_exception seq_region_start int unsigned 10
density_feature seq_region_start int unsigned 10
dna_align_feature seq_region_start int unsigned 10
exon seq_region_start int unsigned 10
gene seq_region_start int unsigned 10
intron_supporting_evidence seq_region_start int unsigned 10
karyotype seq_region_start int unsigned 10
marker_feature seq_region_start int unsigned 10
operon seq_region_start int unsigned 10
operon_transcript seq_region_start int unsigned 10
prediction_exon seq_region_start int unsigned 10
prediction_transcript seq_region_start int unsigned 10
protein_align_feature seq_region_start int unsigned 10
repeat_feature seq_region_start int unsigned 10
simple_feature seq_region_start int unsigned 10
transcript seq_region_start int unsigned 10
dna_align_feature seq_region_strand bit 0
exon seq_region_strand tinyint 3
gene seq_region_strand tinyint 3
intron_supporting_evidence seq_region_strand tinyint 3
operon seq_region_strand tinyint 3
operon_transcript seq_region_strand tinyint 3
prediction_exon seq_region_strand tinyint 3
prediction_transcript seq_region_strand tinyint 3
simple_feature seq_region_strand bit 0
transcript seq_region_strand tinyint 3
seq_region_synonym seq_region_synonym_id int unsigned 10  √ 
protein_feature seq_start int 10
rnaproduct seq_start int 10
translation seq_start int 10
ditag sequence tinytext 255
dna sequence longtext 2147483647
simple_feature simple_feature_id int unsigned 10  √ 
biotype so_acc varchar 64  √  null
biotype so_term varchar 1023  √  null
gene source varchar 40
marker_synonym source varchar 20  √  null
associated_xref source_xref_id int unsigned 10  √  null
ontology_xref source_xref_id int unsigned 10  √  null
exon stable_id varchar 128  √  null
gene stable_id varchar 128  √  null
operon stable_id varchar 128  √  null
operon_transcript stable_id varchar 128  √  null
rnaproduct stable_id varchar 128  √  null
transcript stable_id varchar 128  √  null
translation stable_id varchar 128  √  null
karyotype stain varchar 40  √  null
rnaproduct start_exon_id int unsigned 10  √  null
translation start_exon_id int unsigned 10
prediction_exon start_phase tinyint 3
genome_statistics statistic varchar 128
external_db status enum 10
unmapped_reason summary_description varchar 255  √  null
external_synonym synonym varchar 100
seq_region_synonym synonym varchar 250
meta_coord table_name varchar 40
unmapped_object target_score double 22  √  null
genome_statistics timestamp datetime 19  √  null
exon_transcript transcript_id int unsigned 10
rnaproduct transcript_id int unsigned 10
transcript transcript_id int unsigned 10  √ 
transcript_intron_supporting_evidence transcript_id int unsigned 10
translation transcript_id int unsigned 10
gene_archive transcript_stable_id varchar 128
protein_feature translation_id int unsigned 10
translation translation_id int unsigned 10  √ 
gene_archive translation_stable_id varchar 128  √  null
ditag type varchar 30
external_db type enum 18  √  null
marker type enum 14  √  null
stable_id_event type enum 11
unmapped_object type enum 6
unmapped_object unmapped_object_id int unsigned 10  √ 
unmapped_object unmapped_reason_id int unsigned 10
unmapped_reason unmapped_reason_id int unsigned 10  √ 
data_file url text 65535  √  null
dna_align_feature_attrib value text 65535
gene_attrib value text 65535
misc_attrib value text 65535
rnaproduct_attrib value text 65535
seq_region_attrib value text 65535
transcript_attrib value text 65535
translation_attrib value text 65535
density_type value_type enum 5
coord_system version varchar 255  √  null
exon version smallint unsigned 5  √  null
gene version smallint unsigned 5  √  null
operon version smallint unsigned 5  √  null
operon_transcript version smallint unsigned 5  √  null
rnaproduct version smallint unsigned 5  √  null
transcript version smallint unsigned 5  √  null
translation version smallint unsigned 5  √  null
xref version varchar 10  √  null
analysis_description web_data text 65535  √  null
identity_xref xref_end int 10  √  null
external_synonym xref_id int unsigned 10
object_xref xref_id int unsigned 10
xref xref_id int unsigned 10  √ 
identity_xref xref_identity int 10  √  null
identity_xref xref_start int 10  √  null
unmapped_object ensembl_object_type enum 11  √  RawContig