Skip to main content

Table 1 Tables, fields, and primary and foreign keys in DOG-SPOT.

From: DOG-SPOT database for comprehensive management of dog genetic research data

Table Field Primary/Foreign Key [Table]
Activity id Primary Key
  member_id Member
  date  
  time_in  
  time_out  
  activity  
Amplicon id Primary Key
  F_seq  
  R_seq  
  F_Tm  
  R_Tm  
  designed_by Member
  date_ordered  
  chr_cf2  
  start_cf2  
  end_cf2  
  gene Gene
  purpose  
  optimization_exp  
  optimized_by Member
  PCR_good  
  PCR_annealing_temp  
  PCR_band  
  seq_result  
  notes  
Breed breed Primary Key
  specialist Member
  kennel_club Kennel_Club
  notes  
  written_standard  
  collection_status  
Communication id Primary Key
  Owner_id Owner
  action  
  action_date  
  do_next  
  by_date  
  lab_contact Member
  completed  
Dog id Primary Key
  breed Breed
  sex  
  owner Owner
  registered_name  
  registration_number  
  call_name  
  date_of_birth  
  sire_id Dog
  dam_id Dog
  notes  
  date_of_trait_measures  
  weight  
  coat_color_pattern  
  skin_color  
  diagnosis  
  height_withers  
Experiment id Primary Key
  date  
  assay_type  
  completed_by Member
  quality_score  
  notes  
Gene abbreviation Primary Key
  name  
  description  
  chr_cf2  
  start_cf2  
  end_cf2  
Genotype id Primary Key
  sample_id Sample
  experiment_id Experiment
  genotype  
  marker_id Marker
Kennel_Club abbreviation Primary Key
  name  
  country  
  url  
  note  
Marker id Primary Key
  chr_cf2  
  start_cf2  
  end_cf2  
  allele1  
  allele2  
  left_flank  
  right_flank  
  marker_type  
  notes  
Member netid Primary Key
  first_name  
  last_name  
  active  
  description  
Owner id Primary Key
  breed_affiliation Breed
  first_name  
  last_name  
  email  
  home_phone  
  street_address  
  city  
  state  
  zipcode  
  country  
  lab_contact Member
  kennel_name  
  URL  
  date_entered  
  work_phone  
  cell_phone  
  fax  
  notes  
  is_contact_allowed  
  referred_by Owner
  generate_label  
  date_of_last_mailing  
  number_kits_mailed  
  number_kits_transferred  
Sample sid Primary Key
  dog_id Dog
  date_received  
  biomaterial_received  
  received_by Member
  process_type  
  date_processed  
  processed_by Member
  post_process_vol_ul  
  post_process_conc  
  post_process_OD  
  post_process_biomat  
  notes  
  source_id Sample
Sequence id Primary Key
  name  
  amplicon_id Amplicon
  sample_id Sample
  experiment_id Experiment
  sequencing_primer  
  quality_ok  
  notes