»

payments

payments —

payments

Column nameTypeNullDefaultDescription
payidint unsigned auto_increment  
anumsmallint unsignedYES 
useridint unsigned 0 
datesentdatetime 0000-00-00 00:00:00 
daterecvdatetime 0000-00-00 00:00:00 
amountdecimal(8,2)YES 
monthstinyint unsignedYES 
usedenum('N','Y','C') N 
mailedenum('N','Y','C','X') N 
notestextYES 
methodvarchar(20)  
forwhatvarchar(20)YES 
giveafterint unsignedYES 
Key nameTypeColumn(s)
PRIMARYPRIMARY
forwhatINDEX
mailedINDEX
methodINDEX
usedINDEX
useridINDEX