accession

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
accession_id serial 10 nextval('sgn.accession_accession_id_seq'::regclass)
library.accession_id library_accession_id_fkey R
genotype_experiment.background_accession_id genotype_experiment_background_accession_id_fkey R
individual.accession_id individual_accession_id_fkey R
phenome_genotype.background_accession_id genotype_background_accession_id_fkey R
population.background_accession_id population_background_accession_id_fkey R
population.donor_parent_id population_donor_parent_id_fkey R
population.female_parent_id population_female_parent_id_fkey R
population.male_parent_id population_male_parent_id_fkey R
population.recurrent_parent_id population_recurrent_parent_id_fkey R
accession_names.accession_id accession_id_fk R
map.ancestor map_ancestor_fkey R
map.parent_1 map_parent_1_fkey R
map.parent_2 map_parent_2_fkey R
pcr_exp_accession.accession_id accession_id_fk R
user_map.parent1_accession_id user_map_parent1_accession_id_fkey R
user_map.parent2_accession_id user_map_parent2_accession_id_fkey R
organism_id int8 19 null
organism.organism_id organism_id_fk R
common_name varchar 80 null
accession_name_id int8 19 null
accession_names.accession_name_id accession_name_id_fk R
chado_organism_id int4 10 null
organism.organism_id accession_chado_organism_id_fkey R
stock_id int4 10 null

Indexes

Constraint Name Type Sort Column(s)
accession_pkey Primary key Asc accession_id
unique_accession_name Must be unique Asc accession_name_id

Relationships