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))) |
Relationships
Close relationships within degrees of separation
