propel:
  _attributes:
    package: lib.model
    defaultIdMethod: native
  abuse_comment:
    _attributes: { phpName: AbuseComment }
    ac_user: { type: INTEGER, size: '10', foreignTable: user, foreignReference: u_id, onDelete: cascade, required: true }
    ac_comment: { type: INTEGER, size: '10', foreignTable: commentary, foreignReference: com_id, onDelete: cascade, required: true }
    ac_txt: { type: LONGVARCHAR, required: false }
    ac_type: { type: TINYINT, size: '3', required: false }
    created_at: { type: TIMESTAMP, required: false }
  abuse_media:
    _attributes: { phpName: AbuseMedia }
    am_user: { type: INTEGER, size: '10', foreignTable: user, foreignReference: u_id, onDelete: cascade, required: true }
    am_media: { type: INTEGER, size: '10', foreignTable: commentary, foreignReference: com_id, onDelete: cascade, required: true }
    am_txt: { type: LONGVARCHAR, required: false }
    am_type: { type: TINYINT, size: '3', required: false }
    created_at: { type: TIMESTAMP, required: false }
  abuse_user:
    _attributes: { phpName: AbuseUser }
    au_from: { type: INTEGER, size: '10', foreignTable: user, foreignReference: u_id, required: true }
    au_to: { type: INTEGER, size: '10', foreignTable: user, foreignReference: u_id, required: true }
    au_txt: { type: LONGVARCHAR, required: false }
    au_type: { type: TINYINT, size: '3', required: false }
    created_at: { type: TIMESTAMP, required: false }
commentary:
    _attributes: { phpName: Commentary }
    com_id: { type: INTEGER, size: '10', primaryKey: true, autoIncrement: true, required: true }
    com_media: { type: INTEGER, size: '10',  foreignTable: media, foreignReference: med_id , onDelete: cascade, required: true }
    com_user: { type: INTEGER, size: '10', foreignTable: user, foreignReference: u_id, onDelete: cascade, required: true }
    com_title: { type: VARCHAR, size: '150', required: false }
    com_txt: { type: LONGVARCHAR, required: false }
    com_perti: { type: INTEGER, size: '10', required: false }
    created_at: { type: TIMESTAMP, required: false }
    updated_at: { type: TIMESTAMP, required: false }
media:
    _attributes: { phpName: Media }
    med_id: { type: INTEGER, size: '10', primaryKey: true, autoIncrement: true, required: true }
    med_title: { type: VARCHAR, size: '150', required: false }
    med_txt: { type: LONGVARCHAR, required: false }
    med_type: { type: TINYINT, size: '3', required: false }
    med_date_orig: { type: DATE, required: false }
    med_author: { type: VARCHAR, size: '100', required: false }
    med_lic: { type: VARCHAR, size: '20', required: false }
    med_file: { type: LONGVARCHAR, required: false }
    created_at: { type: TIMESTAMP, required: false }
    updated_at: { type: TIMESTAMP, required: false }
user:
    _attributes: { phpName: User }
    u_id: { type: INTEGER, size: '10', primaryKey: true, autoIncrement: true, required: true }
    u_name: { type: VARCHAR, size: '100', required: false }
    u_forname: { type: VARCHAR, size: '100', required: false }
    u_email: { type: VARCHAR, size: '150', required: false }
    u_nick: { type: VARCHAR, size: '100', required: false }
    u_pass: { type: VARCHAR, size: '32', required: false }
    u_cp: { type: VARCHAR, size: '2', required: false }
    u_addr: { type: VARCHAR, size: '200', required: false }
    u_age: { type: DATE, required: false }
    u_hobby: { type: LONGVARCHAR, required: false }
    u_key: { type: VARCHAR, size: '32', required: false }
    u_status: { type: TINYINT, size: '3', required: false }
    u_role: { type: TINYINT, size: '3', required: false }
    u_abuse: { type: TINYINT, size: '3', required: false }
    u_last_con: { type: TIMESTAMP, required: false }
    created_at: { type: TIMESTAMP, required: false }
    updated_at: { type: TIMESTAMP, required: false }