Instrument:
    columns:
        name: { type: string(255), notnull: true, unique: true }
        description: clob

Question:
    actAs: [ Taggable ]
    columns:
        name: string(255)
        type: string(255)
        instrument_id: { type: integer, notnull: true }
        item_number: { type: float, notnull: true }
    relations:
        Instrument:
            local: instrument_id
            foreign: id
            foreignAlias: Questions


Test:
    actAs: [ Timestampable, sfDoctrineSlotTemplate ]
    columns:
        client_id: { type: integer, notnull: true }
        staff_id: { type: integer, notnull: true }
        instrument_id: { type: integer, notnull: true }
    relations:
        Instrument: { local: instrument_id, foreign: id, type: one, foreignType: many, foreignAlias: Tests }
        Staff: { local: staff_id, foreign: id, type: one, foreignType: many, foreignAlias: Tests }
        Client: { local: client_id, foreign: id, type: one, foreignType: many, foreignAlias: Tests }

Answer:
    columns:
        test_id: { type: integer, primary: true, notnull: true }
        question_id: { type: integer, primary: true, notnull: true }
        response: string
    relations:
        Test: { local: test_id, foreign: id, type: one, foreignType: many, foreignAlias: Answers }
        Question: { local: question_id, foreign: id, type: one, foreignType: many, foreignAlias: Answers }