payitems —
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| piid | int unsigned auto_increment | |||
| payid | int unsigned | 0 | ||
| item | varchar(25) | YES | ||
| subitem | varchar(35) | YES | ||
| qty | smallint unsigned | YES | ||
| rcptid | int unsigned | 0 | ||
| amt | decimal(8,2) | YES | ||
| status | enum('cart','pend','done','refund','bogus') | YES | ||
| rcptemail | varchar(80) | YES | ||
| anon | enum('0','1') | YES | ||
| giveafter | int unsigned | YES | ||
| token | varchar(25) | YES | ||
| tokenid | int unsigned | YES | ||
| qty_res | smallint unsigned | YES |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| payid | INDEX | |
| rcptemail | INDEX | |
| rcptid | INDEX | |
| status | INDEX |