<?xml version="1.0" encoding="ASCII"?> | |
<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/test/compiler/0.1/SimpleRDBMS" | |
xsi:schemaLocation="http://www.eclipse.org/qvtd/test/compiler/0.1/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="name" | |
type="VARCHAR"/> | |
<columns | |
name="employed" | |
type="BOOLEAN"/> | |
<columns | |
name="professorLivesAt_tid" | |
type="NUMBER" | |
foreignKeys="//@tables.2/@foreignKeys.0"/> | |
<columns | |
name="professorGroup_tid" | |
type="NUMBER" | |
foreignKeys="//@tables.2/@foreignKeys.1"/> | |
<keys name="Professor_pk" | |
kind="primary" | |
column="//@tables.2/@columns.0"/> | |
<foreignKeys | |
name="professorLivesAt" | |
refersTo="//@tables.0/@keys.0" | |
columns="//@tables.2/@columns.3"/> | |
<foreignKeys | |
name="professorGroup" | |
refersTo="//@tables.3/@keys.0" | |
columns="//@tables.2/@columns.4"/> | |
</tables> | |
<tables name="ResearchGroup" | |
kind="base"> | |
<columns | |
name="ResearchGroup_tid" | |
type="NUMBER" | |
keys="//@tables.3/@keys.0"/> | |
<columns | |
name="name" | |
type="VARCHAR"/> | |
<columns | |
name="groupBudget_tid" | |
type="NUMBER" | |
foreignKeys="//@tables.3/@foreignKeys.0"/> | |
<keys name="ResearchGroup_pk" | |
kind="primary" | |
column="//@tables.3/@columns.0"/> | |
<foreignKeys | |
name="groupBudget" | |
refersTo="//@tables.1/@keys.0" | |
columns="//@tables.3/@columns.2"/> | |
</tables> | |
<tables name="Student" | |
kind="base"> | |
<columns | |
name="Student_tid" | |
type="NUMBER" | |
keys="//@tables.4/@keys.0"/> | |
<columns | |
name="guardian" | |
type="VARCHAR"/> | |
<columns | |
name="name" | |
type="VARCHAR"/> | |
<columns | |
name="studentNumber" | |
type="NUMBER"/> | |
<columns | |
name="studentTimetable_tid" | |
type="NUMBER" | |
foreignKeys="//@tables.4/@foreignKeys.0"/> | |
<keys name="Student_pk" | |
kind="primary" | |
column="//@tables.4/@columns.0"/> | |
<foreignKeys | |
name="studentTimetable" | |
refersTo="//@tables.5/@keys.0" | |
columns="//@tables.4/@columns.4"/> | |
</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> |