Collection Mapping

Naming conventions

All the tables and columns in the database are all lowercase. (Which is quite handy with an Mysql database because the names are case-sensitive if the underlying file system is also case-sensitive. So Mysql Names are case sensitive on Linux but not on Windows.)

Tablenames are plural.

Prototype names start with upper case and are camel case. Prototype names are singular.

Property- Object- and Collection-Mapping start with lower case and are also camel case.

Foreign keys are prefixed with the name of the table they are referring to.

1:n relation

DB schema

Mapping

   images         = Collection(Image)
   images.local   = gallery_id
   images.foreign = galleries_gallery_id

m:n relation

DB schema

Mapping

   tags                          = Collection(Tag)
   tags.filter                   = ${image_id} = tags2images.images_image_id AND \
                                   tags2images.tags_tag_id = tags.tag_id
   tags.filter.additionalTables  = tags2images

The Backslash "\" is only necessary when you have a filter that continues in the next line.

Pages linking to this page: Documentation Drafts