<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ns2:sqlResourceMetaData resName="healthok.Order" hierarchical="false" multipleDatabases="false" xmlns:ns2="http://restsql.org/schema">
    <tables>
        <table databaseName="healthok" tableName="Order" qualifiedTableName="healthok.Order" rowAlias="Order" rowSetAlias="Orders" tableRole="Parent">
            <columns>
                <column columnLabel="IsDeleted" columnName="IsDeleted" columnNumber="14" columnType="-2" columnTypeName="BINARY" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Order.IsDeleted" qualifiedColumnName="Order.IsDeleted" qualifiedTableName="healthok.Order" readOnly="false" sequence="false" tableName="Order"/>
                <column columnLabel="Discount" columnName="Discount" columnNumber="9" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Order.Discount" qualifiedColumnName="Order.Discount" qualifiedTableName="healthok.Order" readOnly="false" sequence="false" tableName="Order"/>
                <column columnLabel="CashbackBonusApplied" columnName="CashbackBonusApplied" columnNumber="10" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Order.CashbackBonusApplied" qualifiedColumnName="Order.CashbackBonusApplied" qualifiedTableName="healthok.Order" readOnly="false" sequence="false" tableName="Order"/>
                <column columnLabel="OrderFulfillDate" columnName="OrderFulfillDate" columnNumber="12" columnType="91" columnTypeName="DATE" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Order.OrderFulfillDate" qualifiedColumnName="Order.OrderFulfillDate" qualifiedTableName="healthok.Order" readOnly="false" sequence="false" tableName="Order"/>
                <column columnLabel="Comments" columnName="Comments" columnNumber="7" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Order.Comments" qualifiedColumnName="Order.Comments" qualifiedTableName="healthok.Order" readOnly="false" sequence="false" tableName="Order"/>
                <column columnLabel="OrderCompletionDate" columnName="OrderCompletionDate" columnNumber="6" columnType="91" columnTypeName="DATE" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Order.OrderCompletionDate" qualifiedColumnName="Order.OrderCompletionDate" qualifiedTableName="healthok.Order" readOnly="false" sequence="false" tableName="Order"/>
                <column columnLabel="OrderId" columnName="OrderId" columnNumber="1" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="true" qualifiedColumnLabel="Order.OrderId" qualifiedColumnName="Order.OrderId" qualifiedTableName="healthok.Order" readOnly="false" sequence="true" sequenceName="Order" tableName="Order"/>
                <column columnLabel="OrderDate" columnName="OrderDate" columnNumber="4" columnType="91" columnTypeName="DATE" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Order.OrderDate" qualifiedColumnName="Order.OrderDate" qualifiedTableName="healthok.Order" readOnly="false" sequence="false" tableName="Order"/>
                <column columnLabel="TotalCost" columnName="TotalCost" columnNumber="8" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Order.TotalCost" qualifiedColumnName="Order.TotalCost" qualifiedTableName="healthok.Order" readOnly="false" sequence="false" tableName="Order"/>
                <column columnLabel="DoctorId" columnName="DoctorId" columnNumber="13" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Order.DoctorId" qualifiedColumnName="Order.DoctorId" qualifiedTableName="healthok.Order" readOnly="false" sequence="false" tableName="Order"/>
                <column columnLabel="MemberId" columnName="MemberId" columnNumber="2" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Order.MemberId" qualifiedColumnName="Order.MemberId" qualifiedTableName="healthok.Order" readOnly="false" sequence="false" tableName="Order"/>
                <column columnLabel="OrderTypeId" columnName="OrderTypeId" columnNumber="3" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Order.OrderTypeId" qualifiedColumnName="Order.OrderTypeId" qualifiedTableName="healthok.Order" readOnly="false" sequence="false" tableName="Order"/>
                <column columnLabel="NetAmount" columnName="NetAmount" columnNumber="11" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Order.NetAmount" qualifiedColumnName="Order.NetAmount" qualifiedTableName="healthok.Order" readOnly="false" sequence="false" tableName="Order"/>
                <column columnLabel="OrderStatusTypeId" columnName="OrderStatusTypeId" columnNumber="5" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Order.OrderStatusTypeId" qualifiedColumnName="Order.OrderStatusTypeId" qualifiedTableName="healthok.Order" readOnly="false" sequence="false" tableName="Order"/>
            </columns>
            <primaryKeys>
                <column>Order.OrderId</column>
            </primaryKeys>
        </table>
    </tables>
    <parentTable>healthok.Order</parentTable>
    <parentPlusExtTables>
        <table>healthok.Order</table>
    </parentPlusExtTables>
    <childPlusExtTables/>
    <allReadColumns>
        <column>Order.OrderId</column>
        <column>Order.MemberId</column>
        <column>Order.OrderTypeId</column>
        <column>Order.OrderDate</column>
        <column>Order.OrderStatusTypeId</column>
        <column>Order.OrderCompletionDate</column>
        <column>Order.Comments</column>
        <column>Order.TotalCost</column>
        <column>Order.Discount</column>
        <column>Order.CashbackBonusApplied</column>
        <column>Order.NetAmount</column>
        <column>Order.OrderFulfillDate</column>
        <column>Order.DoctorId</column>
        <column>Order.IsDeleted</column>
    </allReadColumns>
    <parentReadColumns>
        <column>Order.OrderId</column>
        <column>Order.MemberId</column>
        <column>Order.OrderTypeId</column>
        <column>Order.OrderDate</column>
        <column>Order.OrderStatusTypeId</column>
        <column>Order.OrderCompletionDate</column>
        <column>Order.Comments</column>
        <column>Order.TotalCost</column>
        <column>Order.Discount</column>
        <column>Order.CashbackBonusApplied</column>
        <column>Order.NetAmount</column>
        <column>Order.OrderFulfillDate</column>
        <column>Order.DoctorId</column>
        <column>Order.IsDeleted</column>
    </parentReadColumns>
    <childReadColumns/>
</ns2:sqlResourceMetaData>
