databaseStructure.drawio.svg

<svg host="65bd71144e" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" version="1.1" width="681px" height="351px" viewBox="-0.5 -0.5 681 351" content="&lt;mxfile&gt;&lt;diagram id=&quot;T-cmqvpSK2OCofqQhWN3&quot; name=&quot;Page-1&quot;&gt;5Vpdc6IwFP01znQf2hEiVh+r7W5fdmZnOzu7+5hChEyBMCFW3V+/F0lESLRUwGp9aeHki3tOcnOI9NA0Wn7jOAm+M4+EPbvvLXvovmfbyBnB3wxY5YDtODngc+rlkFUAT/QfkWBfonPqkbRUUTAWCpqUQZfFMXFFCcOcs0W52oyF5VET7BMNeHJxqKO/qSeCHB3ZtwX+SKgfqJGt4TgvibCqLCNJA+yxxRaEHnpoyhkT+VW0nJIw407xkrf7uqN082CcxKJWg0He4hWHcxmcfDCxUtH6nM0TvWM51ivhgixNtONn1UMRGcwIwiIi+ArqqVaKDDkbBvJ2UVCLlPLBNq1DCWIpp7/puogYLmTQZgJqxA/hxx7J6vd7aLIIqCBPCXaz0gVMb8ACEUH/9xZcGnga7CBKJ+QoETuGiIchjDB5hgs/u3hk85QEsCpSVQSdbko1giAsUWYhFZy9kCkLGQckZjHUnMxoGFYgHFI/hlsX2CKATzKSKCy0O1kQUc/LhjHSXhamEfOq1LJvnNJktPTJOHJ0ZewWhBlqwmQldxnXhFOcVU04jfD6gV/IqgMdQjITH6+CyiNSAqRLYN8aVkcbGtxqGsQ4IrkKa3ovhHPniJyPNc4h+/A0J51CYvAhNaw3bpw98BXBbgD/OZkRiNgFI2D3sxb5qvhyKRLdHlEilQW3NMJeROOqRleXLsr4iKIg9LZ3IbF3lxnebI8NcZpSt65dIV7JA+81K44hQoVxEmJBX8vO2RS2HOEHg+m0k1+196oOUjbnLpFttn3u/m6scYV/gblPhNbPWoJNzLVU2fjiD3TUw7KhNjrqvslfOm3kCpPBbGKpKwte520ncfsddncM6E5Os9i/1lvcObvrd7CuSsvT0mCt7VFXG5hu7D6FuW4sgslcdybCSBPhLN11Y9JN7roz0nV7zYlLE/I+g63anJWdayyUyWN3JZSte+xAncPs99lFtctSx2S2O1NHz10azV3bukENX2ckoBVXowI+oq8b7WBur6/rkAHTC1fF1/1UefKcnV193us7u2FXC1M/wf8czq6pCCZn15kI+jvfeTq7pqSbnF1npOuvmflxyOXRbvJpndGuv0omLBXEe159tuPQxrqYHFpXuqh81+5xqKLgRI5DtY32wPPQ63GlI6uiQHsHoqjGgegBx9QnJQtyKntvdULX1WXwVkct6lLDz7+lC8jBV3+y/HGD0Ab4C8B1/6YPmVIi90uZY/K71fbdD3Bp8NiZjd31q0wO5aFLyDkp/a1BZTkNDtTfGpsTaAfy1/jy5eBluS3Vif2eVPnYCB2q1MZzqJfx1qSC2+IDsLx68RUdevgP&lt;/diagram&gt;&lt;/mxfile&gt;">
    <defs/>
    <g>
        <rect x="60" y="0" width="310" height="160" fill="#ffffff" stroke="#000000" pointer-events="none"/>
        <g transform="translate(-0.5 -0.5)">
            <switch>
                <foreignObject style="overflow: visible; text-align: left;" pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility">
                    <div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 83px; height: 1px; padding-top: 20px; margin-left: 174px;">
                        <div style="box-sizing: border-box; font-size: 0; text-align: center; ">
                            <div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: #000000; line-height: 1.2; pointer-events: none; white-space: normal; word-wrap: normal; ">
                                <b>
                                    Households
                                </b>
                            </div>
                        </div>
                    </div>
                </foreignObject>
                <text x="215" y="24" fill="#000000" font-family="Helvetica" font-size="12px" text-anchor="middle">
                    Households
                </text>
            </switch>
        </g>
        <g transform="translate(-0.5 -0.5)">
            <switch>
                <foreignObject style="overflow: visible; text-align: left;" pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility">
                    <div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-start; width: 268px; height: 1px; padding-top: 40px; margin-left: 83px;">
                        <div style="box-sizing: border-box; font-size: 0; text-align: left; ">
                            <div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: #000000; line-height: 1.2; pointer-events: none; white-space: normal; word-wrap: normal; ">
                                id: serial primary key
                            </div>
                        </div>
                    </div>
                </foreignObject>
                <text x="83" y="44" fill="#000000" font-family="Helvetica" font-size="12px">
                    id: serial primary key
                </text>
            </switch>
        </g>
        <g transform="translate(-0.5 -0.5)">
            <switch>
                <foreignObject style="overflow: visible; text-align: left;" pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility">
                    <div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-start; width: 268px; height: 1px; padding-top: 60px; margin-left: 83px;">
                        <div style="box-sizing: border-box; font-size: 0; text-align: left; ">
                            <div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: #000000; line-height: 1.2; pointer-events: none; white-space: normal; word-wrap: normal; ">
                                name: text
                            </div>
                        </div>
                    </div>
                </foreignObject>
                <text x="83" y="64" fill="#000000" font-family="Helvetica" font-size="12px">
                    name: text
                </text>
            </switch>
        </g>
        <g transform="translate(-0.5 -0.5)">
            <switch>
                <foreignObject style="overflow: visible; text-align: left;" pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility">
                    <div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-start; width: 268px; height: 1px; padding-top: 80px; margin-left: 83px;">
                        <div style="box-sizing: border-box; font-size: 0; text-align: left; ">
                            <div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: #000000; line-height: 1.2; pointer-events: none; white-space: normal; word-wrap: normal; ">
                                users: integer array (each references user key)
                            </div>
                        </div>
                    </div>
                </foreignObject>
                <text x="83" y="84" fill="#000000" font-family="Helvetica" font-size="12px">
                    users: integer array (each references user ke...
                </text>
            </switch>
        </g>
        <g transform="translate(-0.5 -0.5)">
            <switch>
                <foreignObject style="overflow: visible; text-align: left;" pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility">
                    <div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-start; width: 268px; height: 1px; padding-top: 100px; margin-left: 83px;">
                        <div style="box-sizing: border-box; font-size: 0; text-align: left; ">
                            <div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: #000000; line-height: 1.2; pointer-events: none; white-space: normal; word-wrap: normal; ">
                                admin: integer (references user key)
                            </div>
                        </div>
                    </div>
                </foreignObject>
                <text x="83" y="104" fill="#000000" font-family="Helvetica" font-size="12px">
                    admin: integer (references user key)
                </text>
            </switch>
        </g>
        <path d="M 81 85 L 81 183.63" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/>
        <path d="M 81 188.88 L 77.5 181.88 L 81 183.63 L 84.5 181.88 Z" fill="#000000" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/>
        <rect x="0" y="200" width="300" height="150" fill="#ffffff" stroke="#000000" pointer-events="none"/>
        <g transform="translate(-0.5 -0.5)">
            <switch>
                <foreignObject style="overflow: visible; text-align: left;" pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility">
                    <div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 278px; height: 1px; padding-top: 220px; margin-left: 11px;">
                        <div style="box-sizing: border-box; font-size: 0; text-align: center; ">
                            <div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: #000000; line-height: 1.2; pointer-events: none; white-space: normal; word-wrap: normal; ">
                                <b>
                                    Users
                                </b>
                            </div>
                        </div>
                    </div>
                </foreignObject>
                <text x="150" y="224" fill="#000000" font-family="Helvetica" font-size="12px" text-anchor="middle">
                    Users
                </text>
            </switch>
        </g>
        <g transform="translate(-0.5 -0.5)">
            <switch>
                <foreignObject style="overflow: visible; text-align: left;" pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility">
                    <div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-start; width: 278px; height: 1px; padding-top: 240px; margin-left: 12px;">
                        <div style="box-sizing: border-box; font-size: 0; text-align: left; ">
                            <div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: #000000; line-height: 1.2; pointer-events: none; white-space: normal; word-wrap: normal; ">
                                id: serial primary key
                            </div>
                        </div>
                    </div>
                </foreignObject>
                <text x="12" y="244" fill="#000000" font-family="Helvetica" font-size="12px">
                    id: serial primary key
                </text>
            </switch>
        </g>
        <g transform="translate(-0.5 -0.5)">
            <switch>
                <foreignObject style="overflow: visible; text-align: left;" pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility">
                    <div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-start; width: 278px; height: 1px; padding-top: 260px; margin-left: 12px;">
                        <div style="box-sizing: border-box; font-size: 0; text-align: left; ">
                            <div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: #000000; line-height: 1.2; pointer-events: none; white-space: normal; word-wrap: normal; ">
                                name: text
                            </div>
                        </div>
                    </div>
                </foreignObject>
                <text x="12" y="264" fill="#000000" font-family="Helvetica" font-size="12px">
                    name: text
                </text>
            </switch>
        </g>
        <g transform="translate(-0.5 -0.5)">
            <switch>
                <foreignObject style="overflow: visible; text-align: left;" pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility">
                    <div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-start; width: 278px; height: 1px; padding-top: 280px; margin-left: 12px;">
                        <div style="box-sizing: border-box; font-size: 0; text-align: left; ">
                            <div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: #000000; line-height: 1.2; pointer-events: none; white-space: normal; word-wrap: normal; ">
                                recipes: integer array (each references recipes key)
                            </div>
                        </div>
                    </div>
                </foreignObject>
                <text x="12" y="284" fill="#000000" font-family="Helvetica" font-size="12px">
                    recipes: integer array (each references recipe...
                </text>
            </switch>
        </g>
        <g transform="translate(-0.5 -0.5)">
            <switch>
                <foreignObject style="overflow: visible; text-align: left;" pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility">
                    <div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-start; width: 278px; height: 1px; padding-top: 300px; margin-left: 12px;">
                        <div style="box-sizing: border-box; font-size: 0; text-align: left; ">
                            <div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: #000000; line-height: 1.2; pointer-events: none; white-space: normal; word-wrap: normal; ">
                                household: integer (references household key)
                            </div>
                        </div>
                    </div>
                </foreignObject>
                <text x="12" y="304" fill="#000000" font-family="Helvetica" font-size="12px">
                    household: integer (references household key)
                </text>
            </switch>
        </g>
        <rect x="400" y="200" width="280" height="150" fill="#ffffff" stroke="#000000" pointer-events="none"/>
        <g transform="translate(-0.5 -0.5)">
            <switch>
                <foreignObject style="overflow: visible; text-align: left;" pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility">
                    <div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe center; width: 258px; height: 1px; padding-top: 220px; margin-left: 411px;">
                        <div style="box-sizing: border-box; font-size: 0; text-align: center; ">
                            <div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: #000000; line-height: 1.2; pointer-events: none; white-space: normal; word-wrap: normal; ">
                                <b>
                                    Recipes
                                </b>
                            </div>
                        </div>
                    </div>
                </foreignObject>
                <text x="540" y="224" fill="#000000" font-family="Helvetica" font-size="12px" text-anchor="middle">
                    Recipes
                </text>
            </switch>
        </g>
        <g transform="translate(-0.5 -0.5)">
            <switch>
                <foreignObject style="overflow: visible; text-align: left;" pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility">
                    <div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-start; width: 258px; height: 1px; padding-top: 240px; margin-left: 412px;">
                        <div style="box-sizing: border-box; font-size: 0; text-align: left; ">
                            <div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: #000000; line-height: 1.2; pointer-events: none; white-space: normal; word-wrap: normal; ">
                                id: serial primary key
                            </div>
                        </div>
                    </div>
                </foreignObject>
                <text x="412" y="244" fill="#000000" font-family="Helvetica" font-size="12px">
                    id: serial primary key
                </text>
            </switch>
        </g>
        <g transform="translate(-0.5 -0.5)">
            <switch>
                <foreignObject style="overflow: visible; text-align: left;" pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility">
                    <div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-start; width: 258px; height: 1px; padding-top: 260px; margin-left: 412px;">
                        <div style="box-sizing: border-box; font-size: 0; text-align: left; ">
                            <div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: #000000; line-height: 1.2; pointer-events: none; white-space: normal; word-wrap: normal; ">
                                name: text
                            </div>
                        </div>
                    </div>
                </foreignObject>
                <text x="412" y="264" fill="#000000" font-family="Helvetica" font-size="12px">
                    name: text
                </text>
            </switch>
        </g>
        <g transform="translate(-0.5 -0.5)">
            <switch>
                <foreignObject style="overflow: visible; text-align: left;" pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility">
                    <div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-start; width: 258px; height: 1px; padding-top: 280px; margin-left: 412px;">
                        <div style="box-sizing: border-box; font-size: 0; text-align: left; ">
                            <div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: #000000; line-height: 1.2; pointer-events: none; white-space: normal; word-wrap: normal; ">
                                source: text
                            </div>
                        </div>
                    </div>
                </foreignObject>
                <text x="412" y="284" fill="#000000" font-family="Helvetica" font-size="12px">
                    source: text
                </text>
            </switch>
        </g>
        <g transform="translate(-0.5 -0.5)">
            <switch>
                <foreignObject style="overflow: visible; text-align: left;" pointer-events="none" width="100%" height="100%" requiredFeatures="http://www.w3.org/TR/SVG11/feature#Extensibility">
                    <div xmlns="http://www.w3.org/1999/xhtml" style="display: flex; align-items: unsafe center; justify-content: unsafe flex-start; width: 258px; height: 1px; padding-top: 300px; margin-left: 412px;">
                        <div style="box-sizing: border-box; font-size: 0; text-align: left; ">
                            <div style="display: inline-block; font-size: 12px; font-family: Helvetica; color: #000000; line-height: 1.2; pointer-events: none; white-space: normal; word-wrap: normal; ">
                                postedby: integer (references user key)
                            </div>
                        </div>
                    </div>
                </foreignObject>
                <text x="412" y="304" fill="#000000" font-family="Helvetica" font-size="12px">
                    postedby: integer (references user key)
                </text>
            </switch>
        </g>
        <path d="M 410 305 L 316.36 309.68" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/>
        <path d="M 311.12 309.94 L 317.93 306.1 L 316.36 309.68 L 318.28 313.09 Z" fill="#000000" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/>
        <path d="M 290 280 L 383.63 280" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/>
        <path d="M 388.88 280 L 381.88 283.5 L 383.63 280 L 381.88 276.5 Z" fill="#000000" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/>
        <path d="M 80 100 L 98.04 189.71" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/>
        <path d="M 99.08 194.85 L 94.27 188.68 L 98.04 189.71 L 101.13 187.3 Z" fill="#000000" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/>
        <path d="M 160 300 L 193.46 166.18" fill="none" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/>
        <path d="M 194.73 161.08 L 196.43 168.72 L 193.46 166.18 L 189.64 167.03 Z" fill="#000000" stroke="#000000" stroke-miterlimit="10" pointer-events="none"/>
    </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%">
                Viewer does not support full SVG 1.1
            </text>
        </a>
    </switch>
</svg>