Linuxero/pyqcrm
SHA256
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

Datenbank aktualisiert

Browse Source
This commit is contained in:
Daniel Stoppek
2024-10-29 10:53:42 +01:00
parent 8b45dee4c1
commit 459ce17225
2 changed files with 69 additions and 13 deletions
Download Patch File Download Diff File Expand all files Collapse all files

82
doc/datenbank.drawio
View File

@@ -1,6 +1,6 @@
<mxfile host="Electron" agent="Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) draw.io/24.7.17 Chrome/128.0.6613.36 Electron/32.0.1 Safari/537.36" version="24.7.17"> <mxfile host="Electron" agent="Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) draw.io/24.7.17 Chrome/128.0.6613.36 Electron/32.0.1 Safari/537.36" version="24.7.17">
<diagram name="Seite-1" id="krh1Wum05D0y0HCIq7V8"> <diagram name="Seite-1" id="krh1Wum05D0y0HCIq7V8">
<mxGraphModel dx="3010" dy="1258" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0"> <mxGraphModel dx="11197" dy="5975" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
<root> <root>
<mxCell id="0" /> <mxCell id="0" />
<mxCell id="1" parent="0" /> <mxCell id="1" parent="0" />
@@ -464,7 +464,7 @@
</mxGeometry> </mxGeometry>
</mxCell> </mxCell>
<mxCell id="Ya_982ONw7_15APAzA8q-176" value="Angebot" style="shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;" parent="1" vertex="1"> <mxCell id="Ya_982ONw7_15APAzA8q-176" value="Angebot" style="shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;" parent="1" vertex="1">
<mxGeometry x="900" y="880" width="180" height="90" as="geometry" /> <mxGeometry x="900" y="880" width="180" height="120" as="geometry" />
</mxCell> </mxCell>
<mxCell id="Ya_982ONw7_15APAzA8q-177" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;" parent="Ya_982ONw7_15APAzA8q-176" vertex="1"> <mxCell id="Ya_982ONw7_15APAzA8q-177" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;" parent="Ya_982ONw7_15APAzA8q-176" vertex="1">
<mxGeometry y="30" width="180" height="30" as="geometry" /> <mxGeometry y="30" width="180" height="30" as="geometry" />
@@ -497,7 +497,7 @@
<mxPoint x="830" y="590" as="sourcePoint" /> <mxPoint x="830" y="590" as="sourcePoint" />
<mxPoint x="1080" y="590" as="targetPoint" /> <mxPoint x="1080" y="590" as="targetPoint" />
<Array as="points"> <Array as="points">
<mxPoint x="1110" y="695" /> <mxPoint x="1110" y="655" />
<mxPoint x="1110" y="590" /> <mxPoint x="1110" y="590" />
</Array> </Array>
</mxGeometry> </mxGeometry>
@@ -577,10 +577,10 @@
</mxGeometry> </mxGeometry>
</mxCell> </mxCell>
<mxCell id="Ya_982ONw7_15APAzA8q-227" value="" style="group" parent="1" vertex="1" connectable="0"> <mxCell id="Ya_982ONw7_15APAzA8q-227" value="" style="group" parent="1" vertex="1" connectable="0">
<mxGeometry x="1150" y="620" width="180" height="150" as="geometry" /> <mxGeometry x="1151" y="580" width="180" height="180" as="geometry" />
</mxCell> </mxCell>
<mxCell id="Ya_982ONw7_15APAzA8q-189" value="Auftrag" style="shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;" parent="Ya_982ONw7_15APAzA8q-227" vertex="1"> <mxCell id="Ya_982ONw7_15APAzA8q-189" value="Auftrag" style="shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=0;align=center;resizeLast=1;html=1;" parent="Ya_982ONw7_15APAzA8q-227" vertex="1">
<mxGeometry width="180" height="150" as="geometry" /> <mxGeometry width="180" height="180" as="geometry" />
</mxCell> </mxCell>
<mxCell id="Ya_982ONw7_15APAzA8q-190" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;" parent="Ya_982ONw7_15APAzA8q-189" vertex="1"> <mxCell id="Ya_982ONw7_15APAzA8q-190" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;" parent="Ya_982ONw7_15APAzA8q-189" vertex="1">
<mxGeometry y="30" width="180" height="30" as="geometry" /> <mxGeometry y="30" width="180" height="30" as="geometry" />
@@ -634,6 +634,16 @@
<mxRectangle width="30" height="30" as="alternateBounds" /> <mxRectangle width="30" height="30" as="alternateBounds" />
</mxGeometry> </mxGeometry>
</mxCell> </mxCell>
<mxCell id="5CqAkLydmV_yxfNIBBfD-90" value="Auftragsdatum" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=1;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="Ya_982ONw7_15APAzA8q-227">
<mxGeometry x="30" y="150" width="150" height="30" as="geometry">
<mxRectangle width="150" height="30" as="alternateBounds" />
</mxGeometry>
</mxCell>
<mxCell id="5CqAkLydmV_yxfNIBBfD-91" value="FK" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="Ya_982ONw7_15APAzA8q-227">
<mxGeometry y="150" width="30" height="30" as="geometry">
<mxRectangle width="30" height="30" as="alternateBounds" />
</mxGeometry>
</mxCell>
<mxCell id="Ya_982ONw7_15APAzA8q-229" value="" style="group" parent="1" vertex="1" connectable="0"> <mxCell id="Ya_982ONw7_15APAzA8q-229" value="" style="group" parent="1" vertex="1" connectable="0">
<mxGeometry x="1400" y="39" width="186" height="141" as="geometry" /> <mxGeometry x="1400" y="39" width="186" height="141" as="geometry" />
</mxCell> </mxCell>
@@ -1117,16 +1127,16 @@
<mxCell id="Ya_982ONw7_15APAzA8q-278" value="" style="endArrow=none;html=1;rounded=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;" parent="1" source="Ya_982ONw7_15APAzA8q-244" edge="1"> <mxCell id="Ya_982ONw7_15APAzA8q-278" value="" style="endArrow=none;html=1;rounded=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;" parent="1" source="Ya_982ONw7_15APAzA8q-244" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry"> <mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="880" y="840" as="sourcePoint" /> <mxPoint x="880" y="840" as="sourcePoint" />
<mxPoint x="1240" y="770" as="targetPoint" /> <mxPoint x="1240" y="760" as="targetPoint" />
<Array as="points"> <Array as="points">
<mxPoint x="1130" y="985" /> <mxPoint x="1130" y="985" />
<mxPoint x="1130" y="800" /> <mxPoint x="1130" y="810" />
<mxPoint x="1240" y="800" /> <mxPoint x="1240" y="810" />
</Array> </Array>
</mxGeometry> </mxGeometry>
</mxCell> </mxCell>
<mxCell id="Ya_982ONw7_15APAzA8q-279" value="1" style="resizable=0;html=1;whiteSpace=wrap;align=right;verticalAlign=bottom;" parent="1" connectable="0" vertex="1"> <mxCell id="Ya_982ONw7_15APAzA8q-279" value="1" style="resizable=0;html=1;whiteSpace=wrap;align=right;verticalAlign=bottom;" parent="1" connectable="0" vertex="1">
<mxGeometry x="1240" y="790" as="geometry" /> <mxGeometry x="1240" y="780" as="geometry" />
</mxCell> </mxCell>
<mxCell id="Ya_982ONw7_15APAzA8q-280" value="N" style="resizable=0;html=1;whiteSpace=wrap;align=right;verticalAlign=bottom;" parent="1" connectable="0" vertex="1"> <mxCell id="Ya_982ONw7_15APAzA8q-280" value="N" style="resizable=0;html=1;whiteSpace=wrap;align=right;verticalAlign=bottom;" parent="1" connectable="0" vertex="1">
<mxGeometry x="1130" y="940" as="geometry"> <mxGeometry x="1130" y="940" as="geometry">
@@ -1140,6 +1150,8 @@
<Array as="points"> <Array as="points">
<mxPoint x="800" y="705" /> <mxPoint x="800" y="705" />
<mxPoint x="800" y="665" /> <mxPoint x="800" y="665" />
<mxPoint x="1130" y="665" />
<mxPoint x="1130" y="625" />
</Array> </Array>
</mxGeometry> </mxGeometry>
</mxCell> </mxCell>
@@ -1521,7 +1533,7 @@
<mxPoint x="1240" y="770" as="targetPoint" /> <mxPoint x="1240" y="770" as="targetPoint" />
<Array as="points"> <Array as="points">
<mxPoint x="1360" y="505" /> <mxPoint x="1360" y="505" />
<mxPoint x="1360" y="725" /> <mxPoint x="1360" y="685" />
</Array> </Array>
</mxGeometry> </mxGeometry>
</mxCell> </mxCell>
@@ -2026,12 +2038,12 @@
<mxCell id="5CqAkLydmV_yxfNIBBfD-66" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" vertex="1" parent="5CqAkLydmV_yxfNIBBfD-56"> <mxCell id="5CqAkLydmV_yxfNIBBfD-66" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" vertex="1" parent="5CqAkLydmV_yxfNIBBfD-56">
<mxGeometry y="120" width="180" height="30" as="geometry" /> <mxGeometry y="120" width="180" height="30" as="geometry" />
</mxCell> </mxCell>
<mxCell id="5CqAkLydmV_yxfNIBBfD-67" value="" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="5CqAkLydmV_yxfNIBBfD-66"> <mxCell id="5CqAkLydmV_yxfNIBBfD-67" value="FK" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="5CqAkLydmV_yxfNIBBfD-66">
<mxGeometry width="30" height="30" as="geometry"> <mxGeometry width="30" height="30" as="geometry">
<mxRectangle width="30" height="30" as="alternateBounds" /> <mxRectangle width="30" height="30" as="alternateBounds" />
</mxGeometry> </mxGeometry>
</mxCell> </mxCell>
<mxCell id="5CqAkLydmV_yxfNIBBfD-68" value="Krankenkasse" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="5CqAkLydmV_yxfNIBBfD-66"> <mxCell id="5CqAkLydmV_yxfNIBBfD-68" value="mediacalcareid" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="5CqAkLydmV_yxfNIBBfD-66">
<mxGeometry x="30" width="150" height="30" as="geometry"> <mxGeometry x="30" width="150" height="30" as="geometry">
<mxRectangle width="150" height="30" as="alternateBounds" /> <mxRectangle width="150" height="30" as="alternateBounds" />
</mxGeometry> </mxGeometry>
@@ -2045,6 +2057,50 @@
<mxCell id="5CqAkLydmV_yxfNIBBfD-70" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" vertex="1" parent="1"> <mxCell id="5CqAkLydmV_yxfNIBBfD-70" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" vertex="1" parent="1">
<mxGeometry x="-260" y="1050" width="180" height="30" as="geometry" /> <mxGeometry x="-260" y="1050" width="180" height="30" as="geometry" />
</mxCell> </mxCell>
<mxCell id="5CqAkLydmV_yxfNIBBfD-73" value="mediacalcare" style="shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;" vertex="1" parent="1">
<mxGeometry x="-790" y="720" width="180" height="90" as="geometry" />
</mxCell>
<mxCell id="5CqAkLydmV_yxfNIBBfD-74" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;" vertex="1" parent="5CqAkLydmV_yxfNIBBfD-73">
<mxGeometry y="30" width="180" height="30" as="geometry" />
</mxCell>
<mxCell id="5CqAkLydmV_yxfNIBBfD-75" value="PK" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="5CqAkLydmV_yxfNIBBfD-74">
<mxGeometry width="30" height="30" as="geometry">
<mxRectangle width="30" height="30" as="alternateBounds" />
</mxGeometry>
</mxCell>
<mxCell id="5CqAkLydmV_yxfNIBBfD-76" value="medicalcareid" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="5CqAkLydmV_yxfNIBBfD-74">
<mxGeometry x="30" width="150" height="30" as="geometry">
<mxRectangle width="150" height="30" as="alternateBounds" />
</mxGeometry>
</mxCell>
<mxCell id="5CqAkLydmV_yxfNIBBfD-77" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" vertex="1" parent="5CqAkLydmV_yxfNIBBfD-73">
<mxGeometry y="60" width="180" height="30" as="geometry" />
</mxCell>
<mxCell id="5CqAkLydmV_yxfNIBBfD-78" value="" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="5CqAkLydmV_yxfNIBBfD-77">
<mxGeometry width="30" height="30" as="geometry">
<mxRectangle width="30" height="30" as="alternateBounds" />
</mxGeometry>
</mxCell>
<mxCell id="5CqAkLydmV_yxfNIBBfD-79" value="company" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="5CqAkLydmV_yxfNIBBfD-77">
<mxGeometry x="30" width="150" height="30" as="geometry">
<mxRectangle width="150" height="30" as="alternateBounds" />
</mxGeometry>
</mxCell>
<mxCell id="5CqAkLydmV_yxfNIBBfD-86" value="" style="endArrow=none;html=1;rounded=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" edge="1" parent="1" source="5CqAkLydmV_yxfNIBBfD-66" target="5CqAkLydmV_yxfNIBBfD-74">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="30" y="790" as="sourcePoint" />
<mxPoint x="80" y="740" as="targetPoint" />
<Array as="points">
<mxPoint x="-810" y="635" />
<mxPoint x="-810" y="765" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="5CqAkLydmV_yxfNIBBfD-100" value="Angebotsdatum" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=1;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="1">
<mxGeometry x="930" y="970" width="150" height="30" as="geometry">
<mxRectangle width="150" height="30" as="alternateBounds" />
</mxGeometry>
</mxCell>
</root> </root>
</mxGraphModel> </mxGraphModel>
</diagram> </diagram>

BIN
doc/datenbank.pdf
View File

Binary file not shown.