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