Table cxgn.genomic_bt.clone_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

Children

Parents

Comments

clone_type_id

serial

√

nextval('clone_type_clone_type_id_seq'::regclass)

clone.clone_type_id	clone_clone_type_id_fkey
library.clone_type_id	library_clone_type_id_fkey

name

varchar

√

null

shortname

varchar

√

null

cxgn_production_visible

bool

√

false

Table contained 1 rows at Thu Jun 21 23:00 EDT 2007

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
clone_type_id	Primary key	Asc	clone_type_pkey
name	Must be unique	Asc	clone_type_name_key	This unique column is also nullable
shortname	Must be unique	Asc	clone_type_shortname_key	This unique column is also nullable