<mxfile host="Electron" version="29.6.6" type="device">
  <diagram id="service-delivery" name="Design work, time, and billing">
    <mxGraphModel grid="1" gridSize="10" page="0" pageWidth="1160" pageHeight="1000" background="#FFFFFF">
      <root>
        <mxCell id="0" />
        <mxCell id="1" parent="0" />
        <object id="title" label="Design work, time, and billing">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=28;fontStyle=1;" vertex="1" parent="1">
            <mxGeometry x="25" y="15" width="1110" height="70" as="geometry" />
          </mxCell>
        </object>
        <object id="subtitle" label="How are dated time entries matched to a billing-period rollup?">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=18;fontStyle=0;" vertex="1" parent="1">
            <mxGeometry x="25" y="87" width="1110" height="55" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceEngagement" label="ServiceEngagement" tableName="ServiceEngagement" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="25" y="170" width="330" height="214.0" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceEngagement__grain" label="One engagement for a service order&#10;line" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceEngagement">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceEngagement__ServiceEngagementID" label="ServiceEngagementID (PK)" fieldName="ServiceEngagementID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceEngagement">
            <mxGeometry x="0" y="94.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceEngagement__SalesOrderLineID" label="SalesOrderLineID (FK)" fieldName="SalesOrderLineID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceEngagement">
            <mxGeometry x="0" y="124.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceEngagement__EngagementNumber" label="EngagementNumber" fieldName="EngagementNumber">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceEngagement">
            <mxGeometry x="0" y="154.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceEngagement__CustomerID" label="CustomerID (FK)" fieldName="CustomerID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceEngagement">
            <mxGeometry x="0" y="184.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceEngagementAssignment" label="ServiceEngagementAssignment" tableName="ServiceEngagementAssignment" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="410" y="170" width="330" height="234.0" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceEngagementAssignment__grain" label="One employee assignment to an&#10;engagement" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceEngagementAssignment">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceEngagementAssignment__ServiceEngagementAssignmentID" label="ServiceEngagementAssignmentID (PK)" fieldName="ServiceEngagementAssignmentID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceEngagementAssignment">
            <mxGeometry x="0" y="94.0" width="330" height="50" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceEngagementAssignment__ServiceEngagementID" label="ServiceEngagementID (FK)" fieldName="ServiceEngagementID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceEngagementAssignment">
            <mxGeometry x="0" y="144.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceEngagementAssignment__EmployeeID" label="EmployeeID (FK)" fieldName="EmployeeID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceEngagementAssignment">
            <mxGeometry x="0" y="174.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceEngagementAssignment__AssignedRole" label="AssignedRole" fieldName="AssignedRole">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceEngagementAssignment">
            <mxGeometry x="0" y="204.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceTimeEntry" label="ServiceTimeEntry" tableName="ServiceTimeEntry" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="795" y="170" width="330" height="264.0" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceTimeEntry__grain" label="One employee service-time entry on&#10;a work date" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceTimeEntry">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceTimeEntry__ServiceTimeEntryID" label="ServiceTimeEntryID (PK)" fieldName="ServiceTimeEntryID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceTimeEntry">
            <mxGeometry x="0" y="94.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceTimeEntry__ServiceEngagementAssignmentID" label="ServiceEngagementAssignmentID (FK)" fieldName="ServiceEngagementAssignmentID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceTimeEntry">
            <mxGeometry x="0" y="124.0" width="330" height="50" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceTimeEntry__ServiceEngagementID" label="ServiceEngagementID (FK)" fieldName="ServiceEngagementID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceTimeEntry">
            <mxGeometry x="0" y="174.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceTimeEntry__WorkDate" label="WorkDate" fieldName="WorkDate">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceTimeEntry">
            <mxGeometry x="0" y="204.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceTimeEntry__BillableHours" label="BillableHours" fieldName="BillableHours">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceTimeEntry">
            <mxGeometry x="0" y="234.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceBillingLine" label="ServiceBillingLine" tableName="ServiceBillingLine" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="25" y="610" width="330" height="244.0" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceBillingLine__grain" label="One engagement billing-period&#10;rollup linked to an invoice line" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceBillingLine">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceBillingLine__ServiceBillingLineID" label="ServiceBillingLineID (PK)" fieldName="ServiceBillingLineID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceBillingLine">
            <mxGeometry x="0" y="94.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceBillingLine__ServiceEngagementID" label="ServiceEngagementID (FK)" fieldName="ServiceEngagementID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceBillingLine">
            <mxGeometry x="0" y="124.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceBillingLine__SalesInvoiceLineID" label="SalesInvoiceLineID (FK)" fieldName="SalesInvoiceLineID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceBillingLine">
            <mxGeometry x="0" y="154.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceBillingLine__BillingPeriodStartDate" label="BillingPeriodStartDate" fieldName="BillingPeriodStartDate">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceBillingLine">
            <mxGeometry x="0" y="184.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="ServiceBillingLine__BillingPeriodEndDate" label="BillingPeriodEndDate" fieldName="BillingPeriodEndDate">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="ServiceBillingLine">
            <mxGeometry x="0" y="214.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesOrderLine" label="SalesOrderLine&#10;Shared reference" tableName="SalesOrderLine" primaryHome="false">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=65;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#f0f1f3;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="410" y="610" width="330" height="207.0" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesOrderLine__grain" label="One ordered item or service line" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesOrderLine">
            <mxGeometry x="0" y="65.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesOrderLine__SalesOrderLineID" label="SalesOrderLineID (PK)" fieldName="SalesOrderLineID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesOrderLine">
            <mxGeometry x="0" y="117.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesOrderLine__SalesOrderID" label="SalesOrderID (FK)" fieldName="SalesOrderID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesOrderLine">
            <mxGeometry x="0" y="147.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesOrderLine__ItemID" label="ItemID (FK)" fieldName="ItemID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesOrderLine">
            <mxGeometry x="0" y="177.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesInvoiceLine" label="SalesInvoiceLine&#10;Shared reference" tableName="SalesInvoiceLine" primaryHome="false">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=65;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#f0f1f3;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="795" y="610" width="330" height="237.0" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesInvoiceLine__grain" label="One billed goods or service line" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesInvoiceLine">
            <mxGeometry x="0" y="65.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesInvoiceLine__SalesInvoiceLineID" label="SalesInvoiceLineID (PK)" fieldName="SalesInvoiceLineID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesInvoiceLine">
            <mxGeometry x="0" y="117.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesInvoiceLine__SalesInvoiceID" label="SalesInvoiceID (FK)" fieldName="SalesInvoiceID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesInvoiceLine">
            <mxGeometry x="0" y="147.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesInvoiceLine__ShipmentLineID" label="ShipmentLineID (FK)" fieldName="ShipmentLineID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesInvoiceLine">
            <mxGeometry x="0" y="177.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesInvoiceLine__SalesOrderLineID" label="SalesOrderLineID (FK)" fieldName="SalesOrderLineID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesInvoiceLine">
            <mxGeometry x="0" y="207.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="r1" label="r1" relationKind="reference" childTable="ServiceEngagement" childFields="SalesOrderLineID" parentTable="SalesOrderLine" parentFields="SalesOrderLineID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=0;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="SalesOrderLine__SalesOrderLineID" target="ServiceEngagement__SalesOrderLineID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="386.0" y="742.0" />
                <mxPoint x="386.0" y="408.0" />
                <mxPoint x="1.0" y="408.0" />
                <mxPoint x="1.0" y="309.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r2" label="r2" relationKind="reference" childTable="ServiceEngagementAssignment" childFields="ServiceEngagementID" parentTable="ServiceEngagement" parentFields="ServiceEngagementID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="ServiceEngagement__ServiceEngagementID" target="ServiceEngagementAssignment__ServiceEngagementID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="379.0" y="279.0" />
                <mxPoint x="379.0" y="329.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r3" label="r3" relationKind="reference" childTable="ServiceTimeEntry" childFields="ServiceEngagementAssignmentID" parentTable="ServiceEngagementAssignment" parentFields="ServiceEngagementAssignmentID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="ServiceEngagementAssignment__ServiceEngagementAssignmentID" target="ServiceTimeEntry__ServiceEngagementAssignmentID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="764.0" y="289.0" />
                <mxPoint x="764.0" y="319.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r4" label="r4" relationKind="reference" childTable="ServiceBillingLine" childFields="ServiceEngagementID" parentTable="ServiceEngagement" parentFields="ServiceEngagementID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=0;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="ServiceEngagement__ServiceEngagementID" target="ServiceBillingLine__ServiceEngagementID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="-45.0" y="279.0" />
                <mxPoint x="-45.0" y="749.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r5" label="r5" relationKind="reference" childTable="ServiceBillingLine" childFields="SalesInvoiceLineID" parentTable="SalesInvoiceLine" parentFields="SalesInvoiceLineID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="SalesInvoiceLine__SalesInvoiceLineID" target="ServiceBillingLine__SalesInvoiceLineID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="1149.0" y="742.0" />
                <mxPoint x="1149.0" y="871.0" />
                <mxPoint x="1.0" y="871.0" />
                <mxPoint x="1.0" y="779.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r6" label="r6" relationKind="aggregate" childTable="ServiceTimeEntry" childFields="ServiceEngagementID,WorkDate" parentTable="ServiceBillingLine" parentFields="ServiceEngagementID,BillingPeriodStartDate" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=none;endArrow=open;endFill=1;dashed=1;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="ServiceBillingLine__ServiceEngagementID" target="ServiceTimeEntry__ServiceEngagementID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="379.0" y="749.0" />
                <mxPoint x="379.0" y="841.0" />
                <mxPoint x="771.0" y="841.0" />
                <mxPoint x="771.0" y="359.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="footer" label="(PK) = primary key. (FK) = foreign key.&#10;Solid crow’s-foot lines show foreign-key relationships; dashed labeled lines show conditional traces or analytical matches. See r1, r2… in the relationship table.">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=17;fontStyle=0;" vertex="1" parent="1">
            <mxGeometry x="25" y="903.0" width="1110" height="60" as="geometry" />
          </mxCell>
        </object>
      </root>
    </mxGraphModel>
  </diagram>
</mxfile>
