   homology_id                 int(10) unsigned NOT NULL, # FK homology.homology_id
   member_id                   int(10) unsigned NOT NULL, # FK member.member_id
   peptide_member_id           int(10) unsigned, # FK member.member_id
-  peptide_align_feature_id    int(10) unsigned, # FK peptide_align_feature.peptide_align_feature_id
+#  peptide_align_feature_id    int(10) unsigned, # FK peptide_align_feature.peptide_align_feature_id
   cigar_line                  mediumtext,
   cigar_start                 int(10),
   cigar_end                   int(10),

  FOREIGN KEY (homology_id) REFERENCES homology(homology_id),
  FOREIGN KEY (member_id) REFERENCES member(member_id),
  FOREIGN KEY (peptide_member_id) REFERENCES member(member_id),
  FOREIGN KEY (peptide_align_feature_id) REFERENCES peptide_align_feature(peptide_align_feature_id),

  UNIQUE homology_member_id (homology_id,member_id),
  KEY (homology_id),
  KEY (member_id),
  KEY (peptide_member_id),
  KEY (peptide_align_feature_id)
) COLLATE=latin1_swedish_ci;



# conventions taken from the new clean schema of EnsEMBL
# use lower case and underscores
# internal ids are integers named tablename_id
# same name is given in foreign key relations
