blob: fa83ce58789acac5670bf12e06a74e0707cefb65 [file] [log] [blame]
<?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>