verleihnix/Verleihnix/impl/data/schema.xml

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <database name="mkrimi" defaultIdMethod="native">
   3         <table name="medium">
   4                 <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
   5                 <column name="mod" type="integer" required="true"/>
   6                 <column name="autor" type="varchar" size="100" required="true"/>
   7                 <column name="titel" type="varchar" size="100" required="true"/>
   8                 <column name="eigentumer" type="varchar" size="100" required="true"/>
   9                 <column name="zz_bei" type="varchar" size="100" required="true"/>
  10                 <column name="kommentar" type="varchar" size="100" required="true"/>
  11                 <column name="class_key" type="integer" required="true" inheritance="single">
  12                         <inheritance key="1" class="Krimi" extends="Medium"/>
  13                         <inheritance key="2" class="Horbuch" extends="Medium"/>
  14                         <inheritance key="3" class="Roman" extends="Medium"/>
  15                 </column>
  16         </table>
  17         <table name="werkzeug">
  18                 <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
  19                 <column name="mod" type="integer" required="true"/>
  20                 <column name="typ" type="varchar" size="100" required="true"/>
  21                 <column name="beschreibung" type="varchar" size="100" required="true"/>
  22                 <column name="eigentumer" type="varchar" size="100" required="true"/>
  23                 <column name="zz_bei" type="varchar" size="100" required="true"/>
  24         </table>
  25 </database>