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