src/main/resources/META-INF/database.xml

   1 <?xml version="1.0"?>\r
   2 \r
   3 <database name="birthmark-store">\r
   4   <table name="extracted_birthmarks" description="extracted birthmark">\r
   5     <column name="extracted_id"\r
   6             required="true"\r
   7             primaryKey="true"\r
   8             type="VARCHAR"\r
   9             size="128"\r
  10             description="stored date" />\r
  11     <column name="unit"\r
  12             required="true"\r
  13             type="VARCHAR"\r
  14             size="128"\r
  15             description="extracted unit" />\r
  16   </table>\r
  17 \r
  18   <table name="extracted_birthmark">\r
  19     <column name="extracted_id"\r
  20             required="true"\r
  21             primaryKey="true"\r
  22             type="VARCHAR"\r
  23             size="128"\r
  24             description="stored date" />\r
  25     <column name="name"\r
  26             required="true"\r
  27             primaryKey="true"\r
  28             type="VARCHAR"\r
  29             size="256"\r
  30             description="location of target" />\r
  31     <column name="location"\r
  32             required="true"\r
  33             primaryKey="true"\r
  34             type="VARCHAR"\r
  35             size="256"\r
  36             description="location of target" />\r
  37     <column name="store_target"\r
  38             required="true"\r
  39             primaryKey="true"\r
  40             type="VARCHAR"\r
  41             size="64"\r
  42             description="target_x, target_y, target_xy?" />\r
  43     <column name="type"\r
  44             required="true"\r
  45             primaryKey="true"\r
  46             type="VARCHAR"\r
  47             size="64"\r
  48             description="birthmark type name" />\r
  49     <column name="element"\r
  50             required="true"\r
  51             primaryKey="false"\r
  52             type="VARCHAR"\r
  53             size="256"\r
  54             description="birthmark element" />\r
  55     <column name="index"\r
  56             required="true"\r
  57             primaryKey="false"\r
  58             type="INTEGER"\r
  59             size="10"\r
  60             description="birthmark element order index" />\r
  61     <foreign-key foreignTable="extracted_birthmark"\r
  62       <reference local="extracted_id"\r
  63                  foreign="extracted_id" />\r
  64       <reference local="name"\r
  65                  foreign="name" />\r
  66       <reference local="location"\r
  67                  foreign="location" />\r
  68       <reference local="store_target"\r
  69                  foreign="store_target" />\r
  70     </foreign-key>\r
  71     <foreign-key foreignTable="birthmark_type"\r
  72       <reference local="type"\r
  73                  foreign="type" />\r
  74     </foreign-key>\r
  75   </table>\r
  76 \r
  77   <table name="extracted_birthmark_types">\r
  78     <column name="extracted_id"\r
  79             required="true"\r
  80             primaryKey="true"\r
  81             type="VARCHAR"\r
  82             size="128"\r
  83             description="stored date" />\r
  84     <column name="type"\r
  85             required="true"\r
  86             primaryKey="true"\r
  87             type="VARCHAR"\r
  88             size="64"\r
  89             description="birthmark type name" />\r
  90     <foreign-key foreignTable="extracted_birthmarks"\r
  91       <reference\r
  92         local="extracted_id"\r
  93         foreign="extracted_id" />\r
  94     </foreign-key>\r
  95     <foreign-key foreignTable="birthmark_type"\r
  96       <reference\r
  97         local="type"\r
  98         foreign="type" />\r
  99     </foreign-key>\r
 100   </table>\r
 101 \r
 102   <table name="birthmark_type"\r
 103          description="birthmark type">\r
 104     <column name="type"\r
 105             required="true"\r
 106             primaryKey="true"\r
 107             type="VARCHAR"\r
 108             size="64"\r
 109             description="birthmark type name" />\r
 110     <column name="display_name"\r
 111             type="VARCHAR"\r
 112             size="256" />\r
 113     <column name="description"\r
 114             type="VARCHAR"\r
 115             size="256" />\r
 116     <column name="class_name"\r
 117             type="VARCHAR"\r
 118             size="256" />\r
 119     <column name="extractor"\r
 120             type="VARCHAR"\r
 121             size="256" />\r
 122     <column name="comparator"\r
 123             type="VARCHAR"\r
 124             size="256" />\r
 125   </table>\r
 126 </database>\r