User:
 columns:
  id:
   type: integer(11)
   unsigned: true
   primary: true
   autoincrement: true
  salutation: string(20)
  firstname: string(80)
  lastname: string(80)
  email: string(80)
  password: string(128)
  phone: string(80)
  fax: string(80)
  street: string(80)
  number: string(20)
  zip: string(20)
  city: string(80)
  country: string(80)
  bankaccount_owner: string(80)
  bankaccount_accountnumber: string(20)
  bankaccount_banknumber: string(20)
  bankaccount_bankname: string(80)
  bankaccount_iban: string(30)
  bankaccount_swift: string(30)
  paypal: string(80)
  date_registered: datetime
  date_updated: datetime
  date_deleted: datetime
  date_activated: datetime
  flag_active:
   type: boolean
   default: 0
  flag_blocked:
   type: boolean
   default: 0
  flag_deleted:
   type: boolean
   default: 0
  clicks: string
  hash: string(128)
  declinereason: string

Campaign:
 columns:
  id:
   type: integer(11)
   unsigned: true
   autoincrement: true
   primary: true
  title: string(80)
  active_from: datetime
  active_to: datetime
  visibility:
   type: enum
   length: 7
   values: ['public', 'private']
  type:
   type: enum
   length: 5
   values: ['click', 'lead']
  flag_fixed: boolean
 actAs:
  Timestampable:
  Sluggable:
   unique: true
   fields: [type,title,created_at]
   canUpdate: false
 relations:
  Users:
   foreignAlias: Campaigns
   class: User
   refClass: CampaignUser

CampaignUser:
 columns:
  id:
   type: integer(11)
   unsigned: true
   autoincrement: true
   primary: true
  user_id:
   type: integer(11)
   unsigned: true
   primary: true
  campaign_id:
   type: integer(11)
   unsigned: true
   primary: true
 relations:
  User:
   foreignAlias: CampaignUsers
  Campaign:
   foreignAlias: CampaignUsers