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     <column name="notes" type="longvarchar" lazyLoad="true"/>
  65     <foreign-key foreignTable="Address" phpName="Address" refPhpName="Contact">
  66       <reference local="address_id" foreign="id"/>
  67     </foreign-key>
  68   </table>
  69
  70   <!-- User -->
  71   <table name="User" phpName="User" baseClass="ReadifoodObject">
  72     <vendor type="mysql">
  73       <parameter name="Engine" value="InnoDB"/>
  74       <parameter name="Charset" value="utf8"/>
  75     </vendor>
  76     <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
  77     <column name="contact_id" type="integer" required="true"/>
  78     <column name="username" type="varchar" size="64" required="true"/>
  79     <column name="admin" type="integer" required="true"/>
  80     <foreign-key foreignTable="Contact" phpName="Contact" refPhpName="User">
  81       <reference local="contact_id" foreign="id"/>
  82     </foreign-key>
  83   </table>
  84
  85   <!-- Hub -->
  86   <table name="Hub" phpName="Hub" baseClass="ReadifoodObject">
  87     <vendor type="mysql">
  88       <parameter name="Engine" value="InnoDB"/>
  89       <parameter name="Charset" value="utf8"/>
  90     </vendor>
  91     <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
  92     <column name="address_id" type="integer" required="true"/>
  93     <column name="displayname" type="varchar" size="256" required="true"/>
  94     <column name="telephone1" type="varchar" size="32" required="true"/>
  95     <column name="telephone2" type="varchar" size="32" required="true"/>
  96     <column name="email" type="varchar" size="64" required="true"/>
  97     <column name="role" type="integer" required="true"/>
  98     <foreign-key foreignTable="Address" phpName="Address" refPhpName="Hub">
  99       <reference local="address_id" foreign="id"/>
 100     </foreign-key>
 101   </table>
 102
 103   <!-- Donation -->
 104   <table name="Donation" phpName="Donation" baseClass="ReadifoodObject">
 105     <vendor type="mysql">
 106       <parameter name="Engine" value="InnoDB"/>
 107       <parameter name="Charset" value="utf8"/>
 108     </vendor>
 109     <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
 110     <column name="date" type="date" required="true"/>
 111     <column name="contact_id" type="integer" required="true"/>
 112     <column name="hub_id" type="integer" required="true"/>
 113     <column name="quantity" type="integer" required="true"/>
 114     <foreign-key foreignTable="Contact" phpName="Contact" refPhpName="Donation">
 115       <reference local="contact_id" foreign="id"/>
 116     </foreign-key>
 117     <foreign-key foreignTable="Hub" phpName="Hub" refPhpName="Donation">
 118       <reference local="hub_id" foreign="id"/>
 119     </foreign-key>
 120   </table>
 121
 122   <!-- Order -->
 123   <table name="FoodOrder" phpName="Order" baseClass="ReadifoodObject">
 124     <vendor type="mysql">
 125       <parameter name="Engine" value="InnoDB"/>
 126       <parameter name="Charset" value="utf8"/>
 127     </vendor>
 128     <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
 129     <column name="date" type="date" required="true"/>
 130     <column name="requester_id" type="integer" required="true"/>
 131     <column name="beneficiary_id" type="integer" required="true"/>
 132     <column name="hub_id" type="integer" required="false"/>
 133     <column name="quantity" type="integer" required="true"/>
 134     <foreign-key foreignTable="Contact" phpName="Requester" refPhpName="Requester">
 135       <reference local="requester_id" foreign="id"/>
 136     </foreign-key>
 137     <foreign-key foreignTable="Contact" phpName="Beneficiary" refPhpName="Beneficiary">
 138       <reference local="beneficiary_id" foreign="id"/>
 139     </foreign-key>
 140     <foreign-key foreignTable="Hub" phpName="Hub" refPhpName="Hub">
 141       <reference local="hub_id" foreign="id"/>
 142     </foreign-key>
 143   </table>
 144
 145   <!-- Order state -->
 146   <table name="OrderState" phpName="OrderState" baseClass="ReadifoodObject">
 147     <vendor type="mysql">
 148       <parameter name="Engine" value="InnoDB"/>
 149       <parameter name="Charset" value="utf8"/>
 150     </vendor>
 151     <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
 152     <column name="updated" type="timestamp" required="true"/>
 153     <column name="order_id" type="integer" required="true"/>
 154     <column name="user_id" type="integer" required="true"/>
 155     <column name="driver_id" type="integer" required="false"/>
 156     <column name="state" type="integer" required="true"/>
 157     <foreign-key foreignTable="FoodOrder" phpName="Order" refPhpName="OrderState">
 158       <reference local="order_id" foreign="id"/>
 159     </foreign-key>
 160     <foreign-key foreignTable="User" phpName="User" refPhpName="OrderState">
 161       <reference local="user_id" foreign="contact_id"/>
 162     </foreign-key>
 163     <foreign-key foreignTable="Contact" phpName="Driver" refPhpName="OrderState">
 164       <reference local="driver_id" foreign="id"/>
 165     </foreign-key>
 166   </table>
 167 </database>