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 |
|
|
|||||
enzyme_id | int8 | 19 | √ | null |
|
|
|||||
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))) |