payitems

payitems —

payitems

Column nameTypeNullDefaultDescription
piidint unsigned auto_increment
payidint unsigned0
itemvarchar(25)YES
subitemvarchar(35)YES
qtysmallint unsignedYES
rcptidint unsigned0
amtdecimal(8,2)YES
statusenum('cart','pend','done','refund','bogus')YES
rcptemailvarchar(80)YES
anonenum('0','1')YES
giveafterint unsignedYES
tokenvarchar(25)YES
tokenidint unsignedYES
qty_ressmallint unsignedYES
Key nameTypeColumn(s)
PRIMARYPRIMARY
payidINDEX
rcptemailINDEX
rcptidINDEX
statusINDEX