fpc_band

0 rows


Description

each row is a band in a gel lane or capillary run

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fpc_band_id serial 10 √ nextval('fpc_band_fpc_band_id_seq'::regclass)
fpc_fingerprint_id int4 10 null
fpc_fingerprint.fpc_fingerprint_id fpc_band_fpc_fingerprint_id_fkey C
fragment_size int4 10 √ null
band_position int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
fpc_band_pkey Primary key Asc fpc_band_id
fpc_band_fpc_fingerprint_id_idx1 Performance Asc fpc_fingerprint_id

Check Constraints

Constraint Name Constraint
fragcheck (((fragment_size IS NULL) OR (fragment_size > 0)))
datacheck (((fragment_size IS NOT NULL) OR (band_position IS NOT NULL)))
bandcheck (((band_position IS NULL) OR (band_position > 0)))

Relationships

Close relationships within degrees of separation