aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--.gitignore8
-rw-r--r--common.mk2
-rw-r--r--eindopdracht/b5.sql42
-rw-r--r--eindopdracht/eindopdracht.m452
-rw-r--r--eindopdracht/imgs.drawio1
-rw-r--r--eindopdracht/imgs_database_diagram.svg1760
-rw-r--r--eindopdracht/imgs_erd.svg3
-rw-r--r--eindopdracht/imgs_strokendiagram.svg3
-rwxr-xr-xeindopdracht/import.js47
-rw-r--r--eindopdracht/makefile16
-rw-r--r--eindopdracht/q8.sql12
-rw-r--r--eindopdracht/reset.sql6
-rw-r--r--eindopdracht/t8.sql1
-rw-r--r--eindopdracht/t9.sql9
-rw-r--r--opdracht-1/reset.sql8
15 files changed, 1962 insertions, 8 deletions
diff --git a/.gitignore b/.gitignore
index 5c49fdf..54e250c 100644
--- a/.gitignore
+++ b/.gitignore
@@ -1,7 +1,9 @@
-opdracht-*/*.md
-opdracht-*/.tmp.sql
+**/*.md
+**/.tmp.sql
opdracht-*/opdracht.pdf
-opdracht-*/opdracht-*.md
+eindopdracht/nfs.xlsx
+eindopdracht/nfs.csv
+eindopdracht/q5.sql
# latex files
**/*.aux
diff --git a/common.mk b/common.mk
index 3770740..20b0474 100644
--- a/common.mk
+++ b/common.mk
@@ -24,6 +24,6 @@ reset: .tmp.sql
$(TARGET).md: $(TESTS_MD) $(TARGET).m4
$(M4) $(TARGET).m4 > $(TARGET).md
-clean:
+clean::
$(RM) $(wildcard *.md) .tmp.sql
diff --git a/eindopdracht/b5.sql b/eindopdracht/b5.sql
new file mode 100644
index 0000000..fa7a548
--- /dev/null
+++ b/eindopdracht/b5.sql
@@ -0,0 +1,42 @@
+create table if not exists Land (
+ ID int unsigned not null auto_increment,
+ Naam varchar(90) not null,
+ primary key (ID),
+ unique(Naam)
+);
+
+create table if not exists Locatie (
+ ID int unsigned not null auto_increment,
+ LandID int unsigned not null,
+ Naam varchar(90) not null,
+ primary key (ID),
+ foreign key (LandID) references Land(ID),
+ unique(Naam)
+);
+
+create table if not exists Merk (
+ ID int unsigned not null auto_increment,
+ Naam varchar(90) not null,
+ primary key (ID),
+ unique(Naam)
+);
+
+create table if not exists Hoofdkantoor (
+ ID int unsigned not null auto_increment,
+ LocatieID int unsigned not null,
+ MerkID int unsigned not null,
+ primary key (ID),
+ foreign key (LocatieID) references Locatie(ID),
+ foreign key (MerkID) references Merk(ID)
+);
+
+create table if not exists `Type` (
+ ID int unsigned not null auto_increment,
+ Naam varchar(90) not null,
+ MerkID int unsigned not null,
+ Vermogen int unsigned not null,
+ primary key (ID),
+ foreign key (MerkID) references Merk(ID),
+ unique(Naam)
+);
+
diff --git a/eindopdracht/eindopdracht.m4 b/eindopdracht/eindopdracht.m4
new file mode 100644
index 0000000..ce4d795
--- /dev/null
+++ b/eindopdracht/eindopdracht.m4
@@ -0,0 +1,52 @@
+changequote(`{{', `}}')
+include({{../common.m4}})
+
+# Eindopdracht
+
+## Opdracht 1
+
+1. Data bekijken en redundante kolommen in eigen tabellen zetten
+2. Strokendiagram maken
+3. SQL script maken om de database tabellen te initialiseren
+4. SQL scripts maken om de tabellen te vullen met data uit de spreadsheet
+
+## Opdracht 2
+
+- Hoofdkantoren kunnen in een eigen tabel, en naar gerefereerd worden via id
+ nummers
+- Merken kunnen in een eigen tabel, en naar gerefereerd worden via id nummers
+- Types kunnen in een eigen tabel opgeslagen worden en een referentie hebben
+ naar een merk
+- Vermogen wordt in twee eenheden opgeslagen terwijl de ene eenheid van de
+ andere afgeleid kan worden
+
+## Opdracht 3
+
+![](imgs_erd.svg)
+
+## Opdracht 4
+
+![](imgs_strokendiagram.svg)
+
+De keuze om bij de `Hoofdkantoor` tabel geen alternate key boven de `LocatieID` en
+`MerkID` te zetten is een bewuste, op deze manier kan er namelijk onderscheid
+blijven tussen meerdere bedrijven die in verschillende delen van een
+kantoorgebouw zitten.
+
+q_norm(5)
+
+De `insert` commando's worden door een script gegenereerd die de excel
+spreadsheet als csv inneemt, zie makefile voor implementatie.
+
+## Opdracht 6
+
+![](imgs_database_diagram.svg)
+
+## Opdracht 7
+
+De primary/foreign key relaties zijn al aangelegd door de database initalisatie
+query.
+
+q_with_test(8)
+q_with_output(9)
+
diff --git a/eindopdracht/imgs.drawio b/eindopdracht/imgs.drawio
new file mode 100644
index 0000000..ff79943
--- /dev/null
+++ b/eindopdracht/imgs.drawio
@@ -0,0 +1 @@
+<mxfile host="Electron" modified="2022-10-07T15:54:26.253Z" agent="5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) draw.io/20.3.0 Chrome/104.0.5112.114 Electron/20.1.3 Safari/537.36" etag="Ei6lezoM3Df-31srvb4B" version="20.3.0" type="device" pages="2"><diagram id="R2lEEEUBdFMjLlhIrx00" name="ERD">7Vpbb5swFP41PKaCALk8Nrd2XbJlTbd2e5k8cAAFMDImCf31M8VcTdIsaoBIk6KI89k+xp8/n3MgEeSxs7/DwDMXSIe20BX1vSBPhG532OvT7wgIY0AdMsDAlh5DUgasrFfIQJGhgaVDv9CRIGQTyyuCGnJdqJECBjBGu2K3NbKLs3rAgByw0oDNo8+WTswYHahiht9DyzCTmSWRtTgg6cwA3wQ62hUguCcz5BJ2i0uIHeBCl9CWBcAbiAV1ahISrfRW6M7oZx31vjEQMmwIPMu/0ZBDYc2nXWZr4Fh2RHPO0Yg5otPJU0EeY4RIfOXsx9COtirZhvieZgdaUx5w5PeEAc+LX9v+bvwj3E0+r7x7uTMSv3e6sZctsAPG7wLiDeOHhAnpGAWuDiNHoiCPdqZF4MoDWtS6oyqjmEkcm1oSvWQuISZwf/BepZQBKlSIHEhwSLuwAV2Fbcgu2+I+g8zc7soMA2zHjNRTRgS9YFz8Ay8yx8tT6MHmeGmKB4Xj4R6htb4BLj30uHGdKCqvk/TA10KQyhHkYaQHGqTL4ukxkfMn8GuhJqUhT41UJzU9jhoTwnWzrMgVgqn1QPU5Ujg+oE4THjPpsiwSPkIbEAu506xlFGUelp2lbpEn6Oq3Uaal5vSRJh79qxuNKB5O6hmHL3njZ2TcqIk52ecbJ2Fi7S3ykkxEr3OjqJUNioxkDEuuOpfZS9tGaUAB1uD7540AbEDyXmI7Gkcr40QK4jfKt8UbrlIDm2OJrLc6IUlgiaiSKqukp3idbFA+aZf8yCU/nbKjmAjO0Zs203WfL9dB3XJFLnxCC+CGhwUrnSdYsd2Clf8L9iMEK0ktVOx1hdjeiYpVmlWsLBaVppypWKXkp9O7mGKX8sN68zRffpqLndeOtr0zto8dXrBzpFFiGnzaYAN6w/qKpUpq+KdTnwAQ7Z3l8uzUWEaqA56ZQZ3M8M+nF45y75aR15WVT41xTZeRg2Jsks4NcvLgeLC8cIzjXyM0LdfWpuRjgTAv18O5pDm5KsrHpGRVaTYl8y91LizXa37qOVWwbawhr1CwQF0M5+Fv/dss+OI/BLNvClxV1JCW33yV1K+oHy9VJVXSwtePc5oXeE5qrquHFa9mL1VXV/LSvuqxten42HHLR7fD+msuug1KUWl4ZnQblqObVG90q716vOZ0fKpg21g/tl+w1Mx+sY+7Z/+ykKd/AQ==</diagram><diagram id="zBtBVbs9YWVG884YRixd" name="Strokendiagram">7Vxbd9o4EP41PIbjK9iPAUKbLsk2TdPd7EuPsAU4GIsjRMD59ZWxhG1J0Cw3OwW/xBpLsvTNfDPSyKFmtifLTxhMR3fIh2HN0PxlzezUDEN3HJf+SSRxKmlYeioY4sBnlTLBY/AGmVBj0nngw1mhIkEoJMG0KPRQFEGPFGQAY7QoVhugsPjWKRhCSfDogVCW/hP4ZJRKHVvL5J9hMBzxN+saezIBvDITzEbAR4ucyLypmW2MEEnvJss2DBPwOC5pu+6Gp+uBYRiR9zT4YQ0XV7D3BLrL70/tB7+10PtXrJdXEM7ZhG87bLgk5hhgNI98mHSj1czWYhQQ+DgFXvJ0QbVOZSMyCWlJp7fysPg7ICZwmROxYX6CaAIJjmkV9nSt/JhbESsvMg00mWiUA58jDZjOh+ueM1joDUPmf6BkSCjdAzApHyenYjjplgTUHcRjCSg6P1JEY0YwGsM2ChGmkghFtGZrEIShIAJhMIxoEaezaSVgBZSt10w+CXw/eYsS/aJ+DqGApqAAW1aAc0oFWI6kAAl8GPnXiWOkJS8Es1ngrfAHmMjinIbeCR70C/5Uhi4Hja2AhsswDAEJXoteWIUXe8NXFNCRrDVjGkXNGJZbbzaKvczQHHuQNcw7TrEvV+7LdYt9UfiGkEh9rZS4nvweenUlvQJZsRT6HujTAFxQHKeMR1UF8TbOYDgL3kB/1V+i5GkyndUE7VbN7lBJmHTfQtiHmBOzZpjd1ZVYEeVbEA2/MXWqDWW74YrcW0d2Nq5C8CwY1q4Ww6ugwWAG99WeeQOul90Xvz+P+y68XzrduytF+DhMkFWAJTFyo+8SXZd2utihBMk8WozdCyZpLXJCnP6ybsJ5l4wH3Z+vnVvDm/wdg6Ot2HZDibvExulQ+foQwy/9peeY5nOn4b9cP4Inbj2CN3xkRYTJCA1RBMKbTCpEtKxOD6Epg+YFEhKzTQmYE1QEDi4D8m/SvG6z0jPrLLnvLPOFmBciOt1co6T4zPtLClmzVYm3U0ZXZQROw9oWC2KLtDRk/c5t7eFn9zJzeSXZQx59L6ye6yzd+BVrvIvxU7X85zq338xm8Dp++zkat++n9zPuPvPGv3ljfALj3zZIYRtVAcvXrfJMX4lUJZdW601MVVCq6NpK2qSVjZMcdL7HUyjhVKH0xV74W6KdWjL+x0pfKAOZdQlk7w5k9okC2arpNcYgzlVgmYGN6RfLsIuWZQq5aaE+NcVt9elNOoJdt+XbEKxelJUSTmX7xYaE1A+IJ2gIo9KxshoVW4zLViU7tcNlYH/vSsrKwEqLoH0ysIps7vEysEq1yhSYKoNVRROw786rFi1os4VXNP+qHHDzQsmUNuJ5YVNwgu/moy11VKchO7uMk3JTPvT6UIcjh+Rm86NxUz7YOlNuiucMu3JTQfIyucmndQmczNY/Ejl1ORF5nuwUMv6OW3d2Y6eYQHW1ulYiOY0LOYu2/qHYKad1z5OdMqkOEzrFfo7NRjn9fLbr2NS2K8pG5Wn5xgNrSYV/yvGBoRXpwoNkWacH+tmn3nh6zN7RAYofNtjlbh0uOTfBtivqD5Uf8MiLk88IDfwxiAiiGB7eKYZwUKJPFA6uynOCcrKzAida4gpNgdJJD2l0OWVYiS8ixCxQ6Thd0nNqA9bdetPNXba9W8QVFW5odc3I9ds0TxpyuSFdQi63/YqGXLX2Lum6TazakZ2OxM7CelgXsoDHZqecrjvbBMEmA6swO+UVcQ9EvqTAPy49cIKlsPPk9Uevi29krs/tQc9++AJvL5/FZ6L814RKrBSfxW/ZXuxBu700Kse3hEEV3N8c8b/EaDH7zYDUN2W/vGDe/AI=</diagram></mxfile> \ No newline at end of file
diff --git a/eindopdracht/imgs_database_diagram.svg b/eindopdracht/imgs_database_diagram.svg
new file mode 100644
index 0000000..77c5adb
--- /dev/null
+++ b/eindopdracht/imgs_database_diagram.svg
@@ -0,0 +1,1760 @@
+<?xml version="1.0" encoding="UTF-8" standalone="no"?>
+<svg
+ width="332.21927"
+ height="161.57471"
+ viewBox="0 0 332.21927 161.57471"
+ version="1.1"
+ id="svg1324"
+ sodipodi:docname="imgs_database_diagram.svg"
+ inkscape:version="1.2.1 (9c6d41e410, 2022-07-14, custom)"
+ xmlns:inkscape="http://www.inkscape.org/namespaces/inkscape"
+ xmlns:sodipodi="http://sodipodi.sourceforge.net/DTD/sodipodi-0.dtd"
+ xmlns:xlink="http://www.w3.org/1999/xlink"
+ xmlns="http://www.w3.org/2000/svg"
+ xmlns:svg="http://www.w3.org/2000/svg">
+ <sodipodi:namedview
+ id="namedview1326"
+ pagecolor="#505050"
+ bordercolor="#eeeeee"
+ borderopacity="1"
+ inkscape:showpageshadow="0"
+ inkscape:pageopacity="0"
+ inkscape:pagecheckerboard="0"
+ inkscape:deskcolor="#505050"
+ showgrid="false"
+ inkscape:zoom="1.7052195"
+ inkscape:cx="-26.389565"
+ inkscape:cy="104.67861"
+ inkscape:window-width="1900"
+ inkscape:window-height="1040"
+ inkscape:window-x="10"
+ inkscape:window-y="450"
+ inkscape:window-maximized="1"
+ inkscape:current-layer="svg1324" />
+ <defs
+ id="defs824">
+ <g
+ id="g822">
+ <g
+ id="glyph-0-0" />
+ <g
+ id="glyph-0-1">
+ <path
+ d="M 1.53125,-4.875 H 0.515625 V 0 H 3.96875 v -0.890625 h -2.4375 z m 0,0"
+ id="path682" />
+ </g>
+ <g
+ id="glyph-0-2">
+ <path
+ d="m 3.375,-2.671875 c 0,-0.890625 -0.9375,-1.046875 -1.4375,-1.046875 -0.75,0 -1.515625,0.15625 -1.625,1.265625 h 0.921875 c 0.015625,-0.203125 0.109375,-0.5 0.578125,-0.5 0.25,0 0.625,0.03125 0.625,0.421875 0,0.203125 -0.1875,0.265625 -0.328125,0.28125 L 1.25,-2.109375 c -0.609375,0.078125 -1.046875,0.4375 -1.046875,1.15625 0,0.75 0.546875,1.046875 1.09375,1.046875 C 1.9375,0.09375 2.25,-0.203125 2.46875,-0.421875 2.484375,-0.21875 2.5,-0.171875 2.5625,0 H 3.578125 V -0.140625 C 3.46875,-0.1875 3.375,-0.28125 3.375,-0.703125 Z m -0.9375,1.375 c 0,0.4375 -0.421875,0.71875 -0.84375,0.71875 -0.1875,0 -0.4375,-0.109375 -0.4375,-0.4375 C 1.15625,-1.40625 1.4375,-1.5 1.796875,-1.5625 2.1875,-1.625 2.34375,-1.6875 2.4375,-1.765625 Z m 0,0"
+ id="path685" />
+ </g>
+ <g
+ id="glyph-0-3">
+ <path
+ d="m 3.71875,-2.5 c 0,-0.796875 -0.5625,-1.21875 -1.265625,-1.21875 -0.6875,0 -0.953125,0.421875 -1.09375,0.640625 v -0.53125 H 0.4375 V 0 h 0.953125 v -2.078125 c 0,-0.546875 0.328125,-0.828125 0.75,-0.828125 0.609375,0 0.625,0.453125 0.625,0.703125 V 0 H 3.71875 Z m 0,0"
+ id="path688" />
+ </g>
+ <g
+ id="glyph-0-4">
+ <path
+ d="M 3.75,-4.875 H 2.796875 v 1.734375 H 2.78125 C 2.625,-3.375 2.34375,-3.71875 1.734375,-3.71875 c -0.796875,0 -1.5,0.625 -1.5,1.875 0,0.984375 0.4375,1.9375 1.515625,1.9375 0.390625,0 0.8125,-0.140625 1.046875,-0.546875 H 2.8125 V 0 H 3.75 Z m -2.546875,3.09375 c 0,-0.578125 0.203125,-1.109375 0.8125,-1.109375 0.65625,0 0.8125,0.59375 0.8125,1.171875 0,0.53125 -0.234375,1.03125 -0.84375,1.03125 -0.609375,0 -0.78125,-0.671875 -0.78125,-1.09375 z m 0,0"
+ id="path691" />
+ </g>
+ <g
+ id="glyph-0-5">
+ <path
+ d="m 3.921875,-1.8125 c 0,-1.296875 -0.875,-1.90625 -1.84375,-1.90625 -0.96875,0 -1.84375,0.609375 -1.84375,1.90625 0,1.3125 0.875,1.90625 1.84375,1.90625 0.96875,0 1.84375,-0.59375 1.84375,-1.90625 z m -0.96875,0 c 0,0.46875 -0.140625,1.109375 -0.875,1.109375 -0.734375,0 -0.875,-0.640625 -0.875,-1.109375 0,-0.453125 0.140625,-1.09375 0.875,-1.09375 0.734375,0 0.875,0.640625 0.875,1.09375 z m 0,0"
+ id="path694" />
+ </g>
+ <g
+ id="glyph-0-6">
+ <path
+ d="m 2.59375,-1.3125 c 0,0.15625 -0.171875,0.625 -0.65625,0.625 -0.71875,0 -0.734375,-0.78125 -0.734375,-1.171875 0,-0.453125 0.15625,-1.046875 0.765625,-1.046875 0.4375,-0.03125 0.59375,0.34375 0.625,0.578125 H 3.5625 c -0.09375,-1.125 -1.03125,-1.390625 -1.59375,-1.390625 -1.234375,0 -1.734375,0.84375 -1.734375,2.015625 0,0.765625 0.3125,1.796875 1.671875,1.796875 1.328125,0 1.609375,-1.03125 1.65625,-1.40625 z m 0,0"
+ id="path697" />
+ </g>
+ <g
+ id="glyph-0-7">
+ <path
+ d="M 1.515625,-4.59375 H 0.5625 v 0.984375 h -0.5 V -2.9375 h 0.5 v 2.203125 c 0,0.46875 0.140625,0.78125 0.96875,0.78125 h 0.125 c 0.140625,0 0.296875,-0.015625 0.4375,-0.015625 V -0.6875 c -0.0625,0 -0.125,0.015625 -0.1875,0.015625 -0.390625,0 -0.390625,-0.09375 -0.390625,-0.296875 V -2.9375 H 2.09375 V -3.609375 H 1.515625 Z m 0,0"
+ id="path700" />
+ </g>
+ <g
+ id="glyph-0-8">
+ <path
+ d="M 0.46875,-3.609375 V 0 h 0.953125 v -3.609375 z m 0.953125,-1.3125 H 0.46875 v 0.875 h 0.953125 z m 0,0"
+ id="path703" />
+ </g>
+ <g
+ id="glyph-0-9">
+ <path
+ d="M 2.5625,-1.0625 C 2.5,-0.796875 2.21875,-0.671875 1.953125,-0.671875 c -0.765625,0 -0.8125,-0.609375 -0.84375,-0.875 H 3.59375 V -1.71875 c 0,-1.65625 -0.984375,-2 -1.703125,-2 -1.578125,0 -1.734375,1.40625 -1.734375,1.84375 0,1.484375 0.78125,1.96875 1.796875,1.96875 0.625,0 1.34375,-0.28125 1.59375,-1.15625 z M 1.140625,-2.171875 c 0.046875,-0.46875 0.28125,-0.75 0.734375,-0.75 0.3125,0 0.6875,0.171875 0.734375,0.75 z m 0,0"
+ id="path706" />
+ </g>
+ <g
+ id="glyph-0-10">
+ <path
+ d="M 5.203125,-4.875 H 3.71875 L 2.859375,-1.03125 H 2.84375 L 1.953125,-4.875 H 0.46875 V 0 H 1.421875 V -4.078125 H 1.4375 L 2.328125,0 h 1 l 0.90625,-4.078125 H 4.25 V 0 h 0.953125 z m 0,0"
+ id="path709" />
+ </g>
+ <g
+ id="glyph-0-11">
+ <path
+ d="m 0.4375,0 h 0.953125 v -1.875 c 0,-0.40625 0.125,-0.875 0.875,-0.875 0.09375,0 0.1875,0 0.265625,0.015625 v -0.96875 c -0.0625,0 -0.125,-0.015625 -0.171875,-0.015625 -0.578125,0 -0.796875,0.359375 -1,0.734375 H 1.34375 v -0.625 H 0.4375 Z m 0,0"
+ id="path712" />
+ </g>
+ <g
+ id="glyph-0-12">
+ <path
+ d="M 1.421875,-1.140625 1.8125,-1.546875 2.671875,0 H 3.8125 L 2.515625,-2.21875 3.78125,-3.609375 H 2.609375 L 1.421875,-2.25 V -4.875 H 0.46875 V 0 h 0.953125 z m 0,0"
+ id="path715" />
+ </g>
+ <g
+ id="glyph-0-13">
+ <path
+ d="M 3.40625,-2.1875 V 0 H 4.421875 V -4.875 H 3.40625 v 1.84375 H 1.5 V -4.875 H 0.484375 V 0 H 1.5 v -2.1875 z m 0,0"
+ id="path718" />
+ </g>
+ <g
+ id="glyph-0-14">
+ <path
+ d="M 1.546875,-2.9375 H 2.15625 V -3.609375 H 1.546875 v -0.15625 c 0,-0.296875 0,-0.390625 0.328125,-0.390625 H 2.140625 V -4.921875 C 2.0625,-4.9375 1.9375,-4.9375 1.65625,-4.9375 1,-4.9375 0.59375,-4.65625 0.59375,-3.90625 v 0.296875 H 0.0625 V -2.9375 H 0.59375 V 0 h 0.953125 z m 0,0"
+ id="path721" />
+ </g>
+ <g
+ id="glyph-0-15">
+ <path
+ d="M 2.59375,-4.015625 H 4.0625 V -4.875 H 0.09375 v 0.859375 H 1.5625 V 0 h 1.03125 z m 0,0"
+ id="path724" />
+ </g>
+ <g
+ id="glyph-0-16">
+ <path
+ d="m 3.65625,-3.609375 h -1 l -0.734375,2.65625 H 1.90625 L 1.125,-3.609375 H 0.0625 L 1.40625,0.15625 C 1.3125,0.640625 1.125,0.6875 0.78125,0.6875 c -0.09375,0 -0.15625,0 -0.1875,-0.015625 V 1.4375 c 0.140625,0.015625 0.296875,0.015625 0.421875,0.015625 0.828125,0 0.953125,-0.171875 1.40625,-1.515625 z m 0,0"
+ id="path727" />
+ </g>
+ <g
+ id="glyph-0-17">
+ <path
+ d="m 1.328125,-1.71875 c 0,-0.578125 0.15625,-1.171875 0.8125,-1.171875 0.609375,0 0.8125,0.53125 0.8125,1.109375 0,0.421875 -0.171875,1.09375 -0.78125,1.09375 -0.609375,0 -0.84375,-0.5 -0.84375,-1.03125 z m 0,-1.890625 H 0.421875 V 1.40625 H 1.375 v -1.875 h 0.015625 c 0.109375,0.203125 0.34375,0.5625 1.015625,0.5625 1.078125,0 1.515625,-0.953125 1.515625,-1.9375 0,-1.25 -0.703125,-1.875 -1.5,-1.875 -0.640625,0 -0.90625,0.34375 -1.078125,0.625 H 1.328125 Z m 0,0"
+ id="path730" />
+ </g>
+ <g
+ id="glyph-1-0" />
+ <g
+ id="glyph-1-1">
+ <path
+ d="M 1.28125,-4.875 H 0.625 V 0 h 0.65625 z m 0,0"
+ id="path734" />
+ </g>
+ <g
+ id="glyph-1-2">
+ <path
+ d="M 0.546875,0 H 2.5 C 4.109375,0 4.578125,-1.40625 4.578125,-2.515625 4.578125,-3.921875 3.796875,-4.875 2.53125,-4.875 H 0.546875 Z m 0.65625,-4.3125 H 2.4375 c 0.90625,0 1.46875,0.609375 1.46875,1.84375 0,1.234375 -0.5625,1.90625 -1.421875,1.90625 h -1.28125 z m 0,0"
+ id="path737" />
+ </g>
+ <g
+ id="glyph-1-3" />
+ <g
+ id="glyph-1-4">
+ <path
+ d="M 3.75,-0.9375 H 3.734375 L 1.296875,-4.875 H 0.515625 V 0 H 1.15625 V -3.9375 H 1.171875 L 3.65625,0 H 4.390625 V -4.875 H 3.75 Z m 0,0"
+ id="path741" />
+ </g>
+ <g
+ id="glyph-1-5">
+ <path
+ d="M 0.09375,-4.296875 H 1.75 V 0 H 2.40625 V -4.296875 H 4.0625 V -4.875 H 0.09375 Z m 0,0"
+ id="path744" />
+ </g>
+ <g
+ id="glyph-1-6">
+ <path
+ d="m 0.96875,-2.46875 c 0.046875,-0.28125 0.140625,-0.6875 0.8125,-0.6875 0.578125,0 0.84375,0.203125 0.84375,0.578125 0,0.34375 -0.171875,0.40625 -0.3125,0.421875 l -0.984375,0.125 c -1,0.109375 -1.078125,0.8125 -1.078125,1.109375 0,0.609375 0.453125,1.03125 1.109375,1.03125 0.6875,0 1.046875,-0.328125 1.28125,-0.578125 C 2.671875,-0.203125 2.75,0.0625 3.28125,0.0625 3.40625,0.0625 3.5,0.03125 3.609375,0 v -0.4375 c -0.078125,0.015625 -0.15625,0.03125 -0.203125,0.03125 -0.125,0 -0.203125,-0.0625 -0.203125,-0.21875 v -2.046875 c 0,-0.90625 -1.03125,-0.984375 -1.3125,-0.984375 -0.875,0 -1.4375,0.328125 -1.46875,1.1875 z m 1.640625,1.234375 c 0,0.484375 -0.546875,0.84375 -1.09375,0.84375 -0.453125,0 -0.65625,-0.234375 -0.65625,-0.625 0,-0.453125 0.46875,-0.53125 0.765625,-0.578125 0.734375,-0.09375 0.890625,-0.140625 0.984375,-0.21875 z m 0,0"
+ id="path747" />
+ </g>
+ <g
+ id="glyph-1-7">
+ <path
+ d="m 0.4375,0 h 0.609375 v -1.9375 c 0,-0.96875 0.59375,-1.1875 0.9375,-1.1875 0.4375,0 0.546875,0.359375 0.546875,0.671875 V 0 h 0.609375 v -2.171875 c 0,-0.46875 0.328125,-0.953125 0.828125,-0.953125 0.515625,0 0.65625,0.34375 0.65625,0.828125 V 0 h 0.609375 v -2.453125 c 0,-1 -0.734375,-1.203125 -1.109375,-1.203125 -0.546875,0 -0.78125,0.25 -1.09375,0.578125 -0.09375,-0.1875 -0.296875,-0.578125 -0.9375,-0.578125 -0.640625,0 -0.9375,0.421875 -1.078125,0.609375 H 1 V -3.5625 H 0.4375 Z m 0,0"
+ id="path750" />
+ </g>
+ <g
+ id="glyph-1-8">
+ <path
+ d="M 2.28125,-0.71875 H 2.265625 L 0.875,-4.875 H 0.140625 L 1.921875,0 h 0.6875 l 1.78125,-4.875 H 3.65625 Z m 0,0"
+ id="path753" />
+ </g>
+ <g
+ id="glyph-1-9">
+ <path
+ d="M 3.234375,-1.421875 3.71875,0 H 4.4375 L 2.671875,-4.875 H 1.9375 L 0.09375,0 h 0.6875 l 0.5,-1.421875 z M 1.484375,-2 2.265625,-4.15625 H 2.28125 L 3,-2 Z m 0,0"
+ id="path756" />
+ </g>
+ <g
+ id="glyph-1-10">
+ <path
+ d="m 1.25,-2.09375 h 1.609375 c 0.78125,0 0.859375,0.46875 0.859375,0.875 0,0.171875 0.03125,0.921875 0.125,1.21875 h 0.8125 v -0.109375 c -0.21875,-0.109375 -0.25,-0.21875 -0.25,-0.484375 L 4.359375,-1.484375 C 4.34375,-2.15625 4.0625,-2.28125 3.78125,-2.40625 c 0.3125,-0.171875 0.671875,-0.4375 0.671875,-1.15625 0,-1.03125 -0.796875,-1.3125 -1.59375,-1.3125 H 0.59375 V 0 H 1.25 Z m 0,-2.21875 h 1.65625 c 0.328125,0 0.875,0.0625 0.875,0.8125 0,0.71875 -0.515625,0.84375 -1,0.84375 H 1.25 Z m 0,0"
+ id="path759" />
+ </g>
+ <g
+ id="glyph-1-11">
+ <path
+ d="m 4.578125,-3.40625 c -0.09375,-0.828125 -0.75,-1.609375 -2,-1.609375 -1.421875,0 -2.28125,1.046875 -2.28125,2.546875 0,1.875 1.09375,2.59375 2.203125,2.59375 0.359375,0 1.859375,-0.078125 2.125,-1.921875 H 3.984375 c -0.21875,1.140625 -0.953125,1.34375 -1.390625,1.34375 -1.203125,0 -1.609375,-0.890625 -1.609375,-2.03125 0,-1.28125 0.703125,-1.9375 1.59375,-1.9375 0.46875,0 1.1875,0.15625 1.359375,1.015625 z m 0,0"
+ id="path762" />
+ </g>
+ <g
+ id="glyph-1-12">
+ <path
+ d="M 3.734375,-2.859375 H 1.1875 V -4.875 H 0.515625 V 0 H 1.1875 V -2.28125 H 3.734375 V 0 h 0.65625 v -4.875 h -0.65625 z m 0,0"
+ id="path765" />
+ </g>
+ <g
+ id="glyph-1-13">
+ <path
+ d="M 1.609375,-4.984375 C 0.875,-3.9375 0.46875,-2.96875 0.46875,-1.78125 c 0,1.28125 0.453125,2.125 1.15625,3.1875 h 0.40625 c -0.546875,-1.0625 -0.9375,-1.890625 -0.9375,-3.015625 0,-1.625 0.359375,-2.28125 0.9375,-3.375 z m 0,0"
+ id="path768" />
+ </g>
+ <g
+ id="glyph-1-14">
+ <path
+ d="m 1.78125,-1.59375 c 0.453125,0 0.921875,-0.203125 1.09375,-0.578125 L 2.890625,-2.15625 C 2.75,-0.921875 2.40625,-0.359375 1.75,-0.359375 c -0.5,0 -0.78125,-0.3125 -0.8125,-0.796875 H 0.34375 C 0.34375,-0.6875 0.640625,0.125 1.765625,0.125 3.40625,0.125 3.5,-2.046875 3.5,-2.5625 c 0,-0.78125 -0.15625,-2.21875 -1.671875,-2.21875 -1.015625,0 -1.546875,0.765625 -1.546875,1.640625 0,0.953125 0.625,1.546875 1.5,1.546875 z M 1.875,-2.140625 c -0.40625,0 -0.96875,-0.109375 -0.96875,-1.03125 0,-0.640625 0.359375,-1.0625 0.921875,-1.0625 0.6875,0 0.96875,0.46875 0.96875,1.015625 0,0.9375 -0.609375,1.078125 -0.921875,1.078125 z m 0,0"
+ id="path771" />
+ </g>
+ <g
+ id="glyph-1-15">
+ <path
+ d="m 2.890625,-2.328125 c 0,1.203125 -0.3125,1.921875 -1,1.921875 -0.6875,0 -1,-0.71875 -1,-1.921875 0,-1.1875 0.3125,-1.90625 1,-1.90625 0.6875,0 1,0.71875 1,1.90625 z m 0.640625,0 c 0,-0.984375 -0.265625,-2.453125 -1.640625,-2.453125 -1.375,0 -1.640625,1.46875 -1.640625,2.453125 0,1 0.265625,2.453125 1.640625,2.453125 1.375,0 1.640625,-1.453125 1.640625,-2.453125 z m 0,0"
+ id="path774" />
+ </g>
+ <g
+ id="glyph-1-16">
+ <path
+ d="m 0.65625,1.40625 c 0.734375,-1.046875 1.140625,-2.015625 1.140625,-3.203125 0,-1.28125 -0.453125,-2.125 -1.171875,-3.1875 H 0.234375 c 0.546875,1.0625 0.921875,1.90625 0.921875,3.015625 0,1.640625 -0.34375,2.28125 -0.921875,3.375 z m 0,0"
+ id="path777" />
+ </g>
+ <g
+ id="glyph-1-17">
+ <path
+ d="M 1.171875,-4.875 H 0.515625 V 0 H 3.65625 V -0.578125 H 1.171875 Z m 0,0"
+ id="path780" />
+ </g>
+ <g
+ id="glyph-1-18">
+ <path
+ d="m 3.34375,-2.421875 c 0,-1.015625 -0.703125,-1.234375 -1.25,-1.234375 -0.609375,0 -0.9375,0.421875 -1.078125,0.609375 H 1 V -3.5625 H 0.4375 V 0 h 0.609375 v -1.9375 c 0,-0.96875 0.59375,-1.1875 0.9375,-1.1875 0.578125,0 0.75,0.3125 0.75,0.9375 V 0 H 3.34375 Z m 0,0"
+ id="path783" />
+ </g>
+ <g
+ id="glyph-1-19">
+ <path
+ d="m 3.390625,-4.875 h -0.59375 v 1.78125 L 2.78125,-3.046875 C 2.640625,-3.25 2.359375,-3.65625 1.71875,-3.65625 c -0.9375,0 -1.484375,0.78125 -1.484375,1.78125 0,0.84375 0.359375,1.984375 1.5625,1.984375 C 2.140625,0.109375 2.5625,0 2.8125,-0.484375 H 2.828125 V 0 h 0.5625 z m -2.53125,3.09375 c 0,-0.46875 0.046875,-1.34375 0.96875,-1.34375 0.859375,0 0.953125,0.9375 0.953125,1.515625 0,0.9375 -0.578125,1.1875 -0.96875,1.1875 C 1.15625,-0.421875 0.859375,-1 0.859375,-1.78125 Z m 0,0"
+ id="path786" />
+ </g>
+ <g
+ id="glyph-1-20">
+ <path
+ d="M 1.25,-2.21875 H 3.640625 V -2.796875 H 1.25 v -1.5 H 3.96875 V -4.875 H 0.578125 V 0 H 1.25 Z m 0,0"
+ id="path789" />
+ </g>
+ <g
+ id="glyph-1-21">
+ <path
+ d="M 1.171875,-1.71875 1.9375,-2.453125 3.65625,0 H 4.5 L 2.421875,-2.90625 4.453125,-4.875 h -0.90625 l -2.375,2.359375 V -4.875 H 0.515625 V 0 h 0.65625 z m 0,0"
+ id="path792" />
+ </g>
+ <g
+ id="glyph-1-22">
+ <path
+ d="m 0.234375,-1.78125 c 0,0.921875 0.515625,1.875 1.65625,1.875 1.140625,0 1.65625,-0.953125 1.65625,-1.875 0,-0.921875 -0.515625,-1.875 -1.65625,-1.875 -1.140625,0 -1.65625,0.953125 -1.65625,1.875 z m 0.625,0 c 0,-0.46875 0.171875,-1.359375 1.03125,-1.359375 0.859375,0 1.03125,0.890625 1.03125,1.359375 0,0.46875 -0.171875,1.359375 -1.03125,1.359375 -0.859375,0 -1.03125,-0.890625 -1.03125,-1.359375 z m 0,0"
+ id="path795" />
+ </g>
+ <g
+ id="glyph-1-23">
+ <path
+ d="M 3.234375,-2.359375 C 3.1875,-2.984375 2.84375,-3.65625 1.90625,-3.65625 c -1.171875,0 -1.703125,0.875 -1.703125,1.984375 0,1.015625 0.59375,1.78125 1.59375,1.78125 1.03125,0 1.390625,-0.796875 1.4375,-1.359375 h -0.5625 C 2.5625,-0.71875 2.21875,-0.421875 1.8125,-0.421875 c -0.8125,0 -0.96875,-0.75 -0.96875,-1.359375 0,-0.625 0.234375,-1.34375 0.984375,-1.34375 0.5,0 0.765625,0.296875 0.84375,0.765625 z m 0,0"
+ id="path798" />
+ </g>
+ <g
+ id="glyph-1-24">
+ <path
+ d="m 1.75,-3.0625 v -0.5 H 1.171875 V -4.546875 H 0.578125 V -3.5625 H 0.09375 v 0.5 h 0.484375 v 2.34375 c 0,0.4375 0.125,0.765625 0.71875,0.765625 C 1.359375,0.046875 1.53125,0.015625 1.75,0 V -0.46875 H 1.53125 c -0.125,0 -0.359375,0 -0.359375,-0.28125 v -2.3125 z m 0,0"
+ id="path801" />
+ </g>
+ <g
+ id="glyph-1-25">
+ <path
+ d="M 1.046875,-3.5625 H 0.453125 V 0 h 0.59375 z m 0,-0.640625 V -4.875 h -0.59375 v 0.671875 z m 0,0"
+ id="path804" />
+ </g>
+ <g
+ id="glyph-1-26">
+ <path
+ d="m 2.859375,-1.109375 c -0.015625,0.265625 -0.34375,0.6875 -0.921875,0.6875 -0.6875,0 -1.03125,-0.421875 -1.03125,-1.15625 H 3.5 C 3.5,-2.84375 3,-3.65625 1.984375,-3.65625 c -1.1875,0 -1.71875,0.875 -1.71875,1.984375 0,1.015625 0.59375,1.78125 1.59375,1.78125 0.578125,0 0.8125,-0.140625 0.96875,-0.25 C 3.28125,-0.4375 3.4375,-0.9375 3.453125,-1.109375 Z M 0.90625,-2.0625 c 0,-0.546875 0.4375,-1.0625 0.984375,-1.0625 0.734375,0 0.96875,0.515625 1,1.0625 z m 0,0"
+ id="path807" />
+ </g>
+ <g
+ id="glyph-1-27">
+ <path
+ d="m 5.171875,0 v -4.875 h -0.9375 L 2.84375,-0.75 H 2.828125 L 1.4375,-4.875 H 0.5 V 0 H 1.140625 V -2.875 C 1.140625,-3.03125 1.125,-3.640625 1.125,-4.09375 H 1.140625 L 2.515625,0 H 3.15625 l 1.375,-4.09375 h 0.015625 c 0,0.453125 -0.015625,1.0625 -0.015625,1.21875 V 0 Z m 0,0"
+ id="path810" />
+ </g>
+ <g
+ id="glyph-1-28">
+ <path
+ d="m 1.125,-2.0625 c 0,-0.515625 0.34375,-0.953125 0.90625,-0.953125 H 2.25 v -0.625 C 2.203125,-3.65625 2.171875,-3.65625 2.09375,-3.65625 c -0.4375,0 -0.75,0.28125 -1,0.6875 V -3.5625 H 0.515625 V 0 H 1.125 Z m 0,0"
+ id="path813" />
+ </g>
+ <g
+ id="glyph-1-29">
+ <path
+ d="M 1.96875,-2.234375 3.328125,-3.5625 H 2.5625 L 1.03125,-2.046875 V -4.875 H 0.453125 V 0 H 1.03125 v -1.34375 l 0.5,-0.453125 L 2.640625,0 H 3.40625 Z m 0,0"
+ id="path816" />
+ </g>
+ <g
+ id="glyph-1-30">
+ <path
+ d="m 0.890625,-1.78125 c 0,-0.46875 0.046875,-1.34375 0.96875,-1.34375 0.859375,0 0.96875,0.9375 0.96875,1.515625 0,0.9375 -0.59375,1.1875 -0.984375,1.1875 C 1.203125,-0.421875 0.890625,-1 0.890625,-1.78125 Z m 2.5,-1.78125 h -0.5625 v 0.515625 H 2.8125 C 2.671875,-3.25 2.40625,-3.65625 1.75,-3.65625 c -0.9375,0 -1.484375,0.78125 -1.484375,1.78125 0,0.84375 0.359375,1.984375 1.5625,1.984375 C 2.3125,0.109375 2.625,-0.125 2.78125,-0.375 V -0.40625 H 2.796875 V -0.25 C 2.796875,0.171875 2.8125,1 1.78125,1 1.640625,1 1.09375,1 0.984375,0.4375 H 0.375 C 0.5,1.375 1.3125,1.5 1.734375,1.5 c 1.65625,0 1.65625,-1.28125 1.65625,-1.796875 z m 0,0"
+ id="path819" />
+ </g>
+ </g>
+ </defs>
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-dasharray="10, 4"
+ stroke-miterlimit="10"
+ d="m 220.25222,134.64674 h 76.53513 v -27.21483"
+ id="path826" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 219.96706,137.19753 5.66797,-2.83594 -5.66797,-2.83593"
+ id="path828" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 226.77174,137.19753 v -5.67187"
+ id="path830" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 294.23268,110.54909 h 4.53906"
+ id="path832" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 294.23268,112.81862 h 4.53906"
+ id="path834" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-dasharray="10, 4"
+ stroke-miterlimit="10"
+ d="m 62.076436,115.93581 h 44.222644 v 18.71094 h 43.65234"
+ id="path836" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 61.795186,118.4866 5.667967,-2.83204 -5.667967,-2.83593"
+ id="path838" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 68.595965,118.4866 v -5.66797"
+ id="path840" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 146.26784,132.09597 v 4.53516"
+ id="path842" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 143.99831,132.09597 v 4.53516"
+ id="path844" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-dasharray="10, 4"
+ stroke-miterlimit="10"
+ d="M 62.076436,98.361585 H 105.72877 V 57.541282 h 43.08983"
+ id="path846" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 61.795186,100.91238 5.667967,-2.832031 -5.667967,-2.835937"
+ id="path848" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="M 68.595965,100.91238 V 95.244412"
+ id="path850" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 145.13112,54.990502 v 4.535155"
+ id="path852" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 142.8655,54.990502 v 4.535155"
+ id="path854" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-dasharray="10, 4"
+ stroke-miterlimit="10"
+ d="M 71.713154,33.732688 H 110.26783 V 44.502217 H 148.8186"
+ id="path856" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 71.431904,36.283469 5.667967,-2.835937 -5.667967,-2.832031"
+ id="path858" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="M 78.232684,36.283469 V 30.615501"
+ id="path860" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 145.13112,41.951439 v 4.535155"
+ id="path862" />
+ <path
+ fill="none"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 142.8655,41.951439 v 4.535155"
+ id="path864" />
+ <path
+ fill-rule="nonzero"
+ fill="#98bfda"
+ fill-opacity="1"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 261.63497,67.748292 h 70.30076 v 39.683588 h -70.30076 z m 0,0"
+ id="path866" />
+ <path
+ fill-rule="nonzero"
+ fill="#ffffff"
+ fill-opacity="1"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 261.63503,67.748313 h 70.30076 v 13.039059 h -70.30076 z m 0,0"
+ id="path868" />
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g878"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-0-1"
+ x="273.26172"
+ y="99.191406"
+ id="use870" />
+ <use
+ xlink:href="#glyph-0-2"
+ x="277.41846"
+ y="99.191406"
+ id="use872" />
+ <use
+ xlink:href="#glyph-0-3"
+ x="281.20099"
+ y="99.191406"
+ id="use874" />
+ <use
+ xlink:href="#glyph-0-4"
+ x="285.35773"
+ y="99.191406"
+ id="use876" />
+ </g>
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g892"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-1-1"
+ x="272.125"
+ y="112.63281"
+ id="use880" />
+ <use
+ xlink:href="#glyph-1-2"
+ x="274.01627"
+ y="112.63281"
+ id="use882" />
+ <use
+ xlink:href="#glyph-1-3"
+ x="278.92816"
+ y="112.63281"
+ id="use884" />
+ <use
+ xlink:href="#glyph-1-1"
+ x="280.81943"
+ y="112.63281"
+ id="use886" />
+ <use
+ xlink:href="#glyph-1-4"
+ x="282.71069"
+ y="112.63281"
+ id="use888" />
+ <use
+ xlink:href="#glyph-1-5"
+ x="287.62259"
+ y="112.63281"
+ id="use890" />
+ </g>
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g926"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-1-4"
+ x="272.125"
+ y="126.24219"
+ id="use894" />
+ <use
+ xlink:href="#glyph-1-6"
+ x="277.03687"
+ y="126.24219"
+ id="use896" />
+ <use
+ xlink:href="#glyph-1-6"
+ x="280.81943"
+ y="126.24219"
+ id="use898" />
+ <use
+ xlink:href="#glyph-1-7"
+ x="284.60199"
+ y="126.24219"
+ id="use900" />
+ <use
+ xlink:href="#glyph-1-3"
+ x="290.26901"
+ y="126.24219"
+ id="use902" />
+ <use
+ xlink:href="#glyph-1-8"
+ x="292.16028"
+ y="126.24219"
+ id="use904" />
+ <use
+ xlink:href="#glyph-1-9"
+ x="296.69797"
+ y="126.24219"
+ id="use906" />
+ <use
+ xlink:href="#glyph-1-10"
+ x="301.23569"
+ y="126.24219"
+ id="use908" />
+ <use
+ xlink:href="#glyph-1-11"
+ x="306.14755"
+ y="126.24219"
+ id="use910" />
+ <use
+ xlink:href="#glyph-1-12"
+ x="311.05942"
+ y="126.24219"
+ id="use912" />
+ <use
+ xlink:href="#glyph-1-9"
+ x="315.97131"
+ y="126.24219"
+ id="use914" />
+ <use
+ xlink:href="#glyph-1-10"
+ x="320.509"
+ y="126.24219"
+ id="use916" />
+ <use
+ xlink:href="#glyph-1-13"
+ x="325.42087"
+ y="126.24219"
+ id="use918" />
+ <use
+ xlink:href="#glyph-1-14"
+ x="327.68631"
+ y="126.24219"
+ id="use920" />
+ <use
+ xlink:href="#glyph-1-15"
+ x="331.46887"
+ y="126.24219"
+ id="use922" />
+ <use
+ xlink:href="#glyph-1-16"
+ x="335.25143"
+ y="126.24219"
+ id="use924" />
+ </g>
+ <path
+ fill-rule="nonzero"
+ fill="#98bfda"
+ fill-opacity="1"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 149.9514,107.99828 h 70.30076 v 53.29296 H 149.9514 Z m 0,0"
+ id="path928" />
+ <path
+ fill-rule="nonzero"
+ fill="#ffffff"
+ fill-opacity="1"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 149.95144,107.99831 h 70.30076 v 13.03906 h -70.30076 z m 0,0"
+ id="path930" />
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g946"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-0-1"
+ x="161.57422"
+ y="139.44531"
+ id="use932" />
+ <use
+ xlink:href="#glyph-0-5"
+ x="165.73094"
+ y="139.44531"
+ id="use934" />
+ <use
+ xlink:href="#glyph-0-6"
+ x="169.88766"
+ y="139.44531"
+ id="use936" />
+ <use
+ xlink:href="#glyph-0-2"
+ x="173.67021"
+ y="139.44531"
+ id="use938" />
+ <use
+ xlink:href="#glyph-0-7"
+ x="177.45277"
+ y="139.44531"
+ id="use940" />
+ <use
+ xlink:href="#glyph-0-8"
+ x="179.71822"
+ y="139.44531"
+ id="use942" />
+ <use
+ xlink:href="#glyph-0-9"
+ x="181.6095"
+ y="139.44531"
+ id="use944" />
+ </g>
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g960"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-1-1"
+ x="160.44141"
+ y="152.88672"
+ id="use948" />
+ <use
+ xlink:href="#glyph-1-2"
+ x="162.33269"
+ y="152.88672"
+ id="use950" />
+ <use
+ xlink:href="#glyph-1-3"
+ x="167.24455"
+ y="152.88672"
+ id="use952" />
+ <use
+ xlink:href="#glyph-1-1"
+ x="169.13583"
+ y="152.88672"
+ id="use954" />
+ <use
+ xlink:href="#glyph-1-4"
+ x="171.0271"
+ y="152.88672"
+ id="use956" />
+ <use
+ xlink:href="#glyph-1-5"
+ x="175.93898"
+ y="152.88672"
+ id="use958" />
+ </g>
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g992"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-1-17"
+ x="160.44141"
+ y="166.49219"
+ id="use962" />
+ <use
+ xlink:href="#glyph-1-6"
+ x="164.22395"
+ y="166.49219"
+ id="use964" />
+ <use
+ xlink:href="#glyph-1-18"
+ x="168.00652"
+ y="166.49219"
+ id="use966" />
+ <use
+ xlink:href="#glyph-1-19"
+ x="171.78906"
+ y="166.49219"
+ id="use968" />
+ <use
+ xlink:href="#glyph-1-1"
+ x="175.57161"
+ y="166.49219"
+ id="use970" />
+ <use
+ xlink:href="#glyph-1-2"
+ x="177.46289"
+ y="166.49219"
+ id="use972" />
+ <use
+ xlink:href="#glyph-1-3"
+ x="182.37476"
+ y="166.49219"
+ id="use974" />
+ <use
+ xlink:href="#glyph-1-1"
+ x="184.26604"
+ y="166.49219"
+ id="use976" />
+ <use
+ xlink:href="#glyph-1-4"
+ x="186.15732"
+ y="166.49219"
+ id="use978" />
+ <use
+ xlink:href="#glyph-1-5"
+ x="191.06918"
+ y="166.49219"
+ id="use980" />
+ <use
+ xlink:href="#glyph-1-3"
+ x="195.22591"
+ y="166.49219"
+ id="use982" />
+ <use
+ xlink:href="#glyph-1-13"
+ x="197.11719"
+ y="166.49219"
+ id="use984" />
+ <use
+ xlink:href="#glyph-1-20"
+ x="199.38263"
+ y="166.49219"
+ id="use986" />
+ <use
+ xlink:href="#glyph-1-21"
+ x="203.53935"
+ y="166.49219"
+ id="use988" />
+ <use
+ xlink:href="#glyph-1-16"
+ x="208.07706"
+ y="166.49219"
+ id="use990" />
+ </g>
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g1026"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-1-4"
+ x="160.44141"
+ y="180.09766"
+ id="use994" />
+ <use
+ xlink:href="#glyph-1-6"
+ x="165.35329"
+ y="180.09766"
+ id="use996" />
+ <use
+ xlink:href="#glyph-1-6"
+ x="169.13583"
+ y="180.09766"
+ id="use998" />
+ <use
+ xlink:href="#glyph-1-7"
+ x="172.91838"
+ y="180.09766"
+ id="use1000" />
+ <use
+ xlink:href="#glyph-1-3"
+ x="178.5854"
+ y="180.09766"
+ id="use1002" />
+ <use
+ xlink:href="#glyph-1-8"
+ x="180.47668"
+ y="180.09766"
+ id="use1004" />
+ <use
+ xlink:href="#glyph-1-9"
+ x="185.01439"
+ y="180.09766"
+ id="use1006" />
+ <use
+ xlink:href="#glyph-1-10"
+ x="189.55208"
+ y="180.09766"
+ id="use1008" />
+ <use
+ xlink:href="#glyph-1-11"
+ x="194.46396"
+ y="180.09766"
+ id="use1010" />
+ <use
+ xlink:href="#glyph-1-12"
+ x="199.37582"
+ y="180.09766"
+ id="use1012" />
+ <use
+ xlink:href="#glyph-1-9"
+ x="204.2877"
+ y="180.09766"
+ id="use1014" />
+ <use
+ xlink:href="#glyph-1-10"
+ x="208.82541"
+ y="180.09766"
+ id="use1016" />
+ <use
+ xlink:href="#glyph-1-13"
+ x="213.73727"
+ y="180.09766"
+ id="use1018" />
+ <use
+ xlink:href="#glyph-1-14"
+ x="216.00273"
+ y="180.09766"
+ id="use1020" />
+ <use
+ xlink:href="#glyph-1-15"
+ x="219.78528"
+ y="180.09766"
+ id="use1022" />
+ <use
+ xlink:href="#glyph-1-16"
+ x="223.56783"
+ y="180.09766"
+ id="use1024" />
+ </g>
+ <path
+ fill-rule="nonzero"
+ fill="#98bfda"
+ fill-opacity="1"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 148.81858,30.896738 h 70.30077 v 39.683585 h -70.30077 z m 0,0"
+ id="path1028" />
+ <path
+ fill-rule="nonzero"
+ fill="#ffffff"
+ fill-opacity="1"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="m 148.81862,30.896751 h 70.30077 v 13.03906 h -70.30077 z m 0,0"
+ id="path1030" />
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g1040"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-0-10"
+ x="160.44141"
+ y="62.339844"
+ id="use1032" />
+ <use
+ xlink:href="#glyph-0-9"
+ x="166.10843"
+ y="62.339844"
+ id="use1034" />
+ <use
+ xlink:href="#glyph-0-11"
+ x="169.89098"
+ y="62.339844"
+ id="use1036" />
+ <use
+ xlink:href="#glyph-0-12"
+ x="172.5374"
+ y="62.339844"
+ id="use1038" />
+ </g>
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g1054"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-1-1"
+ x="159.30859"
+ y="75.785156"
+ id="use1042" />
+ <use
+ xlink:href="#glyph-1-2"
+ x="161.19987"
+ y="75.785156"
+ id="use1044" />
+ <use
+ xlink:href="#glyph-1-3"
+ x="166.11174"
+ y="75.785156"
+ id="use1046" />
+ <use
+ xlink:href="#glyph-1-1"
+ x="168.00302"
+ y="75.785156"
+ id="use1048" />
+ <use
+ xlink:href="#glyph-1-4"
+ x="169.8943"
+ y="75.785156"
+ id="use1050" />
+ <use
+ xlink:href="#glyph-1-5"
+ x="174.80617"
+ y="75.785156"
+ id="use1052" />
+ </g>
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g1088"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-1-4"
+ x="159.30859"
+ y="89.390625"
+ id="use1056" />
+ <use
+ xlink:href="#glyph-1-6"
+ x="164.22047"
+ y="89.390625"
+ id="use1058" />
+ <use
+ xlink:href="#glyph-1-6"
+ x="168.00302"
+ y="89.390625"
+ id="use1060" />
+ <use
+ xlink:href="#glyph-1-7"
+ x="171.78557"
+ y="89.390625"
+ id="use1062" />
+ <use
+ xlink:href="#glyph-1-3"
+ x="177.45259"
+ y="89.390625"
+ id="use1064" />
+ <use
+ xlink:href="#glyph-1-8"
+ x="179.34387"
+ y="89.390625"
+ id="use1066" />
+ <use
+ xlink:href="#glyph-1-9"
+ x="183.88158"
+ y="89.390625"
+ id="use1068" />
+ <use
+ xlink:href="#glyph-1-10"
+ x="188.41927"
+ y="89.390625"
+ id="use1070" />
+ <use
+ xlink:href="#glyph-1-11"
+ x="193.33115"
+ y="89.390625"
+ id="use1072" />
+ <use
+ xlink:href="#glyph-1-12"
+ x="198.24301"
+ y="89.390625"
+ id="use1074" />
+ <use
+ xlink:href="#glyph-1-9"
+ x="203.15489"
+ y="89.390625"
+ id="use1076" />
+ <use
+ xlink:href="#glyph-1-10"
+ x="207.6926"
+ y="89.390625"
+ id="use1078" />
+ <use
+ xlink:href="#glyph-1-13"
+ x="212.60446"
+ y="89.390625"
+ id="use1080" />
+ <use
+ xlink:href="#glyph-1-14"
+ x="214.86992"
+ y="89.390625"
+ id="use1082" />
+ <use
+ xlink:href="#glyph-1-15"
+ x="218.65247"
+ y="89.390625"
+ id="use1084" />
+ <use
+ xlink:href="#glyph-1-16"
+ x="222.43501"
+ y="89.390625"
+ id="use1086" />
+ </g>
+ <path
+ fill-rule="nonzero"
+ fill="#98bfda"
+ fill-opacity="1"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="M 0.2834645,80.220945 H 62.080324 V 133.5139 H 0.2834645 Z m 0,0"
+ id="path1090" />
+ <path
+ fill-rule="nonzero"
+ fill="#ffffff"
+ fill-opacity="1"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="M 0.2834665,80.220967 H 62.080326 V 93.260026 H 0.2834665 Z m 0,0"
+ id="path1092" />
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g1118"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-0-13"
+ x="11.90625"
+ y="111.66406"
+ id="use1094" />
+ <use
+ xlink:href="#glyph-0-5"
+ x="16.818125"
+ y="111.66406"
+ id="use1096" />
+ <use
+ xlink:href="#glyph-0-5"
+ x="20.974848"
+ y="111.66406"
+ id="use1098" />
+ <use
+ xlink:href="#glyph-0-14"
+ x="25.131573"
+ y="111.66406"
+ id="use1100" />
+ <use
+ xlink:href="#glyph-0-4"
+ x="27.397022"
+ y="111.66406"
+ id="use1102" />
+ <use
+ xlink:href="#glyph-0-12"
+ x="31.553745"
+ y="111.66406"
+ id="use1104" />
+ <use
+ xlink:href="#glyph-0-2"
+ x="35.336296"
+ y="111.66406"
+ id="use1106" />
+ <use
+ xlink:href="#glyph-0-3"
+ x="39.118847"
+ y="111.66406"
+ id="use1108" />
+ <use
+ xlink:href="#glyph-0-7"
+ x="43.275574"
+ y="111.66406"
+ id="use1110" />
+ <use
+ xlink:href="#glyph-0-5"
+ x="45.541023"
+ y="111.66406"
+ id="use1112" />
+ <use
+ xlink:href="#glyph-0-5"
+ x="49.697746"
+ y="111.66406"
+ id="use1114" />
+ <use
+ xlink:href="#glyph-0-11"
+ x="53.854469"
+ y="111.66406"
+ id="use1116" />
+ </g>
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g1132"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-1-1"
+ x="10.773438"
+ y="125.10547"
+ id="use1120" />
+ <use
+ xlink:href="#glyph-1-2"
+ x="12.664713"
+ y="125.10547"
+ id="use1122" />
+ <use
+ xlink:href="#glyph-1-3"
+ x="17.576588"
+ y="125.10547"
+ id="use1124" />
+ <use
+ xlink:href="#glyph-1-1"
+ x="19.467863"
+ y="125.10547"
+ id="use1126" />
+ <use
+ xlink:href="#glyph-1-4"
+ x="21.359138"
+ y="125.10547"
+ id="use1128" />
+ <use
+ xlink:href="#glyph-1-5"
+ x="26.271011"
+ y="125.10547"
+ id="use1130" />
+ </g>
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g1170"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-1-17"
+ x="10.773438"
+ y="138.71484"
+ id="use1134" />
+ <use
+ xlink:href="#glyph-1-22"
+ x="14.555989"
+ y="138.71484"
+ id="use1136" />
+ <use
+ xlink:href="#glyph-1-23"
+ x="18.338539"
+ y="138.71484"
+ id="use1138" />
+ <use
+ xlink:href="#glyph-1-6"
+ x="21.740114"
+ y="138.71484"
+ id="use1140" />
+ <use
+ xlink:href="#glyph-1-24"
+ x="25.522667"
+ y="138.71484"
+ id="use1142" />
+ <use
+ xlink:href="#glyph-1-25"
+ x="27.41394"
+ y="138.71484"
+ id="use1144" />
+ <use
+ xlink:href="#glyph-1-26"
+ x="28.92424"
+ y="138.71484"
+ id="use1146" />
+ <use
+ xlink:href="#glyph-1-1"
+ x="32.706791"
+ y="138.71484"
+ id="use1148" />
+ <use
+ xlink:href="#glyph-1-2"
+ x="34.598068"
+ y="138.71484"
+ id="use1150" />
+ <use
+ xlink:href="#glyph-1-3"
+ x="39.509941"
+ y="138.71484"
+ id="use1152" />
+ <use
+ xlink:href="#glyph-1-1"
+ x="41.401218"
+ y="138.71484"
+ id="use1154" />
+ <use
+ xlink:href="#glyph-1-4"
+ x="43.292492"
+ y="138.71484"
+ id="use1156" />
+ <use
+ xlink:href="#glyph-1-5"
+ x="48.204369"
+ y="138.71484"
+ id="use1158" />
+ <use
+ xlink:href="#glyph-1-3"
+ x="52.361092"
+ y="138.71484"
+ id="use1160" />
+ <use
+ xlink:href="#glyph-1-13"
+ x="54.252365"
+ y="138.71484"
+ id="use1162" />
+ <use
+ xlink:href="#glyph-1-20"
+ x="56.517815"
+ y="138.71484"
+ id="use1164" />
+ <use
+ xlink:href="#glyph-1-21"
+ x="60.674541"
+ y="138.71484"
+ id="use1166" />
+ <use
+ xlink:href="#glyph-1-16"
+ x="65.212242"
+ y="138.71484"
+ id="use1168" />
+ </g>
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g1202"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-1-27"
+ x="10.773438"
+ y="152.32031"
+ id="use1172" />
+ <use
+ xlink:href="#glyph-1-26"
+ x="16.44046"
+ y="152.32031"
+ id="use1174" />
+ <use
+ xlink:href="#glyph-1-28"
+ x="20.223013"
+ y="152.32031"
+ id="use1176" />
+ <use
+ xlink:href="#glyph-1-29"
+ x="22.488461"
+ y="152.32031"
+ id="use1178" />
+ <use
+ xlink:href="#glyph-1-1"
+ x="25.890036"
+ y="152.32031"
+ id="use1180" />
+ <use
+ xlink:href="#glyph-1-2"
+ x="27.781313"
+ y="152.32031"
+ id="use1182" />
+ <use
+ xlink:href="#glyph-1-3"
+ x="32.693188"
+ y="152.32031"
+ id="use1184" />
+ <use
+ xlink:href="#glyph-1-1"
+ x="34.584461"
+ y="152.32031"
+ id="use1186" />
+ <use
+ xlink:href="#glyph-1-4"
+ x="36.475739"
+ y="152.32031"
+ id="use1188" />
+ <use
+ xlink:href="#glyph-1-5"
+ x="41.387611"
+ y="152.32031"
+ id="use1190" />
+ <use
+ xlink:href="#glyph-1-3"
+ x="45.544334"
+ y="152.32031"
+ id="use1192" />
+ <use
+ xlink:href="#glyph-1-13"
+ x="47.435612"
+ y="152.32031"
+ id="use1194" />
+ <use
+ xlink:href="#glyph-1-20"
+ x="49.701061"
+ y="152.32031"
+ id="use1196" />
+ <use
+ xlink:href="#glyph-1-21"
+ x="53.857784"
+ y="152.32031"
+ id="use1198" />
+ <use
+ xlink:href="#glyph-1-16"
+ x="58.395485"
+ y="152.32031"
+ id="use1200" />
+ </g>
+ <path
+ fill-rule="nonzero"
+ fill="#98bfda"
+ fill-opacity="1"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="M 1.4162765,0.2834645 H 71.71704 V 67.181884 H 1.4162765 Z m 0,0"
+ id="path1204" />
+ <path
+ fill-rule="nonzero"
+ fill="#ffffff"
+ fill-opacity="1"
+ stroke-width="0.566929"
+ stroke-linecap="butt"
+ stroke-linejoin="miter"
+ stroke="#000000"
+ stroke-opacity="1"
+ stroke-miterlimit="10"
+ d="M 1.4162785,0.2834695 H 71.717042 V 13.322529 H 1.4162785 Z m 0,0"
+ id="path1206" />
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g1216"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-0-15"
+ x="13.039063"
+ y="31.726562"
+ id="use1208" />
+ <use
+ xlink:href="#glyph-0-16"
+ x="17.195787"
+ y="31.726562"
+ id="use1210" />
+ <use
+ xlink:href="#glyph-0-17"
+ x="20.978338"
+ y="31.726562"
+ id="use1212" />
+ <use
+ xlink:href="#glyph-0-9"
+ x="25.135063"
+ y="31.726562"
+ id="use1214" />
+ </g>
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g1230"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-1-1"
+ x="11.90625"
+ y="45.171875"
+ id="use1218" />
+ <use
+ xlink:href="#glyph-1-2"
+ x="13.797526"
+ y="45.171875"
+ id="use1220" />
+ <use
+ xlink:href="#glyph-1-3"
+ x="18.7094"
+ y="45.171875"
+ id="use1222" />
+ <use
+ xlink:href="#glyph-1-1"
+ x="20.600676"
+ y="45.171875"
+ id="use1224" />
+ <use
+ xlink:href="#glyph-1-4"
+ x="22.491951"
+ y="45.171875"
+ id="use1226" />
+ <use
+ xlink:href="#glyph-1-5"
+ x="27.403826"
+ y="45.171875"
+ id="use1228" />
+ </g>
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g1264"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-1-4"
+ x="11.90625"
+ y="58.777344"
+ id="use1232" />
+ <use
+ xlink:href="#glyph-1-6"
+ x="16.818125"
+ y="58.777344"
+ id="use1234" />
+ <use
+ xlink:href="#glyph-1-6"
+ x="20.600676"
+ y="58.777344"
+ id="use1236" />
+ <use
+ xlink:href="#glyph-1-7"
+ x="24.383226"
+ y="58.777344"
+ id="use1238" />
+ <use
+ xlink:href="#glyph-1-3"
+ x="30.050249"
+ y="58.777344"
+ id="use1240" />
+ <use
+ xlink:href="#glyph-1-8"
+ x="31.941526"
+ y="58.777344"
+ id="use1242" />
+ <use
+ xlink:href="#glyph-1-9"
+ x="36.479225"
+ y="58.777344"
+ id="use1244" />
+ <use
+ xlink:href="#glyph-1-10"
+ x="41.016926"
+ y="58.777344"
+ id="use1246" />
+ <use
+ xlink:href="#glyph-1-11"
+ x="45.928802"
+ y="58.777344"
+ id="use1248" />
+ <use
+ xlink:href="#glyph-1-12"
+ x="50.840675"
+ y="58.777344"
+ id="use1250" />
+ <use
+ xlink:href="#glyph-1-9"
+ x="55.752548"
+ y="58.777344"
+ id="use1252" />
+ <use
+ xlink:href="#glyph-1-10"
+ x="60.290249"
+ y="58.777344"
+ id="use1254" />
+ <use
+ xlink:href="#glyph-1-13"
+ x="65.202126"
+ y="58.777344"
+ id="use1256" />
+ <use
+ xlink:href="#glyph-1-14"
+ x="67.467575"
+ y="58.777344"
+ id="use1258" />
+ <use
+ xlink:href="#glyph-1-15"
+ x="71.250122"
+ y="58.777344"
+ id="use1260" />
+ <use
+ xlink:href="#glyph-1-16"
+ x="75.032677"
+ y="58.777344"
+ id="use1262" />
+ </g>
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g1296"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-1-27"
+ x="11.90625"
+ y="72.382812"
+ id="use1266" />
+ <use
+ xlink:href="#glyph-1-26"
+ x="17.573275"
+ y="72.382812"
+ id="use1268" />
+ <use
+ xlink:href="#glyph-1-28"
+ x="21.355825"
+ y="72.382812"
+ id="use1270" />
+ <use
+ xlink:href="#glyph-1-29"
+ x="23.621275"
+ y="72.382812"
+ id="use1272" />
+ <use
+ xlink:href="#glyph-1-1"
+ x="27.022848"
+ y="72.382812"
+ id="use1274" />
+ <use
+ xlink:href="#glyph-1-2"
+ x="28.914124"
+ y="72.382812"
+ id="use1276" />
+ <use
+ xlink:href="#glyph-1-3"
+ x="33.825996"
+ y="72.382812"
+ id="use1278" />
+ <use
+ xlink:href="#glyph-1-1"
+ x="35.717274"
+ y="72.382812"
+ id="use1280" />
+ <use
+ xlink:href="#glyph-1-4"
+ x="37.608547"
+ y="72.382812"
+ id="use1282" />
+ <use
+ xlink:href="#glyph-1-5"
+ x="42.520424"
+ y="72.382812"
+ id="use1284" />
+ <use
+ xlink:href="#glyph-1-3"
+ x="46.677147"
+ y="72.382812"
+ id="use1286" />
+ <use
+ xlink:href="#glyph-1-13"
+ x="48.568424"
+ y="72.382812"
+ id="use1288" />
+ <use
+ xlink:href="#glyph-1-20"
+ x="50.833874"
+ y="72.382812"
+ id="use1290" />
+ <use
+ xlink:href="#glyph-1-21"
+ x="54.990597"
+ y="72.382812"
+ id="use1292" />
+ <use
+ xlink:href="#glyph-1-16"
+ x="59.528297"
+ y="72.382812"
+ id="use1294" />
+ </g>
+ <g
+ fill="#000000"
+ fill-opacity="1"
+ id="g1322"
+ transform="translate(-8.5055961,-22.677468)">
+ <use
+ xlink:href="#glyph-1-8"
+ x="11.90625"
+ y="85.988281"
+ id="use1298" />
+ <use
+ xlink:href="#glyph-1-26"
+ x="16.443951"
+ y="85.988281"
+ id="use1300" />
+ <use
+ xlink:href="#glyph-1-28"
+ x="20.226501"
+ y="85.988281"
+ id="use1302" />
+ <use
+ xlink:href="#glyph-1-7"
+ x="22.491951"
+ y="85.988281"
+ id="use1304" />
+ <use
+ xlink:href="#glyph-1-22"
+ x="28.158974"
+ y="85.988281"
+ id="use1306" />
+ <use
+ xlink:href="#glyph-1-30"
+ x="31.941526"
+ y="85.988281"
+ id="use1308" />
+ <use
+ xlink:href="#glyph-1-26"
+ x="35.724075"
+ y="85.988281"
+ id="use1310" />
+ <use
+ xlink:href="#glyph-1-18"
+ x="39.506626"
+ y="85.988281"
+ id="use1312" />
+ <use
+ xlink:href="#glyph-1-3"
+ x="43.289181"
+ y="85.988281"
+ id="use1314" />
+ <use
+ xlink:href="#glyph-1-1"
+ x="45.180454"
+ y="85.988281"
+ id="use1316" />
+ <use
+ xlink:href="#glyph-1-4"
+ x="47.071732"
+ y="85.988281"
+ id="use1318" />
+ <use
+ xlink:href="#glyph-1-5"
+ x="51.983604"
+ y="85.988281"
+ id="use1320" />
+ </g>
+</svg>
diff --git a/eindopdracht/imgs_erd.svg b/eindopdracht/imgs_erd.svg
new file mode 100644
index 0000000..3edc377
--- /dev/null
+++ b/eindopdracht/imgs_erd.svg
@@ -0,0 +1,3 @@
+<?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="972px" height="32px" viewBox="-0.5 -0.5 972 32"><defs><style type="text/css">@import url(https://fonts.googleapis.com/css?family=Permanent+Marker);&#xa;</style></defs><g><rect x="240" y="0" width="70" height="30" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 15px; margin-left: 241px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Merk</div></div></div></foreignObject><text x="275" y="19" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Merk</text></switch></g><rect x="0" y="0" width="70" height="30" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 15px; margin-left: 1px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Type</div></div></div></foreignObject><text x="35" y="19" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Type</text></switch></g><rect x="450" y="0" width="100" height="30" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 98px; height: 1px; padding-top: 15px; margin-left: 451px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Hoofdkantoor</div></div></div></foreignObject><text x="500" y="19" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Hoofdkantoor</text></switch></g><path d="M 155 0 L 210 15 L 155 30 L 100 15 Z" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 108px; height: 1px; padding-top: 15px; margin-left: 101px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">produceert</div></div></div></foreignObject><text x="155" y="19" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">produceert</text></switch></g><path d="M 385 0 L 420 15 L 385 30 L 350 15 Z" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 15px; margin-left: 351px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">heeft</div></div></div></foreignObject><text x="385" y="19" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">heeft</text></switch></g><path d="M 210 15 L 240 15 L 210 15 L 240 15" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 236 19 L 236 11 M 232 19 L 232 11" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 100 15 L 70 15 L 100 15 L 70 15" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 78 11 L 78 19 M 70 19 L 78 15 L 70 11" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 420 15 L 450 15 L 420 15 L 450 15" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 442 19 L 442 11 M 450 11 L 442 15 L 450 19" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><rect x="690" y="0" width="70" height="30" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 15px; margin-left: 691px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Locatie</div></div></div></foreignObject><text x="725" y="19" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Locatie</text></switch></g><path d="M 620 0 L 660 15 L 620 30 L 580 15 Z" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 78px; height: 1px; padding-top: 15px; margin-left: 581px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">staat in</div></div></div></foreignObject><text x="620" y="19" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">staat in</text></switch></g><path d="M 350 15 L 320 15 L 340 15 L 310 15" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 314 11 L 314 19 M 318 11 L 318 19" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 660 15 L 690 15 L 660 15 L 690 15" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 686 19 L 686 11 M 682 19 L 682 11" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 580 15 L 550 15 L 580 15 L 550 15" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 558 11 L 558 19 M 550 19 L 558 15 L 550 11" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 830 0 L 870 15 L 830 30 L 790 15 Z" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 78px; height: 1px; padding-top: 15px; margin-left: 791px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">is in</div></div></div></foreignObject><text x="830" y="19" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">is in</text></switch></g><rect x="900" y="0" width="70" height="30" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 15px; margin-left: 901px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Land</div></div></div></foreignObject><text x="935" y="19" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Land</text></switch></g><path d="M 870 15 L 900 15 L 870 15 L 900 15" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 896 19 L 896 11 M 892 19 L 892 11" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 790 15 L 760 15 L 790 15 L 760 15" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 768 11 L 768 19 M 760 19 L 768 15 L 760 11" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/></g><switch><g requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"/><a transform="translate(0,-5)" xlink:href="https://www.diagrams.net/doc/faq/svg-export-text-problems" target="_blank"><text text-anchor="middle" font-size="10px" x="50%" y="100%">Text is not SVG - cannot display</text></a></switch></svg> \ No newline at end of file
diff --git a/eindopdracht/imgs_strokendiagram.svg b/eindopdracht/imgs_strokendiagram.svg
new file mode 100644
index 0000000..913550d
--- /dev/null
+++ b/eindopdracht/imgs_strokendiagram.svg
@@ -0,0 +1,3 @@
+<?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="539px" height="281px" viewBox="-0.5 -0.5 539 281"><defs/><g><rect x="218" y="180" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 190px; margin-left: 219px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">ID</div></div></div></foreignObject><text x="253" y="194" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">ID</text></switch></g><rect x="288" y="180" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 190px; margin-left: 289px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Naam</div></div></div></foreignObject><text x="323" y="194" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Naam</text></switch></g><rect x="278" y="150" width="80" height="20" fill="none" stroke="none" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-end; width: 78px; height: 1px; padding-top: 160px; margin-left: 278px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: right;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Merk</div></div></div></foreignObject><text x="356" y="164" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="end">Merk</text></switch></g><path d="M 334.37 249.78 L 391.63 249.97" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 329.12 249.76 L 336.13 246.29 L 334.37 249.78 L 336.11 253.29 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 396.88 249.99 L 389.87 253.46 L 391.63 249.97 L 389.89 246.46 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 1px; height: 1px; padding-top: 250px; margin-left: 363px;"><div data-drawio-colors="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); border-color: #FFFFFF; " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 11px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; background-color: rgb(255, 255, 255); border: 1px solid rgb(255, 255, 255); white-space: nowrap;">a</div></div></div></foreignObject><text x="363" y="254" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="11px" text-anchor="middle">a</text></switch></g><rect x="78" y="100" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 110px; margin-left: 79px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">ID</div></div></div></foreignObject><text x="113" y="114" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">ID</text></switch></g><rect x="218" y="100" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 110px; margin-left: 219px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Naam</div></div></div></foreignObject><text x="253" y="114" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Naam</text></switch></g><rect x="8" y="260" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 270px; margin-left: 9px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">ID</div></div></div></foreignObject><text x="43" y="274" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">ID</text></switch></g><path d="M 113 260 L 113 126.37" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 113 121.12 L 116.5 128.12 L 113 126.37 L 109.5 128.12 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><rect x="78" y="260" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 270px; margin-left: 79px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">LocatieID</div></div></div></foreignObject><text x="113" y="274" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">LocatieID</text></switch></g><path d="M 183 260 L 183 230.04 L 253 230.04 L 253 206.37" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 253 201.12 L 256.5 208.12 L 253 206.37 L 249.5 208.12 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><rect x="148" y="260" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 270px; margin-left: 149px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">MerkID</div></div></div></foreignObject><text x="183" y="274" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">MerkID</text></switch></g><rect x="258" y="260" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 270px; margin-left: 259px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">ID</div></div></div></foreignObject><text x="293" y="274" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">ID</text></switch></g><rect x="328" y="260" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 270px; margin-left: 329px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Naam</div></div></div></foreignObject><text x="363" y="274" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Naam</text></switch></g><rect x="458" y="240" width="80" height="20" fill="none" stroke="none" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-end; width: 78px; height: 1px; padding-top: 250px; margin-left: 458px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: right;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Type</div></div></div></foreignObject><text x="536" y="254" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="end">Type</text></switch></g><path d="M 433 260 L 433 230.04 L 253 230.04 L 253 206.37" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 253 201.12 L 256.5 208.12 L 253 206.37 L 249.5 208.12 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><rect x="398" y="260" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 270px; margin-left: 399px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">MerkID</div></div></div></foreignObject><text x="433" y="274" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">MerkID</text></switch></g><rect x="468" y="260" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 270px; margin-left: 469px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Vermogen</div></div></div></foreignObject><text x="503" y="274" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Vermogen</text></switch></g><path d="M 264.37 249.78 L 321.63 249.97" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 259.12 249.76 L 266.13 246.29 L 264.37 249.78 L 266.11 253.29 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 326.88 249.99 L 319.87 253.46 L 321.63 249.97 L 319.89 246.46 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 1px; height: 1px; padding-top: 250px; margin-left: 293px;"><div data-drawio-colors="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); border-color: #FFFFFF; " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 11px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; background-color: rgb(255, 255, 255); border: 1px solid rgb(255, 255, 255); white-space: nowrap;">p</div></div></div></foreignObject><text x="293" y="254" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="11px" text-anchor="middle">p</text></switch></g><path d="M 294.37 170.02 L 351.63 170.21" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 289.12 170 L 296.13 166.53 L 294.37 170.02 L 296.11 173.53 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 356.88 170.23 L 349.87 173.7 L 351.63 170.21 L 349.89 166.7 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 1px; height: 1px; padding-top: 170px; margin-left: 323px;"><div data-drawio-colors="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); border-color: #FFFFFF; " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 11px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; background-color: rgb(255, 255, 255); border: 1px solid rgb(255, 255, 255); white-space: nowrap;">a</div></div></div></foreignObject><text x="323" y="174" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="11px" text-anchor="middle">a</text></switch></g><path d="M 224.37 170.02 L 281.63 170.21" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 219.12 170 L 226.13 166.53 L 224.37 170.02 L 226.11 173.53 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 286.88 170.23 L 279.87 173.7 L 281.63 170.21 L 279.89 166.7 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 1px; height: 1px; padding-top: 170px; margin-left: 253px;"><div data-drawio-colors="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); border-color: #FFFFFF; " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 11px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; background-color: rgb(255, 255, 255); border: 1px solid rgb(255, 255, 255); white-space: nowrap;">p</div></div></div></foreignObject><text x="253" y="174" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="11px" text-anchor="middle">p</text></switch></g><path d="M 84.37 89.82 L 141.63 90.01" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 79.12 89.8 L 86.13 86.33 L 84.37 89.82 L 86.11 93.33 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 146.88 90.03 L 139.87 93.5 L 141.63 90.01 L 139.89 86.5 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 1px; height: 1px; padding-top: 90px; margin-left: 113px;"><div data-drawio-colors="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); border-color: #FFFFFF; " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 11px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; background-color: rgb(255, 255, 255); border: 1px solid rgb(255, 255, 255); white-space: nowrap;">p</div></div></div></foreignObject><text x="113" y="94" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="11px" text-anchor="middle">p</text></switch></g><path d="M 154.37 90 L 281.63 90" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 149.12 90 L 156.12 86.5 L 154.37 90 L 156.12 93.5 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 286.88 90 L 279.88 93.5 L 281.63 90 L 279.88 86.5 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 1px; height: 1px; padding-top: 90px; margin-left: 219px;"><div data-drawio-colors="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); border-color: #FFFFFF; " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 11px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; background-color: rgb(255, 255, 255); border: 1px solid rgb(255, 255, 255); white-space: nowrap;">a</div></div></div></foreignObject><text x="219" y="94" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="11px" text-anchor="middle">a</text></switch></g><rect x="208" y="70" width="80" height="20" fill="none" stroke="none" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-end; width: 78px; height: 1px; padding-top: 80px; margin-left: 208px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: right;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Locatie</div></div></div></foreignObject><text x="286" y="84" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="end">Locatie</text></switch></g><path d="M 14.37 250.02 L 71.63 250.21" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 9.12 250 L 16.13 246.53 L 14.37 250.02 L 16.11 253.53 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 76.88 250.23 L 69.87 253.7 L 71.63 250.21 L 69.89 246.7 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 1px; height: 1px; padding-top: 250px; margin-left: 43px;"><div data-drawio-colors="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); border-color: #FFFFFF; " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 11px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; background-color: rgb(255, 255, 255); border: 1px solid rgb(255, 255, 255); white-space: nowrap;">p</div></div></div></foreignObject><text x="43" y="254" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="11px" text-anchor="middle">p</text></switch></g><rect x="8" y="230" width="80" height="20" fill="none" stroke="none" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-start; width: 78px; height: 1px; padding-top: 240px; margin-left: 10px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: left;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Hoofdkantoor</div></div></div></foreignObject><text x="10" y="244" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px">Hoofdkantoor</text></switch></g><rect x="148" y="30" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 40px; margin-left: 149px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">ID</div></div></div></foreignObject><text x="183" y="44" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">ID</text></switch></g><rect x="218" y="30" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 40px; margin-left: 219px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Naam</div></div></div></foreignObject><text x="253" y="44" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">Naam</text></switch></g><path d="M 154.37 19.82 L 211.63 20.01" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 149.12 19.8 L 156.13 16.33 L 154.37 19.82 L 156.11 23.33 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 216.88 20.03 L 209.87 23.5 L 211.63 20.01 L 209.89 16.5 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 1px; height: 1px; padding-top: 20px; margin-left: 183px;"><div data-drawio-colors="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); border-color: #FFFFFF; " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 11px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; background-color: rgb(255, 255, 255); border: 1px solid rgb(255, 255, 255); white-space: nowrap;">p</div></div></div></foreignObject><text x="183" y="24" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="11px" text-anchor="middle">p</text></switch></g><path d="M 224.37 20.02 L 281.63 20.21" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 219.12 20 L 226.13 16.53 L 224.37 20.02 L 226.11 23.53 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><path d="M 286.88 20.23 L 279.87 23.7 L 281.63 20.21 L 279.89 16.7 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 1px; height: 1px; padding-top: 20px; margin-left: 253px;"><div data-drawio-colors="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); border-color: #FFFFFF; " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 11px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; background-color: rgb(255, 255, 255); border: 1px solid rgb(255, 255, 255); white-space: nowrap;">a</div></div></div></foreignObject><text x="253" y="24" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="11px" text-anchor="middle">a</text></switch></g><rect x="208" y="0" width="80" height="20" fill="none" stroke="none" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-end; width: 78px; height: 1px; padding-top: 10px; margin-left: 208px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: right;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">Land</div></div></div></foreignObject><text x="286" y="14" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="end">Land</text></switch></g><path d="M 183 100 L 183 56.37" fill="none" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="stroke"/><path d="M 183 51.12 L 186.5 58.12 L 183 56.37 L 179.5 58.12 Z" fill="rgb(0, 0, 0)" stroke="rgb(0, 0, 0)" stroke-miterlimit="10" pointer-events="all"/><rect x="148" y="100" width="70" height="20" fill="rgb(255, 255, 255)" stroke="rgb(0, 0, 0)" pointer-events="all"/><g transform="translate(-0.5 -0.5)"><switch><foreignObject pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility" style="overflow: visible; text-align: left;"><div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 68px; height: 1px; padding-top: 110px; margin-left: 149px;"><div data-drawio-colors="color: rgb(0, 0, 0); " style="box-sizing: border-box; font-size: 0px; text-align: center;"><div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: rgb(0, 0, 0); line-height: 1.2; pointer-events: all; white-space: normal; overflow-wrap: normal;">LandID</div></div></div></foreignObject><text x="183" y="114" fill="rgb(0, 0, 0)" font-family="Helvetica" font-size="12px" text-anchor="middle">LandID</text></switch></g></g><switch><g requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility"/><a transform="translate(0,-5)" xlink:href="https://www.diagrams.net/doc/faq/svg-export-text-problems" target="_blank"><text text-anchor="middle" font-size="10px" x="50%" y="100%">Text is not SVG - cannot display</text></a></switch></svg> \ No newline at end of file
diff --git a/eindopdracht/import.js b/eindopdracht/import.js
new file mode 100755
index 0000000..7f553b5
--- /dev/null
+++ b/eindopdracht/import.js
@@ -0,0 +1,47 @@
+#!/bin/node
+
+var fs = require("fs");
+var lines = fs.readFileSync(process.argv[2]).toString().trim().split("\n");
+var records = [];
+
+function objArrToSQLInsertArr(objArr) {
+ var temp = JSON.stringify(objArr).replaceAll("[", "(").replaceAll("]", ")");
+ return temp.substr(1, temp.length - 2)
+}
+
+lines.forEach(line => {
+ var columns = line.split("\t");
+ var plaats = columns[4].split(",");
+ records.push({
+ "Merk": columns[0],
+ "Type": columns[1],
+ "Vermogen": Number(columns[3]),
+ "Locatie": plaats[0].trim(),
+ "Land": plaats[1].trim(),
+ });
+});
+
+var landen = [];
+records.forEach(record => landen.push(record.Land));
+landen = Array.from(new Set(landen));
+console.log(`insert into Land (Naam) values ${objArrToSQLInsertArr(landen.map(i => [i]))};`);
+
+var merken = [];
+records.forEach(record => merken.push(record.Merk));
+merken = Array.from(new Set(merken));
+console.log(`insert into Merk (Naam) values ${objArrToSQLInsertArr(merken.map(i => [i]))};`);
+
+var locaties = [];
+records.forEach(record => locaties.push(JSON.stringify([record.Locatie, landen.indexOf(record.Land) + 1])));
+locaties = Array.from(new Set(locaties)).map(i => JSON.parse(i));
+console.log(`insert into Locatie (Naam, LandID) values ${objArrToSQLInsertArr(locaties)};`);
+
+var hoofdkantoren = [];
+records.forEach(record => hoofdkantoren.push(JSON.stringify([locaties.indexOf(locaties.find(x => x[0] == record.Locatie)) + 1, merken.indexOf(record.Merk) + 1])));
+hoofdkantoren = Array.from(new Set(hoofdkantoren)).map(i => JSON.parse(i));
+console.log(`insert into Hoofdkantoor (LocatieID, MerkID) values ${objArrToSQLInsertArr(hoofdkantoren)};`);
+
+var types = [];
+records.forEach(record => types.push(JSON.stringify([merken.indexOf(record.Merk) + 1, record.Type, record.Vermogen])));
+types = Array.from(new Set(types)).map(i => JSON.parse(i));
+console.log(`insert into \`Type\` (MerkID, Naam, Vermogen) values ${objArrToSQLInsertArr(types)};`);
diff --git a/eindopdracht/makefile b/eindopdracht/makefile
new file mode 100644
index 0000000..3bac82c
--- /dev/null
+++ b/eindopdracht/makefile
@@ -0,0 +1,16 @@
+RM = rm -f
+TARGET := eindopdracht
+QUERY_SQL += q5.sql
+
+all: $(TARGET).md
+
+nfs.csv: nfs.xlsx
+ xlsx2csv -dtab -qnone $< | sed '1d' > $@
+
+q5.sql: nfs.csv
+ ./import.js $< | cat b5.sql - > $@
+
+clean::
+ rm q5.sql nfs.csv
+
+include ../common.mk
diff --git a/eindopdracht/q8.sql b/eindopdracht/q8.sql
new file mode 100644
index 0000000..4a1151a
--- /dev/null
+++ b/eindopdracht/q8.sql
@@ -0,0 +1,12 @@
+create or replace view NFS_Excel as
+select
+ Merk.Naam as "Merk",
+ `Type`.Naam as "Type",
+ round(`Type`.Vermogen * 1.3637) as "Vermogen [pk]",
+ `Type`.Vermogen as "Vermogen [kW]",
+ concat(Locatie.Naam, ", ", Land.Naam) as "Hoofdkantoor"
+from `Type`
+left join Merk on Merk.ID = `Type`.MerkID
+left join Hoofdkantoor on Hoofdkantoor.MerkID = Merk.ID
+left join Locatie on Locatie.ID = Hoofdkantoor.LocatieID
+left join Land on Land.ID = Locatie.LandID;
diff --git a/eindopdracht/reset.sql b/eindopdracht/reset.sql
new file mode 100644
index 0000000..306d94b
--- /dev/null
+++ b/eindopdracht/reset.sql
@@ -0,0 +1,6 @@
+drop table if exists Hoofdkantoor;
+drop table if exists `Type`;
+drop table if exists Merk;
+drop table if exists Locatie;
+drop table if exists Land;
+
diff --git a/eindopdracht/t8.sql b/eindopdracht/t8.sql
new file mode 100644
index 0000000..cebeddf
--- /dev/null
+++ b/eindopdracht/t8.sql
@@ -0,0 +1 @@
+select * from NFS_Excel;
diff --git a/eindopdracht/t9.sql b/eindopdracht/t9.sql
new file mode 100644
index 0000000..6c72b90
--- /dev/null
+++ b/eindopdracht/t9.sql
@@ -0,0 +1,9 @@
+select
+ Land.Naam,
+ count(`Type`.ID) as "Aantal types"
+from `Type`
+left join Merk on Merk.ID = `Type`.MerkID
+left join Hoofdkantoor on Hoofdkantoor.MerkID = Merk.ID
+left join Locatie on Locatie.ID = Hoofdkantoor.LocatieID
+left join Land on Land.ID = Locatie.LandID
+group by Land.ID;
diff --git a/opdracht-1/reset.sql b/opdracht-1/reset.sql
index c2f5ee9..097194f 100644
--- a/opdracht-1/reset.sql
+++ b/opdracht-1/reset.sql
@@ -1,5 +1,5 @@
-drop table OrderProduct;
-drop table `Order`;
-drop table Product;
-drop table Klant;
+drop table if exists OrderProduct;
+drop table if exists `Order`;
+drop table if exists Product;
+drop table if exists Klant;