SchemaSpy - Table homo_sapiens_core_52_36n.protein_feature

Generated by
SchemaSpy

Legend:

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

protein_feature_id

int unsigned

10

√

translation_id

int unsigned

10

0

translation.translation_id

Implied Constraint

seq_start

int

10

0

seq_end

int

10

0

hit_start

int

10

0

hit_end

int

10

0

hit_name

varchar

40

analysis_id

smallint unsigned

5

0

analysis.analysis_id

Implied Constraint

score

double

22

√

null

evalue

double

22

√

null

perc_ident

float

12

√

null

external_data

text

65535

√

null

Table contained 710 047 rows at ma maalis 23 00:31 EET 2009

Indexes:

Column(s)	Type	Sort	Constraint Name
protein_feature_id	Primary key	Asc	PRIMARY
analysis_id	Performance	Asc	analysis_idx
hit_name	Performance	Asc	hitname_idx
translation_id	Performance	Asc	translation_id