# Campaign has many Designers
        Designers:
            refClass: CampaignDesigners
            class: Designer
            local: id
            foreign: designer_ids

A few errors:

1.) refClass should be CampaignDesigner
2.) Your local and foreign are wrong. It should be local: campaign_id and
foreign: design_id as those are the columsn defined on CampaignDesigner
3.) You are using type: bool in a few places. It should be boolean
4.) You have relationships defined Participant which specify local: id but
you have username defined as the primary key, so no id column exists.
5.) You ave DeviceCapability and you have a column defined as capacity_id,
but I think you meant it to be capability_id

I corrected the errors and now this schema builds:
http://pastebin.com/m74fe31ab

Run a diff between mine and yours so you can see my changes.

I would recommend writing your schema and re-building it after every change
;) It looks like you wrote a lot of the schema then tested at the very end
and you end up with lots of errors that are hard to figure out. If you
rebuild it at each step and you get an error, you will know where the error
is obviously and you can fix it right then.

- Jon