diff options
| -rw-r--r-- | sql/schema.org | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/sql/schema.org b/sql/schema.org new file mode 100644 index 0000000..0d0646f --- /dev/null +++ b/sql/schema.org @@ -0,0 +1,26 @@ +#+TITLE: GeneNetwork Database Schema + +This is an attempt to reverse engineer and understand the schema of the +GeneNetwork database. The goal is to prune redundant tables, fields, etc. and +arrive at a simplified schema. This simplified schema will be useful when +migrating the database. + +* Species +** Id + Primary key +** SpeciesId + Looks like a redundant key referred to as a foreign key from many other + tables. This field should be replaced by Id. +** SpeciesName + Common name of the species. This field can be replaced by MenuName. +** Name + Downcased common name used as key for the species in dictionaries +** MenuName + Name in the Species dropdown menu. This is the SpeciesName, but sometimes + with the reference genome identifier mentioned in brackets. +** FullName + Binomial name of the species +** TaxonomyId + Foreign keys? +** OrderId + Foreign keys? |