| <?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> |