Skip to content

Instantly share code, notes, and snippets.

@hansek

hansek/workshops.mysql.schema.xml

Created February 8, 2013 13:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hansek/4739050 to your computer and use it in GitHub Desktop.
Save hansek/4739050 to your computer and use it in GitHub Desktop.
Download ZIP
XML schema of xPDO model for Workshops CMP
Raw
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>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment