diff options
Diffstat (limited to 'migrations/dbasik.sql')
-rw-r--r-- | migrations/dbasik.sql | 32 |
1 files changed, 0 insertions, 32 deletions
diff --git a/migrations/dbasik.sql b/migrations/dbasik.sql deleted file mode 100644 index b5bb6f9..0000000 --- a/migrations/dbasik.sql +++ /dev/null @@ -1,32 +0,0 @@ -CREATE TABLE "datamap" ( - "id" int PRIMARY KEY, - "name" varchar, - "description" varchar -); - -CREATE TABLE "datamapline" ( - "id" uuid PRIMARY KEY, - "datamap_id" uuid, - "name" string, - "cellref" string, - "sheet" string, - "data_type" string -); - -CREATE TABLE "returnitem" ( - "id" uuid PRIMARY KEY, - "datamapline_id" uuid, - "return_id" int, - "value" string -); - -CREATE TABLE "return" ( - "id" int PRIMARY KEY, - "name" string -); - -ALTER TABLE "datamapline" ADD FOREIGN KEY ("datamap_id") REFERENCES "datamap" ("id"); - -ALTER TABLE "returnitem" ADD FOREIGN KEY ("datamapline_id") REFERENCES "datamapline" ("id"); - -ALTER TABLE "returnitem" ADD FOREIGN KEY ("return_id") REFERENCES "return" ("id"); |