
Untitled
By: a guest on
May 7th, 2012 | syntax:
None | size: 0.93 KB | hits: 14 | expires: Never
expense:
id: ~
expended_at: { type: date, required: true }
type_id: { type: integer, foreignTable: expense_type, foreignReference: id, required: true }
user_id: { type: integer, foreignTable: sf_guard_user, foreignReference: id }
status_id: { type: integer, foreignTable: expense_status, foreignReference: id, required: true}
total: { type: decimal, size: 10, scale: 2, required: true }
subtotal: { type: decimal, size: 10, scale: 2, required: true }
taxes: { type: decimal, size: 10, scale: 2 }
created_at: ~
expense_comment:
id: ~
expense_id: { type: integer, foreignTable: expense, foreignReference: id, required: true, onDelete: cascade }
body: { type: longvarchar, required: true }
created_by: { type: integer, foreignTable: sf_guard_user, foreignReference: id, required: true, onDelete: cascade }
created_at: ~