Table cxgn.public.fpc_fingerprint

each row is a lane in a gel or a single capillary run of a single clone

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

fpc_fingerprint_id

serial

√

nextval('fpc_fingerprint_fpc_fingerprint_id_seq'::regclass)

fpc_band.fpc_fingerprint_id	fpc_band_fpc_fingerprint_id_fkey
fpc_build_fpc_fingerprint.fpc_fingerprint_id	fpc_build_fpc_fingerprint_fpc_fingerprint_id_fkey

clone_id

int4

gel_name

varchar

√

null

enzyme_id

int4

Table contained 132,482 rows at Sat Oct 11 01:33 EDT 2008

Indexes:

Column(s)	Type	Sort	Constraint Name
fpc_fingerprint_id	Primary key	Asc	fpc_fingerprint_pkey
clone_id	Performance	Asc	fpc_fingerprint_clone_id_idx1
clone_id + gel_name	Must be unique	Asc/Asc	fpc_fingerprint_clone_id_key
enzyme_id	Performance	Asc	fpc_fingerprint_enzyme_id_idx1
gel_name	Performance	Asc	fpc_fingerprint_gel_name_idx1