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     <foreign-key foreignTable="Address" phpName="Address" refPhpName="Hub">
  97       <reference local="address_id" foreign="id"/>
  98     </foreign-key>
  99   </table>
 100
 101   <!-- Donation -->
 102   <table name="Donation" phpName="Donation" baseClass="ReadifoodObject">
 103     <vendor type="mysql">
 104       <parameter name="Engine" value="InnoDB"/>
 105       <parameter name="Charset" value="utf8"/>
 106     </vendor>
 107     <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
 108     <column name="date" type="date" required="true"/>
 109     <column name="contact_id" type="integer" required="true"/>
 110     <column name="hub_id" type="integer" required="true"/>
 111     <column name="quantity" type="integer" required="true"/>
 112     <foreign-key foreignTable="Contact" phpName="Contact" refPhpName="Donation">
 113       <reference local="contact_id" foreign="id"/>
 114     </foreign-key>
 115     <foreign-key foreignTable="Hub" phpName="Hub" refPhpName="Donation">
 116       <reference local="hub_id" foreign="id"/>
 117     </foreign-key>
 118   </table>
 119
 120   <!-- Order -->
 121   <table name="FoodOrder" phpName="Order" baseClass="ReadifoodObject">
 122     <vendor type="mysql">
 123       <parameter name="Engine" value="InnoDB"/>
 124       <parameter name="Charset" value="utf8"/>
 125     </vendor>
 126     <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
 127     <column name="date" type="date" required="true"/>
 128     <column name="requester_id" type="integer" required="true"/>
 129     <column name="beneficiary_id" type="integer" required="true"/>
 130     <column name="hub_id" type="integer" required="false"/>
 131     <column name="quantity" type="integer" required="true"/>
 132     <foreign-key foreignTable="Contact" phpName="Requester" refPhpName="Requester">
 133       <reference local="requester_id" foreign="id"/>
 134     </foreign-key>
 135     <foreign-key foreignTable="Contact" phpName="Beneficiary" refPhpName="Beneficiary">
 136       <reference local="beneficiary_id" foreign="id"/>
 137     </foreign-key>
 138     <foreign-key foreignTable="Hub" phpName="Hub" refPhpName="Hub">
 139       <reference local="hub_id" foreign="id"/>
 140     </foreign-key>
 141   </table>
 142
 143   <!-- Order state -->
 144   <table name="OrderState" phpName="OrderState" baseClass="ReadifoodObject">
 145     <vendor type="mysql">
 146       <parameter name="Engine" value="InnoDB"/>
 147       <parameter name="Charset" value="utf8"/>
 148     </vendor>
 149     <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
 150     <column name="updated" type="timestamp" required="true"/>
 151     <column name="order_id" type="integer" required="true"/>
 152     <column name="user_id" type="integer" required="true"/>
 153     <column name="driver_id" type="integer" required="false"/>
 154     <column name="state" type="integer" required="true"/>
 155     <foreign-key foreignTable="FoodOrder" phpName="Order" refPhpName="OrderState">
 156       <reference local="order_id" foreign="id"/>
 157     </foreign-key>
 158     <foreign-key foreignTable="User" phpName="User" refPhpName="OrderState">
 159       <reference local="user_id" foreign="id"/>
 160     </foreign-key>
 161     <foreign-key foreignTable="Contact" phpName="Driver" refPhpName="OrderState">
 162       <reference local="driver_id" foreign="id"/>
 163     </foreign-key>
 164   </table>
 165 </database>