DkEvent:
  actAs:
    Sluggable:
      unique: true
      fields: [title]
      canUpdate: true
  columns:
    competition_id:  { type: integer, notnull: true }
    title:           { type: string(168), notnull: true }
    short:           { type: string(1000), notnull: false }
    full:            { type: clob(2147483647), notnull: false }
    date:            { type: date, notnull: false }
    css:             { type: string(256), notnull: false }
    class:           { type: string(168), notnull: false }
  relations:
    Competition:
      class:         DkCompetition
      local:         competition_id
      foreign:       id
      onUpdate:      CASCADE
      foreignAlias:  Events
    CompetitionTeams:
      class:         DkCompetitionTeam
      local:         event_id
      foreign:       competition_team_id
      refClass:      DkEventDkCompetitionTeam
      foreignAlias:  Events
    Users:
      class:         sfGuardUser
      local:         event_id
      foreign:       user_id
      refClass:      DkEventSfGuardUser
      foreignAlias:  Events

DkEventSfGuardUser:
  options:
    symfony:        { filter: false }
  columns:
    event_id:       { type: integer, primary: true }
    user_id:        { type: integer, primary: true }
    points:         { type: integer }
  relations:
    Event:
      class:        DkEvent
      local:        event_id
      onDelete:     CASCADE
      foreignAlias: EventUser
    User:
      class:        sfGuardUser
      local:        user_id
      onDelete:     CASCADE
      foreignAlias: EventUser