summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authormo khan <mo.khan@gmail.com>2020-04-27 11:53:54 -0600
committermo khan <mo.khan@gmail.com>2020-04-27 11:53:54 -0600
commit3de6da114215277048e0855464a7b4e8ba2caacc (patch)
tree926577262502b92bbc1fe41d5dcbe28f2f956225
parent6b62cc1e839233f7baf122d4a7b898eee2b98590 (diff)
Describe difference between primary key constraint and not null constraint
-rw-r--r--README.md9
1 files changed, 9 insertions, 0 deletions
diff --git a/README.md b/README.md
index 37c3d17..1a72810 100644
--- a/README.md
+++ b/README.md
@@ -882,3 +882,12 @@ Time: 0.813 ms
Using a range type can sometimes make it easier to model something.
Never use strings to store dates or numbers.
Use a range type to store a range.
+
+* Primary key constraint
+ * only on per table
+ * unique
+ * not null
+* unique constraint
+ * more than one per table allowed
+ * unique
+ * nulls are allowed