Table cxgn.sgn.common_name

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

common_name_id

bigserial

√

nextval('common_name_common_name_id_seq'::regclass)

organism.common_name_id	common_name_id_fk
organismprop.common_name_id	organismprop_common_name_id_fkey

common_name

varchar

255

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

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
common_name_id	Primary key	Asc	common_name_pkey
	Must be unique		common_name_common_name_case_insensitive_unique	These unique columns are also nullable
common_name	Must be unique	Asc	common_name_unique