Lesson13 Init DB

Tanechka · Tanechka · commit 79f4e1d3ecc9 · 2017-08-24T23:33:24.000-07:00
diff --git a/config/init_db.sql b/config/init_db.sql
@@ -0,0 +1,13 @@
+CREATE TABLE resume (
+  uuid      CHAR(36) PRIMARY KEY NOT NULL,
+  full_name TEXT                 NOT NULL
+);
+
+CREATE TABLE contact (
+  id          SERIAL,
+  resume_uuid CHAR(36) NOT NULL REFERENCES resume (uuid) ON DELETE CASCADE,
+  type        TEXT     NOT NULL,
+  value       TEXT     NOT NULL
+);
+CREATE UNIQUE INDEX contact_uuid_type_index
+  ON contact (resume_uuid, type);
