AspGD Schema Specifications

Last Updated:

This page contains links to the table specifications, schema diagrams, and business rules for the AspGD database.

Download all tables

Table Specifications	Relevant Schema Diagram	Business Rules
Administration: code, dbuser, state, update_log, delete_log, external_id, template_url, acelink Linking tables: ei_tu	Admin	Admin rules
Chromosome: chromosome	Locus, Locus-Feature-Ids, Sequence	Sequence rules
Colleague: colleague, colleague_remark, associate, pi, email, phone, keyword Linking tables: coll_cn, coll_email, coll_locus, coll_phone, coll_url, coll_keyword, coll_para	Colleague	Colleague rules
Community Annotation: annotation_set, community_annotation, annotation_detail	Colleague	Community Annotation rules
Dataset: dataset, dataset_display, dataset_sample, sample_value, dataset_group, regulator, dataset_regulator, score Linking tables: dg_feat	Dataset-Sage	Dataset rules
Feature: feature, subfeature, feature_type, subfeature_type, chromosome, feat_gene_info, alias Linking tables: feat_alias, feat_cn, feat_pheno	Reference, GO-Phenotype, Locus-Feature-Ids, Sequence	Feature rules
Gene Ontology (GO): go, go_set, go_evidence, go_synonym, go_path Linking tables: go_gosyn, go_feat_goev, go_locus_goev	GO-Phenotype	GO rules
Homolog: homolog, homolog_alignment	Homolog-Taxonomy	Alignments/Taxonomy rules
Locus: locus, gene_product, gene_reservation, alias, locus_gene_info, chromosome, clone Linking tables: locus_alias, locus_cn, locus_gp, locus_twopt	Colleague, Locus, Locus-Feature-Ids, Go-Phenotype, Reference	Locus rules
Note: note, note_link, curator_note Linking tables: coll_cn, locus_cn feat_cn	Admin	Note rules
Paragraph: paragraph, phrase, phrase_category, phrase_link Linking tables: coll_para	Locus	Paragraph rules
PDB data: pdb_sequence, pdb_alignment, alignment_sequence	Homolog-Taxonomy	PDB rules
Phenotype: phenotype, interaction Linking tables: feat_pheno, , feat_interaction, interaction_pheno	GO-Phenotype	Phenotype rules
Protein: protein_info, protein_detail,	Protein	Protein rules YPD Protein Info rules
Reference: reference, abstract, author, book, journal, publication_type, related_ref, feat_gene_info, locus_gene_info, reflink Linking tables: author_editor, ref_unlink, ref_bad, ref_url	Reference	Reference rules
Sequence: display_seq, chromosome_archive, chromosome_update, feature_update, subfeature_update	Sequence	Sequence rules
AspGDID: AspGDID	Locus-Feature-Ids	AspGDID rules
Taxonomy: taxonomy, tax_synonym, tax_hierarchy	Homology-Taxonomy	Alignments/Taxonomy rules
URL: url Linking tables: ref_url, coll_url	Reference, Colleague	URL rules