Table cxgn.sgn_bt.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

cxgn_production_visible

bool

√

false

Table contained 21,099 rows at Thu Jun 21 23:03 EDT 2007

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