pcr_product

0 rows


Columns

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

Indexes

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

Check Constraints

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)))

Relationships