payitems

payitems

payitems

Column name Type Null Default Description
piid int unsigned auto_increment    
payid int unsigned   0  
item varchar(25) YES  
subitem varchar(35) YES  
qty smallint unsigned YES  
rcptid int unsigned   0  
amt decimal(8,2) YES  
status enum('cart','pend','done','refund','bogus') YES  
rcptemail varchar(80) YES  
anon enum('0','1') YES  
giveafter int unsigned YES  
token varchar(25) YES  
tokenid int unsigned YES  
qty_res smallint unsigned YES  
Key name Type Column(s)
PRIMARY PRIMARY
payid INDEX
rcptemail INDEX
rcptid INDEX
status INDEX