--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/README	Tue Jun 26 16:14:59 2018 +0200
@@ -0,0 +1,24 @@
+Build Dockerfile with e.g.:
+$ docker build -t wamos .
+
+Get a running instance with e.g.:
+$ docker run --name wamos -d -p 54321:5432 -v $PWD:/opt/wamos wamos
+
+Run tests for RLS policies as database superuser (within container) with:
+$ psql -d wamos -Xf tap_tests.sql
+
+Create ER diagrams with e.g.:
+Auxiliary tables:
+$ postgresql_autodoc -p 54321 -h $dockerhost \
+      -U wamos --password=wamos -t dot -l . -s 'wamos'
+$ dot -Tpdf wamos.dot > wamos_auxiliary.pdf
+
+Waterway related tables:
+$ postgresql_autodoc -p 54321 -h $dockerhost \
+      -U wamos --password=wamos -t dot -l . -s 'wamos_waterway'
+$ dot -Tpdf wamos.dot > wamos_waterway.pdf
+
+Fairway/bottleneck related tables:
+$ postgresql_autodoc -p 54321 -h $dockerhost \
+      -U wamos --password=wamos -t dot -l . -s 'wamos_fairway'
+$ dot -Tpdf wamos.dot > wamos_fairway.pdf