subscription
| 欄位 | 型態 | 範例 |
| biblionumber | int(11) | |
| subscriptionid | int(11) | |
| librarian | varchar(100) | |
| startdate | date | |
| aqbooksellerid | int(11) | |
| cost | int(11) | |
| aqbudgetid | int(11) | |
| weeklength | tinyint(4) | |
| monthlength | tinyint(4) | |
| numberlength | tinyint(4) | |
| periodicity | tinyint(4) | |
| dow | varchar(100) | |
| numberingmethod | varchar(100) | |
| notes | text | |
| status | varchar(100) | |
| add1 | int(11) | |
| every1 | int(11) | |
| whenmorethan1 | int(11) | |
| setto1 | int(11) | |
| lastvalue1 | int(11) | |
| add2 | int(11) | |
| every2 | int(11) | |
| whenmorethan2 | int(11) | |
| setto2 | int(11) | |
| lastvalue2 | int(11) | |
| add3 | int(11) | |
| every3 | int(11) | |
| innerloop1 | int(11) | |
| innerloop2 | int(11) | |
| innerloop3 | int(11) | |
| whenmorethan3 | int(11) | |
| setto3 | int(11) | |
| lastvalue3 | int(11) |
