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 |