about summary refs log tree commit diff
diff options
context:
space:
mode:
-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