payments

payments

payments

Column name Type Null Default Description
payid int unsigned auto_increment    
anum smallint unsigned YES  
userid int unsigned   0  
datesent datetime   0000-00-00 00:00:00  
daterecv datetime   0000-00-00 00:00:00  
amount decimal(8,2) YES  
months tinyint unsigned YES  
used enum('N','Y','C')   N  
mailed enum('N','Y','C','X')   N  
notes text YES  
method varchar(20)    
forwhat varchar(20) YES  
giveafter int unsigned YES  
Key name Type Column(s)
PRIMARY PRIMARY
forwhat INDEX
mailed INDEX
method INDEX
used INDEX
userid INDEX