1 <?xml version="1.0" encoding="UTF-8"?>
2 <database name="readifood" defaultIdMethod="native">
4 <table name="City" phpName="City" baseClass="ReadifoodObject">
6 <parameter name="Engine" value="InnoDB"/>
7 <parameter name="Charset" value="utf8"/>
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"/>
18 <!-- Area or neighbourhood -->
19 <table name="Area" phpName="Area" baseClass="ReadifoodObject">
21 <parameter name="Engine" value="InnoDB"/>
22 <parameter name="Charset" value="utf8"/>
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"/>
34 <table name="Address" phpName="Address" baseClass="ReadifoodObject">
36 <parameter name="Engine" value="InnoDB"/>
37 <parameter name="Charset" value="utf8"/>
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"/>
49 <table name="Contact" phpName="Contact" baseClass="ReadifoodObject">
51 <parameter name="Engine" value="InnoDB"/>
52 <parameter name="Charset" value="utf8"/>
54 <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
55 <column name="added" type="date" required="true"/>
56 <column name="address_id" type="integer" required="true"/>
57 <column name="forename" type="varchar" size="64" required="true"/>
58 <column name="middle" type="varchar" size="128" required="true"/>
59 <column name="surname" type="varchar" size="64" required="true"/>
60 <column name="displayname" type="varchar" size="256" required="true"/>
61 <column name="role" type="integer" required="true"/>
62 <column name="telephone1" type="varchar" size="32" required="true"/>
63 <column name="telephone2" type="varchar" size="32" required="true"/>
64 <column name="email" type="varchar" size="64" required="true"/>
65 <column name="notes" type="longvarchar" lazyLoad="true"/>
66 <foreign-key foreignTable="Address" phpName="Address" refPhpName="Contact">
67 <reference local="address_id" foreign="id"/>
72 <table name="User" phpName="User" baseClass="ReadifoodObject">
74 <parameter name="Engine" value="InnoDB"/>
75 <parameter name="Charset" value="utf8"/>
77 <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
78 <column name="contact_id" type="integer" required="true"/>
79 <column name="username" type="varchar" size="64" required="true"/>
80 <column name="admin" type="integer" required="true"/>
81 <foreign-key foreignTable="Contact" phpName="Contact" refPhpName="User">
82 <reference local="contact_id" foreign="id"/>
87 <table name="Hub" phpName="Hub" baseClass="ReadifoodObject">
89 <parameter name="Engine" value="InnoDB"/>
90 <parameter name="Charset" value="utf8"/>
92 <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
93 <column name="address_id" type="integer" required="true"/>
94 <column name="displayname" type="varchar" size="256" required="true"/>
95 <column name="telephone1" type="varchar" size="32" required="true"/>
96 <column name="telephone2" type="varchar" size="32" required="true"/>
97 <column name="email" type="varchar" size="64" required="true"/>
98 <column name="role" type="integer" required="true"/>
99 <foreign-key foreignTable="Address" phpName="Address" refPhpName="Hub">
100 <reference local="address_id" foreign="id"/>
105 <table name="Donation" phpName="Donation" baseClass="ReadifoodObject">
106 <vendor type="mysql">
107 <parameter name="Engine" value="InnoDB"/>
108 <parameter name="Charset" value="utf8"/>
110 <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
111 <column name="date" type="date" required="true"/>
112 <column name="contact_id" type="integer" required="true"/>
113 <column name="hub_id" type="integer" required="true"/>
114 <column name="quantity" type="integer" required="true"/>
115 <foreign-key foreignTable="Contact" phpName="Contact" refPhpName="Donation">
116 <reference local="contact_id" foreign="id"/>
118 <foreign-key foreignTable="Hub" phpName="Hub" refPhpName="Donation">
119 <reference local="hub_id" foreign="id"/>
124 <table name="FoodOrder" phpName="Order" baseClass="ReadifoodObject">
125 <vendor type="mysql">
126 <parameter name="Engine" value="InnoDB"/>
127 <parameter name="Charset" value="utf8"/>
129 <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
130 <column name="date" type="date" required="true"/>
131 <column name="requester_id" type="integer" required="true"/>
132 <column name="beneficiary_id" type="integer" required="true"/>
133 <column name="hub_id" type="integer" required="false"/>
134 <column name="parcel" type="integer" required="true"/>
135 <foreign-key foreignTable="Contact" phpName="Requester" refPhpName="Requester">
136 <reference local="requester_id" foreign="id"/>
138 <foreign-key foreignTable="Contact" phpName="Beneficiary" refPhpName="Beneficiary">
139 <reference local="beneficiary_id" foreign="id"/>
141 <foreign-key foreignTable="Hub" phpName="Hub" refPhpName="Hub">
142 <reference local="hub_id" foreign="id"/>
147 <table name="OrderState" phpName="OrderState" baseClass="ReadifoodObject">
148 <vendor type="mysql">
149 <parameter name="Engine" value="InnoDB"/>
150 <parameter name="Charset" value="utf8"/>
152 <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
153 <column name="updated" type="timestamp" required="true"/>
154 <column name="order_id" type="integer" required="true"/>
155 <column name="user_id" type="integer" required="true"/>
156 <column name="driver_id" type="integer" required="false"/>
157 <column name="state" type="integer" required="true"/>
158 <foreign-key foreignTable="FoodOrder" phpName="Order" refPhpName="OrderState">
159 <reference local="order_id" foreign="id"/>
161 <foreign-key foreignTable="User" phpName="User" refPhpName="OrderState">
162 <reference local="user_id" foreign="contact_id"/>
164 <foreign-key foreignTable="Contact" phpName="Driver" refPhpName="OrderState">
165 <reference local="driver_id" foreign="id"/>