SchemaSpy - Table pub.mgd.mld

Defines Concordance values for Hybrid Experiment. The Concordance table contains results for either Markers or Chromosomes. Concordance values are stored as integers which represent the number of Hybrid cells recording the presence/absence of a particular Marker/Chromosome in the Concordance table vs. the presence/absence of the Marker being tested for linkage: -/- (neither present), -/+ (linkage Marker present), +/- (Marker/Chromosome present), +/+ (both present).

Detail of MLD_Hybrid.

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

_expt_key

int4

mld_expts._expt_key

mld_concordance__expt_key_fkey C

foreign key to MLD_Expts

sequencenum

int4

sequence number for ordering records

_marker_key

int4

√

null

mrk_marker._marker_key

mld_concordance__marker_key_fkey R

foreign key to MRK_Marker

chromosome

text

2147483647

√

null

chromosome value; is NULL if _Marker_key is not NULL

cpp

int4

+/+; number of Hybrid cells where both the Concordance Marker/Chromosome and the linkage Marker are present

cpn

int4

+/-; number of Hybrid cells where the Concordance Marker/Chromosome is present, but the linkage Marker is not present

cnp

int4

-/+; number of Hybrid cells where the Concordance Marker/Chromosome is not present, but the linkage Marker is present

cnn

int4

-/-; number of Hybrid cells where neither the Concordance Marker/Chromosome nor the linkage Marker is present

creation_date

timestamp

29,6

now()

date record was created

modification_date

timestamp

29,6

now()

date record was last modified

Table contained 11,827 rows at Mon Sep 11 06:12 EDT 2023

Indexes:

Column(s)	Type	Sort	Constraint Name
_expt_key + sequencenum	Primary key, Used to cluster data	Asc/Asc	mld_concordance_pkey
_marker_key	Performance	Asc	mld_concordance_idx_marker_key