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_Strength, GXD_Pattern, 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

int4

gxd_insituresult_view._result_key	Implied Constraint R
gxd_insituresultimage._result_key	gxd_insituresultimage__result_key_fkey C
gxd_isresultimage_view._result_key	Implied Constraint R
gxd_isresultstructure._result_key	gxd_isresultstructure__result_key_fkey C
gxd_isresultstructure_view._result_key	Implied Constraint R

primary key

_specimen_key

int4

gxd_specimen._specimen_key

gxd_insituresult__specimen_key_fkey C

foreign key to GXD_Specimen

_strength_key

int4

gxd_strength._strength_key

gxd_insituresult__strength_key_fkey R

foreign key to GXD_Strength

_pattern_key

int4

gxd_pattern._pattern_key

gxd_insituresult__pattern_key_fkey R

foreign key to GXD_Pattern

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,410,786 rows at Mon Mar 09 10:28 EDT 2020

Indexes:

Column(s)	Type	Sort	Constraint Name
_result_key	Primary key, Used to cluster data	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