coupon —
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| cpid | mediumint unsigned auto_increment | |||
| auth | varchar(10) | YES | ||
| type | varchar(20) | YES | ||
| arg | varchar(30) | YES | ||
| rcptid | int unsigned | 0 | ||
| locked | enum('0','1') | 0 | ||
| payid | int unsigned | 0 | ||
| ppayid | int unsigned | 0 |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| payid | INDEX | |
| ppayid | INDEX | |
| rcptid | INDEX |