SchemaSpy - Table pub.mgd.mld

Defines a Mapping Experiment for a specific Reference. A Reference may have one or more Experiments associated with it. Each Experiment within a specific Reference is assigned an Experiment Type and and Experiment Tag value (CROSS-1). The currently supported Experiment Types are: CONTIG, CROSS, FISH, HYBRID, IN SITU, MAP, RI, TEXT.

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

serial

√

nextval('mld_expts_seq'::regclass)

mld_concordance._expt_key	mld_concordance__expt_key_fkey C
mld_contig._expt_key	mld_contig__expt_key_fkey C
mld_expt_marker._expt_key	mld_expt_marker__expt_key_fkey C
mld_expt_notes._expt_key	mld_expt_notes__expt_key_fkey C
mld_fish._expt_key	mld_fish__expt_key_fkey C
mld_fish_region._expt_key	mld_fish_region__expt_key_fkey C
mld_hit._expt_key	mld_hit__expt_key_fkey C
mld_hybrid._expt_key	mld_hybrid__expt_key_fkey C
mld_insitu._expt_key	mld_insitu__expt_key_fkey C
mld_isregion._expt_key	mld_isregion__expt_key_fkey C
mld_matrix._expt_key	mld_matrix__expt_key_fkey C
mld_mc2point._expt_key	mld_mc2point__expt_key_fkey C
mld_mcdatalist._expt_key	mld_mcdatalist__expt_key_fkey C
mld_ri._expt_key	mld_ri__expt_key_fkey C
mld_ri2point._expt_key	mld_ri2point__expt_key_fkey C
mld_ridata._expt_key	mld_ridata__expt_key_fkey C
mld_statistics._expt_key	mld_statistics__expt_key_fkey C
ri_summary_expt_ref._expt_key	ri_summary_expt_ref__expt_key_fkey R

primary key

_refs_key

int4

bib_refs._refs_key

mld_expts__refs_key_fkey R

foreign key to BIB_Refs

expttype

text

2147483647

experiment type (ex. CROSS, RI, FISH, IN SITU, TEXT)

tag

int4

unique integer value for each experiment type defined for a given reference (CROSS-1, CROSS-2, etc.)

chromosome

text

2147483647

chromosome value

creation_date

timestamp

29,6

now()

date record was created

modification_date

timestamp

29,6

now()

date record was last modified

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

Indexes:

Column(s)	Type	Sort	Constraint Name
_expt_key	Primary key, Used to cluster data	Asc	mld_expts_pkey
chromosome	Performance	Asc	mld_expts_idx_chromosome
creation_date	Performance	Asc	mld_expts_idx_creation_date
expttype	Performance	Asc	mld_expts_idx_expttype
modification_date	Performance	Asc	mld_expts_idx_modification_date
_refs_key	Performance	Asc	mld_expts_idx_refs_key