pcr_product

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

pcr_product_id

bigserial

19

√

nextval('sgn.pcr_product_pcr_product_id_seq'::regclass)

pcr_exp_accession_id

int8

19

√

null

pcr_exp_accession.pcr_exp_accession_id

pcr_exp_accession_id_fk

C

enzyme_id

int8

19

√

null

enzymes.enzyme_id

enzyme_id_fk

R

multiple_flag

int8

19

√

null

band_size

int8

19

√

null

predicted

bool

1

√

false

Showing 1 to 6 of 6 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
pcr_product_pkey	Primary key	Asc	pcr_product_id
pcr_exp_accession_id_idx	Performance	Asc	pcr_exp_accession_id
unique_acc_enz_mult_pred_size	Must be unique	Asc/Asc/Asc/Asc/Asc	pcr_exp_accession_id + enzyme_id + multiple_flag + band_size + predicted

Showing 1 to 3 of 3 entries

Check Constraints

Search:

Constraint Name	Constraint
band_size_or_multiple_check	((((band_size IS NOT NULL) OR (multiple_flag IS NOT NULL)) AND (NOT ((band_size IS NOT NULL) AND (multiple_flag IS NOT NULL)))))
multiple_flag_null_or_1	(((multiple_flag = 1) OR (multiple_flag IS NULL)))

Showing 1 to 2 of 2 entries

Columns

Indexes

Check Constraints

Relationships

Close relationships within degrees of separation