Collection Mapping

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

40	tags.filter = ${image_id} = tags2images.images_image_id ANDAND

40	tags.filter = ${image_id} = tags2images.images_image_id AND tags2images.tags_tag_id = tags.tag_idAND
41	tags2images.tags_tag_id = tags.tag_id

22
39	tags = Collection(Tag)
40	tags.filter = ${image_id} = tags2images.images_image_id AND tags2images.tags_tag_id = tags.tag_id
41	tags.filter.additionalTables = tags2images

1	<b>Naming conventions</b>
2
3	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.)
4
5	Tablenames are plural.
6
7	Prototype names start with upper case and are camel case. Prototype names are singular.
8
9	Property- Object- and Collection-Mapping start with lower case and are also camel case.
10
11	Foreign keys are prefixed with the name of the table they are referring to.
12
13
4	<b>DB schema</b>
5
8	<b>Mapping</b>
9
17	<b>DB schema</b>
18
19
20
21	<b>Mapping</b>

5	<b>Gallery/type.properties</b>
6	images = Collection(Image)
7	images.local = gallery_id
8	images.foreign = galleries_gallery_id
7
11
12	<b>Image/type.properties</b>

3	test<% this.image name="1-to-n-relation.jpg" %>
8	test<% this.image name="m-to-n-relation.jpg" %>
9

test