propel/schema.xml

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <database name="readifood" defaultIdMethod="native">
   3   <!-- City -->
   4   <table name="City" phpName="City" baseClass="ReadifoodObject">
   5     <vendor type="mysql">
   6       <parameter name="Engine" value="InnoDB"/>
   7       <parameter name="Charset" value="utf8"/>
   8     </vendor>
   9     <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
  10     <column name="name" type="varchar" size="64" required="true"/>
  11     <column name="postcode_area" type="varchar" size="4" required="true"/>
  12     <unique name="postcode">
  13       <unique-column name="name"/>
  14       <unique-column name="postcode_area"/>
  15     </unique>
  16   </table>
  17
  18   <!-- Area or neighbourhood -->
  19   <table name="Area" phpName="Area" baseClass="ReadifoodObject">
  20     <vendor type="mysql">
  21       <parameter name="Engine" value="InnoDB"/>
  22       <parameter name="Charset" value="utf8"/>
  23     </vendor>
  24     <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
  25     <column name="city_id" type="integer" required="true"/>
  26     <column name="name" type="varchar" size="64" required="true"/>
  27     <column name="days" type="integer" required="true"/>
  28     <foreign-key foreignTable="City" phpName="City" refPhpName="Area">
  29       <reference local="city_id" foreign="id"/>
  30     </foreign-key>
  31   </table>
  32
  33   <!-- Address -->
  34   <table name="Address" phpName="Address" baseClass="ReadifoodObject">
  35     <vendor type="mysql">
  36       <parameter name="Engine" value="InnoDB"/>
  37       <parameter name="Charset" value="utf8"/>
  38     </vendor>
  39     <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
  40     <column name="area_id" type="integer" required="true"/>
  41     <column name="line" type="varchar" size="128" required="true"/>
  42     <column name="postcode" type="varchar" size="16" required="true"/>
  43     <foreign-key foreignTable="Area" phpName="Area" refPhpName="Address">
  44       <reference local="area_id" foreign="id"/>
  45     </foreign-key>
  46   </table>
  47
  48   <!-- Contact -->
  49   <table name="Contact" phpName="Contact" baseClass="ReadifoodObject">
  50     <vendor type="mysql">
  51       <parameter name="Engine" value="InnoDB"/>
  52       <parameter name="Charset" value="utf8"/>
  53     </vendor>
  54     <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
  55     <column name="address_id" type="integer" required="true"/>
  56     <column name="forename" type="varchar" size="64" required="true"/>
  57     <column name="middle" type="varchar" size="128" required="true"/>
  58     <column name="surname" type="varchar" size="64" required="true"/>
  59     <column name="displayname" type="varchar" size="256" required="true"/>
  60     <column name="role" type="integer" required="true"/>
  61     <column name="telephone1" type="varchar" size="32" required="true"/>
  62     <column name="telephone2" type="varchar" size="32" required="true"/>
  63     <column name="email" type="varchar" size="64" required="true"/>
  64     <foreign-key foreignTable="Address" phpName="Address" refPhpName="Contact">
  65       <reference local="address_id" foreign="id"/>
  66     </foreign-key>
  67   </table>
  68
  69   <!-- User -->
  70   <table name="User" phpName="User" baseClass="ReadifoodObject">
  71     <vendor type="mysql">
  72       <parameter name="Engine" value="InnoDB"/>
  73       <parameter name="Charset" value="utf8"/>
  74     </vendor>
  75     <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
  76     <column name="contact_id" type="integer" required="true"/>
  77     <column name="username" type="varchar" size="64" required="true"/>
  78     <column name="admin" type="integer" required="true"/>
  79     <foreign-key foreignTable="Contact" phpName="Contact" refPhpName="User">
  80       <reference local="contact_id" foreign="id"/>
  81     </foreign-key>
  82   </table>
  83
  84   <!-- Hub -->
  85   <table name="Hub" phpName="Hub" baseClass="ReadifoodObject">
  86     <vendor type="mysql">
  87       <parameter name="Engine" value="InnoDB"/>
  88       <parameter name="Charset" value="utf8"/>
  89     </vendor>
  90     <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
  91     <column name="address_id" type="integer" required="true"/>
  92     <column name="displayname" type="varchar" size="256" required="true"/>
  93     <column name="telephone1" type="varchar" size="32" required="true"/>
  94     <column name="telephone2" type="varchar" size="32" required="true"/>
  95     <column name="email" type="varchar" size="64" required="true"/>
  96     <column name="role" type="integer" required="true"/>
  97     <foreign-key foreignTable="Address" phpName="Address" refPhpName="Hub">
  98       <reference local="address_id" foreign="id"/>
  99     </foreign-key>
 100   </table>
 101
 102   <!-- Donation -->
 103   <table name="Donation" phpName="Donation" baseClass="ReadifoodObject">
 104     <vendor type="mysql">
 105       <parameter name="Engine" value="InnoDB"/>
 106       <parameter name="Charset" value="utf8"/>
 107     </vendor>
 108     <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
 109     <column name="date" type="date" required="true"/>
 110     <column name="contact_id" type="integer" required="true"/>
 111     <column name="hub_id" type="integer" required="true"/>
 112     <column name="quantity" type="integer" required="true"/>
 113     <foreign-key foreignTable="Contact" phpName="Contact" refPhpName="Donation">
 114       <reference local="contact_id" foreign="id"/>
 115     </foreign-key>
 116     <foreign-key foreignTable="Hub" phpName="Hub" refPhpName="Donation">
 117       <reference local="hub_id" foreign="id"/>
 118     </foreign-key>
 119   </table>
 120
 121   <!-- Order -->
 122   <table name="FoodOrder" phpName="Order" baseClass="ReadifoodObject">
 123     <vendor type="mysql">
 124       <parameter name="Engine" value="InnoDB"/>
 125       <parameter name="Charset" value="utf8"/>
 126     </vendor>
 127     <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
 128     <column name="date" type="date" required="true"/>
 129     <column name="requester_id" type="integer" required="true"/>
 130     <column name="beneficiary_id" type="integer" required="true"/>
 131     <column name="hub_id" type="integer" required="false"/>
 132     <column name="quantity" type="integer" required="true"/>
 133     <foreign-key foreignTable="Contact" phpName="Requester" refPhpName="Requester">
 134       <reference local="requester_id" foreign="id"/>
 135     </foreign-key>
 136     <foreign-key foreignTable="Contact" phpName="Beneficiary" refPhpName="Beneficiary">
 137       <reference local="beneficiary_id" foreign="id"/>
 138     </foreign-key>
 139     <foreign-key foreignTable="Hub" phpName="Hub" refPhpName="Hub">
 140       <reference local="hub_id" foreign="id"/>
 141     </foreign-key>
 142   </table>
 143
 144   <!-- Order state -->
 145   <table name="OrderState" phpName="OrderState" baseClass="ReadifoodObject">
 146     <vendor type="mysql">
 147       <parameter name="Engine" value="InnoDB"/>
 148       <parameter name="Charset" value="utf8"/>
 149     </vendor>
 150     <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
 151     <column name="updated" type="timestamp" required="true"/>
 152     <column name="order_id" type="integer" required="true"/>
 153     <column name="user_id" type="integer" required="true"/>
 154     <column name="driver_id" type="integer" required="false"/>
 155     <column name="state" type="integer" required="true"/>
 156     <foreign-key foreignTable="FoodOrder" phpName="Order" refPhpName="OrderState">
 157       <reference local="order_id" foreign="id"/>
 158     </foreign-key>
 159     <foreign-key foreignTable="User" phpName="User" refPhpName="OrderState">
 160       <reference local="user_id" foreign="id"/>
 161     </foreign-key>
 162     <foreign-key foreignTable="Contact" phpName="Driver" refPhpName="OrderState">
 163       <reference local="driver_id" foreign="id"/>
 164     </foreign-key>
 165   </table>
 166 </database>