SchemaSpy - Table pub.mgd.mrk

Defines Aliases for Markers. Aliases must be valid Markers and should have the same chromosome value as the aliased Marker. This is enforced within the Editorial Interface. A Marker may have one or more Aliases associated with it.

See MRK_Marker.

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

_alias_key

int4

mrk_marker._marker_key

mrk_alias__alias_key_fkey C

primary key

_marker_key

int4

mrk_marker._marker_key

mrk_alias__marker_key_fkey C

foreign key to MRK_Marker

creation_date

timestamp

29,6

now()

date record was created

modification_date

timestamp

29,6

now()

date record was last modified

Table contained 590 rows at Mon May 07 06:18 EDT 2018

Indexes:

Column(s)	Type	Sort	Constraint Name
_alias_key + _marker_key	Primary key, Used to cluster data	Asc/Asc	mrk_alias_pkey
_alias_key	Performance	Asc	mrk_alias_idx_alias_key