documentation/img/dp3t-backend-dbschema.svg

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" version="1.1" width="391px" height="167px" viewBox="-0.5 -0.5 391 167" content="&lt;mxfile host=&quot;app.diagrams.net&quot; modified=&quot;2020-04-14T11:57:08.969Z&quot; agent=&quot;5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.149 Safari/537.36&quot; etag=&quot;ABKW_OrZOrpn-uTBgUs8&quot; version=&quot;12.9.12&quot; type=&quot;device&quot;&gt;&lt;diagram name=&quot;Page-1&quot; id=&quot;efa7a0a1-bf9b-a30e-e6df-94a7791c09e9&quot;&gt;7Zpdb5swFIZ/DVJ3sYmPkCaXhXSb1LSrlk67jBxwwIvBzJgm6a/fMZhASrvSbiSLRhU1+Pj465zXDziJZrnR5hNHSXjNfEw1U/c3mjXRTNMYmKYmX7q/LSyjc2UIOPGVU2WYkQesjLqyZsTH6Z6jYIwKkuwbPRbH2BN7NsQ5W++7LRndHzVBAW4YZh6iTet34otQrcIcVvbPmARhObIxHBc1C+StAs6yWI2nmdYy/yuqI1T2pRaahshn65rJutQslzMmiqto42IqY1uGrWj38Zna3bw5jkWbBldz9jNb/djeTM6HKPMmc34/fm8Yg6Kfe0QzFRExx5uEpdhX8xbbMlbpmkQUxVByliwWM1WjQ9kLCfWnaMsyOZlUQHDKkhMyTh7AH1GoMsAA1VwoKUCg6x4z2VL1yXEKPrflCo1Hpmu02XOcolSUs2GUoiQli3x+smGEeEBihwnBIuWEKAliuPagL8zLNRWzgrBYjooM5gJvng26sUslbBHMIiz4FlxUA9MYFU3U7jCGSg3rSmvWWNnCus6GSoBI6TvY9V3lGC5Uml+VcruR8mRV5nwu215A7QxzAglrSCBEibyEEAio/wpbEsWBrHUES1RkKV6WmeBqSfJ6UUbfqEW/8HVklAnsygtljojv570uCaUuowwSNIlZrr00QR6Jg2kxijWoTF/VaNLEoMslzXdcCJ3hWM6GCSTQYqfahJFY5AG2HXhBHlz9g63ZsFIXykZVhpd058JlcSo4Inn+MUhujaXsHJ+z5A5EhsvV1neI/UhdZlt1/W7TNkWnRFay6yWNWXpnEhs2JHZ79cdaWtR37xO6aCupff38Nfm8pBC5TCX+1lpQdz01ZnUzaaER+2mN1EVxWE2cNzSxwtsCNnd4I+Dt5sud/P9tOu2GO/rLIsk7O3Ho1IRVh5DRHXHslsQxu7upjRrqOjZvCin9H7A5fxNsOpTDuCEHjj1M7uEJBwkFHRJBrFCU5BOFecLJA0zw9iDza+oTvEQZlWCK2frsXQ+oDgDVHZNG5rGZVO6fnklHYdL4H2NSuaSaHCBQWNFoggTuCXNShDH00dERY/aIOR5invvw52iIsZrnbpQk85Rl3MMFZ9wQceTJD7ykG99CSs5svX+4OTH0WIOW6OnsPG81z/M9eg6GnmKnvx493cmhgwN4j5GuMWK3xEh3d6zmQb2nyOEoMnoTRbp7nLV6iJweRNp+p9mdbJpfYvcQOdwpyDoQRKBY/Vwir6v9JsW6/AU=&lt;/diagram&gt;&lt;/mxfile&gt;" style="background-color: rgb(255, 255, 255);"><defs><clipPath id="mx-clip-34-26-352-30-0"><rect x="34" y="26" width="352" height="30"/></clipPath><clipPath id="mx-clip-4-26-22-30-0"><rect x="4" y="26" width="22" height="30"/></clipPath><clipPath id="mx-clip-34-61-352-26-0"><rect x="34" y="61" width="352" height="26"/></clipPath><clipPath id="mx-clip-34-87-352-26-0"><rect x="34" y="87" width="352" height="26"/></clipPath><clipPath id="mx-clip-34-113-352-26-0"><rect x="34" y="113" width="352" height="26"/></clipPath><clipPath id="mx-clip-34-139-352-20-0"><rect x="34" y="139" width="352" height="20"/></clipPath></defs><g><path d="M 0 26 L 0 0 L 390 0 L 390 26" fill="#ffffff" stroke="#000000" stroke-miterlimit="10" pointer-events="all"/><path d="M 0 26 L 0 166 L 390 166 L 390 26" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><path d="M 0 26 L 390 26" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><g fill="#000000" font-family="Helvetica" text-anchor="middle" font-size="14px"><text x="194.5" y="18.5">t_exposed</text></g><path d="M 0 26 M 390 26 M 390 56 L 0 56" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><g fill="#000000" font-family="Helvetica" font-weight="bold" text-decoration="underline" clip-path="url(#mx-clip-34-26-352-30-0)" font-size="12px"><text x="35.5" y="45.5">pk_exposed_id: Serial</text></g><path d="M 0 26 M 30 26 L 30 56 M 0 56" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><g fill="#000000" font-family="Helvetica" clip-path="url(#mx-clip-4-26-22-30-0)" font-size="12px"><text x="5.5" y="45.5">PK</text></g><path d="M 0 56 M 390 56 M 390 82 M 0 82" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><g fill="#000000" font-family="Helvetica" font-weight="bold" clip-path="url(#mx-clip-34-61-352-26-0)" font-size="12px"><text x="35.5" y="73.5">key: Text NOT NULL</text></g><path d="M 0 56 M 30 56 L 30 82 M 0 82" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><path d="M 0 82 M 390 82 M 390 108 M 0 108" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><g fill="#000000" font-family="Helvetica" clip-path="url(#mx-clip-34-87-352-26-0)" font-size="12px"><text x="35.5" y="99.5">received_at: Timestamp with time zone Default now() NOT NULL</text></g><path d="M 0 82 M 30 82 L 30 108 M 0 108" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><path d="M 0 108 M 390 108 M 390 134 M 0 134" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><g fill="#000000" font-family="Helvetica" clip-path="url(#mx-clip-34-113-352-26-0)" font-size="12px"><text x="35.5" y="125.5">onset: Date NOT NULL</text></g><path d="M 0 108 M 30 108 L 30 134 M 0 134" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><path d="M 0 134 M 390 134 M 390 154 M 0 154" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><g fill="#000000" font-family="Helvetica" clip-path="url(#mx-clip-34-139-352-20-0)" font-size="12px"><text x="35.5" y="151.5">app_source: Character varying(50) NOT NULL</text></g><path d="M 0 134 M 30 134 L 30 154 M 0 154" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><path d="M 0 154 M 390 154 M 390 160 M 0 160" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><path d="M 0 154 M 30 154 L 30 160 M 0 160" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><path d="M 0 160 M 390 160 M 390 166 M 0 166" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/><path d="M 0 160 M 30 160 L 30 166 M 0 166" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/></g></svg>