Restoroo/doc/database.dbs

<?xml version="1.0" encoding="UTF-8" ?>
<project name="Restoroo" id="Project-8d5" database="LogicalDesign" >
	<schema name="INSTANCE" catalogname="Restoroo" >
		<table name="Chain" prior="entity" >
			<column name="name" type="VARCHAR" length="100" jt="12" />
			<column name="logo" type="BLOB" jt="1111" />
		</table>
		<table name="Commission Invoice" prior="entity" />
		<table name="Delivery Area" prior="entity" >
			<column name="area_definition" type="TEXT" jt="-1" />
			<column name="minimum_order" type="DECIMAL" jt="3" />
			<column name="price" type="DECIMAL" jt="3" />
		</table>
		<table name="Extras" prior="entity" >
			<column name="name" type="VARCHAR" length="100" jt="12" />
			<column name="description" type="TEXT" jt="-1" />
			<column name="price" type="DECIMAL" jt="3" />
		</table>
		<table name="Media" prior="entity" />
		<table name="Menu Item" prior="entity" >
			<column name="name" type="VARCHAR" length="100" jt="12" />
			<column name="description" type="TEXT" jt="-1" />
			<column name="price" type="DECIMAL" jt="3" />
		</table>
		<table name="Order" prior="entity" >
			<column name="status" type="CHAR" length="1" jt="1" />
			<column name="remarks" type="TEXT" jt="-1" />
		</table>
		<table name="Order Item" prior="entity" >
			<column name="remarks" type="TEXT" jt="-1" />
			<column name="price" type="DECIMAL" jt="3" />
		</table>
		<table name="Payment" prior="entity" >
			<column name="amount" type="DECIMAL" jt="3" />
			<column name="transaction_id" type="VARCHAR" length="100" jt="12" />
			<column name="gateway" type="VARCHAR" length="100" jt="12" />
			<column name="fee" type="DECIMAL" jt="3" />
		</table>
		<table name="Permission" prior="entity" >
			<column name="permission_type" type="VARCHAR" length="20" jt="12" />
		</table>
		<table name="Profile" prior="Provile" >
			<column name="first_name" type="VARCHAR" length="100" jt="12" />
			<column name="last_name" type="VARCHAR" length="100" jt="12" />
			<column name="display_name" type="VARCHAR" length="100" jt="12" />
			<column name="profile_image" type="BLOB" jt="1111" />
		</table>
		<table name="Reservation" prior="entity" >
			<column name="persons" type="INT" jt="4" />
			<column name="remarks" type="TEXT" jt="-1" />
		</table>
		<table name="Restaurant" prior="entity" >
			<column name="name" type="VARCHAR" length="100" jt="12" />
			<column name="address*" type="TEXT" length="100" jt="-1" />
			<column name="email" type="VARCHAR" length="100" jt="12" />
			<column name="phone" type="VARCHAR" length="100" jt="12" />
			<column name="logo" type="BLOB" jt="1111" />
			<column name="coordinates*" type="DECIMAL" jt="3" />
		</table>
		<table name="Restaurant Area" prior="Restaurant Areas" />
		<table name="Restaurant Setting" prior="entity" />
		<table name="Review" prior="review" />
		<table name="Schedule" prior="Delivery Schedule" >
			<column name="priority" type="DECIMAL" jt="3" />
			<column name="valid_from" type="DATE" jt="91" mandatory="y" >
				<defo><![CDATA[sysdate]]></defo>
			</column>
			<column name="valid_until" type="DATE" jt="91" />
			<column name="opening" type="INT" jt="4" />
			<column name="closing" type="INT" jt="4" />
			<column name="day_of_week" type="ENUM" jt="12" >
				<enumeration><![CDATA[0,1,2,3,4,5,6]]></enumeration>
			</column>
			<column name="schedule_type" type="ENUM" jt="12" >
				<enumeration><![CDATA["delivery","pickup","open"]]></enumeration>
			</column>
		</table>
		<table name="Table" prior="entity" />
		<table name="User" prior="entity" >
			<column name="username" type="VARCHAR" length="100" jt="12" />
			<column name="email" type="VARCHAR" length="100" jt="12" />
			<column name="password" type="VARCHAR" length="100" jt="12" />
		</table>
	</schema>
	<connector name="MyDb" database="MySql" host="localhost" port="3306" user="root" />
	<layout name="Default Layout" id="Layout-55f" show_relation="columns" >
		<entity schema="Restoroo.INSTANCE" name="Chain" color="C1D8EE" x="656" y="240" />
		<entity schema="Restoroo.INSTANCE" name="Commission Invoice" color="C1D8EE" x="656" y="96" />
		<entity schema="Restoroo.INSTANCE" name="Delivery Area" color="C1D8EE" x="512" y="656" />
		<entity schema="Restoroo.INSTANCE" name="Extras" color="C1D8EE" x="80" y="720" />
		<entity schema="Restoroo.INSTANCE" name="Media" color="C1D8EE" x="816" y="240" />
		<entity schema="Restoroo.INSTANCE" name="Menu Item" color="C1D8EE" x="80" y="576" />
		<entity schema="Restoroo.INSTANCE" name="Order" color="C1D8EE" x="224" y="240" />
		<entity schema="Restoroo.INSTANCE" name="Order Item" color="C1D8EE" x="208" y="400" />
		<entity schema="Restoroo.INSTANCE" name="Payment" color="C1D8EE" x="48" y="240" />
		<entity schema="Restoroo.INSTANCE" name="Permission" color="C1D8EE" x="416" y="224" />
		<entity schema="Restoroo.INSTANCE" name="Profile" color="C1D8EE" x="416" y="48" />
		<entity schema="Restoroo.INSTANCE" name="Reservation" color="C1D8EE" x="304" y="560" />
		<entity schema="Restoroo.INSTANCE" name="Restaurant" color="C1D8EE" x="432" y="384" />
		<entity schema="Restoroo.INSTANCE" name="Restaurant Area" color="C1D8EE" x="448" y="576" />
		<entity schema="Restoroo.INSTANCE" name="Restaurant Setting" color="C1D8EE" x="736" y="432" />
		<entity schema="Restoroo.INSTANCE" name="Review" color="C1D8EE" x="96" y="416" />
		<entity schema="Restoroo.INSTANCE" name="Schedule" color="C1D8EE" x="720" y="592" />
		<entity schema="Restoroo.INSTANCE" name="Table" color="C1D8EE" x="400" y="656" />
		<entity schema="Restoroo.INSTANCE" name="User" color="C1D8EE" x="176" y="48" />
	</layout>
</project>