propel:
  _attributes: { package: plugins.sfFormGuiPlugin.lib.model }
  
  sf_form_gui:
    _attributes: { phpName: sfFormGui }
    _behaviors: 
      owned: { column: owner_id }
    id:
    name: { type: varchar, size: 255 }
    description:  { type: longvarchar }
    published: { type: boolean }
    rank: { type: integer }
    owner_id: { type: integer }
    created_at:
    updated_at:
  
  sf_form_gui_question:
    _attributes: { phpName: sfFormGuiQuestion }
    _behaviors: 
      owned: { column: owner_id }
    id:
    sf_form_gui_id: { type: integer, required: true, foreignTable: sf_form_gui, foreignReference: id, onDelete: cascade }
    name: { type: varchar, size: 255 }
    description:  { type: longvarchar }
    widget: { type: varchar, size: 255 }
    published: boolean
    required: boolean
    rank: { type: integer, required: true }
    created_at:
    updated_at:
    owner_id: { type: integer }
  
  sf_form_gui_question_parameter:
    _attributes: { phpName: sfFormGuiQuestionParameter }
    name: { type: varchar, size: 255, required: true }
    key: { type: varchar, size: 255, required: true }
    value: {type: longvarchar }
    question_id: { type: integer, required: true, foreignTable: sf_form_gui_question, foreignReference: id, onDelete: cascade }
    type: { type: varchar, size: 255 }
    scope: { type: varchar, size: 255, default: NULL }
  
  sf_form_gui_response:
    _attributes: { phpName: sfFormGuiResponse }
    _behaviors: 
      owned: { column: owner_id }
    id:
    session_id: {type: varchar, size: 255 }
    created_at:
    updated_at:
    owner_id: { type: integer }
  
  sf_form_gui_response_question:
    _attributes: { phpName: sfFormGuiResponseQuestion }
    _behaviors: 
      owned: { column: owner_id }
    id:
    question_id: { type: integer, required: true, foreignTable: sf_form_gui_question, foreignReference: id }
    response_id: { type: integer, required: true, foreignTable: sf_form_gui_response, foreignReference: id, onDelete: cascade }
    value: { type: longvarchar }
    created_at:
    updated_at:
    owner_id: { type: integer }