User:Chughakshay16/transactionstable

From mediawiki.org
Jump to navigation Jump to search

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[edit]

tr_id[edit]

Primary key for the transaction.

tr_reg_id[edit]

The registration for which this transaction happened.

tr_type[edit]

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

tr_amount[edit]

The amount for the transaction.

tr_status[edit]

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

Schema summary[edit]

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