Table cxgn.sgn.accession

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

Dashed lines show
implied relationships

< n > number of related tables

Please support this project

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

accession_id

serial

√

nextval('accession_accession_id_seq'::regclass)

accession_names.accession_id	accession_id_fk
map.ancestor	map_ancestor_fkey
map.parent_1	map_parent_1_fkey
map.parent_2	map_parent_2_fkey
pcr_exp_accession.accession_id	accession_id_fk

organism_id

int8

√

null

organism.organism_id

organism_id_fk

common_name

varchar

√

null

accession_name_id

int8

√

null

accession_names.accession_name_id

accession_name_id_fk

Table contained 66 rows at Wed May 20 01:50 EDT 2009

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
accession_id	Primary key	Asc	accession_pkey
accession_name_id	Must be unique	Asc	unique_accession_name	This unique column is also nullable