gistfile1.yml

Category:
  actAs:
    Sluggable: 
      unique: true
      fields: [name]
      canUpdate: true
    NestedSet:
      hasManyRoots: true
      rootColumnName: root_id
  columns:
    name:               { type: string(255), notnull: true }

Offer:
  actAs: 
    Timestampable: ~
    Sluggable: 
      unique: true
      fields: [name]
      canUpdate: true
  columns:
    provider_id:    { type: integer }
    name:           { type: string(255), notnull: true }
    description:    { type: string(500), notnull: true }
    price:    { type: float, notnull: true }}
    picture:        { type: string(255), notnull: true }
  relations:
    Provider:       { class: sfGuardUser, local : provider_id, foreignType: one }
    Categories:     { foreignAlias: Offers, class: Category, refClass: OfferCategory }

OfferCategory:
  columns:
    category_id:    { type: integer, primary: true }
    offer_id:       { type: integer, primary: true }
  relations:
    Category: { foreignAlias: OfferCategories }
    Offer:    { foreignAlias: OfferCategories }