<?xml version="1.0" encoding="UTF-8" ?>
<XMLDB PATH="local/presentialtracker/db" VERSION="2025061102" COMMENT="Presential Tracker DB structure">
    <TABLES>
        <TABLE NAME="local_presentialtracker" COMMENT="Stores presential course records">
            <FIELDS>
                <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="true"/>
                <FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true"/>
                <FIELD NAME="coursename" TYPE="char" LENGTH="255" NOTNULL="true"/>
                <FIELD NAME="grade" TYPE="char" LENGTH="20" NOTNULL="false"/>
                <FIELD NAME="comments" TYPE="text" NOTNULL="false"/>
                <FIELD NAME="completiondate" TYPE="int" LENGTH="10" NOTNULL="false"/>
                <FIELD NAME="timecreated" TYPE="int" LENGTH="10" NOTNULL="true"/>
            </FIELDS>
            <KEYS>
                <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
                <KEY NAME="userfk" TYPE="foreign" FIELDS="userid" REFTABLE="user" REFFIELDS="id"/>
            </KEYS>
        </TABLE>
    </TABLES>
</XMLDB>