Table cxgn.phenome.dbxref_type

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
dbxref_type_id	serial	10		√	nextval('dbxref_type_dbxref_type_id_seq'::regclass)
dbxref_type_name	varchar	32	√		null
dbxref_type_definition	varchar	255	√		null
dbxref_type_url	varchar	255	√		null

Table contained 9 rows at Wed May 20 01:35 EDT 2009

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
dbxref_type_id	Primary key	Asc	dbxref_type_pkey
dbxref_type_definition	Must be unique	Asc	dbxref_type_dbxref_type_definition_key	This unique column is also nullable
dbxref_type_name	Must be unique	Asc	dbxref_type_dbxref_type_name_key	This unique column is also nullable
dbxref_type_url	Must be unique	Asc	dbxref_type_dbxref_type_url_key	This unique column is also nullable