fpc_fingerprint

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

fpc_fingerprint_id

serial

10

√

nextval('fpc_fingerprint_fpc_fingerprint_id_seq'::regclass)

fpc_band.fpc_fingerprint_id	fpc_band_fpc_fingerprint_id_fkey	C
fpc_build_fpc_fingerprint.fpc_fingerprint_id	fpc_build_fpc_fingerprint_fpc_fingerprint_id_fkey	C

clone_id

int4

10

null

clone.clone_id

fpc_fingerprint_clone_id_fkey

C

gel_name

varchar

30

√

null

enzyme_id

int4

10

null

enzymes.enzyme_id

fpc_fingerprint_enzyme_id_fkey

R

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