payments

0 rows


Description

Stores information about payments

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
paygw_paypal.paymentid paygpayp_pay_fkR
component VARCHAR 100

The plugin this payment belongs to.

paymentarea VARCHAR 50

The name of payable area

itemid BIGINT 19 null
userid BIGINT 19 null
user.id paym_use2_fkR
amount VARCHAR 20
currency VARCHAR 3
accountid BIGINT 19 null
payment_accounts.id paym_acc2_fkR
gateway VARCHAR 100
timecreated BIGINT 19 0
timemodified BIGINT 19 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
paym_acc_ix Performance Asc accountid
paym_compayite_ix Performance Asc/Asc/Asc component + paymentarea + itemid
paym_gat_ix Performance Asc gateway
paym_use_ix Performance Asc userid

Relationships