
Untitled
By: a guest on
Jul 4th, 2012 | syntax:
None | size: 1.44 KB | hits: 9 | expires: Never
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 }