SchemaSpy - Table pub.mgd.gxd

Defines an In Situ Specimen Result. For each Specimen defined, one or more results can be recorded. Each result contains the anatomical structure(s), signal strength, pattern of expression within the structure(s) and optional notes. One or more
Image Panes may also be associated with a result.

See GXD_Specimen, GXD_InSituResultImage, GXD_ISResultStructure.

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

_result_key

serial

√

nextval('gxd_insituresult_seq'::regclass)

gxd_insituresultimage._result_key	gxd_insituresultimage__result_key_fkey C
gxd_isresultcelltype._result_key	gxd_isresultcelltype__result_key_fkey C
gxd_isresultstructure._result_key	gxd_isresultstructure__result_key_fkey C

primary key

_specimen_key

int4

gxd_specimen._specimen_key

gxd_insituresult__specimen_key_fkey C

foreign key to GXD_Specimen

_strength_key

int4

voc_term._term_key

gxd_insituresult__strength_key_fkey R

foreign key to VOC_Term

_pattern_key

int4

voc_term._term_key

gxd_insituresult__pattern_key_fkey R

foreign key to VOC_Term

sequencenum

int4

sequence number for ordering records

resultnote

text

2147483647

√

null

textual information

creation_date

timestamp

29,6

now()

date record was created

modification_date

timestamp

29,6

now()

date record was last modified

Table contained 1,565,117 rows at Mon Sep 11 06:12 EDT 2023

Indexes:

Column(s)	Type	Sort	Constraint Name
_result_key	Primary key	Asc	gxd_insituresult_pkey
_pattern_key	Performance	Asc	gxd_insituresult_idx_pattern_key
_specimen_key	Performance	Asc	gxd_insituresult_idx_specimen_key
_strength_key	Performance	Asc	gxd_insituresult_idx_strength_key