User:Chughakshay16/transactionstable
Appearance
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 | | +-----------------------+---------------------+------+-----+---------+----------------+