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.

Fields

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    |                |
+-----------------------+---------------------+------+-----+---------+----------------+