Doctrine

Member:
  tableName: member
  columns:
    sf_guard_user_id: integer(4)
    first_name:     string(255)
    last_name:      string(255)
    email_address:  string(255)
    bio:            string
    inspiration:    string
    list_position:  integer(3)
    featured:       { type: boolean, default: false }
    image_on_id:    integer(4)
    image_off_id:   integer(4)
  relations:
    User:
      class: sfGuardUser
      foreignType: one
      local: sf_guard_user_id
    ImageOn:
      class: ImageAsset
      type: one
      local: image_on_id
    ImageOff:
      class: ImageAsset
      type: one
      local: image_off_id
 
CaseStudy:
  tableName: case_study
  columns:
    client_id:  { type: integer(4), notnull: true }
    objective:  { type: string(255) }
    strategy:   { type: string }
  relations:
    Images: 
      class:  ImageAsset
      type:   many
      foreignType: one
    Client:
      class:  Client
      type:   one
      foreignType: many
 
Client:
  tableName: client
  columns:
    id:   { type: integer(4), autoincrement: true, notnull: true, primary: true }
    image_asset_id:   integer(4)
    name: { type: string(255) }
  relations:
    Logo:
      class:  ImageAsset
      type:   one
      foreignType: one

Section:
  actAs:
    Sluggable:
      unique: true
      fields: [name]
      canUpdate: true
    NestedSet:
  columns:
    name: { type: string(20) }
    content: { type: string }
    image_asset_id: integer(4)
  relations:
    Image:
      class:  ImageAsset
      foreignType: one
    
ImageAsset:
  tableName: asset_image
  columns:
    id:   { type: integer(4), autoincrement: true, notnull: true, primary: true }
    filename: { type: string(255) }
    path: { type: string(255) }
    mime_type: { type: string(100) }
    extension: { type: string(3) }
    width: { type: integer(5) }
    height: { type: integer(5) }