<?xml version="1.0"?><?xml-stylesheet type="text/xsl" href="../../tools/Documentation.xsl" ?><ns2:sqlResourceMetaData resName="healthok.DoctorAppointment" hierarchical="false" multipleDatabases="false" xmlns:ns2="http://restsql.org/schema">
    <tables>
        <table databaseName="healthok" tableName="DoctorAppointment" qualifiedTableName="healthok.DoctorAppointment" rowAlias="DoctorAppointment" rowSetAlias="DoctorAppointments" tableRole="Parent">
            <columns>
                <column columnLabel="ApptDays" columnName="ApptDays" columnNumber="6" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.ApptDays" qualifiedColumnName="DoctorAppointment.ApptDays" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="referralReason" columnName="referralReason" columnNumber="29" columnType="-1" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.referralReason" qualifiedColumnName="DoctorAppointment.referralReason" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="Description" columnName="Description" columnNumber="9" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.Description" qualifiedColumnName="DoctorAppointment.Description" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="VCEndTime" columnName="VCEndTime" columnNumber="31" columnType="93" columnTypeName="DATETIME" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.VCEndTime" qualifiedColumnName="DoctorAppointment.VCEndTime" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="IsConfirmed" columnName="IsConfirmed" columnNumber="17" columnType="-6" columnTypeName="TINYINT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.IsConfirmed" qualifiedColumnName="DoctorAppointment.IsConfirmed" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="PrescriptionImageId" columnName="PrescriptionImageId" columnNumber="26" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.PrescriptionImageId" qualifiedColumnName="DoctorAppointment.PrescriptionImageId" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="PatientHistory" columnName="PatientHistory" columnNumber="23" columnType="-1" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.PatientHistory" qualifiedColumnName="DoctorAppointment.PatientHistory" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="LastSpokenTo" columnName="LastSpokenTo" columnNumber="20" columnType="-1" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.LastSpokenTo" qualifiedColumnName="DoctorAppointment.LastSpokenTo" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="DoctorId" columnName="DoctorId" columnNumber="13" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.DoctorId" qualifiedColumnName="DoctorAppointment.DoctorId" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="LabFinding" columnName="LabFinding" columnNumber="19" columnType="-1" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.LabFinding" qualifiedColumnName="DoctorAppointment.LabFinding" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="DoctorDailyScheduleId" columnName="DoctorDailyScheduleId" columnNumber="12" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.DoctorDailyScheduleId" qualifiedColumnName="DoctorAppointment.DoctorDailyScheduleId" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="PatientAppointmentLink" columnName="PatientAppointmentLink" columnNumber="22" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.PatientAppointmentLink" qualifiedColumnName="DoctorAppointment.PatientAppointmentLink" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="apptCustomType" columnName="apptCustomType" columnNumber="4" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.apptCustomType" qualifiedColumnName="DoctorAppointment.apptCustomType" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="ApptStatusId" columnName="ApptStatusId" columnNumber="7" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.ApptStatusId" qualifiedColumnName="DoctorAppointment.ApptStatusId" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="AmountReceived" columnName="AmountReceived" columnNumber="1" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.AmountReceived" qualifiedColumnName="DoctorAppointment.AmountReceived" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="DoctorAppointmentId" columnName="DoctorAppointmentId" columnNumber="10" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="true" qualifiedColumnLabel="DoctorAppointment.DoctorAppointmentId" qualifiedColumnName="DoctorAppointment.DoctorAppointmentId" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="true" sequenceName="DoctorAppointment" tableName="DoctorAppointment"/>
                <column columnLabel="Comments" columnName="Comments" columnNumber="8" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.Comments" qualifiedColumnName="DoctorAppointment.Comments" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="FollowDate" columnName="FollowDate" columnNumber="15" columnType="91" columnTypeName="DATE" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.FollowDate" qualifiedColumnName="DoctorAppointment.FollowDate" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="PrescriptionId" columnName="PrescriptionId" columnNumber="24" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.PrescriptionId" qualifiedColumnName="DoctorAppointment.PrescriptionId" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="ApptDate" columnName="ApptDate" columnNumber="5" columnType="91" columnTypeName="DATE" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.ApptDate" qualifiedColumnName="DoctorAppointment.ApptDate" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="OrderId" columnName="OrderId" columnNumber="21" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.OrderId" qualifiedColumnName="DoctorAppointment.OrderId" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="AppointmentDate" columnName="AppointmentDate" columnNumber="2" columnType="91" columnTypeName="DATE" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.AppointmentDate" qualifiedColumnName="DoctorAppointment.AppointmentDate" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="TransactionId" columnName="TransactionId" columnNumber="30" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.TransactionId" qualifiedColumnName="DoctorAppointment.TransactionId" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="FollowDays" columnName="FollowDays" columnNumber="16" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.FollowDays" qualifiedColumnName="DoctorAppointment.FollowDays" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="AppointmentType" columnName="AppointmentType" columnNumber="3" columnType="-6" columnTypeName="TINYINT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.AppointmentType" qualifiedColumnName="DoctorAppointment.AppointmentType" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="referralDoctorId" columnName="referralDoctorId" columnNumber="27" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.referralDoctorId" qualifiedColumnName="DoctorAppointment.referralDoctorId" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="eConsent" columnName="eConsent" columnNumber="14" columnType="-7" columnTypeName="TINYINT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.eConsent" qualifiedColumnName="DoctorAppointment.eConsent" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="DoctorAppointmentLink" columnName="DoctorAppointmentLink" columnNumber="11" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.DoctorAppointmentLink" qualifiedColumnName="DoctorAppointment.DoctorAppointmentLink" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="PrescriptionImageBackId" columnName="PrescriptionImageBackId" columnNumber="25" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.PrescriptionImageBackId" qualifiedColumnName="DoctorAppointment.PrescriptionImageBackId" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="VCStartTime" columnName="VCStartTime" columnNumber="32" columnType="93" columnTypeName="DATETIME" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.VCStartTime" qualifiedColumnName="DoctorAppointment.VCStartTime" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="referralDoctorName" columnName="referralDoctorName" columnNumber="28" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.referralDoctorName" qualifiedColumnName="DoctorAppointment.referralDoctorName" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
                <column columnLabel="isNewPatient" columnName="isNewPatient" columnNumber="18" columnType="-7" columnTypeName="TINYINT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="DoctorAppointment.isNewPatient" qualifiedColumnName="DoctorAppointment.isNewPatient" qualifiedTableName="healthok.DoctorAppointment" readOnly="false" sequence="false" tableName="DoctorAppointment"/>
            </columns>
            <primaryKeys>
                <column>DoctorAppointment.DoctorAppointmentId</column>
            </primaryKeys>
        </table>
    </tables>
    <parentTable>healthok.DoctorAppointment</parentTable>
    <parentPlusExtTables>
        <table>healthok.DoctorAppointment</table>
    </parentPlusExtTables>
    <childPlusExtTables/>
    <allReadColumns>
        <column>DoctorAppointment.AmountReceived</column>
        <column>DoctorAppointment.AppointmentDate</column>
        <column>DoctorAppointment.AppointmentType</column>
        <column>DoctorAppointment.apptCustomType</column>
        <column>DoctorAppointment.ApptDate</column>
        <column>DoctorAppointment.ApptDays</column>
        <column>DoctorAppointment.ApptStatusId</column>
        <column>DoctorAppointment.Comments</column>
        <column>DoctorAppointment.Description</column>
        <column>DoctorAppointment.DoctorAppointmentId</column>
        <column>DoctorAppointment.DoctorAppointmentLink</column>
        <column>DoctorAppointment.DoctorDailyScheduleId</column>
        <column>DoctorAppointment.DoctorId</column>
        <column>DoctorAppointment.eConsent</column>
        <column>DoctorAppointment.FollowDate</column>
        <column>DoctorAppointment.FollowDays</column>
        <column>DoctorAppointment.IsConfirmed</column>
        <column>DoctorAppointment.isNewPatient</column>
        <column>DoctorAppointment.LabFinding</column>
        <column>DoctorAppointment.LastSpokenTo</column>
        <column>DoctorAppointment.OrderId</column>
        <column>DoctorAppointment.PatientAppointmentLink</column>
        <column>DoctorAppointment.PatientHistory</column>
        <column>DoctorAppointment.PrescriptionId</column>
        <column>DoctorAppointment.PrescriptionImageBackId</column>
        <column>DoctorAppointment.PrescriptionImageId</column>
        <column>DoctorAppointment.referralDoctorId</column>
        <column>DoctorAppointment.referralDoctorName</column>
        <column>DoctorAppointment.referralReason</column>
        <column>DoctorAppointment.TransactionId</column>
        <column>DoctorAppointment.VCEndTime</column>
        <column>DoctorAppointment.VCStartTime</column>
    </allReadColumns>
    <parentReadColumns>
        <column>DoctorAppointment.AmountReceived</column>
        <column>DoctorAppointment.AppointmentDate</column>
        <column>DoctorAppointment.AppointmentType</column>
        <column>DoctorAppointment.apptCustomType</column>
        <column>DoctorAppointment.ApptDate</column>
        <column>DoctorAppointment.ApptDays</column>
        <column>DoctorAppointment.ApptStatusId</column>
        <column>DoctorAppointment.Comments</column>
        <column>DoctorAppointment.Description</column>
        <column>DoctorAppointment.DoctorAppointmentId</column>
        <column>DoctorAppointment.DoctorAppointmentLink</column>
        <column>DoctorAppointment.DoctorDailyScheduleId</column>
        <column>DoctorAppointment.DoctorId</column>
        <column>DoctorAppointment.eConsent</column>
        <column>DoctorAppointment.FollowDate</column>
        <column>DoctorAppointment.FollowDays</column>
        <column>DoctorAppointment.IsConfirmed</column>
        <column>DoctorAppointment.isNewPatient</column>
        <column>DoctorAppointment.LabFinding</column>
        <column>DoctorAppointment.LastSpokenTo</column>
        <column>DoctorAppointment.OrderId</column>
        <column>DoctorAppointment.PatientAppointmentLink</column>
        <column>DoctorAppointment.PatientHistory</column>
        <column>DoctorAppointment.PrescriptionId</column>
        <column>DoctorAppointment.PrescriptionImageBackId</column>
        <column>DoctorAppointment.PrescriptionImageId</column>
        <column>DoctorAppointment.referralDoctorId</column>
        <column>DoctorAppointment.referralDoctorName</column>
        <column>DoctorAppointment.referralReason</column>
        <column>DoctorAppointment.TransactionId</column>
        <column>DoctorAppointment.VCEndTime</column>
        <column>DoctorAppointment.VCStartTime</column>
    </parentReadColumns>
    <childReadColumns/>
</ns2:sqlResourceMetaData>