<?xml version="1.0"?><?xml-stylesheet type="text/xsl" href="../../tools/Documentation.xsl" ?><ns2:sqlResourceMetaData resName="healthok.MemberMedicalConditionFull" hierarchical="true" multipleDatabases="false" xmlns:ns2="http://restsql.org/schema">
    <tables>
        <table databaseName="healthok" tableName="Member" qualifiedTableName="healthok.Member" rowAlias="Member" rowSetAlias="Members" tableRole="Parent">
            <columns>
                <column columnLabel="BloodGroup" columnName="BloodGroup" columnNumber="3" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.BloodGroup" qualifiedColumnName="Member.BloodGroup" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="Sex" columnName="Sex" columnNumber="7" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.Sex" qualifiedColumnName="Member.Sex" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="AadharNumber" columnName="AadharNumber" columnNumber="17" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.AadharNumber" qualifiedColumnName="Member.AadharNumber" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="MemberImageId" columnName="MemberImageId" columnNumber="20" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.MemberImageId" qualifiedColumnName="Member.MemberImageId" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="LastSpokenTo" columnName="LastSpokenTo" columnNumber="25" columnType="-1" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.LastSpokenTo" qualifiedColumnName="Member.LastSpokenTo" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="MemberId" columnName="MemberId" columnNumber="1" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="true" qualifiedColumnLabel="Member.MemberId" qualifiedColumnName="Member.MemberId" qualifiedTableName="healthok.Member" readOnly="false" sequence="true" sequenceName="Member" tableName="Member"/>
                <column columnLabel="DOB" columnName="DOB" columnNumber="13" columnType="91" columnTypeName="DATE" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.DOB" qualifiedColumnName="Member.DOB" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="ClinicalConsultantNotes" columnName="ClinicalConsultantNotes" columnNumber="21" columnType="-1" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.ClinicalConsultantNotes" qualifiedColumnName="Member.ClinicalConsultantNotes" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="MemberNumber" columnName="MemberNumber" columnNumber="2" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.MemberNumber" qualifiedColumnName="Member.MemberNumber" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="RecurringTests" columnName="RecurringTests" columnNumber="8" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.RecurringTests" qualifiedColumnName="Member.RecurringTests" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="Height" columnName="Height" columnNumber="18" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.Height" qualifiedColumnName="Member.Height" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="Age" columnName="Age" columnNumber="10" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.Age" qualifiedColumnName="Member.Age" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="Status" columnName="Status" columnNumber="27" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.Status" qualifiedColumnName="Member.Status" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="AadhaarFrontId" columnName="AadhaarFrontId" columnNumber="23" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.AadhaarFrontId" qualifiedColumnName="Member.AadhaarFrontId" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="Comments" columnName="Comments" columnNumber="9" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.Comments" qualifiedColumnName="Member.Comments" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="FirstName" columnName="FirstName" columnNumber="11" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.FirstName" qualifiedColumnName="Member.FirstName" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="Allergies" columnName="Allergies" columnNumber="4" columnType="-1" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.Allergies" qualifiedColumnName="Member.Allergies" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="Weight" columnName="Weight" columnNumber="19" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.Weight" qualifiedColumnName="Member.Weight" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="CurrentMedications" columnName="CurrentMedications" columnNumber="5" columnType="-1" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.CurrentMedications" qualifiedColumnName="Member.CurrentMedications" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="LongTermCareNeeds" columnName="LongTermCareNeeds" columnNumber="14" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.LongTermCareNeeds" qualifiedColumnName="Member.LongTermCareNeeds" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="eConsent" columnName="eConsent" columnNumber="22" columnType="-7" columnTypeName="TINYINT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.eConsent" qualifiedColumnName="Member.eConsent" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="UserId" columnName="UserId" columnNumber="6" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.UserId" qualifiedColumnName="Member.UserId" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="CalculatedDateOfBirth" columnName="CalculatedDateOfBirth" columnNumber="16" columnType="91" columnTypeName="DATE" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.CalculatedDateOfBirth" qualifiedColumnName="Member.CalculatedDateOfBirth" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="LastName" columnName="LastName" columnNumber="12" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.LastName" qualifiedColumnName="Member.LastName" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="IsSelf" columnName="IsSelf" columnNumber="15" columnType="-7" columnTypeName="TINYINT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.IsSelf" qualifiedColumnName="Member.IsSelf" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="AadhaarBackId" columnName="AadhaarBackId" columnNumber="24" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.AadhaarBackId" qualifiedColumnName="Member.AadhaarBackId" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
                <column columnLabel="LanguageId" columnName="LanguageId" columnNumber="26" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="Member.LanguageId" qualifiedColumnName="Member.LanguageId" qualifiedTableName="healthok.Member" readOnly="false" sequence="false" tableName="Member"/>
            </columns>
            <primaryKeys>
                <column>Member.MemberId</column>
            </primaryKeys>
        </table>
        <table databaseName="healthok" tableName="MemberMedicalCondition" qualifiedTableName="healthok.MemberMedicalCondition" rowAlias="MemberMedicalCondition" rowSetAlias="MemberMedicalConditions" tableRole="Child">
            <columns>
                <column columnLabel="MemberId" columnName="MemberId" columnNumber="0" columnType="0" columnTypeName="int" databaseName="healthok" nonqueriedForeignKey="true" primaryKey="false" qualifiedColumnLabel="MemberMedicalCondition.MemberId" qualifiedColumnName="MemberMedicalCondition.MemberId" qualifiedTableName="healthok.MemberMedicalCondition" readOnly="false" sequence="false" tableName="MemberMedicalCondition"/>
                <column columnLabel="MedicalConditionTypeId" columnName="MedicalConditionTypeId" columnNumber="28" columnType="4" columnTypeName="INT" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="MemberMedicalCondition.MedicalConditionTypeId" qualifiedColumnName="MemberMedicalCondition.MedicalConditionTypeId" qualifiedTableName="healthok.MemberMedicalCondition" readOnly="false" sequence="false" tableName="MemberMedicalCondition"/>
            </columns>
            <primaryKeys/>
        </table>
        <table databaseName="healthok" tableName="MedicalConditionType" qualifiedTableName="healthok.MedicalConditionType" rowAlias="MedicalConditionType" rowSetAlias="MedicalConditionTypes" tableRole="ChildExtension">
            <columns>
                <column columnLabel="MedicalConditionCode" columnName="MedicalConditionCode" columnNumber="29" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="MedicalConditionType.MedicalConditionCode" qualifiedColumnName="MedicalConditionType.MedicalConditionCode" qualifiedTableName="healthok.MedicalConditionType" readOnly="false" sequence="false" tableName="MedicalConditionType"/>
                <column columnLabel="MedicalConditionDescription" columnName="MedicalConditionDescription" columnNumber="30" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="MedicalConditionType.MedicalConditionDescription" qualifiedColumnName="MedicalConditionType.MedicalConditionDescription" qualifiedTableName="healthok.MedicalConditionType" readOnly="false" sequence="false" tableName="MedicalConditionType"/>
            </columns>
            <primaryKeys/>
        </table>
    </tables>
    <parentTable>healthok.Member</parentTable>
    <childTable>healthok.MemberMedicalCondition</childTable>
    <parentPlusExtTables>
        <table>healthok.Member</table>
    </parentPlusExtTables>
    <childPlusExtTables>
        <table>healthok.MemberMedicalCondition</table>
        <table>healthok.MedicalConditionType</table>
    </childPlusExtTables>
    <allReadColumns>
        <column>Member.MemberId</column>
        <column>Member.MemberNumber</column>
        <column>Member.BloodGroup</column>
        <column>Member.Allergies</column>
        <column>Member.CurrentMedications</column>
        <column>Member.UserId</column>
        <column>Member.Sex</column>
        <column>Member.RecurringTests</column>
        <column>Member.Comments</column>
        <column>Member.Age</column>
        <column>Member.FirstName</column>
        <column>Member.LastName</column>
        <column>Member.DOB</column>
        <column>Member.LongTermCareNeeds</column>
        <column>Member.IsSelf</column>
        <column>Member.CalculatedDateOfBirth</column>
        <column>Member.AadharNumber</column>
        <column>Member.Height</column>
        <column>Member.Weight</column>
        <column>Member.MemberImageId</column>
        <column>Member.ClinicalConsultantNotes</column>
        <column>Member.eConsent</column>
        <column>Member.AadhaarFrontId</column>
        <column>Member.AadhaarBackId</column>
        <column>Member.LastSpokenTo</column>
        <column>Member.LanguageId</column>
        <column>Member.Status</column>
        <column>MemberMedicalCondition.MedicalConditionTypeId</column>
        <column>MedicalConditionType.MedicalConditionCode</column>
        <column>MedicalConditionType.MedicalConditionDescription</column>
    </allReadColumns>
    <parentReadColumns>
        <column>Member.MemberId</column>
        <column>Member.MemberNumber</column>
        <column>Member.BloodGroup</column>
        <column>Member.Allergies</column>
        <column>Member.CurrentMedications</column>
        <column>Member.UserId</column>
        <column>Member.Sex</column>
        <column>Member.RecurringTests</column>
        <column>Member.Comments</column>
        <column>Member.Age</column>
        <column>Member.FirstName</column>
        <column>Member.LastName</column>
        <column>Member.DOB</column>
        <column>Member.LongTermCareNeeds</column>
        <column>Member.IsSelf</column>
        <column>Member.CalculatedDateOfBirth</column>
        <column>Member.AadharNumber</column>
        <column>Member.Height</column>
        <column>Member.Weight</column>
        <column>Member.MemberImageId</column>
        <column>Member.ClinicalConsultantNotes</column>
        <column>Member.eConsent</column>
        <column>Member.AadhaarFrontId</column>
        <column>Member.AadhaarBackId</column>
        <column>Member.LastSpokenTo</column>
        <column>Member.LanguageId</column>
        <column>Member.Status</column>
    </parentReadColumns>
    <childReadColumns>
        <column>MemberMedicalCondition.MedicalConditionTypeId</column>
        <column>MedicalConditionType.MedicalConditionCode</column>
        <column>MedicalConditionType.MedicalConditionDescription</column>
    </childReadColumns>
</ns2:sqlResourceMetaData>