SchemaSpy - Table pub.mgd.gxd

Defines relationship between an In Situ Result and an Image Pane. One In Situ Result can have one or more Image Panes associated with it.

See GXD_InSituResult, GXD_ImagePane.

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

_resultimage_key

serial

√

nextval('gxd_insituresultimage_seq'::regclass)

_result_key

int4

gxd_insituresult._result_key

gxd_insituresultimage__result_key_fkey C

foreign key to GXD_InSituResult

_imagepane_key

int4

img_imagepane._imagepane_key

gxd_insituresultimage__imagepane_key_fkey R

foreign key to IMG_ImagePane

creation_date

timestamp

29,6

now()

date record was created

modification_date

timestamp

29,6

now()

date record was last modified

Table contained 1,470,460 rows at Mon Sep 11 06:12 EDT 2023

Indexes:

Column(s)	Type	Sort	Constraint Name
_resultimage_key	Primary key	Asc	gxd_insituresultimage_pkey
_imagepane_key	Performance	Asc	gxd_insituresultimage_idx_imagepane_key
_result_key	Performance	Asc	gxd_insituresultimage_idx_result_key