File: scrubs-config.xml

<?xml version="1.0" encoding="ISO-8859-1" ?>
<scrubs-config>
 <class name="writer" table="writers">
  <primaryKey field="username" autoIncrement="false" />
  <property name="password" field="password" />
  <property name="fullName" field="full_name" />
  <relationship type="oneToMany" name="story" linkOn="writer" 
  				objectArray="stories" cascade="false" />
  <relationship type="oneToMany" name="writerPermission" linkOn="writer" 
  				objectArray="writerPermissions" cascade="false" />
 </class>
 <class name="story" table="stories">
  <primaryKey field="id" autoIncrement="true" />
  <property name="writer" field="writer" />
  <property name="page" field="page" />
  <property name="headline" field="headline" />
  <property name="storyText" field="story_text" />
  <property name="picture" field="picture" />
  <property name="created" field="created" />
  <property name="modified" field="modified" />
  <property name="published" field="published" />
  <relationship type="manyToOne" name="writers" linkOn="writer" />
  <relationship type="manyToOne" name="pages" linkOn="page" />
  <relationship type="oneToMany" name="keyword" linkOn="story" objectArray="keywords" cascade="false" />
 </class>
 <class name="keyword" table="keywords">
  <primaryKey field="story" autoIncrement="false" />
  <property name="keyword" field="keyword" />
  <property name="weight" field="weight" />
  <relationship type="manyToOne" name="stories" linkOn="story" />
 </class>
 <class name="page" table="pages">
  <primaryKey field="code" autoIncrement="false" />
  <property name="description" field="description" />
  <relationship type="oneToMany" name="story" linkOn="page" objectArray="stories" cascade="false" />
  <relationship type="oneToMany" name="writerPermission" linkOn="page" objectArray="writerPermissions" cascade="false" />
 </class>
 <class name="writerPermission" table="writer_permissions">
  <primaryKey field="writer" autoIncrement="false" />
  <property name="page" field="page" />
  <relationship type="manyToOne" name="pages" linkOn="page" />
  <relationship type="manyToOne" name="writers" linkOn="writer" />
 </class>
</scrubs-config>