map

0 rows


Columns

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
parent1_stock_id int8 19 √ null
stock.stock_id map_parent1_stock_id_fkey R
parent2_stock_id int8 19 √ null
stock.stock_id map_parent2_stock_id_fkey R
population_stock_id int8 19 √ null
stock.stock_id map_population_stock_id_fkey R

Indexes

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

Check Constraints

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)))

Relationships

Close relationships within degrees of separation