Table cxgn.sgn.map

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

Dashed lines show
implied relationships

< n > number of related tables

Please support this project

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

map_id

serial

10

√

nextval('map_map_id_seq'::regclass)

map_version.map_id	map_version_map_id_fkey
pcr_experiment.map_id	map_id_fk

deprecated_maps.map_id

Implied Constraint

short_name

text

2147483647

long_name

text

2147483647

√

null

abstract

text

2147483647

√

null

map_type

text

2147483647

√

null

parent_1

int4

10

√

null

accession.accession_id

map_parent_1_fkey

parent_2

int4

10

√

null

accession.accession_id

map_parent_2_fkey

units

text

2147483647

√

'cM'::text

ancestor

int4

10

√

null

accession.accession_id

map_ancestor_fkey

Table contained 19 rows at Wed May 20 01:50 EDT 2009

Indexes:

Column(s)	Type	Sort	Constraint Name
map_id	Primary key	Asc	map_pkey