propel:
  _attributes:
    package: lib.model
    defaultIdMethod: native
  users:
    id: { type: INTEGER, primaryKey: true, autoIncrement: true, required: true }
    user: { type: VARCHAR, size: '50', required: true }
    pass: { type: VARCHAR, size: '32', required: true }
    publicname: { type: VARCHAR, size: '150', required: true }
    email: { type: VARCHAR, size: '50', required: true }
    avatar: { type: VARCHAR, size: '255', required: false }
    is_admin: {type: BOOLEAN, required: true }
  surveys:
    id: { type: INTEGER, primaryKey: true, autoIncrement: true, required: true }
    user_id: { type: INTEGER, foreignTable: users, foreignReference: id, required: true, onDelete: cascade }
    name: { type: VARCHAR, size: '150', required: true }
    creationdate: { type: TIMESTAMP, required: true }
    data: { type: LONGVARCHAR, required: true }
    is_simple: {type: BOOLEAN, required: true }
  results:
    id: { type: INTEGER, primaryKey: true, autoIncrement: true, required: true }
    survey_id: { type: INTEGER, foreignTable: surveys, foreignReference: id, required: true, onDelete: cascade }
    result: { type: LONGVARCHAR, required: true }
    is_simple: {type: BOOLEAN, required: true }