Table cxgn.sgn.marker_experiment

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

Dashed lines show
implied relationships

< n > number of related tables

Please support this project

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

marker_experiment_id

serial

√

nextval('marker_experiment_marker_experiment_id_seq'::regclass)

marker_id

int4

√

null

marker.marker_id

marker_experiment_marker_id_fkey

pcr_experiment_id

int4

√

null

pcr_experiment.pcr_experiment_id

marker_experiment_pcr_experiment_id_fkey

rflp_experiment_id

int4

√

null

rflp_markers.rflp_id

marker_experiment_rflp_experiment_id_fkey

location_id

int4

√

null

marker_location.location_id

marker_experiment_location_id_fkey

protocol

text

2147483647

Table contained 27,361 rows at Wed May 20 01:50 EDT 2009

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
marker_experiment_id	Primary key	Asc	marker_experiment_pkey
pcr_experiment_id + rflp_experiment_id + location_id	Must be unique	Asc/Asc/Asc	marker_experiment_pcr_experiment_id_key	These unique columns are also nullable