$EventAdminCampusAssignment->createTable(); /* * CashTransaction Table * * Manages financial data pertaining to cash transactions between some registrant and the event host. * * cashtransaction_id [INTEGER] Unique identifier of a particular cash transaction from some registrant to event host * reg_id [INTEGER] Value identifying the registrant from which the cash originates (if value is positive) * cashtransaction_staffName [STRING] The name of the staff member receiving the cash (or dispersing if cash value is negative). * cashtransaction_recd [INTEGER] Whether or not payment was received (1 or 0 for true/false). * cashtransaction_amtPaid [INTEGER] Dollar amount of cash transaction. * cashtransaction_moddate [DATE] Modification timestamp for cash transaction record. */ $CashTransaction = new RowManager_CashTransactionManager(); $CashTransaction->dropTable(); $CashTransaction->createTable(); /* * CreditCardTransaction Table * * Manages the details pertaining to a credit card transaction from some registrant to the appropriate event host. * * cctransaction_id [INTEGER] Unique identifier for a particular credit card transaction record * reg_id [INTEGER] Identifier of the registrant involved in the credit card transaction (generally the payee). * cctransaction_cardName [STRING] Name displayed on the credit card used for this transaction. * cctype_id [INTEGER] Identifier for the particular credit card type used * cctransaction_cardNum [STRING] The credit card number * cctransaction_expiry [STRING] The expiry date of the credit card being used. * cctransaction_billingPC [STRING] Postal code of the credit card's billing address. * cctransaction_processed [INTEGER] Whether or not transaction has been processed (1 = true, 0 = false). * cctransaction_amount [INTEGER] The amount of money being transacted. * cctransaction_moddate [DATE] The timestamp of the last modification to the transaction record.