User:Chughakshay16/transactionstable

The transactions table is responsible for maintaining a list of all the financial transactions that occurred for a conference.transactions table maintain a 1:1 relationship with the registrations table.

tr_id
Primary key for the transaction.

tr_reg_id
The registration for which this transaction happened.

tr_type
The type of transaction(debit card, paypal..)

tr_amount
The amount for the transaction.

tr_status
The status of the transaction(on failure the value would be0 else it would be 1)

Schema summary
DESCRIBE transactions;: +---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field                | Type                | Null | Key | Default | Extra          |
 * tr_id                | int(8) unsigned     | NO   | PRI | NULL    | auto_increment |
 * tr_reg_id            | int(8)unsigned      | NO   |     | NULL    |                |
 * tr_type              | varchar(10)         | NO   |     | NULL    |                |
 * tr_amount            | int(10)             | NO   |     | NULL    |                |
 * tr_status            | tinyint(1) unsigned | NO   |     | NULL    |                |