homo_sapiens_core_52_36n contains 431 columns - click on heading to sort:

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