XML schema of xPDO model for Workshops CMP

workshops.mysql.schema.xml

<?xml version="1.0" encoding="UTF-8"?>
<model package="workshops" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM" version="1.1">
    <object class="Workshop" table="workshop" extends="xPDOSimpleObject">
		<field key="title" dbtype="varchar" precision="250" phptype="string" null="false" />
		<field key="date" dbtype="int" precision="20" phptype="integer" null="false" default="0" />
		<field key="time_start" dbtype="time" phptype="string" null="true" />
		<field key="time_end" dbtype="time" phptype="string" null="true" />
		<field key="capacity" dbtype="int" precision="11" phptype="integer" null="false" />
		<field key="description" dbtype="text" phptype="string" null="false" />
		<field key="status" dbtype="int" precision="11" phptype="integer" null="false" />
		<field key="annex" dbtype="varchar" precision="250" phptype="string" null="false" />
		<field key="annex_source" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="createdby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="createdon" dbtype="int" precision="20" phptype="integer" null="false" default="0" />
		<field key="deleted" dbtype="tinyint" precision="1" phptype="integer" null="false" default="0" />
		<field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="deletedon" dbtype="int" precision="20" phptype="integer" null="false" default="0" />

		<composite alias="Registrations" class="WorkshopsRegistrations" local="id" foreign="workshop" cardinality="many" owner="local" />
	</object>
	<object class="WorkshopParticipant" table="workshop_participant" extends="xPDOSimpleObject">
		<field key="registration" dbtype="int" precision="11" phptype="integer" null="false" />
		<field key="degree" dbtype="varchar" precision="50" phptype="string" null="false" />
		<field key="first_name" dbtype="varchar" precision="250" phptype="string" null="false" />
		<field key="last_name" dbtype="varchar" precision="250" phptype="string" null="false" />
		<field key="attendance" dbtype="smallint" precision="6" phptype="integer" null="false" />
		<field key="deleted" dbtype="tinyint" precision="1" phptype="integer" null="false" default="0" />
		<field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="deletedon" dbtype="int" precision="20" phptype="integer" null="false" default="0" />

		<aggregate alias="Parent" class="WorkshopsRegistrations" local="registration" foreign="id" cardinality="one" owner="foreign" />
	</object>
	<object class="WorkshopRegistration" table="workshop_registration" extends="xPDOSimpleObject">
		<field key="workshop" dbtype="int" precision="11" phptype="integer" null="false" />
		<field key="type" dbtype="int" precision="11" phptype="integer" null="false" />
		<field key="company" dbtype="varchar" precision="250" phptype="string" null="false" />
		<field key="address" dbtype="text" phptype="string" null="false" />
		<field key="email" dbtype="varchar" precision="250" phptype="string" null="false" />
		<field key="registration_nr" dbtype="varchar" precision="250" phptype="string" null="false" />
		<field key="vat_nr" dbtype="varchar" precision="250" phptype="string" null="false" />
		<field key="phone" dbtype="varchar" precision="250" phptype="string" null="false" />
		<field key="confirmed" dbtype="smallint" precision="6" phptype="integer" null="false" />
		<field key="paid" dbtype="int" precision="20" phptype="integer" null="true" default="0" />
		<field key="remark" dbtype="text" phptype="string" null="false" />
		<field key="createdon" dbtype="int" precision="20" phptype="integer" null="false" default="0" />
		<field key="deleted" dbtype="tinyint" precision="1" phptype="integer" null="false" default="0" />
		<field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="deletedon" dbtype="int" precision="20" phptype="integer" null="false" default="0" />

		<aggregate alias="Workshop" class="Workshops" local="workshop" foreign="id" cardinality="one" owner="foreign" />
		<composite alias="Participants" class="WorkshopsParticipants" local="id" foreign="registration" cardinality="many" owner="local" />
	</object>
</model>