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="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"/>
70 <table name="User" phpName="User" baseClass="ReadifoodObject">
72 <parameter name="Engine" value="InnoDB"/>
73 <parameter name="Charset" value="utf8"/>
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"/>
85 <table name="Hub" phpName="Hub" baseClass="ReadifoodObject">
87 <parameter name="Engine" value="InnoDB"/>
88 <parameter name="Charset" value="utf8"/>
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"/>
103 <table name="Donation" phpName="Donation" baseClass="ReadifoodObject">
104 <vendor type="mysql">
105 <parameter name="Engine" value="InnoDB"/>
106 <parameter name="Charset" value="utf8"/>
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"/>
116 <foreign-key foreignTable="Hub" phpName="Hub" refPhpName="Donation">
117 <reference local="hub_id" foreign="id"/>
122 <table name="FoodOrder" phpName="Order" baseClass="ReadifoodObject">
123 <vendor type="mysql">
124 <parameter name="Engine" value="InnoDB"/>
125 <parameter name="Charset" value="utf8"/>
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"/>
136 <foreign-key foreignTable="Contact" phpName="Beneficiary" refPhpName="Beneficiary">
137 <reference local="beneficiary_id" foreign="id"/>
139 <foreign-key foreignTable="Hub" phpName="Hub" refPhpName="Hub">
140 <reference local="hub_id" foreign="id"/>
145 <table name="OrderState" phpName="OrderState" baseClass="ReadifoodObject">
146 <vendor type="mysql">
147 <parameter name="Engine" value="InnoDB"/>
148 <parameter name="Charset" value="utf8"/>
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"/>
159 <foreign-key foreignTable="User" phpName="User" refPhpName="OrderState">
160 <reference local="user_id" foreign="id"/>
162 <foreign-key foreignTable="Contact" phpName="Driver" refPhpName="OrderState">
163 <reference local="driver_id" foreign="id"/>