<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ns2:sqlResourceMetaData resName="healthok.MemberFull" hierarchical="false" 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="User" qualifiedTableName="healthok.User" rowAlias="User" rowSetAlias="Users" tableRole="ParentExtension">
            <columns>
                <column columnLabel="EmailId" columnName="EmailId" columnNumber="29" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="User.EmailId" qualifiedColumnName="User.EmailId" qualifiedTableName="healthok.User" readOnly="false" sequence="false" tableName="User"/>
                <column columnLabel="RegistrationNumber" columnName="RegistrationNumber" columnNumber="28" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="User.RegistrationNumber" qualifiedColumnName="User.RegistrationNumber" qualifiedTableName="healthok.User" readOnly="false" sequence="false" tableName="User"/>
                <column columnLabel="Mobile" columnName="Mobile" columnNumber="30" columnType="12" columnTypeName="VARCHAR" databaseName="healthok" nonqueriedForeignKey="false" primaryKey="false" qualifiedColumnLabel="User.Mobile" qualifiedColumnName="User.Mobile" qualifiedTableName="healthok.User" readOnly="false" sequence="false" tableName="User"/>
            </columns>
            <primaryKeys/>
        </table>
    </tables>
    <parentTable>healthok.Member</parentTable>
    <parentPlusExtTables>
        <table>healthok.Member</table>
        <table>healthok.User</table>
    </parentPlusExtTables>
    <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>User.RegistrationNumber</column>
        <column>User.EmailId</column>
        <column>User.Mobile</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>
        <column>User.RegistrationNumber</column>
        <column>User.EmailId</column>
        <column>User.Mobile</column>
    </parentReadColumns>
    <childReadColumns/>
</ns2:sqlResourceMetaData>
