payments

payments —

payments

Column nameTypeNullDefaultDescription
payidint unsigned auto_increment
anumsmallint unsignedYES
useridint unsigned0
datesentdatetime0000-00-00 00:00:00
daterecvdatetime0000-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