Enrol Paypal Table Schema (enrol_paypal)


Description

Holds all known information about PayPal transactions

enrol_paypal table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
business varchar 255
receiver_email varchar 255
receiver_id varchar 255
item_name varchar 255
courseid bigint 10 0
course.id Implied Constraint R
userid bigint 10 0
user.id Implied Constraint R
instanceid bigint 10 0
memo varchar 255
tax varchar 255
option_name1 varchar 255
option_selection1_x varchar 255
option_name2 varchar 255
option_selection2_x varchar 255
payment_status varchar 255
pending_reason varchar 255
reason_code varchar 30
txn_id varchar 255
parent_txn_id varchar 255
payment_type varchar 30
timeupdated bigint 10 0

Table contained -1 rows

enrol_paypal table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

enrol_paypal table relationships