aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/schema.org13
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/schema.org b/sql/schema.org
index 0d0646f..2db8a27 100644
--- a/sql/schema.org
+++ b/sql/schema.org
@@ -24,3 +24,16 @@ migrating the database.
Foreign keys?
** OrderId
Foreign keys?
+
+* Strain
+** Id
+ Primary key
+** Name
+ Name of the strain
+** Name2
+ A second name. For most rows, this is the same as Name. Why is this
+ necessary?
+** SpeciesId
+ Foreign key into the Species table
+** Symbol
+** Alias