map

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

map_id

serial

10

√

nextval('sgn.map_map_id_seq'::regclass)

genotype_experiment.reference_map_id	genotype_experiment_reference_map_id_fkey	C
phenome_genotype.reference_map_id	genotype_reference_map_id_fkey	R
map_version.map_id	map_version_map_id_fkey	C
pcr_experiment.map_id	map_id_fk	R

short_name

text

2147483647

null

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

R

parent_2

int4

10

√

null

accession.accession_id

map_parent_2_fkey

R

units

text

2147483647

√

'cM'::text

ancestor

int4

10

√

null

accession.accession_id

map_ancestor_fkey

R

population_id

int4

10

√

null

population.population_id

map_population_id_fkey

C

Showing 1 to 10 of 13 entries

Indexes

Search:

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

Showing 1 to 1 of 1 entries

Check Constraints

Search:

Constraint Name	Constraint
map_units_check	(((units = 'cM'::text) OR (units = 'Mb'::text)))
map_map_type_check	(((map_type = 'genetic'::text) OR (map_type = 'fish'::text) OR (map_type = 'sequence'::text) OR (map_type = 'QTL'::text)))

Showing 1 to 2 of 2 entries

Columns

Indexes

Check Constraints

Relationships

Close relationships within degrees of separation