blob: babfa4124bc37c7fec2a7a93a4c9b8b98212ca74 [file] [log] [blame]
<?xml version="1.0" encoding="UTF-8"?>
<simplerdbms:Schema xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:simplerdbms="http://www.eclipse.org/qvtd/examples/qvtcore/UML2RDBMS/1.0/SimpleRDBMS"
xsi:schemaLocation="http://www.eclipse.org/qvtd/examples/qvtcore/UML2RDBMS/1.0/SimpleRDBMS ../SimpleRDBMS.ecore" name="People">
<tables name="Address" kind="base">
<columns name="Address_tid" type="NUMBER" keys="//@tables.0/@keys.0"/>
<columns name="street" type="VARCHAR"/>
<columns name="number" type="VARCHAR"/>
<keys name="Address_pk" kind="primary" column="//@tables.0/@columns.0"/>
</tables>
<tables name="Budget" kind="base">
<columns name="Budget_tid" type="NUMBER" keys="//@tables.1/@keys.0"/>
<columns name="year" type="VARCHAR"/>
<columns name="budget" type="NUMBER"/>
<keys name="Budget_pk" kind="primary" column="//@tables.1/@columns.0"/>
</tables>
<tables name="Professor" kind="base">
<columns name="Professor_tid" type="NUMBER" keys="//@tables.2/@keys.0"/>
<columns name="professorLivesAt_tid" type="NUMBER" foreignKeys="//@tables.2/@foreignKeys.0"/>
<columns name="professorGroup_tid" type="NUMBER" foreignKeys="//@tables.2/@foreignKeys.1"/>
<columns name="employed" type="BOOLEAN"/>
<columns name="name" type="VARCHAR"/>
<keys name="Professor_pk" kind="primary" column="//@tables.2/@columns.0"/>
<foreignKeys name="professorLivesAt" refersTo="//@tables.0/@keys.0" columns="//@tables.2/@columns.1"/>
<foreignKeys name="professorGroup" refersTo="//@tables.3/@keys.0" columns="//@tables.2/@columns.2"/>
</tables>
<tables name="ResearchGroup" kind="base">
<columns name="ResearchGroup_tid" type="NUMBER" keys="//@tables.3/@keys.0"/>
<columns name="groupBudget_tid" type="NUMBER" foreignKeys="//@tables.3/@foreignKeys.0"/>
<columns name="name" type="VARCHAR"/>
<keys name="ResearchGroup_pk" kind="primary" column="//@tables.3/@columns.0"/>
<foreignKeys name="groupBudget" refersTo="//@tables.1/@keys.0" columns="//@tables.3/@columns.1"/>
</tables>
<tables name="Student" kind="base">
<columns name="Student_tid" type="NUMBER" keys="//@tables.4/@keys.0"/>
<columns name="studentTimetable_tid" type="NUMBER" foreignKeys="//@tables.4/@foreignKeys.0"/>
<columns name="guardian" type="VARCHAR"/>
<columns name="name" type="VARCHAR"/>
<columns name="studentNumber" type="NUMBER"/>
<keys name="Student_pk" kind="primary" column="//@tables.4/@columns.0"/>
<foreignKeys name="studentTimetable" refersTo="//@tables.5/@keys.0" columns="//@tables.4/@columns.1"/>
</tables>
<tables name="Timetable" kind="base">
<columns name="Timetable_tid" type="NUMBER" keys="//@tables.5/@keys.0"/>
<columns name="year" type="VARCHAR"/>
<keys name="Timetable_pk" kind="primary" column="//@tables.5/@columns.0"/>
</tables>
</simplerdbms:Schema>