pcr_experiment

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

pcr_experiment_id

bigserial

19

√

nextval('sgn.pcr_experiment_pcr_experiment_id_seq'::regclass)

marker_experiment.pcr_experiment_id	marker_experiment_pcr_experiment_id_fkey	R
pcr_exp_accession.pcr_experiment_id	pcr_experiment_id_fk	C
pcr_experiment_sequence.pcr_experiment_id	pcr_experiment_sequence_pcr_experiment_id_fkey	C

marker_id

int8

19

√

null

marker.marker_id

marker_id_fk

R

mg_concentration

float4

8,8

√

null

annealing_temp

int8

19

√

null

primer_id_fwd

int8

19

√

null

sequence.sequence_id

primer_id_fwd_fk

R

primer_id_rev

int8

19

√

null

sequence.sequence_id

primer_id_rev_fk

R

subscript

varchar

255

√

null

experiment_type_id

int8

19

√

null

experiment_type.experiment_type_id

experiment_type_id_fk

R

map_id

int8

19

√

null

map.map_id

map_id_fk

R

additional_enzymes

varchar

1023

√

null

Showing 1 to 10 of 15 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
pcr_experiment_pkey	Primary key	Asc	pcr_experiment_id
marker_id_idx6	Performance	Asc/Asc	marker_id + experiment_type_id

Showing 1 to 2 of 2 entries

Check Constraints

Search:

Constraint Name	Constraint
primer_type_enum	((((primer_type)::text = 'iUPA'::text) OR ((primer_type)::text = 'eUPA'::text) OR (primer_type IS NULL)))
different_primers	(((primer_id_fwd IS NULL) OR (primer_id_rev IS NULL) OR (NOT (primer_id_fwd = primer_id_rev))))

Showing 1 to 2 of 2 entries

Columns

Indexes

Check Constraints

Relationships

Close relationships within degrees of separation